PREVIEW / etf_30min / 2024-11-20

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-20.parquet
  size:    900 KB
  rows:    35,707

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-11-20 04:00:00	SPY	ETF	591.57	592.01	591.42	591.9	8105.0
2024-11-20 04:30:00	SPY	ETF	591.72	591.78	591.21	591.42	33494.0
2024-11-20 05:00:00	SPY	ETF	591.44	591.44	590.58	590.58	14829.0
2024-11-20 05:30:00	SPY	ETF	590.53	591.1	590.45	590.75	4273.0
2024-11-20 06:00:00	SPY	ETF	590.78	591.29	590.78	591.2	2783.0
2024-11-20 06:30:00	SPY	ETF	591.12	591.12	590.63	591.03	31243.0
2024-11-20 07:00:00	SPY	ETF	591.0	591.54	590.95	591.46	22408.0
2024-11-20 07:30:00	SPY	ETF	591.45	591.72	591.25	591.66	20992.0
2024-11-20 08:00:00	SPY	ETF	591.11	592.03	590.9699	591.6	118791.0
2024-11-20 08:30:00	SPY	ETF	591.57	591.57	590.84	591.0	80223.0
2024-11-20 09:00:00	SPY	ETF	590.96	590.96	589.64	590.35	314341.0
2024-11-20 09:30:00	SPY	ETF	590.38	590.53	587.4	587.43	3663737.0
2024-11-20 10:00:00	SPY	ETF	587.4	588.1566	584.63	585.714	3129836.0
2024-11-20 10:30:00	SPY	ETF	585.72	587.6	585.62	587.41	2138300.0
2024-11-20 11:00:00	SPY	ETF	587.4	587.686	585.87	585.87	1520624.0
2024-11-20 11:30:00	SPY	ETF	585.9	588.8	585.54	588.36	1687813.0
2024-11-20 12:00:00	SPY	ETF	588.34	588.69	586.1401	587.205	1430302.0
2024-11-20 12:30:00	SPY	ETF	587.2	588.29	586.8543	587.07	920140.0
2024-11-20 13:00:00	SPY	ETF	587.06	587.72	586.54	587.6	827728.0
2024-11-20 13:30:00	SPY	ETF	587.6022	587.6022	586.15	586.8	702714.0
2024-11-20 14:00:00	SPY	ETF	586.77	586.87	586.25	586.6198	1225008.0
2024-11-20 14:30:00	SPY	ETF	586.61	587.9	586.52	587.52	1428357.0
2024-11-20 15:00:00	SPY	ETF	587.48	588.52	587.23	588.48	1524946.0
2024-11-20 15:30:00	SPY	ETF	588.48	590.79	588.48	590.51	7261477.0
2024-11-20 16:00:00	SPY	ETF	590.51	590.98	587.66	588.97	2105194.0
2024-11-20 16:30:00	SPY	ETF	589.07	590.74	587.2893	590.57	210277.0
2024-11-20 17:00:00	SPY	ETF	590.65	591.3	590.5	590.6	122345.0
2024-11-20 17:30:00	SPY	ETF	590.61	590.7	590.15	590.3703	33775.0
2024-11-20 18:00:00	SPY	ETF	590.37	590.45	589.49	590.08	59199.0
2024-11-20 18:30:00	SPY	ETF	590.19	590.85	590.19	590.6	20842.0
2024-11-20 19:00:00	SPY	ETF	590.63	590.69	589.44	589.45	24309.0
2024-11-20 19:30:00	SPY	ETF	589.3	589.5	588.47	588.51	38661.0
2024-11-20 04:00:00	QQQ	ETF	504.22	504.97	504.13	504.7	18709.0
2024-11-20 04:30:00	QQQ	ETF	504.6	504.66	503.89	504.19	43990.0
2024-11-20 05:00:00	QQQ	ETF	503.96	504.21	503.32	503.39	24772.0
2024-11-20 05:30:00	QQQ	ETF	503.39	504.08	503.25	503.78	7417.0
2024-11-20 06:00:00	QQQ	ETF	503.73	504.4	503.66	504.21	12484.0
2024-11-20 06:30:00	QQQ	ETF	504.13	504.25	503.78	504.25	27769.0
2024-11-20 07:00:00	QQQ	ETF	504.17	504.84	504.08	504.67	45672.0
2024-11-20 07:30:00	QQQ	ETF	504.62	504.84	504.38	504.78	21726.0
2024-11-20 08:00:00	QQQ	ETF	504.7	505.25	503.914	504.7	77896.0
2024-11-20 08:30:00	QQQ	ETF	504.67	504.67	503.9771	504.16	83039.0
2024-11-20 09:00:00	QQQ	ETF	504.04	504.12	502.55	503.15	319169.0
2024-11-20 09:30:00	QQQ	ETF	503.11	503.21	499.8	499.83	3003653.0
2024-11-20 10:00:00	QQQ	ETF	499.9	500.58	496.555	497.57	2792398.0
2024-11-20 10:30:00	QQQ	ETF	497.56	500.41	497.38	500.14	2191642.0
2024-11-20 11:00:00	QQQ	ETF	500.13	500.57	498.58	498.65	1269796.0
2024-11-20 11:30:00	QQQ	ETF	498.69	502.09	498.24	501.63	1559554.0
2024-11-20 12:00:00	QQQ	ETF	501.62	502.05	499.01	500.2299	1205491.0
2024-11-20 12:30:00	QQQ	ETF	500.2	500.89	499.39	499.68	711013.0

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

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