PREVIEW / stock_30min / 2020-05-21

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-21.parquet
  size:    1.9 MB
  rows:    93,787
  symbols: 2,364

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-05-21 04:00:00	AAPL	Stock	79.5325	79.5325	79.25	79.3225	18880.0
2020-05-21 04:30:00	AAPL	Stock	79.3	79.3475	79.19	79.3475	2464.0
2020-05-21 05:00:00	AAPL	Stock	79.4775	79.4925	79.47	79.4825	2684.0
2020-05-21 05:30:00	AAPL	Stock	79.3775	79.3775	79.3775	79.3775	804.0
2020-05-21 06:00:00	AAPL	Stock	79.3075	79.3825	79.29	79.3675	11992.0
2020-05-21 06:30:00	AAPL	Stock	79.4225	79.4425	79.4225	79.4425	1656.0
2020-05-21 07:00:00	AAPL	Stock	79.45	79.7125	79.415	79.675	88664.0
2020-05-21 07:30:00	AAPL	Stock	79.6825	79.7175	79.5875	79.605	59836.0
2020-05-21 08:00:00	AAPL	Stock	79.7125	79.7125	79.375	79.525	129896.0
2020-05-21 08:30:00	AAPL	Stock	79.5125	79.8725	79.5	79.6675	214612.0
2020-05-21 09:00:00	AAPL	Stock	79.6625	79.76	79.5	79.6675	198228.0
2020-05-21 09:30:00	AAPL	Stock	79.665	80.2225	79.635	79.915	14409128.0
2020-05-21 10:00:00	AAPL	Stock	79.9125	80.01	79.545	79.7568	7993404.0
2020-05-21 10:30:00	AAPL	Stock	79.7525	79.7525	79.2582	79.59	7365948.0
2020-05-21 11:00:00	AAPL	Stock	79.58	79.58	78.9675	79.225	6528276.0
2020-05-21 11:30:00	AAPL	Stock	79.22	79.415	79.1575	79.275	4546052.0
2020-05-21 12:00:00	AAPL	Stock	79.275	79.47	79.2575	79.3488	3446972.0
2020-05-21 12:30:00	AAPL	Stock	79.35	79.445	79.1575	79.4075	3950556.0
2020-05-21 13:00:00	AAPL	Stock	79.425	79.68	79.32	79.525	4862792.0
2020-05-21 13:30:00	AAPL	Stock	79.52	79.665	79.44	79.5942	3397796.0
2020-05-21 14:00:00	AAPL	Stock	79.595	79.7225	79.5575	79.7045	3529552.0
2020-05-21 14:30:00	AAPL	Stock	79.7075	79.765	79.2625	79.445	5065692.0
2020-05-21 15:00:00	AAPL	Stock	79.455	79.6675	79.425	79.465	4443124.0
2020-05-21 15:30:00	AAPL	Stock	79.4575	79.5825	79.145	79.235	7950916.0
2020-05-21 16:00:00	AAPL	Stock	79.2725	79.3125	79.05	79.1	5724956.0
2020-05-21 16:30:00	AAPL	Stock	79.1	79.2125	79.0775	79.1975	67456.0
2020-05-21 17:00:00	AAPL	Stock	79.1975	79.1975	79.15	79.1875	11440.0
2020-05-21 17:30:00	AAPL	Stock	79.1875	79.1875	79.125	79.1875	5792.0
2020-05-21 18:00:00	AAPL	Stock	79.1325	79.2725	79.125	79.2725	50384.0
2020-05-21 18:30:00	AAPL	Stock	79.3325	79.3325	79.25	79.29	10000.0
2020-05-21 19:00:00	AAPL	Stock	79.2975	79.375	79.295	79.3125	21156.0
2020-05-21 19:30:00	AAPL	Stock	79.3625	79.5	79.3625	79.5	23688.0
2020-05-21 04:00:00	MSFT	Stock	185.09	185.09	184.12	184.4	2933.0
2020-05-21 04:30:00	MSFT	Stock	184.36	184.36	184.33	184.33	537.0
2020-05-21 05:00:00	MSFT	Stock	184.38	184.38	184.38	184.38	135.0
2020-05-21 05:30:00	MSFT	Stock	184.78	184.78	184.78	184.78	100.0
2020-05-21 06:00:00	MSFT	Stock	184.5	184.69	184.5	184.69	1045.0
2020-05-21 06:30:00	MSFT	Stock	184.8	184.9	184.7	184.76	770.0
2020-05-21 07:00:00	MSFT	Stock	184.77	185.29	184.76	185.29	7728.0
2020-05-21 07:30:00	MSFT	Stock	185.15	185.15	184.85	184.85	6599.0
2020-05-21 08:00:00	MSFT	Stock	184.781	185.3	184.68	184.93	22303.0
2020-05-21 08:30:00	MSFT	Stock	184.93	185.7	184.76	185.34	51079.0
2020-05-21 09:00:00	MSFT	Stock	185.201	185.49	185.1	185.48	25727.0
2020-05-21 09:30:00	MSFT	Stock	185.39	186.67	185.39	185.89	3504540.0
2020-05-21 10:00:00	MSFT	Stock	185.89	186.082	185.29	185.39	1670552.0
2020-05-21 10:30:00	MSFT	Stock	185.39	185.55	184.47	185.27	1733926.0
2020-05-21 11:00:00	MSFT	Stock	185.28	185.28	184.185	184.515	1487406.0
2020-05-21 11:30:00	MSFT	Stock	184.52	185.19	184.44	184.82	1057567.0
2020-05-21 12:00:00	MSFT	Stock	184.805	185.45	184.805	184.992	1043186.0
2020-05-21 12:30:00	MSFT	Stock	184.99	185.04	184.42	184.5	1051653.0

> showing 50 of 93,787 rows — these rows as CSV

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