PREVIEW / stock_30min / 2020-10-09

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-09.parquet
  size:    1.9 MB
  rows:    97,161
  symbols: 2,515

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-09 04:00:00	AAPL	Stock	115.56	115.58	115.22	115.33	12868.0
2020-10-09 04:30:00	AAPL	Stock	115.33	115.45	115.25	115.37	5864.0
2020-10-09 05:00:00	AAPL	Stock	115.37	115.48	115.35	115.45	13613.0
2020-10-09 05:30:00	AAPL	Stock	115.4	115.4	115.3	115.3	3688.0
2020-10-09 06:00:00	AAPL	Stock	115.29	115.34	115.24	115.33	8179.0
2020-10-09 06:30:00	AAPL	Stock	115.33	115.34	115.05	115.1	9458.0
2020-10-09 07:00:00	AAPL	Stock	115.15	115.4	115.05	115.28	94207.0
2020-10-09 07:30:00	AAPL	Stock	115.27	115.3	115.19	115.22	56465.0
2020-10-09 08:00:00	AAPL	Stock	115.14	115.48	115.07	115.34	253184.0
2020-10-09 08:30:00	AAPL	Stock	115.34	115.7	115.34	115.58	271584.0
2020-10-09 09:00:00	AAPL	Stock	115.56	115.56	115.12	115.23	288080.0
2020-10-09 09:30:00	AAPL	Stock	115.23	116.28	114.92	115.94	14716109.0
2020-10-09 10:00:00	AAPL	Stock	115.935	116.22	115.68	115.965	7247244.0
2020-10-09 10:30:00	AAPL	Stock	115.97	116.36	115.92	116.265	5942266.0
2020-10-09 11:00:00	AAPL	Stock	116.26	116.37	115.93	116.019	5192517.0
2020-10-09 11:30:00	AAPL	Stock	116.02	116.27	115.78	116.13	5438893.0
2020-10-09 12:00:00	AAPL	Stock	116.13	116.35	115.77	116.01	4666366.0
2020-10-09 12:30:00	AAPL	Stock	116.01	116.33	115.975	116.29	4359893.0
2020-10-09 13:00:00	AAPL	Stock	116.29	116.63	116.18	116.194	5415513.0
2020-10-09 13:30:00	AAPL	Stock	116.2	116.25	115.99	116.13	4173485.0
2020-10-09 14:00:00	AAPL	Stock	116.13	116.418	116.11	116.235	3715481.0
2020-10-09 14:30:00	AAPL	Stock	116.235	116.45	116.05	116.09	4733744.0
2020-10-09 15:00:00	AAPL	Stock	116.1	116.58	116.03	116.57	5129589.0
2020-10-09 15:30:00	AAPL	Stock	116.567	117.0	116.35	116.98	10465792.0
2020-10-09 16:00:00	AAPL	Stock	116.97	117.39	116.92	117.32	8706034.0
2020-10-09 16:30:00	AAPL	Stock	117.33	117.54	117.13	117.48	260363.0
2020-10-09 17:00:00	AAPL	Stock	117.47	117.55	117.39	117.54	166889.0
2020-10-09 17:30:00	AAPL	Stock	117.54	117.78	117.51	117.7	204759.0
2020-10-09 18:00:00	AAPL	Stock	117.7	117.8	117.55	117.78	147349.0
2020-10-09 18:30:00	AAPL	Stock	117.79	117.95	117.71	117.91	148414.0
2020-10-09 19:00:00	AAPL	Stock	117.92	118.0	117.9	117.99	137809.0
2020-10-09 19:30:00	AAPL	Stock	117.99	118.0	117.93	118.0	169637.0
2020-10-09 04:00:00	MSFT	Stock	211.29	211.29	211.29	211.29	400.0
2020-10-09 05:30:00	MSFT	Stock	211.0	211.0	211.0	211.0	400.0
2020-10-09 06:00:00	MSFT	Stock	211.0	211.0	211.0	211.0	393.0
2020-10-09 07:00:00	MSFT	Stock	211.0	211.25	211.0	211.25	3341.0
2020-10-09 07:30:00	MSFT	Stock	211.22	211.49	211.22	211.23	7541.0
2020-10-09 08:00:00	MSFT	Stock	211.25	211.47	210.58	211.15	11544.0
2020-10-09 08:30:00	MSFT	Stock	211.27	211.86	211.217	211.85	14374.0
2020-10-09 09:00:00	MSFT	Stock	211.868	211.95	211.12	211.12	17799.0
2020-10-09 09:30:00	MSFT	Stock	211.23	212.87	211.23	212.38	2402568.0
2020-10-09 10:00:00	MSFT	Stock	212.38	213.63	212.29	213.615	1689267.0
2020-10-09 10:30:00	MSFT	Stock	213.602	213.825	213.27	213.56	1352508.0
2020-10-09 11:00:00	MSFT	Stock	213.56	213.98	213.4	213.978	1053168.0
2020-10-09 11:30:00	MSFT	Stock	213.975	214.68	213.8	214.29	1911631.0
2020-10-09 12:00:00	MSFT	Stock	214.235	214.76	213.66	214.34	1151927.0
2020-10-09 12:30:00	MSFT	Stock	214.33	215.15	214.32	214.906	1446171.0
2020-10-09 13:00:00	MSFT	Stock	214.895	215.45	214.57	214.63	1215654.0
2020-10-09 13:30:00	MSFT	Stock	214.64	215.13	214.38	215.1	1094255.0
2020-10-09 14:00:00	MSFT	Stock	215.09	215.45	214.46	214.617	1191802.0

> showing 50 of 97,161 rows — these rows as CSV

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