PREVIEW / stock_30min / 2020-05-05

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-05.parquet
  size:    1.9 MB
  rows:    93,793
  symbols: 2,363

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-05 04:00:00	AAPL	Stock	73.9	74.04	73.7775	73.995	21508.0
2020-05-05 04:30:00	AAPL	Stock	73.93	73.985	73.38	73.38	18444.0
2020-05-05 05:00:00	AAPL	Stock	73.38	73.575	73.3	73.5	18792.0
2020-05-05 05:30:00	AAPL	Stock	73.5	73.77	73.5	73.77	21332.0
2020-05-05 06:00:00	AAPL	Stock	73.775	73.785	73.7	73.7325	19056.0
2020-05-05 06:30:00	AAPL	Stock	73.725	73.8075	73.685	73.8075	25116.0
2020-05-05 07:00:00	AAPL	Stock	73.75	73.9025	73.7375	73.845	114696.0
2020-05-05 07:30:00	AAPL	Stock	73.85	74.0	73.835	73.96	91700.0
2020-05-05 08:00:00	AAPL	Stock	73.8	74.06	73.73	74.0295	271864.0
2020-05-05 08:30:00	AAPL	Stock	74.03	74.035	73.8765	73.95	141148.0
2020-05-05 09:00:00	AAPL	Stock	73.95	74.0375	73.75	73.7775	378536.0
2020-05-05 09:30:00	AAPL	Stock	73.7625	74.555	73.615	74.365	18292648.0
2020-05-05 10:00:00	AAPL	Stock	74.3675	74.5825	74.145	74.3575	9573216.0
2020-05-05 10:30:00	AAPL	Stock	74.3625	74.665	74.315	74.51	7404592.0
2020-05-05 11:00:00	AAPL	Stock	74.5125	74.7	74.3325	74.635	6598036.0
2020-05-05 11:30:00	AAPL	Stock	74.6325	74.7675	74.57	74.725	4906672.0
2020-05-05 12:00:00	AAPL	Stock	74.725	74.95	74.725	74.7638	8144096.0
2020-05-05 12:30:00	AAPL	Stock	74.765	74.875	74.6325	74.83	5241424.0
2020-05-05 13:00:00	AAPL	Stock	74.8275	74.9675	74.6675	74.935	5757508.0
2020-05-05 13:30:00	AAPL	Stock	74.9375	75.0	74.8225	74.9275	5256316.0
2020-05-05 14:00:00	AAPL	Stock	74.9325	75.1675	74.875	75.1675	8984188.0
2020-05-05 14:30:00	AAPL	Stock	75.1675	75.245	75.015	75.235	6519796.0
2020-05-05 15:00:00	AAPL	Stock	75.2325	75.25	74.6775	74.725	11085536.0
2020-05-05 15:30:00	AAPL	Stock	74.72	74.8175	74.26	74.445	17295480.0
2020-05-05 16:00:00	AAPL	Stock	74.39	74.475	74.2975	74.425	5850520.0
2020-05-05 16:30:00	AAPL	Stock	74.4125	74.425	74.29	74.415	107636.0
2020-05-05 17:00:00	AAPL	Stock	74.42	74.45	74.4075	74.4275	36632.0
2020-05-05 17:30:00	AAPL	Stock	74.4325	74.4625	74.3875	74.425	87400.0
2020-05-05 18:00:00	AAPL	Stock	74.4375	74.7525	74.405	74.61	81744.0
2020-05-05 18:30:00	AAPL	Stock	74.6375	74.7425	74.6	74.725	17176.0
2020-05-05 19:00:00	AAPL	Stock	74.725	74.725	74.65	74.715	17956.0
2020-05-05 19:30:00	AAPL	Stock	74.7175	74.795	74.7025	74.7225	61684.0
2020-05-05 04:00:00	MSFT	Stock	180.29	181.02	180.29	181.02	11491.0
2020-05-05 04:30:00	MSFT	Stock	181.01	181.01	180.0	180.06	40608.0
2020-05-05 05:00:00	MSFT	Stock	180.06	180.45	180.0	180.25	7013.0
2020-05-05 05:30:00	MSFT	Stock	180.47	180.61	180.44	180.6	3305.0
2020-05-05 06:00:00	MSFT	Stock	180.61	181.04	180.61	180.86	1888.0
2020-05-05 06:30:00	MSFT	Stock	180.82	180.99	180.61	180.85	3664.0
2020-05-05 07:00:00	MSFT	Stock	180.65	180.94	180.52	180.64	23083.0
2020-05-05 07:30:00	MSFT	Stock	180.7	181.0	180.62	180.9	30874.0
2020-05-05 08:00:00	MSFT	Stock	180.6	181.38	180.5	181.37	105518.0
2020-05-05 08:30:00	MSFT	Stock	181.38	181.478	181.05	181.29	91071.0
2020-05-05 09:00:00	MSFT	Stock	181.29	181.33	180.64	180.66	78960.0
2020-05-05 09:30:00	MSFT	Stock	180.62	181.75	180.03	181.4	4997025.0
2020-05-05 10:00:00	MSFT	Stock	181.41	181.85	181.01	181.59	2429628.0
2020-05-05 10:30:00	MSFT	Stock	181.61	181.79	181.3	181.51	1669258.0
2020-05-05 11:00:00	MSFT	Stock	181.53	182.0	181.22	181.86	1790571.0
2020-05-05 11:30:00	MSFT	Stock	181.862	182.329	181.5	182.315	1880421.0
2020-05-05 12:00:00	MSFT	Stock	182.31	182.68	182.05	182.08	1853689.0
2020-05-05 12:30:00	MSFT	Stock	182.09	182.74	182.078	182.42	1219714.0

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

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