PREVIEW / etf_30min / 2024-10-10

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-10.parquet
  size:    835 KB
  rows:    33,194

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-10-10 04:00:00	SPY	ETF	576.37	576.55	576.1	576.55	14969.0
2024-10-10 04:30:00	SPY	ETF	576.51	576.6	576.3	576.33	6924.0
2024-10-10 05:00:00	SPY	ETF	576.23	576.32	576.06	576.32	6472.0
2024-10-10 05:30:00	SPY	ETF	576.32	576.6	576.31	576.54	6281.0
2024-10-10 06:00:00	SPY	ETF	576.6	576.65	576.33	576.38	2681.0
2024-10-10 06:30:00	SPY	ETF	576.39	576.57	576.21	576.25	8125.0
2024-10-10 07:00:00	SPY	ETF	576.24	576.43	576.09	576.4	51700.0
2024-10-10 07:30:00	SPY	ETF	576.4	576.71	576.4	576.71	81845.0
2024-10-10 08:00:00	SPY	ETF	576.52	577.37	576.09	576.55	432480.0
2024-10-10 08:30:00	SPY	ETF	577.02	577.48	574.6	575.29	1303004.0
2024-10-10 09:00:00	SPY	ETF	575.25	575.8	575.14	575.77	151355.0
2024-10-10 09:30:00	SPY	ETF	575.77	576.3199	574.56	575.39	4032283.0
2024-10-10 10:00:00	SPY	ETF	575.41	576.6495	575.32	575.95	1748672.0
2024-10-10 10:30:00	SPY	ETF	575.95	576.24	575.13	575.44	1047592.0
2024-10-10 11:00:00	SPY	ETF	575.44	576.56	575.14	576.294	1148223.0
2024-10-10 11:30:00	SPY	ETF	576.29	577.0	575.8821	576.96	937550.0
2024-10-10 12:00:00	SPY	ETF	576.952	577.58	576.86	577.1694	1509176.0
2024-10-10 12:30:00	SPY	ETF	577.17	577.205	575.79	576.22	2095841.0
2024-10-10 13:00:00	SPY	ETF	576.2105	576.6	575.26	576.37	1440623.0
2024-10-10 13:30:00	SPY	ETF	576.38	576.675	574.77	576.22	1480334.0
2024-10-10 14:00:00	SPY	ETF	576.23	576.23	575.31	575.38	1252210.0
2024-10-10 14:30:00	SPY	ETF	575.37	575.48	574.49	575.3	1744732.0
2024-10-10 15:00:00	SPY	ETF	575.3	575.51	574.84	575.395	1370592.0
2024-10-10 15:30:00	SPY	ETF	575.38	576.54	575.3	576.1	3818154.0
2024-10-10 16:00:00	SPY	ETF	576.1	576.33	575.89	576.29	2871659.0
2024-10-10 16:30:00	SPY	ETF	576.26	576.48	576.26	576.31	87397.0
2024-10-10 17:00:00	SPY	ETF	576.35	576.42	576.25	576.26	13900.0
2024-10-10 17:30:00	SPY	ETF	576.26	576.2915	576.13	576.13	11284.0
2024-10-10 18:00:00	SPY	ETF	576.27	576.37	576.18	576.34	18653.0
2024-10-10 18:30:00	SPY	ETF	576.33	576.4	576.25	576.32	6266.0
2024-10-10 19:00:00	SPY	ETF	576.41	576.87	576.41	576.76	12141.0
2024-10-10 19:30:00	SPY	ETF	576.8	576.84	576.7	576.77	42656.0
2024-10-10 04:00:00	QQQ	ETF	492.35	492.61	492.08	492.46	17122.0
2024-10-10 04:30:00	QQQ	ETF	492.51	492.54	492.21	492.32	10203.0
2024-10-10 05:00:00	QQQ	ETF	492.29	492.33	492.07	492.25	13711.0
2024-10-10 05:30:00	QQQ	ETF	492.39	492.68	492.35	492.59	7606.0
2024-10-10 06:00:00	QQQ	ETF	492.63	492.68	492.36	492.37	8957.0
2024-10-10 06:30:00	QQQ	ETF	492.35	492.58	492.03	492.08	12916.0
2024-10-10 07:00:00	QQQ	ETF	492.12	492.37	491.94	492.3	36693.0
2024-10-10 07:30:00	QQQ	ETF	492.37	492.8	492.37	492.79	57730.0
2024-10-10 08:00:00	QQQ	ETF	492.13	493.57	491.94	492.61	144561.0
2024-10-10 08:30:00	QQQ	ETF	493.05	493.44	490.01	490.92	602272.0
2024-10-10 09:00:00	QQQ	ETF	490.91	491.49	490.57	490.94	144077.0
2024-10-10 09:30:00	QQQ	ETF	490.85	491.6	489.53	490.88	2443556.0
2024-10-10 10:00:00	QQQ	ETF	490.91	492.28	490.81	491.957	1334769.0
2024-10-10 10:30:00	QQQ	ETF	491.98	492.38	490.99	491.4701	1185399.0
2024-10-10 11:00:00	QQQ	ETF	491.51	492.85	491.03	492.679	892426.0
2024-10-10 11:30:00	QQQ	ETF	492.67	493.74	492.32	493.7	839490.0
2024-10-10 12:00:00	QQQ	ETF	493.685	494.47	493.31	493.54	1453717.0
2024-10-10 12:30:00	QQQ	ETF	493.58	493.635	492.32	492.84	1259987.0

> showing 50 of 33,194 rows — these rows as CSV

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