PREVIEW / stock_30min / 2017-01-24

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-24.parquet
  size:    1.6 MB
  rows:    81,479
  symbols: 3,108

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-24 04:00:00	AAPL	Stock	29.875	29.875	29.8	29.8325	18000.0
2017-01-24 04:30:00	AAPL	Stock	29.8075	29.82	29.77	29.78	32296.0
2017-01-24 05:00:00	AAPL	Stock	29.8	29.8	29.8	29.8	3680.0
2017-01-24 05:30:00	AAPL	Stock	29.7725	29.7925	29.7275	29.75	24940.0
2017-01-24 06:00:00	AAPL	Stock	29.7825	29.8075	29.75	29.785	19444.0
2017-01-24 06:30:00	AAPL	Stock	29.7875	29.815	29.7875	29.8	70268.0
2017-01-24 07:00:00	AAPL	Stock	29.8275	29.8375	29.8125	29.815	100408.0
2017-01-24 07:30:00	AAPL	Stock	29.825	29.875	29.825	29.8425	74920.0
2017-01-24 08:00:00	AAPL	Stock	29.825	29.95	29.825	29.8825	207292.0
2017-01-24 08:30:00	AAPL	Stock	29.875	29.885	29.85	29.86	99080.0
2017-01-24 09:00:00	AAPL	Stock	29.8625	29.9175	29.8375	29.89	214988.0
2017-01-24 09:30:00	AAPL	Stock	29.8875	30.025	29.875	29.9962	15289664.0
2017-01-24 10:00:00	AAPL	Stock	29.9988	30.0065	29.9675	29.99	6761416.0
2017-01-24 10:30:00	AAPL	Stock	29.99	30.0075	29.9725	29.9838	6761904.0
2017-01-24 11:00:00	AAPL	Stock	29.9825	30.025	29.9825	29.9912	5046000.0
2017-01-24 11:30:00	AAPL	Stock	29.99	30.0125	29.985	29.995	3256896.0
2017-01-24 12:00:00	AAPL	Stock	29.9938	30.02	29.9875	30.0025	3258264.0
2017-01-24 12:30:00	AAPL	Stock	30.0025	30.0025	29.9675	29.99	3846516.0
2017-01-24 13:00:00	AAPL	Stock	29.99	30.015	29.985	30.0	3882984.0
2017-01-24 13:30:00	AAPL	Stock	29.9988	30.025	29.9975	30.0012	4696080.0
2017-01-24 14:00:00	AAPL	Stock	30.001	30.02	29.9875	29.9938	4872792.0
2017-01-24 14:30:00	AAPL	Stock	29.9925	30.0212	29.9888	30.0025	4573872.0
2017-01-24 15:00:00	AAPL	Stock	30.0048	30.02	29.995	30.005	5594708.0
2017-01-24 15:30:00	AAPL	Stock	30.005	30.01	29.975	29.9925	10346484.0
2017-01-24 16:00:00	AAPL	Stock	30.0025	30.0075	29.9775	30.005	6008760.0
2017-01-24 16:30:00	AAPL	Stock	30.0025	30.0075	29.9925	30.0075	141916.0
2017-01-24 17:00:00	AAPL	Stock	30.0075	30.0075	30.0	30.0	17108.0
2017-01-24 17:30:00	AAPL	Stock	29.9975	29.9975	29.9975	29.9975	8000.0
2017-01-24 18:00:00	AAPL	Stock	29.995	30.0	29.995	30.0	17536.0
2017-01-24 18:30:00	AAPL	Stock	29.995	29.995	29.995	29.995	2800.0
2017-01-24 19:00:00	AAPL	Stock	29.985	29.9975	29.985	29.99	6568.0
2017-01-24 19:30:00	AAPL	Stock	29.99	29.995	29.99	29.995	3768.0
2017-01-24 06:00:00	MSFT	Stock	63.15	63.15	63.15	63.15	159.0
2017-01-24 06:30:00	MSFT	Stock	63.15	63.15	63.15	63.15	159.0
2017-01-24 07:00:00	MSFT	Stock	63.1	63.1	63.1	63.1	100.0
2017-01-24 07:30:00	MSFT	Stock	63.08	63.12	63.08	63.12	1482.0
2017-01-24 08:00:00	MSFT	Stock	63.1	63.15	63.1	63.15	2535.0
2017-01-24 08:30:00	MSFT	Stock	63.13	63.15	63.1	63.12	3311.0
2017-01-24 09:00:00	MSFT	Stock	63.14	63.22	63.11	63.2	25607.0
2017-01-24 09:30:00	MSFT	Stock	63.2	63.28	62.94	63.03	3386594.0
2017-01-24 10:00:00	MSFT	Stock	63.02	63.138	63.01	63.08	1225926.0
2017-01-24 10:30:00	MSFT	Stock	63.08	63.11	63.03	63.079	1142572.0
2017-01-24 11:00:00	MSFT	Stock	63.075	63.13	63.04	63.114	857358.0
2017-01-24 11:30:00	MSFT	Stock	63.115	63.22	63.08	63.11	1123208.0
2017-01-24 12:00:00	MSFT	Stock	63.115	63.205	63.09	63.18	984385.0
2017-01-24 12:30:00	MSFT	Stock	63.18	63.19	63.13	63.157	752146.0
2017-01-24 13:00:00	MSFT	Stock	63.155	63.31	63.14	63.25	1372572.0
2017-01-24 13:30:00	MSFT	Stock	63.25	63.44	63.24	63.41	1366533.0
2017-01-24 14:00:00	MSFT	Stock	63.414	63.5	63.38	63.44	1393758.0
2017-01-24 14:30:00	MSFT	Stock	63.435	63.59	63.415	63.59	1465630.0

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

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