PREVIEW / stock_30min / 2021-06-09

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-06-09.parquet
  size:    2.3 MB
  rows:    113,917
  symbols: 2,974

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
2021-06-09 04:00:00	AAPL	Stock	126.5	127.25	126.5	126.96	10075.0
2021-06-09 04:30:00	AAPL	Stock	126.97	127.0	126.97	126.97	2605.0
2021-06-09 05:00:00	AAPL	Stock	127.01	127.01	126.88	126.91	1889.0
2021-06-09 05:30:00	AAPL	Stock	126.99	127.04	126.96	126.96	2062.0
2021-06-09 06:00:00	AAPL	Stock	127.0	127.03	126.83	126.83	4027.0
2021-06-09 06:30:00	AAPL	Stock	126.82	127.11	126.82	127.11	1203.0
2021-06-09 07:00:00	AAPL	Stock	127.1	127.26	127.0	127.19	28800.0
2021-06-09 07:30:00	AAPL	Stock	127.17	127.17	126.95	127.09	51978.0
2021-06-09 08:00:00	AAPL	Stock	127.19	127.26	126.424	126.88	208530.0
2021-06-09 08:30:00	AAPL	Stock	126.86	127.24	126.84	127.16	109076.0
2021-06-09 09:00:00	AAPL	Stock	127.16	127.24	126.85	127.18	110537.0
2021-06-09 09:30:00	AAPL	Stock	127.18	127.75	126.64	126.9	8328036.0
2021-06-09 10:00:00	AAPL	Stock	126.9	127.11	126.52	127.099	4526267.0
2021-06-09 10:30:00	AAPL	Stock	127.1	127.295	126.8	127.2	3876851.0
2021-06-09 11:00:00	AAPL	Stock	127.1978	127.34	127.0601	127.12	2828239.0
2021-06-09 11:30:00	AAPL	Stock	127.118	127.15	126.8203	126.95	2523026.0
2021-06-09 12:00:00	AAPL	Stock	126.94	127.15	126.8999	127.125	1943772.0
2021-06-09 12:30:00	AAPL	Stock	127.13	127.2368	127.1	127.1488	1824927.0
2021-06-09 13:00:00	AAPL	Stock	127.15	127.28	127.11	127.22	1537655.0
2021-06-09 13:30:00	AAPL	Stock	127.215	127.26	127.06	127.12	1511337.0
2021-06-09 14:00:00	AAPL	Stock	127.13	127.25	127.07	127.2399	1595190.0
2021-06-09 14:30:00	AAPL	Stock	127.2388	127.3	127.14	127.16	2275232.0
2021-06-09 15:00:00	AAPL	Stock	127.155	127.24	126.925	126.925	2432523.0
2021-06-09 15:30:00	AAPL	Stock	126.93	127.205	126.74	127.16	6112063.0
2021-06-09 16:00:00	AAPL	Stock	127.13	127.13	127.02	127.05	7710336.0
2021-06-09 16:30:00	AAPL	Stock	127.04	127.05	126.95	126.97	44587.0
2021-06-09 17:00:00	AAPL	Stock	126.97	127.13	126.88	126.91	37920.0
2021-06-09 17:30:00	AAPL	Stock	126.92	127.13	126.92	126.95	14881.0
2021-06-09 18:00:00	AAPL	Stock	126.9401	127.06	126.94	127.05	14050.0
2021-06-09 18:30:00	AAPL	Stock	127.05	127.13	127.04	127.05	48348.0
2021-06-09 19:00:00	AAPL	Stock	127.04	127.05	126.96	127.03	8334.0
2021-06-09 19:30:00	AAPL	Stock	127.02	127.08	126.98	126.98	17514.0
2021-06-09 04:00:00	MSFT	Stock	253.24	253.24	252.8	252.8	1040.0
2021-06-09 04:30:00	MSFT	Stock	253.28	253.28	253.28	253.28	118.0
2021-06-09 05:00:00	MSFT	Stock	253.0	253.0	253.0	253.0	600.0
2021-06-09 05:30:00	MSFT	Stock	253.03	253.03	253.0	253.0	1022.0
2021-06-09 06:00:00	MSFT	Stock	253.09	253.09	253.09	253.09	472.0
2021-06-09 06:30:00	MSFT	Stock	253.12	253.33	253.12	253.33	206.0
2021-06-09 07:00:00	MSFT	Stock	253.31	253.45	253.24	253.26	5300.0
2021-06-09 07:30:00	MSFT	Stock	253.24	253.28	253.0	253.28	4092.0
2021-06-09 08:00:00	MSFT	Stock	253.11	253.44	253.08	253.1	9683.0
2021-06-09 08:30:00	MSFT	Stock	253.24	253.75	253.15	253.46	7818.0
2021-06-09 09:00:00	MSFT	Stock	253.55	254.21	253.4	254.18	18435.0
2021-06-09 09:30:00	MSFT	Stock	254.0	255.53	253.41	254.74	2131336.0
2021-06-09 10:00:00	MSFT	Stock	254.75	254.88	253.21	253.935	1156207.0
2021-06-09 10:30:00	MSFT	Stock	253.95	254.45	253.8	253.9	873150.0
2021-06-09 11:00:00	MSFT	Stock	253.885	254.92	253.82	254.85	840511.0
2021-06-09 11:30:00	MSFT	Stock	254.85	254.855	254.0	254.21	630459.0
2021-06-09 12:00:00	MSFT	Stock	254.205	254.8	254.1614	254.745	638918.0
2021-06-09 12:30:00	MSFT	Stock	254.75	255.13	254.4899	255.11	638648.0

> showing 50 of 113,917 rows — these rows as CSV

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