PREVIEW / etf_30min / 2024-10-31

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-31.parquet
  size:    878 KB
  rows:    35,178

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-31 04:00:00	SPY	ETF	576.78	576.78	575.12	575.37	39256.0
2024-10-31 04:30:00	SPY	ETF	575.2	575.7	575.12	575.61	14463.0
2024-10-31 05:00:00	SPY	ETF	575.35	575.45	575.04	575.2	18071.0
2024-10-31 05:30:00	SPY	ETF	575.16	575.54	575.08	575.5	8541.0
2024-10-31 06:00:00	SPY	ETF	575.55	575.62	575.2	575.58	23942.0
2024-10-31 06:30:00	SPY	ETF	575.51	575.84	575.35	575.7	49069.0
2024-10-31 07:00:00	SPY	ETF	575.83	576.16	575.69	576.01	233334.0
2024-10-31 07:30:00	SPY	ETF	576.04	576.56	575.69	576.53	215582.0
2024-10-31 08:00:00	SPY	ETF	575.86	577.59	575.05	576.8	255467.0
2024-10-31 08:30:00	SPY	ETF	576.78	576.8	576.07	576.2	319042.0
2024-10-31 09:00:00	SPY	ETF	576.15	580.01	575.44	575.6	267952.0
2024-10-31 09:30:00	SPY	ETF	575.56	575.63	573.14	573.76	4678475.0
2024-10-31 10:00:00	SPY	ETF	573.74	573.79	571.77	571.99	3188600.0
2024-10-31 10:30:00	SPY	ETF	571.97	572.54	570.95	571.1	2839024.0
2024-10-31 11:00:00	SPY	ETF	571.1	571.7	570.275	571.08	2574310.0
2024-10-31 11:30:00	SPY	ETF	571.085	571.3799	570.08	570.94	1773795.0
2024-10-31 12:00:00	SPY	ETF	570.9225	571.91	570.53	571.5	1777183.0
2024-10-31 12:30:00	SPY	ETF	571.48	571.7	571.04	571.33	959615.0
2024-10-31 13:00:00	SPY	ETF	571.32	571.99	571.14	571.1765	842300.0
2024-10-31 13:30:00	SPY	ETF	571.1873	571.2545	570.11	570.36	1350464.0
2024-10-31 14:00:00	SPY	ETF	570.38	570.5611	569.92	570.4901	1572410.0
2024-10-31 14:30:00	SPY	ETF	570.5	570.84	569.71	570.66	2382277.0
2024-10-31 15:00:00	SPY	ETF	570.67	571.74	570.65	571.175	2332740.0
2024-10-31 15:30:00	SPY	ETF	571.18	572.0	568.44	568.55	7344689.0
2024-10-31 16:00:00	SPY	ETF	568.55	570.46	568.48	569.57	4943904.0
2024-10-31 16:30:00	SPY	ETF	569.15	570.23	568.45	568.7509	707594.0
2024-10-31 17:00:00	SPY	ETF	568.85	569.6	568.7	568.8	132213.0
2024-10-31 17:30:00	SPY	ETF	568.75	569.37	568.73	569.11	66014.0
2024-10-31 18:00:00	SPY	ETF	569.11	569.74	569.09	569.41	79355.0
2024-10-31 18:30:00	SPY	ETF	569.48	570.09	569.43	569.5	33241.0
2024-10-31 19:00:00	SPY	ETF	569.6	569.63	569.05	569.5899	35968.0
2024-10-31 19:30:00	SPY	ETF	569.54	569.6	569.31	569.4	22414.0
2024-10-31 04:00:00	QQQ	ETF	492.28	492.28	490.62	490.96	66465.0
2024-10-31 04:30:00	QQQ	ETF	490.84	491.52	490.48	491.13	15135.0
2024-10-31 05:00:00	QQQ	ETF	491.14	491.23	490.94	491.2	5140.0
2024-10-31 05:30:00	QQQ	ETF	491.16	491.48	491.07	491.24	5150.0
2024-10-31 06:00:00	QQQ	ETF	491.34	491.34	490.59	491.08	38761.0
2024-10-31 06:30:00	QQQ	ETF	491.15	491.77	491.0	491.74	38432.0
2024-10-31 07:00:00	QQQ	ETF	491.71	492.54	491.71	492.19	183461.0
2024-10-31 07:30:00	QQQ	ETF	492.16	493.05	491.8	492.991	166308.0
2024-10-31 08:00:00	QQQ	ETF	492.09	496.16	490.4896	493.49	202248.0
2024-10-31 08:30:00	QQQ	ETF	493.0	493.52	492.6927	492.8	121857.0
2024-10-31 09:00:00	QQQ	ETF	492.75	493.05	492.29	492.36	175233.0
2024-10-31 09:30:00	QQQ	ETF	492.37	492.43	487.21	487.61	4433101.0
2024-10-31 10:00:00	QQQ	ETF	487.6	488.43	486.46	486.97	2227192.0
2024-10-31 10:30:00	QQQ	ETF	486.95	487.36	485.32	485.73	2061287.0
2024-10-31 11:00:00	QQQ	ETF	485.7	486.37	484.87	485.94	1896356.0
2024-10-31 11:30:00	QQQ	ETF	485.91	486.15	484.17	485.27	1565040.0
2024-10-31 12:00:00	QQQ	ETF	485.26	486.1	484.79	485.71	1632075.0
2024-10-31 12:30:00	QQQ	ETF	485.71	486.12	485.25	485.68	1030842.0

> showing 50 of 35,178 rows — these rows as CSV

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