PREVIEW / etf_30min / 2024-07-03

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-03.parquet
  size:    552 KB
  rows:    20,849

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
2024-07-03 04:00:00	SPY	ETF	548.71	548.97	548.66	548.86	6151.0
2024-07-03 04:30:00	SPY	ETF	548.9	549.41	548.9	549.29	7767.0
2024-07-03 05:00:00	SPY	ETF	549.19	549.24	549.14	549.19	3195.0
2024-07-03 05:30:00	SPY	ETF	549.25	549.32	549.15	549.26	7264.0
2024-07-03 06:00:00	SPY	ETF	549.23	549.32	549.09	549.32	24040.0
2024-07-03 06:30:00	SPY	ETF	549.3	549.36	549.22	549.24	7116.0
2024-07-03 07:00:00	SPY	ETF	549.17	549.3	549.0	549.0	29176.0
2024-07-03 07:30:00	SPY	ETF	549.07	549.11	548.91	549.1	61905.0
2024-07-03 08:00:00	SPY	ETF	549.24	549.3	548.47	548.58	137541.0
2024-07-03 08:30:00	SPY	ETF	548.73	548.73	548.27	548.44	101853.0
2024-07-03 09:00:00	SPY	ETF	548.43	548.75	548.39	548.68	62894.0
2024-07-03 09:30:00	SPY	ETF	548.68	549.63	548.65	549.58	2788633.0
2024-07-03 10:00:00	SPY	ETF	549.58	550.11	548.88	549.18	2661983.0
2024-07-03 10:30:00	SPY	ETF	549.16	549.93	549.09	549.8105	1583448.0
2024-07-03 11:00:00	SPY	ETF	549.81	550.49	549.48	550.03	1767684.0
2024-07-03 11:30:00	SPY	ETF	550.03	550.42	549.8701	550.385	1253996.0
2024-07-03 12:00:00	SPY	ETF	550.39	551.185	550.32	551.1399	2204446.0
2024-07-03 12:30:00	SPY	ETF	551.13	551.83	550.57	551.38	6071524.0
2024-07-03 13:00:00	SPY	ETF	551.38	551.6224	551.0301	551.1	2115949.0
2024-07-03 13:30:00	SPY	ETF	551.2	551.3	550.85	550.91	174845.0
2024-07-03 14:00:00	SPY	ETF	550.87	551.2	550.51	551.17	152843.0
2024-07-03 14:30:00	SPY	ETF	551.2	551.25	551.05	551.16	19785.0
2024-07-03 15:00:00	SPY	ETF	551.16	551.16	550.99	551.1	15342.0
2024-07-03 15:30:00	SPY	ETF	551.15	551.15	550.86	550.86	14655.0
2024-07-03 16:00:00	SPY	ETF	550.86	551.31	550.5	551.3	41005.0
2024-07-03 16:30:00	SPY	ETF	551.1	551.24	551.07	551.14	2277.0
2024-07-03 04:00:00	QQQ	ETF	486.75	487.19	486.6	487.19	27716.0
2024-07-03 04:30:00	QQQ	ETF	487.14	487.74	487.14	487.55	29383.0
2024-07-03 05:00:00	QQQ	ETF	487.4	487.48	487.24	487.3	12274.0
2024-07-03 05:30:00	QQQ	ETF	487.3	487.62	487.2	487.46	16557.0
2024-07-03 06:00:00	QQQ	ETF	487.36	487.5	487.28	487.48	7567.0
2024-07-03 06:30:00	QQQ	ETF	487.48	487.51	487.18	487.18	25435.0
2024-07-03 07:00:00	QQQ	ETF	487.15	487.33	486.91	487.02	43642.0
2024-07-03 07:30:00	QQQ	ETF	487.07	487.07	486.75	487.06	41272.0
2024-07-03 08:00:00	QQQ	ETF	487.07	487.6596	486.41	486.54	108052.0
2024-07-03 08:30:00	QQQ	ETF	486.54	486.7	485.96	486.25	122981.0
2024-07-03 09:00:00	QQQ	ETF	486.27	486.48	486.02	486.25	112065.0
2024-07-03 09:30:00	QQQ	ETF	486.22	487.86	486.2	487.69	2187034.0
2024-07-03 10:00:00	QQQ	ETF	487.69	488.2	486.7	487.3	1839802.0
2024-07-03 10:30:00	QQQ	ETF	487.29	488.75	487.0897	488.555	1337102.0
2024-07-03 11:00:00	QQQ	ETF	488.57	489.57	488.0701	489.32	1333424.0
2024-07-03 11:30:00	QQQ	ETF	489.34	490.19	488.92	490.13	1138873.0
2024-07-03 12:00:00	QQQ	ETF	490.11	491.17	490.04	491.165	1409418.0
2024-07-03 12:30:00	QQQ	ETF	491.16	491.17	489.89	491.01	3553689.0
2024-07-03 13:00:00	QQQ	ETF	491.01	491.45	490.8	490.84	764469.0
2024-07-03 13:30:00	QQQ	ETF	490.84	491.02	490.58	490.98	96788.0
2024-07-03 14:00:00	QQQ	ETF	490.98	491.1	490.8	490.8	58748.0
2024-07-03 14:30:00	QQQ	ETF	490.78	490.95	490.78	490.9001	3614.0
2024-07-03 15:00:00	QQQ	ETF	490.9601	491.09	490.82	491.04	17316.0
2024-07-03 15:30:00	QQQ	ETF	491.0	491.03	490.47	490.47	15821.0

> showing 50 of 20,849 rows — these rows as CSV

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