PREVIEW / etf_30min / 2024-07-25

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-25.parquet
  size:    850 KB
  rows:    34,148

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-07-25 04:00:00	SPY	ETF	541.88	542.28	539.28	540.75	54419.0
2024-07-25 04:30:00	SPY	ETF	540.55	541.71	540.53	541.69	23979.0
2024-07-25 05:00:00	SPY	ETF	541.72	542.15	540.75	540.99	59422.0
2024-07-25 05:30:00	SPY	ETF	541.23	541.34	540.28	540.43	37382.0
2024-07-25 06:00:00	SPY	ETF	540.49	540.61	539.67	539.83	9517.0
2024-07-25 06:30:00	SPY	ETF	539.83	540.73	539.73	540.59	49624.0
2024-07-25 07:00:00	SPY	ETF	540.6	541.27	540.4	540.5	93918.0
2024-07-25 07:30:00	SPY	ETF	540.37	541.06	539.97	539.97	116263.0
2024-07-25 08:00:00	SPY	ETF	541.02	542.69	539.96	540.03	209233.0
2024-07-25 08:30:00	SPY	ETF	540.35	541.7	539.4	541.7	375091.0
2024-07-25 09:00:00	SPY	ETF	541.69	541.69	540.67	541.35	204097.0
2024-07-25 09:30:00	SPY	ETF	541.35	541.62	539.61	539.858	3949428.0
2024-07-25 10:00:00	SPY	ETF	539.87	540.72	537.45	540.6	5692140.0
2024-07-25 10:30:00	SPY	ETF	540.58	542.82	540.02	542.79	3392313.0
2024-07-25 11:00:00	SPY	ETF	542.8	544.6297	542.0974	543.23	2879672.0
2024-07-25 11:30:00	SPY	ETF	543.22	544.0	542.4	543.97	1630788.0
2024-07-25 12:00:00	SPY	ETF	543.97	546.38	543.3	546.15	2821836.0
2024-07-25 12:30:00	SPY	ETF	546.18	546.64	545.5	546.12	1646624.0
2024-07-25 13:00:00	SPY	ETF	546.13	547.455	544.4605	544.72	2313717.0
2024-07-25 13:30:00	SPY	ETF	544.72	545.1	544.1	544.635	1863244.0
2024-07-25 14:00:00	SPY	ETF	544.635	544.6796	542.53	542.97	1948693.0
2024-07-25 14:30:00	SPY	ETF	542.95	543.5	540.52	540.8299	3163044.0
2024-07-25 15:00:00	SPY	ETF	540.81	543.68	540.8	543.14	3158440.0
2024-07-25 15:30:00	SPY	ETF	543.13	543.31	538.13	538.34	8203530.0
2024-07-25 16:00:00	SPY	ETF	538.34	538.7	537.5	538.34	3971957.0
2024-07-25 16:30:00	SPY	ETF	538.39	538.69	537.98	538.65	143753.0
2024-07-25 17:00:00	SPY	ETF	538.61	538.66	538.39	538.45	69896.0
2024-07-25 17:30:00	SPY	ETF	538.4	538.74	538.4	538.74	17322.0
2024-07-25 18:00:00	SPY	ETF	538.74	539.47	538.74	539.02	47855.0
2024-07-25 18:30:00	SPY	ETF	539.1	539.26	538.8	538.8	14308.0
2024-07-25 19:00:00	SPY	ETF	538.85	539.21	538.77	539.13	29511.0
2024-07-25 19:30:00	SPY	ETF	539.13	539.33	539.11	539.33	15772.0
2024-07-25 04:00:00	QQQ	ETF	463.83	463.83	460.02	461.89	143252.0
2024-07-25 04:30:00	QQQ	ETF	461.74	463.4	461.74	463.28	66242.0
2024-07-25 05:00:00	QQQ	ETF	463.44	464.07	462.5	462.98	92945.0
2024-07-25 05:30:00	QQQ	ETF	463.19	463.35	461.75	461.92	94091.0
2024-07-25 06:00:00	QQQ	ETF	462.16	462.47	460.87	461.08	91258.0
2024-07-25 06:30:00	QQQ	ETF	461.11	462.53	461.0	462.21	164181.0
2024-07-25 07:00:00	QQQ	ETF	462.32	463.47	462.28	462.46	217156.0
2024-07-25 07:30:00	QQQ	ETF	462.34	463.07	461.7	461.73	139028.0
2024-07-25 08:00:00	QQQ	ETF	462.4	465.1	460.9296	461.51	273350.0
2024-07-25 08:30:00	QQQ	ETF	462.18	464.18	460.6	464.18	531656.0
2024-07-25 09:00:00	QQQ	ETF	464.13	464.42	462.73	463.72	349159.0
2024-07-25 09:30:00	QQQ	ETF	463.72	463.95	458.87	459.2	4641011.0
2024-07-25 10:00:00	QQQ	ETF	459.19	460.575	455.63	460.36	6360878.0
2024-07-25 10:30:00	QQQ	ETF	460.37	463.7695	459.5	463.7	4063821.0
2024-07-25 11:00:00	QQQ	ETF	463.7	465.24	462.1601	463.398	3189942.0
2024-07-25 11:30:00	QQQ	ETF	463.39	464.22	461.98	464.19	1973908.0
2024-07-25 12:00:00	QQQ	ETF	464.18	467.08	463.14	466.74	2589171.0
2024-07-25 12:30:00	QQQ	ETF	466.77	467.21	465.79	466.56	1619711.0

> showing 50 of 34,148 rows — these rows as CSV

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