PREVIEW / etf_30min / 2022-05-10

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-10.parquet
  size:    703 KB
  rows:    28,354

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
2022-05-10 04:00:00	SPY	ETF	400.73	402.51	400.73	402.51	54440.0
2022-05-10 04:30:00	SPY	ETF	402.52	402.7	402.31	402.58	8919.0
2022-05-10 05:00:00	SPY	ETF	402.6	402.99	402.41	402.46	37970.0
2022-05-10 05:30:00	SPY	ETF	402.5	402.89	401.35	401.48	55108.0
2022-05-10 06:00:00	SPY	ETF	401.69	402.13	401.3	401.98	47665.0
2022-05-10 06:30:00	SPY	ETF	401.91	402.4	401.27	401.28	85109.0
2022-05-10 07:00:00	SPY	ETF	401.21	401.46	400.17	400.7	131823.0
2022-05-10 07:30:00	SPY	ETF	400.6	401.25	400.5	401.2	298997.0
2022-05-10 08:00:00	SPY	ETF	401.23	402.77	396.9549	402.23	784941.0
2022-05-10 08:30:00	SPY	ETF	402.16	404.05	401.98	403.85	625861.0
2022-05-10 09:00:00	SPY	ETF	403.87	404.54	403.87	404.49	836865.0
2022-05-10 09:30:00	SPY	ETF	404.49	406.08	401.85	404.14	10399172.0
2022-05-10 10:00:00	SPY	ETF	404.16	405.04	401.86	402.455	6031136.0
2022-05-10 10:30:00	SPY	ETF	402.51	402.79	398.34	398.95	7108179.0
2022-05-10 11:00:00	SPY	ETF	398.95	399.86	395.9	397.3361	8837644.0
2022-05-10 11:30:00	SPY	ETF	397.39	398.98	395.77	397.41	6483300.0
2022-05-10 12:00:00	SPY	ETF	397.4	398.5	396.02	396.39	4996934.0
2022-05-10 12:30:00	SPY	ETF	396.37	397.65	394.82	395.95	5347849.0
2022-05-10 13:00:00	SPY	ETF	395.94	398.57	395.63	398.52	5244082.0
2022-05-10 13:30:00	SPY	ETF	398.49	403.14	398.49	403.07	7187572.0
2022-05-10 14:00:00	SPY	ETF	403.1	403.26	399.88	400.7052	6654524.0
2022-05-10 14:30:00	SPY	ETF	400.7	402.32	399.97	401.33	4954195.0
2022-05-10 15:00:00	SPY	ETF	401.32	402.78	399.37	399.77	5476191.0
2022-05-10 15:30:00	SPY	ETF	399.77	399.79	398.08	399.07	14779511.0
2022-05-10 16:00:00	SPY	ETF	399.07	400.71	398.26	399.16	4107570.0
2022-05-10 16:30:00	SPY	ETF	399.14	399.25	398.31	398.7	223146.0
2022-05-10 17:00:00	SPY	ETF	398.52	398.81	398.5124	398.67	45610.0
2022-05-10 17:30:00	SPY	ETF	398.7	398.75	398.57	398.68	56023.0
2022-05-10 18:00:00	SPY	ETF	398.65	398.75	398.43	398.64	83677.0
2022-05-10 18:30:00	SPY	ETF	398.75	399.3	398.7	399.17	109427.0
2022-05-10 19:00:00	SPY	ETF	399.15	399.38	398.98	399.06	103348.0
2022-05-10 19:30:00	SPY	ETF	399.09	399.17	398.21	398.66	63414.0
2022-05-10 04:00:00	QQQ	ETF	300.12	302.1	300.12	301.89	115488.0
2022-05-10 04:30:00	QQQ	ETF	302.17	302.36	301.8	301.94	84757.0
2022-05-10 05:00:00	QQQ	ETF	301.9	302.28	301.77	302.0	90554.0
2022-05-10 05:30:00	QQQ	ETF	301.95	302.65	301.04	301.12	117866.0
2022-05-10 06:00:00	QQQ	ETF	301.01	301.51	300.85	301.37	97831.0
2022-05-10 06:30:00	QQQ	ETF	301.48	301.95	300.7	300.71	139450.0
2022-05-10 07:00:00	QQQ	ETF	300.65	300.87	299.64	300.13	218752.0
2022-05-10 07:30:00	QQQ	ETF	300.1	300.79	299.95	300.69	253737.0
2022-05-10 08:00:00	QQQ	ETF	300.18	302.3	299.47	301.93	928819.0
2022-05-10 08:30:00	QQQ	ETF	301.91	304.0	301.83	303.83	1446530.0
2022-05-10 09:00:00	QQQ	ETF	303.81	305.03	303.48	304.54	1442167.0
2022-05-10 09:30:00	QQQ	ETF	304.5	305.76	300.62	303.7	12083808.0
2022-05-10 10:00:00	QQQ	ETF	303.69	305.49	302.13	302.8129	8814085.0
2022-05-10 10:30:00	QQQ	ETF	302.86	303.41	298.67	298.98	7441992.0
2022-05-10 11:00:00	QQQ	ETF	298.97	299.91	296.57	297.97	7970203.0
2022-05-10 11:30:00	QQQ	ETF	298.02	300.05	296.92	298.99	6218033.0
2022-05-10 12:00:00	QQQ	ETF	298.98	300.16	298.01	298.45	4940421.0
2022-05-10 12:30:00	QQQ	ETF	298.4263	299.9114	297.12	298.045	4800434.0

> showing 50 of 28,354 rows — these rows as CSV

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