PREVIEW / stock_30min / 2010-10-06

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-06.parquet
  size:    1.4 MB
  rows:    73,570
  symbols: 3,487

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2010-10-06 04:00:00	AAPL	Stock	10.3607	10.3607	10.3607	10.3607	4508.0
2010-10-06 06:00:00	AAPL	Stock	10.3821	10.3821	10.3821	10.3821	2800.0
2010-10-06 06:30:00	AAPL	Stock	10.375	10.375	10.375	10.375	26600.0
2010-10-06 07:00:00	AAPL	Stock	10.3571	10.3671	10.3518	10.3536	158760.0
2010-10-06 07:30:00	AAPL	Stock	10.3571	10.3818	10.3554	10.375	497140.0
2010-10-06 08:00:00	AAPL	Stock	10.3768	10.3821	10.3421	10.3529	3166744.0
2010-10-06 08:30:00	AAPL	Stock	10.3554	10.3554	10.3346	10.3482	1710492.0
2010-10-06 09:00:00	AAPL	Stock	10.3482	10.3643	10.3414	10.3461	1249892.0
2010-10-06 09:30:00	AAPL	Stock	10.3443	10.4282	10.3271	10.3437	102666060.0
2010-10-06 10:00:00	AAPL	Stock	10.3436	10.3743	10.2718	10.2936	60273892.0
2010-10-06 10:30:00	AAPL	Stock	10.2914	10.2941	10.2314	10.2821	51613464.0
2010-10-06 11:00:00	AAPL	Stock	10.2814	10.2907	10.2607	10.2879	24713360.0
2010-10-06 11:30:00	AAPL	Stock	10.2875	10.3296	10.2839	10.3007	29743840.0
2010-10-06 12:00:00	AAPL	Stock	10.3018	10.3207	10.25	10.2543	24220112.0
2010-10-06 12:30:00	AAPL	Stock	10.2571	10.2818	10.2321	10.2382	26847212.0
2010-10-06 13:00:00	AAPL	Stock	10.2392	10.2429	10.1879	10.217	39520404.0
2010-10-06 13:30:00	AAPL	Stock	10.2179	10.3107	10.2071	10.3071	44292304.0
2010-10-06 14:00:00	AAPL	Stock	10.3071	10.3393	10.2375	10.325	84592760.0
2010-10-06 14:30:00	AAPL	Stock	10.327	10.3493	10.275	10.325	51979956.0
2010-10-06 15:00:00	AAPL	Stock	10.3268	10.3393	10.2593	10.3007	38521952.0
2010-10-06 15:30:00	AAPL	Stock	10.3007	10.3332	10.2732	10.32	59166016.0
2010-10-06 16:00:00	AAPL	Stock	10.3282	10.33	10.3016	10.3275	11166316.0
2010-10-06 16:30:00	AAPL	Stock	10.3275	10.3375	10.2847	10.3371	1206660.0
2010-10-06 17:00:00	AAPL	Stock	10.3357	10.3457	10.3357	10.3425	1034908.0
2010-10-06 17:30:00	AAPL	Stock	10.3425	10.3486	10.3425	10.3429	516180.0
2010-10-06 18:00:00	AAPL	Stock	10.3421	10.3457	10.3254	10.3254	365736.0
2010-10-06 18:30:00	AAPL	Stock	10.3286	10.3286	10.3129	10.32	511028.0
2010-10-06 19:00:00	AAPL	Stock	10.3214	10.3246	10.3193	10.3214	195384.0
2010-10-06 19:30:00	AAPL	Stock	10.3196	10.3218	10.2964	10.3025	406504.0
2010-10-06 07:00:00	MSFT	Stock	24.45	24.45	24.4	24.45	5000.0
2010-10-06 07:30:00	MSFT	Stock	24.45	24.5	24.4	24.5	5100.0
2010-10-06 08:00:00	MSFT	Stock	24.5	24.5	24.38	24.4	14272.0
2010-10-06 08:30:00	MSFT	Stock	24.37	24.38	24.32	24.35	11478.0
2010-10-06 09:00:00	MSFT	Stock	24.35	24.36	24.28	24.31	72124.0
2010-10-06 09:30:00	MSFT	Stock	24.32	24.5	24.23	24.49	6148053.0
2010-10-06 10:00:00	MSFT	Stock	24.491	24.54	24.28	24.28	4409722.0
2010-10-06 10:30:00	MSFT	Stock	24.28	24.39	24.27	24.32	2964057.0
2010-10-06 11:00:00	MSFT	Stock	24.32	24.33	24.27	24.28	2053101.0
2010-10-06 11:30:00	MSFT	Stock	24.28	24.39	24.28	24.32	2705376.0
2010-10-06 12:00:00	MSFT	Stock	24.325	24.34	24.205	24.21	2520143.0
2010-10-06 12:30:00	MSFT	Stock	24.21	24.23	24.2	24.21	3197308.0
2010-10-06 13:00:00	MSFT	Stock	24.21	24.22	24.13	24.175	2364199.0
2010-10-06 13:30:00	MSFT	Stock	24.17	24.27	24.17	24.27	2148963.0
2010-10-06 14:00:00	MSFT	Stock	24.27	24.3	24.23	24.285	2865122.0
2010-10-06 14:30:00	MSFT	Stock	24.29	24.38	24.28	24.351	3516469.0
2010-10-06 15:00:00	MSFT	Stock	24.35	24.38	24.29	24.35	3536924.0
2010-10-06 15:30:00	MSFT	Stock	24.355	24.44	24.3	24.43	8395695.0
2010-10-06 16:00:00	MSFT	Stock	24.43	24.5	24.306	24.4	2503061.0
2010-10-06 16:30:00	MSFT	Stock	24.4	24.44	24.298	24.44	23100.0
2010-10-06 17:00:00	MSFT	Stock	24.44	24.44	24.44	24.44	400.0

> showing 50 of 73,570 rows — these rows as CSV

> unlock the full archive -- $79 one-time