PREVIEW / stock_30min / 2016-07-11

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-11.parquet
  size:    1.6 MB
  rows:    82,939
  symbols: 3,277

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
2016-07-11 04:00:00	AAPL	Stock	24.23	24.23	24.23	24.23	400.0
2016-07-11 04:30:00	AAPL	Stock	24.2375	24.2375	24.2375	24.2375	400.0
2016-07-11 05:00:00	AAPL	Stock	24.2375	24.2375	24.2375	24.2375	400.0
2016-07-11 05:30:00	AAPL	Stock	24.2375	24.285	24.2275	24.2825	12000.0
2016-07-11 06:00:00	AAPL	Stock	24.2525	24.2525	24.2525	24.2525	1332.0
2016-07-11 06:30:00	AAPL	Stock	24.23	24.25	24.2275	24.25	5388.0
2016-07-11 07:00:00	AAPL	Stock	24.2475	24.33	24.2475	24.33	23056.0
2016-07-11 07:30:00	AAPL	Stock	24.3	24.3	24.2625	24.285	23172.0
2016-07-11 08:00:00	AAPL	Stock	24.36	24.36	24.2725	24.2925	279072.0
2016-07-11 08:30:00	AAPL	Stock	24.3	24.3	24.29	24.3	49756.0
2016-07-11 09:00:00	AAPL	Stock	24.3	24.305	24.1875	24.19	223380.0
2016-07-11 09:30:00	AAPL	Stock	24.19	24.4125	24.1825	24.3608	21414044.0
2016-07-11 10:00:00	AAPL	Stock	24.36	24.375	24.295	24.3145	7918524.0
2016-07-11 10:30:00	AAPL	Stock	24.3125	24.37	24.3125	24.3462	5739352.0
2016-07-11 11:00:00	AAPL	Stock	24.3475	24.365	24.3275	24.3425	4768576.0
2016-07-11 11:30:00	AAPL	Stock	24.345	24.3525	24.308	24.33	3936816.0
2016-07-11 12:00:00	AAPL	Stock	24.3325	24.35	24.3175	24.324	2813496.0
2016-07-11 12:30:00	AAPL	Stock	24.325	24.35	24.32	24.3425	3813172.0
2016-07-11 13:00:00	AAPL	Stock	24.3425	24.3575	24.3175	24.325	3684772.0
2016-07-11 13:30:00	AAPL	Stock	24.3225	24.3238	24.2913	24.2975	4028756.0
2016-07-11 14:00:00	AAPL	Stock	24.3	24.315	24.2775	24.3078	3890108.0
2016-07-11 14:30:00	AAPL	Stock	24.3075	24.315	24.2775	24.29	2736220.0
2016-07-11 15:00:00	AAPL	Stock	24.29	24.305	24.265	24.265	3807080.0
2016-07-11 15:30:00	AAPL	Stock	24.2655	24.275	24.2325	24.245	10527100.0
2016-07-11 16:00:00	AAPL	Stock	24.245	24.3082	24.225	24.23	6698508.0
2016-07-11 16:30:00	AAPL	Stock	24.23	24.2425	24.23	24.2425	53320.0
2016-07-11 17:00:00	AAPL	Stock	24.2325	24.245	24.2325	24.245	20428.0
2016-07-11 17:30:00	AAPL	Stock	24.2425	24.245	24.2375	24.245	1690656.0
2016-07-11 18:00:00	AAPL	Stock	24.2325	24.2375	24.23	24.23	13960.0
2016-07-11 18:30:00	AAPL	Stock	24.2375	24.2425	24.235	24.235	12632.0
2016-07-11 19:00:00	AAPL	Stock	24.235	24.235	24.2275	24.2275	1228.0
2016-07-11 19:30:00	AAPL	Stock	24.2275	24.2425	24.2275	24.2275	27208.0
2016-07-11 05:30:00	MSFT	Stock	52.48	52.57	52.48	52.57	1100.0
2016-07-11 06:00:00	MSFT	Stock	52.57	52.57	52.47	52.47	800.0
2016-07-11 07:00:00	MSFT	Stock	52.34	52.34	52.34	52.34	102.0
2016-07-11 08:00:00	MSFT	Stock	52.35	52.49	52.34	52.45	4423.0
2016-07-11 08:30:00	MSFT	Stock	52.45	52.5	52.44	52.5	4822.0
2016-07-11 09:00:00	MSFT	Stock	52.5	52.83	52.46	52.49	66619.0
2016-07-11 09:30:00	MSFT	Stock	52.5	52.73	52.47	52.71	3055570.0
2016-07-11 10:00:00	MSFT	Stock	52.704	52.705	52.5	52.53	1453408.0
2016-07-11 10:30:00	MSFT	Stock	52.54	52.63	52.51	52.6	1420699.0
2016-07-11 11:00:00	MSFT	Stock	52.6	52.72	52.59	52.69	1230410.0
2016-07-11 11:30:00	MSFT	Stock	52.69	52.75	52.57	52.69	1398286.0
2016-07-11 12:00:00	MSFT	Stock	52.69	52.74	52.66	52.67	788042.0
2016-07-11 12:30:00	MSFT	Stock	52.67	52.83	52.67	52.795	804409.0
2016-07-11 13:00:00	MSFT	Stock	52.8	52.82	52.67	52.694	1078422.0
2016-07-11 13:30:00	MSFT	Stock	52.69	52.77	52.66	52.68	735635.0
2016-07-11 14:00:00	MSFT	Stock	52.69	52.765	52.65	52.715	945966.0
2016-07-11 14:30:00	MSFT	Stock	52.71	52.76	52.65	52.675	812224.0
2016-07-11 15:00:00	MSFT	Stock	52.67	52.79	52.66	52.74	1277178.0

> showing 50 of 82,939 rows — these rows as CSV

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