PREVIEW / stock_30min / 2017-01-26

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-26.parquet
  size:    1.6 MB
  rows:    81,774
  symbols: 3,124

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
2017-01-26 04:00:00	AAPL	Stock	30.5	30.5	30.5	30.5	400.0
2017-01-26 04:30:00	AAPL	Stock	30.515	30.515	30.515	30.515	784.0
2017-01-26 05:00:00	AAPL	Stock	30.52	30.52	30.52	30.52	460.0
2017-01-26 06:00:00	AAPL	Stock	30.5025	30.5025	30.4825	30.4825	1376.0
2017-01-26 06:30:00	AAPL	Stock	30.4825	30.495	30.4825	30.4825	2488.0
2017-01-26 07:00:00	AAPL	Stock	30.4925	30.495	30.4875	30.495	3332.0
2017-01-26 07:30:00	AAPL	Stock	30.5	30.5	30.4575	30.4575	8960.0
2017-01-26 08:00:00	AAPL	Stock	30.495	30.51	30.4	30.445	51648.0
2017-01-26 08:30:00	AAPL	Stock	30.4375	30.45	30.415	30.45	49028.0
2017-01-26 09:00:00	AAPL	Stock	30.45	30.4625	30.415	30.425	136916.0
2017-01-26 09:30:00	AAPL	Stock	30.4425	30.61	30.4175	30.5062	14742220.0
2017-01-26 10:00:00	AAPL	Stock	30.5075	30.53	30.4125	30.4255	7846700.0
2017-01-26 10:30:00	AAPL	Stock	30.425	30.4775	30.425	30.455	5017208.0
2017-01-26 11:00:00	AAPL	Stock	30.4575	30.4725	30.4	30.4285	5520732.0
2017-01-26 11:30:00	AAPL	Stock	30.4288	30.4825	30.42	30.455	4168240.0
2017-01-26 12:00:00	AAPL	Stock	30.455	30.5075	30.4125	30.45	5456716.0
2017-01-26 12:30:00	AAPL	Stock	30.45	30.4875	30.445	30.4725	2778428.0
2017-01-26 13:00:00	AAPL	Stock	30.475	30.5	30.465	30.4725	3861280.0
2017-01-26 13:30:00	AAPL	Stock	30.4725	30.5	30.465	30.4975	2868524.0
2017-01-26 14:00:00	AAPL	Stock	30.4975	30.53	30.495	30.5175	5018136.0
2017-01-26 14:30:00	AAPL	Stock	30.5175	30.5238	30.4725	30.4872	3883424.0
2017-01-26 15:00:00	AAPL	Stock	30.4862	30.515	30.485	30.495	3667928.0
2017-01-26 15:30:00	AAPL	Stock	30.495	30.515	30.4675	30.485	9480636.0
2017-01-26 16:00:00	AAPL	Stock	30.5	30.525	30.4675	30.5125	12980700.0
2017-01-26 16:30:00	AAPL	Stock	30.49	30.5225	30.475	30.49	103756.0
2017-01-26 17:00:00	AAPL	Stock	30.49	30.5	30.4775	30.4875	43196.0
2017-01-26 17:30:00	AAPL	Stock	30.4875	30.5125	30.4875	30.49	12332.0
2017-01-26 18:00:00	AAPL	Stock	30.49	30.49	30.4675	30.4675	32032.0
2017-01-26 18:30:00	AAPL	Stock	30.46	30.46	30.4575	30.4575	2236.0
2017-01-26 19:00:00	AAPL	Stock	30.495	30.495	30.4575	30.4575	15544.0
2017-01-26 19:30:00	AAPL	Stock	30.48	30.48	30.48	30.48	1616.0
2017-01-26 04:00:00	MSFT	Stock	64.01	64.01	64.01	64.01	1095.0
2017-01-26 04:30:00	MSFT	Stock	64.09	64.09	64.09	64.09	200.0
2017-01-26 05:00:00	MSFT	Stock	64.19	64.19	64.19	64.19	414.0
2017-01-26 06:00:00	MSFT	Stock	64.1	64.2	64.1	64.15	697.0
2017-01-26 07:00:00	MSFT	Stock	64.15	64.18	64.04	64.04	5301.0
2017-01-26 07:30:00	MSFT	Stock	64.04	64.12	64.0	64.1	7270.0
2017-01-26 08:00:00	MSFT	Stock	64.07	64.19	63.95	63.99	34294.0
2017-01-26 08:30:00	MSFT	Stock	64.0	64.05	63.94	64.05	27148.0
2017-01-26 09:00:00	MSFT	Stock	64.05	64.14	64.02	64.12	21191.0
2017-01-26 09:30:00	MSFT	Stock	64.12	64.34	63.55	63.81	4939718.0
2017-01-26 10:00:00	MSFT	Stock	63.82	63.99	63.638	63.7	2486125.0
2017-01-26 10:30:00	MSFT	Stock	63.704	63.83	63.66	63.73	1322359.0
2017-01-26 11:00:00	MSFT	Stock	63.74	63.93	63.705	63.885	1370401.0
2017-01-26 11:30:00	MSFT	Stock	63.886	64.05	63.824	63.93	1770686.0
2017-01-26 12:00:00	MSFT	Stock	63.93	64.26	63.86	64.25	2444004.0
2017-01-26 12:30:00	MSFT	Stock	64.245	64.27	64.16	64.225	2271124.0
2017-01-26 13:00:00	MSFT	Stock	64.227	64.24	64.03	64.05	1545822.0
2017-01-26 13:30:00	MSFT	Stock	64.051	64.11	63.97	64.11	1348731.0
2017-01-26 14:00:00	MSFT	Stock	64.11	64.535	64.1	64.48	2890962.0

> showing 50 of 81,774 rows — these rows as CSV

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