PREVIEW / stock_30min / 2018-05-09

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-09.parquet
  size:    1.7 MB
  rows:    84,165
  symbols: 2,868

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
2018-05-09 04:30:00	AAPL	Stock	46.59	46.6125	46.59	46.6125	10400.0
2018-05-09 05:00:00	AAPL	Stock	46.61	46.6725	46.61	46.65	27104.0
2018-05-09 05:30:00	AAPL	Stock	46.635	46.6475	46.635	46.635	1224.0
2018-05-09 06:00:00	AAPL	Stock	46.6	46.6	46.575	46.575	2532.0
2018-05-09 06:30:00	AAPL	Stock	46.5775	46.5875	46.5775	46.5875	800.0
2018-05-09 07:00:00	AAPL	Stock	46.5975	46.6825	46.5925	46.6375	80532.0
2018-05-09 07:30:00	AAPL	Stock	46.625	46.695	46.625	46.6375	143424.0
2018-05-09 08:00:00	AAPL	Stock	46.6338	46.6875	46.61	46.6525	183988.0
2018-05-09 08:30:00	AAPL	Stock	46.665	46.6675	46.6175	46.6175	118304.0
2018-05-09 09:00:00	AAPL	Stock	46.615	46.645	46.5875	46.645	122164.0
2018-05-09 09:30:00	AAPL	Stock	46.645	46.675	46.415	46.4275	12238268.0
2018-05-09 10:00:00	AAPL	Stock	46.4288	46.5325	46.365	46.3775	7083032.0
2018-05-09 10:30:00	AAPL	Stock	46.3775	46.4875	46.305	46.3725	5444368.0
2018-05-09 11:00:00	AAPL	Stock	46.375	46.4988	46.34	46.45	4336220.0
2018-05-09 11:30:00	AAPL	Stock	46.4525	46.48	46.405	46.475	3238388.0
2018-05-09 12:00:00	AAPL	Stock	46.4775	46.5522	46.4175	46.5325	4352872.0
2018-05-09 12:30:00	AAPL	Stock	46.535	46.6123	46.49	46.5625	4409596.0
2018-05-09 13:00:00	AAPL	Stock	46.5625	46.64	46.5225	46.62	4097968.0
2018-05-09 13:30:00	AAPL	Stock	46.62	46.71	46.6125	46.705	4438884.0
2018-05-09 14:00:00	AAPL	Stock	46.7048	46.7475	46.63	46.675	4377620.0
2018-05-09 14:30:00	AAPL	Stock	46.67	46.7475	46.6525	46.74	3832936.0
2018-05-09 15:00:00	AAPL	Stock	46.735	46.8075	46.725	46.7825	6170716.0
2018-05-09 15:30:00	AAPL	Stock	46.7825	46.85	46.74	46.8375	11589412.0
2018-05-09 16:00:00	AAPL	Stock	46.84	46.8775	46.6268	46.85	6985664.0
2018-05-09 16:30:00	AAPL	Stock	46.85	46.875	46.84	46.8675	19856.0
2018-05-09 17:00:00	AAPL	Stock	46.855	46.875	46.8425	46.8725	31876.0
2018-05-09 17:30:00	AAPL	Stock	46.865	46.8725	46.8525	46.865	47244.0
2018-05-09 18:00:00	AAPL	Stock	46.8675	46.875	46.86	46.8625	29576.0
2018-05-09 18:30:00	AAPL	Stock	46.8725	46.8725	46.86	46.8675	18600.0
2018-05-09 19:00:00	AAPL	Stock	46.8575	46.8725	46.855	46.855	22804.0
2018-05-09 19:30:00	AAPL	Stock	46.85	46.875	46.85	46.87	25372.0
2018-05-09 05:30:00	MSFT	Stock	95.76	95.76	95.7	95.7	485.0
2018-05-09 07:00:00	MSFT	Stock	96.15	96.15	96.15	96.15	400.0
2018-05-09 07:30:00	MSFT	Stock	96.24	96.24	96.15	96.15	1738.0
2018-05-09 08:00:00	MSFT	Stock	96.25	96.25	96.0	96.15	16727.0
2018-05-09 08:30:00	MSFT	Stock	96.15	96.15	96.0	96.07	7090.0
2018-05-09 09:00:00	MSFT	Stock	96.05	96.096	96.05	96.05	2325.0
2018-05-09 09:30:00	MSFT	Stock	96.0	96.383	95.43	95.5	2345580.0
2018-05-09 10:00:00	MSFT	Stock	95.505	96.02	95.4	95.7	1453352.0
2018-05-09 10:30:00	MSFT	Stock	95.7	95.74	95.11	95.24	1428509.0
2018-05-09 11:00:00	MSFT	Stock	95.24	95.57	95.05	95.49	1228665.0
2018-05-09 11:30:00	MSFT	Stock	95.5	95.59	95.39	95.494	896445.0
2018-05-09 12:00:00	MSFT	Stock	95.5	96.015	95.484	95.97	1079271.0
2018-05-09 12:30:00	MSFT	Stock	95.97	96.25	95.94	96.19	1815990.0
2018-05-09 13:00:00	MSFT	Stock	96.19	96.505	96.16	96.49	1222250.0
2018-05-09 13:30:00	MSFT	Stock	96.495	96.94	96.465	96.72	1251629.0
2018-05-09 14:00:00	MSFT	Stock	96.71	96.9	96.535	96.58	908505.0
2018-05-09 14:30:00	MSFT	Stock	96.58	96.85	96.576	96.79	860380.0
2018-05-09 15:00:00	MSFT	Stock	96.79	96.83	96.61	96.655	958928.0
2018-05-09 15:30:00	MSFT	Stock	96.651	96.97	96.58	96.95	2750572.0

> showing 50 of 84,165 rows — these rows as CSV

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