PREVIEW / etf_30min / 2023-01-24

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-24.parquet
  size:    681 KB
  rows:    27,559

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
2023-01-24 04:00:00	SPY	ETF	400.18	400.51	400.15	400.35	11759.0
2023-01-24 04:30:00	SPY	ETF	400.3	400.34	399.95	400.08	26260.0
2023-01-24 05:00:00	SPY	ETF	400.1	400.13	399.71	399.78	9410.0
2023-01-24 05:30:00	SPY	ETF	399.71	400.01	399.61	400.0	19882.0
2023-01-24 06:00:00	SPY	ETF	400.04	400.04	399.47	399.53	20599.0
2023-01-24 06:30:00	SPY	ETF	399.5	399.95	399.45	399.77	17680.0
2023-01-24 07:00:00	SPY	ETF	399.75	399.76	399.4	399.68	34541.0
2023-01-24 07:30:00	SPY	ETF	399.63	399.83	399.38	399.66	62989.0
2023-01-24 08:00:00	SPY	ETF	399.6	400.85	399.38	399.62	147907.0
2023-01-24 08:30:00	SPY	ETF	399.78	399.78	398.43	398.82	588256.0
2023-01-24 09:00:00	SPY	ETF	398.76	399.07	398.47	398.92	215468.0
2023-01-24 09:30:00	SPY	ETF	398.88	400.15	397.98	398.376	6058785.0
2023-01-24 10:00:00	SPY	ETF	398.39	399.99	397.64	399.3	4482608.0
2023-01-24 10:30:00	SPY	ETF	399.28	400.75	398.42	400.49	3549213.0
2023-01-24 11:00:00	SPY	ETF	400.5	400.712	399.71	400.66	3300847.0
2023-01-24 11:30:00	SPY	ETF	400.67	400.7	399.848	400.05	2386252.0
2023-01-24 12:00:00	SPY	ETF	400.03	400.54	399.22	400.31	2043791.0
2023-01-24 12:30:00	SPY	ETF	400.3	400.33	399.74	400.04	1674499.0
2023-01-24 13:00:00	SPY	ETF	400.04	400.59	399.4407	400.49	2396889.0
2023-01-24 13:30:00	SPY	ETF	400.47	401.15	400.3	400.78	2544812.0
2023-01-24 14:00:00	SPY	ETF	400.77	400.83	399.95	400.41	2083364.0
2023-01-24 14:30:00	SPY	ETF	400.41	401.005	400.38	400.87	2466059.0
2023-01-24 15:00:00	SPY	ETF	400.87	401.06	400.31	400.55	1936211.0
2023-01-24 15:30:00	SPY	ETF	400.55	400.65	399.29	400.17	5420448.0
2023-01-24 16:00:00	SPY	ETF	400.18	401.81	399.98	401.07	2690059.0
2023-01-24 16:30:00	SPY	ETF	401.06	401.39	400.92	400.95	378173.0
2023-01-24 17:00:00	SPY	ETF	401.08	401.11	400.92	401.04	114296.0
2023-01-24 17:30:00	SPY	ETF	401.02	401.08	400.67	400.88	72063.0
2023-01-24 18:00:00	SPY	ETF	400.88	401.04	398.92	398.97	223718.0
2023-01-24 18:30:00	SPY	ETF	398.99	399.1	398.59	398.89	171418.0
2023-01-24 19:00:00	SPY	ETF	398.94	399.12	398.83	399.0	26729.0
2023-01-24 19:30:00	SPY	ETF	398.9	398.9	398.24	398.54	223422.0
2023-01-24 04:00:00	QQQ	ETF	288.88	289.0	288.51	288.52	33563.0
2023-01-24 04:30:00	QQQ	ETF	288.56	288.64	288.3	288.4	61820.0
2023-01-24 05:00:00	QQQ	ETF	288.45	288.45	288.01	288.07	26773.0
2023-01-24 05:30:00	QQQ	ETF	288.05	288.29	287.96	288.23	6733.0
2023-01-24 06:00:00	QQQ	ETF	288.24	288.24	287.75	287.75	30710.0
2023-01-24 06:30:00	QQQ	ETF	287.8	288.12	287.73	287.86	52447.0
2023-01-24 07:00:00	QQQ	ETF	287.86	288.01	287.68	288.01	32406.0
2023-01-24 07:30:00	QQQ	ETF	287.9	288.0	287.61	287.79	28364.0
2023-01-24 08:00:00	QQQ	ETF	287.89	289.176	287.55	287.82	159684.0
2023-01-24 08:30:00	QQQ	ETF	287.83	287.94	286.73	287.04	314727.0
2023-01-24 09:00:00	QQQ	ETF	287.04	287.32	286.9	287.3	406414.0
2023-01-24 09:30:00	QQQ	ETF	287.31	289.55	286.84	287.88	5063426.0
2023-01-24 10:00:00	QQQ	ETF	287.91	289.15	286.78	288.2299	3481860.0
2023-01-24 10:30:00	QQQ	ETF	288.245	289.29	287.22	289.03	2197574.0
2023-01-24 11:00:00	QQQ	ETF	289.04	289.19	288.23	289.166	1659140.0
2023-01-24 11:30:00	QQQ	ETF	289.17	289.194	288.421	288.6801	1247870.0
2023-01-24 12:00:00	QQQ	ETF	288.67	289.17	287.95	288.898	1227889.0
2023-01-24 12:30:00	QQQ	ETF	288.855	288.86	288.01	288.25	1388640.0

> showing 50 of 27,559 rows — these rows as CSV

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