PREVIEW / stock_30min / 2020-02-07

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-07.parquet
  size:    1.8 MB
  rows:    85,825
  symbols: 2,425

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-02-07 04:00:00	AAPL	Stock	81.2225	81.2225	81.0425	81.0425	50196.0
2020-02-07 04:30:00	AAPL	Stock	81.0325	81.0325	80.925	80.95	82404.0
2020-02-07 05:00:00	AAPL	Stock	80.8775	80.8775	80.7875	80.87	101620.0
2020-02-07 05:30:00	AAPL	Stock	80.875	80.875	80.6275	80.6775	39848.0
2020-02-07 06:00:00	AAPL	Stock	80.68	80.7625	80.5525	80.76	46804.0
2020-02-07 06:30:00	AAPL	Stock	80.7875	80.875	80.6775	80.875	33512.0
2020-02-07 07:00:00	AAPL	Stock	80.845	81.0	80.7525	80.85	141324.0
2020-02-07 07:30:00	AAPL	Stock	80.8525	80.975	80.8375	80.95	123644.0
2020-02-07 08:00:00	AAPL	Stock	80.975	81.0	80.7875	80.9625	277716.0
2020-02-07 08:30:00	AAPL	Stock	80.9775	81.1	80.6875	80.7925	491732.0
2020-02-07 09:00:00	AAPL	Stock	80.7928	80.8875	80.5325	80.565	355676.0
2020-02-07 09:30:00	AAPL	Stock	80.5925	80.6825	80.1625	80.3025	16875936.0
2020-02-07 10:00:00	AAPL	Stock	80.295	80.617	80.11	80.555	10094072.0
2020-02-07 10:30:00	AAPL	Stock	80.555	80.83	80.555	80.5942	7356268.0
2020-02-07 11:00:00	AAPL	Stock	80.5938	80.7832	80.4375	80.74	5033144.0
2020-02-07 11:30:00	AAPL	Stock	80.74	80.85	80.605	80.71	3914540.0
2020-02-07 12:00:00	AAPL	Stock	80.7125	80.85	80.68	80.81	2796984.0
2020-02-07 12:30:00	AAPL	Stock	80.8075	80.8195	80.6425	80.6475	2651648.0
2020-02-07 13:00:00	AAPL	Stock	80.645	80.6875	80.47	80.5558	3191188.0
2020-02-07 13:30:00	AAPL	Stock	80.5575	80.62	79.75	80.185	4097392.0
2020-02-07 14:00:00	AAPL	Stock	80.1825	80.2525	79.5825	79.902	9855284.0
2020-02-07 14:30:00	AAPL	Stock	79.895	80.06	79.7612	79.8925	5469404.0
2020-02-07 15:00:00	AAPL	Stock	79.89	79.9625	79.5	79.5755	6548968.0
2020-02-07 15:30:00	AAPL	Stock	79.5775	80.015	79.53	80.01	11579800.0
2020-02-07 16:00:00	AAPL	Stock	80.0075	80.0075	79.95	79.9925	5695524.0
2020-02-07 16:30:00	AAPL	Stock	79.9975	80.0075	79.9875	79.99	114340.0
2020-02-07 17:00:00	AAPL	Stock	79.995	80.0075	79.995	80.0025	95304.0
2020-02-07 17:30:00	AAPL	Stock	79.9975	79.9975	79.9125	79.9125	58368.0
2020-02-07 18:00:00	AAPL	Stock	79.92	79.92	79.8775	79.88	51192.0
2020-02-07 18:30:00	AAPL	Stock	79.875	79.8875	79.8375	79.84	61632.0
2020-02-07 19:00:00	AAPL	Stock	79.8375	79.92	79.825	79.8725	76944.0
2020-02-07 19:30:00	AAPL	Stock	79.85	79.8725	79.75	79.8725	51716.0
2020-02-07 04:00:00	MSFT	Stock	183.49	183.5	183.31	183.31	4572.0
2020-02-07 04:30:00	MSFT	Stock	183.3	183.3	183.0	183.0	4203.0
2020-02-07 05:00:00	MSFT	Stock	182.91	183.0	182.68	182.91	2663.0
2020-02-07 05:30:00	MSFT	Stock	182.99	183.0	182.88	182.88	1350.0
2020-02-07 06:00:00	MSFT	Stock	182.68	183.0	182.5	182.88	4500.0
2020-02-07 06:30:00	MSFT	Stock	182.88	183.0	182.8	183.0	1694.0
2020-02-07 07:00:00	MSFT	Stock	182.95	183.08	182.8	183.0	23525.0
2020-02-07 07:30:00	MSFT	Stock	183.17	183.17	182.9	183.0	7432.0
2020-02-07 08:00:00	MSFT	Stock	182.87	183.35	182.78	183.32	20077.0
2020-02-07 08:30:00	MSFT	Stock	183.43	183.7	182.72	183.05	53159.0
2020-02-07 09:00:00	MSFT	Stock	182.9	183.63	182.789	182.87	662237.0
2020-02-07 09:30:00	MSFT	Stock	182.87	184.78	182.48	183.926	3865094.0
2020-02-07 10:00:00	MSFT	Stock	183.92	185.29	183.41	185.14	2679111.0
2020-02-07 10:30:00	MSFT	Stock	185.15	185.36	184.74	184.843	1710280.0
2020-02-07 11:00:00	MSFT	Stock	184.845	185.28	184.65	185.26	1358285.0
2020-02-07 11:30:00	MSFT	Stock	185.26	185.63	185.13	185.42	1490518.0
2020-02-07 12:00:00	MSFT	Stock	185.415	185.457	185.14	185.245	943767.0
2020-02-07 12:30:00	MSFT	Stock	185.245	185.26	184.9	185.15	963707.0

> showing 50 of 85,825 rows — these rows as CSV

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