PREVIEW / stock_30min / 2020-06-17

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-17.parquet
  size:    1.9 MB
  rows:    97,981
  symbols: 2,437

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
2020-06-17 04:00:00	AAPL	Stock	88.445	88.71	88.445	88.68	16516.0
2020-06-17 04:30:00	AAPL	Stock	88.74	88.7625	88.7	88.75	34516.0
2020-06-17 05:00:00	AAPL	Stock	88.75	88.8025	88.5625	88.5625	10688.0
2020-06-17 05:30:00	AAPL	Stock	88.5325	88.5325	88.27	88.3	8336.0
2020-06-17 06:00:00	AAPL	Stock	88.265	88.6	88.265	88.6	12508.0
2020-06-17 06:30:00	AAPL	Stock	88.695	88.72	88.6075	88.6075	6728.0
2020-06-17 07:00:00	AAPL	Stock	88.625	88.9375	88.5	88.89	339584.0
2020-06-17 07:30:00	AAPL	Stock	88.8625	89.0	88.7525	88.9275	206772.0
2020-06-17 08:00:00	AAPL	Stock	88.8	89.0	88.4325	88.8775	427112.0
2020-06-17 08:30:00	AAPL	Stock	88.875	88.9	88.7525	88.819	241020.0
2020-06-17 09:00:00	AAPL	Stock	88.8195	88.9625	88.6875	88.79	245732.0
2020-06-17 09:30:00	AAPL	Stock	88.79	88.85	88.205	88.4625	16770544.0
2020-06-17 10:00:00	AAPL	Stock	88.4675	88.6525	88.0825	88.2925	9753564.0
2020-06-17 10:30:00	AAPL	Stock	88.3112	88.6725	88.156	88.5975	5628664.0
2020-06-17 11:00:00	AAPL	Stock	88.59	88.6425	88.239	88.38	5017404.0
2020-06-17 11:30:00	AAPL	Stock	88.38	88.625	88.28	88.617	4598396.0
2020-06-17 12:00:00	AAPL	Stock	88.62	88.7725	88.5525	88.601	5198080.0
2020-06-17 12:30:00	AAPL	Stock	88.5975	88.7875	88.585	88.705	3674464.0
2020-06-17 13:00:00	AAPL	Stock	88.71	88.8	88.6675	88.7312	3522052.0
2020-06-17 13:30:00	AAPL	Stock	88.73	88.8125	88.595	88.6	3358984.0
2020-06-17 14:00:00	AAPL	Stock	88.605	88.755	88.56	88.7025	3775712.0
2020-06-17 14:30:00	AAPL	Stock	88.7	88.77	88.4912	88.52	3690828.0
2020-06-17 15:00:00	AAPL	Stock	88.5	88.5325	88.02	88.14	6661380.0
2020-06-17 15:30:00	AAPL	Stock	88.1425	88.3125	87.7725	87.811	10968680.0
2020-06-17 16:00:00	AAPL	Stock	87.8975	87.98	87.8275	87.96	6671896.0
2020-06-17 16:30:00	AAPL	Stock	87.955	88.0225	87.9	88.0225	82400.0
2020-06-17 17:00:00	AAPL	Stock	88.02	88.02	87.8875	87.945	62700.0
2020-06-17 17:30:00	AAPL	Stock	87.9375	87.94	87.855	87.855	23164.0
2020-06-17 18:00:00	AAPL	Stock	87.855	87.9125	87.8175	87.85	17116.0
2020-06-17 18:30:00	AAPL	Stock	87.8975	88.025	87.875	87.9375	57076.0
2020-06-17 19:00:00	AAPL	Stock	87.9925	88.0	87.7875	87.7875	60356.0
2020-06-17 19:30:00	AAPL	Stock	87.78	87.79	87.5	87.575	75540.0
2020-06-17 04:00:00	MSFT	Stock	194.07	194.96	194.07	194.96	2627.0
2020-06-17 04:30:00	MSFT	Stock	194.94	195.17	194.94	195.17	365.0
2020-06-17 05:00:00	MSFT	Stock	194.8	194.8	194.5	194.5	472.0
2020-06-17 05:30:00	MSFT	Stock	194.91	194.91	194.04	194.04	1951.0
2020-06-17 06:00:00	MSFT	Stock	194.11	194.97	194.11	194.72	3536.0
2020-06-17 06:30:00	MSFT	Stock	194.91	195.36	194.91	195.0	5485.0
2020-06-17 07:00:00	MSFT	Stock	194.8	195.1	194.63	195.08	9505.0
2020-06-17 07:30:00	MSFT	Stock	195.07	195.25	194.5	195.0	33152.0
2020-06-17 08:00:00	MSFT	Stock	194.81	195.23	194.52	194.802	29483.0
2020-06-17 08:30:00	MSFT	Stock	194.97	194.97	194.512	194.8	14456.0
2020-06-17 09:00:00	MSFT	Stock	194.8	195.09	194.26	195.09	26194.0
2020-06-17 09:30:00	MSFT	Stock	195.09	195.62	194.34	194.67	3252156.0
2020-06-17 10:00:00	MSFT	Stock	194.69	194.9	193.69	194.21	2237602.0
2020-06-17 10:30:00	MSFT	Stock	194.24	195.15	193.95	195.01	1242443.0
2020-06-17 11:00:00	MSFT	Stock	195.01	195.52	194.84	195.16	1433318.0
2020-06-17 11:30:00	MSFT	Stock	195.14	195.46	194.883	195.28	807836.0
2020-06-17 12:00:00	MSFT	Stock	195.3	195.39	194.96	195.29	845947.0
2020-06-17 12:30:00	MSFT	Stock	195.28	195.93	195.25	195.823	1096292.0

> showing 50 of 97,981 rows — these rows as CSV

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