PREVIEW / stock_30min / 2020-10-20

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-20.parquet
  size:    1.9 MB
  rows:    96,651
  symbols: 2,487

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-10-20 04:00:00	AAPL	Stock	117.5	118.35	117.25	117.43	47016.0
2020-10-20 04:30:00	AAPL	Stock	117.38	117.5	117.24	117.25	13008.0
2020-10-20 05:00:00	AAPL	Stock	117.27	117.4	117.18	117.2	22054.0
2020-10-20 05:30:00	AAPL	Stock	117.17	117.34	117.09	117.2	7833.0
2020-10-20 06:00:00	AAPL	Stock	117.18	117.43	117.1	117.4	15649.0
2020-10-20 06:30:00	AAPL	Stock	117.49	117.6	117.34	117.37	40384.0
2020-10-20 07:00:00	AAPL	Stock	117.35	117.5	117.09	117.18	152792.0
2020-10-20 07:30:00	AAPL	Stock	117.18	117.19	116.95	117.06	140861.0
2020-10-20 08:00:00	AAPL	Stock	117.42	117.47	116.26	116.55	558234.0
2020-10-20 08:30:00	AAPL	Stock	116.55	116.89	116.46	116.55	272405.0
2020-10-20 09:00:00	AAPL	Stock	116.532	116.58	116.12	116.21	404172.0
2020-10-20 09:30:00	AAPL	Stock	116.23	117.07	115.63	117.05	13770076.0
2020-10-20 10:00:00	AAPL	Stock	117.03	117.62	116.77	116.875	9863754.0
2020-10-20 10:30:00	AAPL	Stock	116.881	117.28	116.21	116.41	6555075.0
2020-10-20 11:00:00	AAPL	Stock	116.41	117.02	115.93	116.72	7685460.0
2020-10-20 11:30:00	AAPL	Stock	116.73	117.19	116.405	117.17	5636853.0
2020-10-20 12:00:00	AAPL	Stock	117.16	117.55	117.0	117.38	4518499.0
2020-10-20 12:30:00	AAPL	Stock	117.38	118.51	117.24	118.175	10259329.0
2020-10-20 13:00:00	AAPL	Stock	118.173	118.7	118.1	118.53	5950150.0
2020-10-20 13:30:00	AAPL	Stock	118.524	118.98	118.13	118.31	7249316.0
2020-10-20 14:00:00	AAPL	Stock	118.305	118.54	117.75	118.06	7557436.0
2020-10-20 14:30:00	AAPL	Stock	118.06	118.34	117.73	117.98	4994304.0
2020-10-20 15:00:00	AAPL	Stock	117.99	118.42	116.94	117.61	10233297.0
2020-10-20 15:30:00	AAPL	Stock	117.62	118.19	117.16	117.5	9540037.0
2020-10-20 16:00:00	AAPL	Stock	117.5	117.7	117.25	117.47	8862594.0
2020-10-20 16:30:00	AAPL	Stock	117.45	117.54	116.95	117.21	292003.0
2020-10-20 17:00:00	AAPL	Stock	117.24	117.5	117.18	117.44	52662.0
2020-10-20 17:30:00	AAPL	Stock	117.44	117.5	117.4	117.5	29916.0
2020-10-20 18:00:00	AAPL	Stock	117.48	117.9	117.48	117.55	117593.0
2020-10-20 18:30:00	AAPL	Stock	117.6	117.74	117.58	117.74	108712.0
2020-10-20 19:00:00	AAPL	Stock	117.74	118.0	117.69	117.91	127538.0
2020-10-20 19:30:00	AAPL	Stock	117.9	117.93	117.8	117.83	92424.0
2020-10-20 04:00:00	MSFT	Stock	216.2	216.5	216.2	216.28	1606.0
2020-10-20 04:30:00	MSFT	Stock	216.3	216.3	216.13	216.13	480.0
2020-10-20 05:00:00	MSFT	Stock	216.14	216.14	216.14	216.14	150.0
2020-10-20 05:30:00	MSFT	Stock	216.13	216.2	216.13	216.2	399.0
2020-10-20 06:00:00	MSFT	Stock	216.4	217.32	216.4	217.32	2174.0
2020-10-20 06:30:00	MSFT	Stock	217.66	217.66	217.01	217.01	2377.0
2020-10-20 07:00:00	MSFT	Stock	216.78	216.98	216.18	216.18	16965.0
2020-10-20 07:30:00	MSFT	Stock	216.19	216.44	216.19	216.37	20326.0
2020-10-20 08:00:00	MSFT	Stock	216.75	216.9	215.0	215.25	47497.0
2020-10-20 08:30:00	MSFT	Stock	215.399	215.8	215.34	215.72	12842.0
2020-10-20 09:00:00	MSFT	Stock	215.57	215.978	215.155	215.81	21759.0
2020-10-20 09:30:00	MSFT	Stock	215.77	216.71	214.67	216.71	1790927.0
2020-10-20 10:00:00	MSFT	Stock	216.63	217.37	215.67	216.0	1264323.0
2020-10-20 10:30:00	MSFT	Stock	216.005	216.45	214.0	214.04	1413625.0
2020-10-20 11:00:00	MSFT	Stock	214.02	214.83	213.09	214.33	1538879.0
2020-10-20 11:30:00	MSFT	Stock	214.348	215.1	213.95	214.93	976113.0
2020-10-20 12:00:00	MSFT	Stock	214.92	215.42	214.72	214.85	803328.0
2020-10-20 12:30:00	MSFT	Stock	214.86	216.05	214.32	215.33	1294261.0

> showing 50 of 96,651 rows — these rows as CSV

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