PREVIEW / stock_30min / 2018-01-24

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-24.parquet
  size:    1.7 MB
  rows:    84,540
  symbols: 2,901

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-01-24 04:00:00	AAPL	Stock	44.3125	44.33	44.3125	44.33	2252.0
2018-01-24 04:30:00	AAPL	Stock	44.33	44.3875	44.3125	44.3625	23192.0
2018-01-24 05:00:00	AAPL	Stock	44.3575	44.3575	44.3575	44.3575	400.0
2018-01-24 06:00:00	AAPL	Stock	44.3275	44.3275	44.3275	44.3275	4800.0
2018-01-24 06:30:00	AAPL	Stock	44.37	44.37	44.3275	44.3275	5948.0
2018-01-24 07:00:00	AAPL	Stock	44.325	44.4	44.3175	44.3175	89508.0
2018-01-24 07:30:00	AAPL	Stock	44.3275	44.345	44.2775	44.3	184572.0
2018-01-24 08:00:00	AAPL	Stock	44.315	44.4425	44.25	44.4175	216568.0
2018-01-24 08:30:00	AAPL	Stock	44.4	44.495	44.3925	44.4375	218476.0
2018-01-24 09:00:00	AAPL	Stock	44.4275	44.4475	44.295	44.3125	462284.0
2018-01-24 09:30:00	AAPL	Stock	44.3125	44.325	43.695	43.9288	30827204.0
2018-01-24 10:00:00	AAPL	Stock	43.9275	43.97	43.7525	43.8138	14328604.0
2018-01-24 10:30:00	AAPL	Stock	43.815	43.895	43.721	43.7312	12757024.0
2018-01-24 11:00:00	AAPL	Stock	43.7278	43.85	43.665	43.7175	14005752.0
2018-01-24 11:30:00	AAPL	Stock	43.715	43.82	43.6275	43.7475	16559180.0
2018-01-24 12:00:00	AAPL	Stock	43.745	43.835	43.6775	43.7188	6972108.0
2018-01-24 12:30:00	AAPL	Stock	43.7188	43.725	43.5875	43.5925	9193796.0
2018-01-24 13:00:00	AAPL	Stock	43.5942	43.5975	43.3	43.4975	13536284.0
2018-01-24 13:30:00	AAPL	Stock	43.4975	43.6525	43.47	43.5475	7681896.0
2018-01-24 14:00:00	AAPL	Stock	43.55	43.5825	43.465	43.5725	6432052.0
2018-01-24 14:30:00	AAPL	Stock	43.575	43.6912	43.4825	43.585	8128708.0
2018-01-24 15:00:00	AAPL	Stock	43.5925	43.61	43.4525	43.5625	8376580.0
2018-01-24 15:30:00	AAPL	Stock	43.5625	43.62	43.495	43.555	12695464.0
2018-01-24 16:00:00	AAPL	Stock	43.5425	43.5875	43.535	43.575	21209424.0
2018-01-24 16:30:00	AAPL	Stock	43.575	43.585	43.555	43.5625	259484.0
2018-01-24 17:00:00	AAPL	Stock	43.5625	43.575	43.555	43.575	125852.0
2018-01-24 17:30:00	AAPL	Stock	43.5875	43.5875	43.5325	43.55	49680.0
2018-01-24 18:00:00	AAPL	Stock	43.55	43.55	43.4625	43.4625	96956.0
2018-01-24 18:30:00	AAPL	Stock	43.465	43.5075	43.465	43.4875	30804.0
2018-01-24 19:00:00	AAPL	Stock	43.4875	43.5	43.4875	43.5	9276.0
2018-01-24 19:30:00	AAPL	Stock	43.5	43.54	43.5	43.54	14200.0
2018-01-24 05:00:00	MSFT	Stock	92.28	92.28	92.28	92.28	348.0
2018-01-24 05:30:00	MSFT	Stock	92.29	92.29	92.29	92.29	219.0
2018-01-24 06:00:00	MSFT	Stock	92.29	92.29	92.21	92.21	300.0
2018-01-24 06:30:00	MSFT	Stock	92.21	92.21	92.21	92.21	1000.0
2018-01-24 07:00:00	MSFT	Stock	92.21	92.29	92.21	92.22	1195.0
2018-01-24 07:30:00	MSFT	Stock	92.3	92.35	92.28	92.3	11014.0
2018-01-24 08:00:00	MSFT	Stock	92.37	92.37	92.28	92.31	15429.0
2018-01-24 08:30:00	MSFT	Stock	92.31	92.4	92.31	92.4	21808.0
2018-01-24 09:00:00	MSFT	Stock	92.38	92.65	92.26	92.63	14041.0
2018-01-24 09:30:00	MSFT	Stock	92.43	93.17	92.19	93.15	2586267.0
2018-01-24 10:00:00	MSFT	Stock	93.155	93.43	93.01	93.21	1864947.0
2018-01-24 10:30:00	MSFT	Stock	93.21	93.3	92.9	93.0	1482125.0
2018-01-24 11:00:00	MSFT	Stock	93.005	93.08	92.48	92.71	1677116.0
2018-01-24 11:30:00	MSFT	Stock	92.71	92.8	92.21	92.605	2099931.0
2018-01-24 12:00:00	MSFT	Stock	92.605	92.76	92.44	92.585	1098005.0
2018-01-24 12:30:00	MSFT	Stock	92.58	92.6	92.145	92.22	2182131.0
2018-01-24 13:00:00	MSFT	Stock	92.21	92.26	91.58	91.87	1875260.0
2018-01-24 13:30:00	MSFT	Stock	91.869	92.28	91.836	92.075	1982430.0
2018-01-24 14:00:00	MSFT	Stock	92.08	92.275	91.995	92.27	1035222.0

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

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