PREVIEW / stock_30min / 2020-08-06

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-06.parquet
  size:    2.0 MB
  rows:    98,485
  symbols: 2,419

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-08-06 04:00:00	AAPL	Stock	110.05	110.05	109.7825	109.9	7392.0
2020-08-06 04:30:00	AAPL	Stock	109.8275	109.875	109.815	109.875	3604.0
2020-08-06 05:00:00	AAPL	Stock	109.85	109.8525	109.825	109.825	7712.0
2020-08-06 05:30:00	AAPL	Stock	109.8525	109.95	109.8325	109.95	13260.0
2020-08-06 06:00:00	AAPL	Stock	109.9975	109.9975	109.7	109.7525	5872.0
2020-08-06 06:30:00	AAPL	Stock	109.69	109.7275	109.6	109.65	20440.0
2020-08-06 07:00:00	AAPL	Stock	109.7	109.85	109.58	109.8175	96128.0
2020-08-06 07:30:00	AAPL	Stock	109.85	109.875	109.65	109.8475	74240.0
2020-08-06 08:00:00	AAPL	Stock	109.843	109.875	109.625	109.8325	210960.0
2020-08-06 08:30:00	AAPL	Stock	109.855	110.4212	109.845	110.355	627868.0
2020-08-06 09:00:00	AAPL	Stock	110.3718	110.515	110.175	110.4625	350288.0
2020-08-06 09:30:00	AAPL	Stock	110.405	111.2275	109.7975	111.06	17554268.0
2020-08-06 10:00:00	AAPL	Stock	111.055	111.45	110.9525	111.129	11540120.0
2020-08-06 10:30:00	AAPL	Stock	111.13	111.415	110.6	111.085	9445368.0
2020-08-06 11:00:00	AAPL	Stock	111.0625	111.5325	111.0625	111.2375	7634764.0
2020-08-06 11:30:00	AAPL	Stock	111.2325	111.7475	111.1375	111.5538	6769452.0
2020-08-06 12:00:00	AAPL	Stock	111.556	111.9875	111.5188	111.915	7191096.0
2020-08-06 12:30:00	AAPL	Stock	111.91	112.425	111.7325	112.3675	8759272.0
2020-08-06 13:00:00	AAPL	Stock	112.3712	112.425	111.87	112.295	7293524.0
2020-08-06 13:30:00	AAPL	Stock	112.2975	112.98	112.22	112.9425	11331952.0
2020-08-06 14:00:00	AAPL	Stock	112.9462	113.3675	112.5875	113.275	10153896.0
2020-08-06 14:30:00	AAPL	Stock	113.2675	114.0125	113.24	113.926	15930472.0
2020-08-06 15:00:00	AAPL	Stock	113.9375	114.4125	113.505	114.2838	17930116.0
2020-08-06 15:30:00	AAPL	Stock	114.2925	114.3458	113.4525	113.97	20997320.0
2020-08-06 16:00:00	AAPL	Stock	113.9525	113.9525	113.64	113.755	7950884.0
2020-08-06 16:30:00	AAPL	Stock	113.75	113.9125	113.685	113.9125	162344.0
2020-08-06 17:00:00	AAPL	Stock	113.9225	114.15	113.91	114.145	180864.0
2020-08-06 17:30:00	AAPL	Stock	114.15	114.1975	114.1	114.125	63304.0
2020-08-06 18:00:00	AAPL	Stock	114.1425	114.1925	114.0325	114.1375	81444.0
2020-08-06 18:30:00	AAPL	Stock	114.1275	114.195	114.125	114.175	39392.0
2020-08-06 19:00:00	AAPL	Stock	114.125	114.185	114.05	114.1275	71988.0
2020-08-06 19:30:00	AAPL	Stock	114.1475	114.275	114.1275	114.25	100252.0
2020-08-06 04:00:00	MSFT	Stock	212.6	212.6	212.1	212.1	1303.0
2020-08-06 04:30:00	MSFT	Stock	212.05	212.05	211.99	211.99	500.0
2020-08-06 05:00:00	MSFT	Stock	211.9	212.0	211.89	212.0	2595.0
2020-08-06 05:30:00	MSFT	Stock	211.99	211.99	211.7	211.86	658.0
2020-08-06 06:00:00	MSFT	Stock	211.93	211.93	211.93	211.93	149.0
2020-08-06 06:30:00	MSFT	Stock	211.91	212.0	211.65	211.75	3544.0
2020-08-06 07:00:00	MSFT	Stock	211.9	211.94	211.74	211.94	7233.0
2020-08-06 07:30:00	MSFT	Stock	211.98	212.0	211.7	211.95	10681.0
2020-08-06 08:00:00	MSFT	Stock	211.799	212.19	211.68	212.15	33290.0
2020-08-06 08:30:00	MSFT	Stock	212.21	212.88	212.07	212.63	37289.0
2020-08-06 09:00:00	MSFT	Stock	212.648	212.648	212.38	212.38	31059.0
2020-08-06 09:30:00	MSFT	Stock	212.39	212.93	211.55	212.81	2522404.0
2020-08-06 10:00:00	MSFT	Stock	212.815	213.95	212.6	213.26	1826911.0
2020-08-06 10:30:00	MSFT	Stock	213.26	213.45	212.08	212.88	1559182.0
2020-08-06 11:00:00	MSFT	Stock	212.87	214.55	212.72	213.265	2972900.0
2020-08-06 11:30:00	MSFT	Stock	213.25	213.71	212.67	213.07	1568990.0
2020-08-06 12:00:00	MSFT	Stock	213.08	213.54	212.8	213.11	1219195.0
2020-08-06 12:30:00	MSFT	Stock	213.106	214.0	212.91	213.97	1156358.0

> showing 50 of 98,485 rows — these rows as CSV

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