PREVIEW / etf_30min / 2024-12-03

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-03.parquet
  size:    919 KB
  rows:    36,527

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-12-03 04:00:00	SPY	ETF	604.01	604.14	603.9	603.96	4393.0
2024-12-03 04:30:00	SPY	ETF	603.87	604.04	603.83	604.04	1695.0
2024-12-03 05:00:00	SPY	ETF	604.0	604.04	603.91	603.91	1287.0
2024-12-03 05:30:00	SPY	ETF	603.81	603.85	603.6	603.6	5331.0
2024-12-03 06:00:00	SPY	ETF	603.6	603.65	603.36	603.52	7476.0
2024-12-03 06:30:00	SPY	ETF	603.52	603.88	603.52	603.88	6838.0
2024-12-03 07:00:00	SPY	ETF	603.91	604.0	603.72	603.89	16675.0
2024-12-03 07:30:00	SPY	ETF	603.86	604.11	603.84	603.84	6757.0
2024-12-03 08:00:00	SPY	ETF	603.79	604.15	603.731	603.97	18804.0
2024-12-03 08:30:00	SPY	ETF	603.9	604.24	603.6291	603.65	97904.0
2024-12-03 09:00:00	SPY	ETF	603.65	603.94	602.98	603.38	243773.0
2024-12-03 09:30:00	SPY	ETF	603.38	603.72	602.77	603.35	1934272.0
2024-12-03 10:00:00	SPY	ETF	603.35	603.62	602.44	602.46	1153283.0
2024-12-03 10:30:00	SPY	ETF	602.48	602.99	602.341	602.8845	1349124.0
2024-12-03 11:00:00	SPY	ETF	602.89	603.4599	602.82	603.42	1033766.0
2024-12-03 11:30:00	SPY	ETF	603.4	603.5	602.37	602.5572	1055001.0
2024-12-03 12:00:00	SPY	ETF	602.56	603.055	602.53	603.005	553323.0
2024-12-03 12:30:00	SPY	ETF	602.995	603.7299	602.94	603.71	782085.0
2024-12-03 13:00:00	SPY	ETF	603.71	603.85	603.505	603.57	630165.0
2024-12-03 13:30:00	SPY	ETF	603.55	603.76	603.29	603.44	777418.0
2024-12-03 14:00:00	SPY	ETF	603.43	603.63	603.17	603.6198	890493.0
2024-12-03 14:30:00	SPY	ETF	603.6	604.16	603.6	604.03	1057814.0
2024-12-03 15:00:00	SPY	ETF	604.0201	604.11	603.79	603.945	1237371.0
2024-12-03 15:30:00	SPY	ETF	603.94	604.14	603.49	603.85	3475656.0
2024-12-03 16:00:00	SPY	ETF	603.86	604.6	603.4002	604.56	1936340.0
2024-12-03 16:30:00	SPY	ETF	604.5	604.58	603.91	604.25	112357.0
2024-12-03 17:00:00	SPY	ETF	604.274	604.369	604.0	604.04	38712.0
2024-12-03 17:30:00	SPY	ETF	604.12	604.43	604.06	604.28	22938.0
2024-12-03 18:00:00	SPY	ETF	604.25	604.25	603.9	604.22	29105.0
2024-12-03 18:30:00	SPY	ETF	604.3413	604.52	604.28	604.5149	4720.0
2024-12-03 19:00:00	SPY	ETF	604.45	604.45	604.2315	604.2315	3804.0
2024-12-03 19:30:00	SPY	ETF	604.23	604.25	604.11	604.1901	10422.0
2024-12-03 04:00:00	QQQ	ETF	515.39	515.5	515.27	515.37	15450.0
2024-12-03 04:30:00	QQQ	ETF	515.29	515.38	515.24	515.32	7353.0
2024-12-03 05:00:00	QQQ	ETF	515.35	515.47	515.27	515.37	6240.0
2024-12-03 05:30:00	QQQ	ETF	515.31	515.33	515.0	515.0	6989.0
2024-12-03 06:00:00	QQQ	ETF	515.0	515.11	514.66	514.86	12394.0
2024-12-03 06:30:00	QQQ	ETF	514.85	515.2	514.79	515.15	11971.0
2024-12-03 07:00:00	QQQ	ETF	515.13	515.33	514.72	515.1	35362.0
2024-12-03 07:30:00	QQQ	ETF	515.23	515.45	515.08	515.18	12920.0
2024-12-03 08:00:00	QQQ	ETF	514.96	515.88	514.7301	515.16	43741.0
2024-12-03 08:30:00	QQQ	ETF	515.14	515.54	514.88	514.88	74663.0
2024-12-03 09:00:00	QQQ	ETF	514.88	515.2	513.67	513.95	223109.0
2024-12-03 09:30:00	QQQ	ETF	513.95	515.19	513.37	515.0555	2241708.0
2024-12-03 10:00:00	QQQ	ETF	515.03	515.79	514.25	514.42	1074534.0
2024-12-03 10:30:00	QQQ	ETF	514.4	515.35	514.13	515.15	894885.0
2024-12-03 11:00:00	QQQ	ETF	515.15	516.23	515.07	516.22	855900.0
2024-12-03 11:30:00	QQQ	ETF	516.21	516.48	514.885	515.11	1061718.0
2024-12-03 12:00:00	QQQ	ETF	515.13	515.45	514.9066	515.05	382694.0
2024-12-03 12:30:00	QQQ	ETF	515.04	516.0	514.75	515.99	531829.0

> showing 50 of 36,527 rows — these rows as CSV

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