PREVIEW / etf_30min / 2024-03-25

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-25.parquet
  size:    787 KB
  rows:    31,641

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-03-25 04:00:00	SPY	ETF	520.85	521.25	520.85	521.15	13509.0
2024-03-25 04:30:00	SPY	ETF	521.22	521.38	521.07	521.1	5525.0
2024-03-25 05:00:00	SPY	ETF	521.08	521.13	520.74	520.74	10029.0
2024-03-25 05:30:00	SPY	ETF	520.72	520.78	520.28	520.3	5111.0
2024-03-25 06:00:00	SPY	ETF	520.28	520.42	520.06	520.21	10414.0
2024-03-25 06:30:00	SPY	ETF	520.23	520.23	520.03	520.08	13537.0
2024-03-25 07:00:00	SPY	ETF	520.13	520.13	519.52	519.65	38081.0
2024-03-25 07:30:00	SPY	ETF	519.65	519.8	519.39	519.66	65508.0
2024-03-25 08:00:00	SPY	ETF	519.79	521.12	519.49	519.9	65907.0
2024-03-25 08:30:00	SPY	ETF	519.92	519.98	519.64	519.89	54077.0
2024-03-25 09:00:00	SPY	ETF	519.8897	520.02	519.66	519.78	142892.0
2024-03-25 09:30:00	SPY	ETF	519.79	520.41	519.61	520.3	4113556.0
2024-03-25 10:00:00	SPY	ETF	520.28	520.89	520.06	520.437	2620167.0
2024-03-25 10:30:00	SPY	ETF	520.44	520.65	520.14	520.64	2014040.0
2024-03-25 11:00:00	SPY	ETF	520.65	520.8	520.3799	520.62	1813905.0
2024-03-25 11:30:00	SPY	ETF	520.62	520.86	520.4099	520.595	1445598.0
2024-03-25 12:00:00	SPY	ETF	520.59	520.7	520.28	520.5	1827495.0
2024-03-25 12:30:00	SPY	ETF	520.5	520.6	520.23	520.43	1422426.0
2024-03-25 13:00:00	SPY	ETF	520.44	520.58	520.13	520.515	1572590.0
2024-03-25 13:30:00	SPY	ETF	520.52	520.705	520.43	520.66	1434252.0
2024-03-25 14:00:00	SPY	ETF	520.67	520.92	520.56	520.85	1335455.0
2024-03-25 14:30:00	SPY	ETF	520.85	520.95	520.65	520.81	1105488.0
2024-03-25 15:00:00	SPY	ETF	520.82	520.83	520.17	520.295	2095178.0
2024-03-25 15:30:00	SPY	ETF	520.29	520.7	519.67	519.81	8948977.0
2024-03-25 16:00:00	SPY	ETF	519.81	520.06	519.77	519.96	3944043.0
2024-03-25 16:30:00	SPY	ETF	519.97	520.13	519.94	520.11	323470.0
2024-03-25 17:00:00	SPY	ETF	520.11	520.13	520.01	520.13	87397.0
2024-03-25 17:30:00	SPY	ETF	520.1286	520.13	520.09	520.13	3533.0
2024-03-25 18:00:00	SPY	ETF	520.14	520.4503	519.77	520.43	73649.0
2024-03-25 18:30:00	SPY	ETF	520.4	520.4	520.31	520.319	19279.0
2024-03-25 19:00:00	SPY	ETF	520.37	520.37	520.24	520.3394	6828.0
2024-03-25 19:30:00	SPY	ETF	520.34	520.53	520.34	520.47	8765.0
2024-03-25 04:00:00	QQQ	ETF	445.65	445.99	445.49	445.77	37463.0
2024-03-25 04:30:00	QQQ	ETF	445.83	446.04	445.72	445.88	15027.0
2024-03-25 05:00:00	QQQ	ETF	445.8	445.8	445.43	445.53	11820.0
2024-03-25 05:30:00	QQQ	ETF	445.71	445.71	445.03	445.16	14006.0
2024-03-25 06:00:00	QQQ	ETF	445.1	445.25	444.78	444.85	21939.0
2024-03-25 06:30:00	QQQ	ETF	444.82	444.94	444.47	444.55	32338.0
2024-03-25 07:00:00	QQQ	ETF	444.59	444.63	443.53	443.71	79743.0
2024-03-25 07:30:00	QQQ	ETF	443.68	443.93	443.6	443.83	60829.0
2024-03-25 08:00:00	QQQ	ETF	443.83	446.714	443.51	444.12	107300.0
2024-03-25 08:30:00	QQQ	ETF	444.17	444.23	443.79	443.99	71612.0
2024-03-25 09:00:00	QQQ	ETF	443.98	444.11	443.53	443.5404	63033.0
2024-03-25 09:30:00	QQQ	ETF	443.55	444.27	442.54	444.07	3615044.0
2024-03-25 10:00:00	QQQ	ETF	444.05	445.56	443.78	444.87	2163153.0
2024-03-25 10:30:00	QQQ	ETF	444.87	445.25	444.54	445.09	1598432.0
2024-03-25 11:00:00	QQQ	ETF	445.09	445.56	444.93	445.2345	1318118.0
2024-03-25 11:30:00	QQQ	ETF	445.26	445.83	444.99	445.465	1443624.0
2024-03-25 12:00:00	QQQ	ETF	445.46	445.48	444.84	445.1495	964897.0
2024-03-25 12:30:00	QQQ	ETF	445.15	445.49	444.82	445.25	838926.0

> showing 50 of 31,641 rows — these rows as CSV

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