PREVIEW / etf_30min / 2024-08-13

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-13.parquet
  size:    823 KB
  rows:    32,708

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-08-13 04:00:00	SPY	ETF	535.12	535.73	535.0	535.17	6442.0
2024-08-13 04:30:00	SPY	ETF	535.11	535.23	534.9	535.18	5556.0
2024-08-13 05:00:00	SPY	ETF	535.06	535.25	534.9	535.25	4786.0
2024-08-13 05:30:00	SPY	ETF	535.41	535.6	535.38	535.39	2917.0
2024-08-13 06:00:00	SPY	ETF	535.28	535.28	533.95	533.95	44294.0
2024-08-13 06:30:00	SPY	ETF	533.84	534.06	533.29	533.45	21688.0
2024-08-13 07:00:00	SPY	ETF	533.32	534.15	533.32	534.0	149722.0
2024-08-13 07:30:00	SPY	ETF	534.02	534.53	533.99	534.53	65900.0
2024-08-13 08:00:00	SPY	ETF	533.69	535.99	533.43	535.43	204587.0
2024-08-13 08:30:00	SPY	ETF	535.5	537.02	534.9	536.49	938106.0
2024-08-13 09:00:00	SPY	ETF	536.58	536.71	535.6	536.59	695235.0
2024-08-13 09:30:00	SPY	ETF	536.53	538.45	536.28	537.78	4047783.0
2024-08-13 10:00:00	SPY	ETF	537.79	537.93	536.58	537.48	2387347.0
2024-08-13 10:30:00	SPY	ETF	537.46	538.54	536.33	538.33	1381076.0
2024-08-13 11:00:00	SPY	ETF	538.35	538.98	538.17	538.68	1197643.0
2024-08-13 11:30:00	SPY	ETF	538.68	539.2894	538.51	539.0	960225.0
2024-08-13 12:00:00	SPY	ETF	539.01	540.175	538.73	539.69	1655604.0
2024-08-13 12:30:00	SPY	ETF	539.7	541.12	539.27	541.03	1815812.0
2024-08-13 13:00:00	SPY	ETF	541.04	541.04	540.54	540.745	1226704.0
2024-08-13 13:30:00	SPY	ETF	540.75	541.02	539.48	540.72	1610234.0
2024-08-13 14:00:00	SPY	ETF	540.73	541.03	540.28	540.92	1218585.0
2024-08-13 14:30:00	SPY	ETF	540.92	541.48	540.8	541.42	1405959.0
2024-08-13 15:00:00	SPY	ETF	541.41	541.6897	540.61	541.2099	2226184.0
2024-08-13 15:30:00	SPY	ETF	541.2	542.28	540.94	542.0	8022117.0
2024-08-13 16:00:00	SPY	ETF	542.0	542.08	541.58	541.63	3546832.0
2024-08-13 16:30:00	SPY	ETF	541.61	542.02	541.47	541.7	574250.0
2024-08-13 17:00:00	SPY	ETF	541.7	542.0	541.38	541.57	91590.0
2024-08-13 17:30:00	SPY	ETF	541.63	541.87	541.51	541.87	8197.0
2024-08-13 18:00:00	SPY	ETF	541.86	542.04	541.41	541.7481	92017.0
2024-08-13 18:30:00	SPY	ETF	541.65	541.7	541.6	541.65	3157.0
2024-08-13 19:00:00	SPY	ETF	541.65	541.95	541.59	541.9291	3513.0
2024-08-13 19:30:00	SPY	ETF	541.89	542.0081	541.7927	541.94	34619.0
2024-08-13 04:00:00	QQQ	ETF	453.12	454.79	453.12	454.11	31424.0
2024-08-13 04:30:00	QQQ	ETF	454.23	454.23	453.75	453.93	59592.0
2024-08-13 05:00:00	QQQ	ETF	453.87	454.01	453.6	454.0	7331.0
2024-08-13 05:30:00	QQQ	ETF	454.2	454.34	453.96	453.96	6153.0
2024-08-13 06:00:00	QQQ	ETF	453.87	453.87	452.38	452.41	15603.0
2024-08-13 06:30:00	QQQ	ETF	452.5	452.68	451.63	451.86	138895.0
2024-08-13 07:00:00	QQQ	ETF	451.77	452.69	451.6	452.65	56362.0
2024-08-13 07:30:00	QQQ	ETF	452.6	453.15	452.51	453.15	46477.0
2024-08-13 08:00:00	QQQ	ETF	451.85	455.65	451.042	454.1	172067.0
2024-08-13 08:30:00	QQQ	ETF	454.42	455.91	453.97	455.7	700684.0
2024-08-13 09:00:00	QQQ	ETF	455.72	456.4	455.1	455.88	246240.0
2024-08-13 09:30:00	QQQ	ETF	455.81	457.979	455.68	457.66	3852107.0
2024-08-13 10:00:00	QQQ	ETF	457.67	458.21	456.98	457.79	1795983.0
2024-08-13 10:30:00	QQQ	ETF	457.78	458.9	456.633	458.675	1461870.0
2024-08-13 11:00:00	QQQ	ETF	458.71	459.52	458.51	459.3	1251829.0
2024-08-13 11:30:00	QQQ	ETF	459.28	460.05	459.05	459.626	1353784.0
2024-08-13 12:00:00	QQQ	ETF	459.65	460.74	459.27	460.4139	1568286.0
2024-08-13 12:30:00	QQQ	ETF	460.4	461.88	460.01	461.85	1598108.0

> showing 50 of 32,708 rows — these rows as CSV

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