PREVIEW / etf_30min / 2024-11-06

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-06.parquet
  size:    978 KB
  rows:    39,249

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-06 04:00:00	SPY	ETF	583.0	590.6	583.0	588.95	153832.0
2024-11-06 04:30:00	SPY	ETF	589.0	590.11	588.96	590.11	114996.0
2024-11-06 05:00:00	SPY	ETF	590.1	590.71	589.39	590.01	65438.0
2024-11-06 05:30:00	SPY	ETF	590.1	590.32	589.3	589.53	192976.0
2024-11-06 06:00:00	SPY	ETF	589.65	589.99	589.21	589.63	124475.0
2024-11-06 06:30:00	SPY	ETF	589.57	589.59	587.3	587.78	237773.0
2024-11-06 07:00:00	SPY	ETF	587.76	589.79	587.46	589.0	468654.0
2024-11-06 07:30:00	SPY	ETF	589.05	590.41	588.91	589.7	269372.0
2024-11-06 08:00:00	SPY	ETF	587.65	590.52	582.5	589.8	594083.0
2024-11-06 08:30:00	SPY	ETF	589.74	589.89	588.5203	588.68	333541.0
2024-11-06 09:00:00	SPY	ETF	588.63	589.24	588.0	589.23	672858.0
2024-11-06 09:30:00	SPY	ETF	589.2	589.43	585.39	586.11	8728450.0
2024-11-06 10:00:00	SPY	ETF	586.12	589.08	586.12	588.82	4068691.0
2024-11-06 10:30:00	SPY	ETF	588.82	589.04	586.39	587.02	3078251.0
2024-11-06 11:00:00	SPY	ETF	586.99	588.33	586.31	588.15	1854009.0
2024-11-06 11:30:00	SPY	ETF	588.16	588.86	588.16	588.78	1942247.0
2024-11-06 12:00:00	SPY	ETF	588.77	589.09	588.3101	588.76	1214066.0
2024-11-06 12:30:00	SPY	ETF	588.75	589.48	588.51	589.265	1254730.0
2024-11-06 13:00:00	SPY	ETF	589.26	590.27	589.12	590.19	1512055.0
2024-11-06 13:30:00	SPY	ETF	590.2	590.71	590.06	590.27	1806662.0
2024-11-06 14:00:00	SPY	ETF	590.28	590.6198	589.79	590.55	1629883.0
2024-11-06 14:30:00	SPY	ETF	590.53	590.85	590.12	590.54	1588699.0
2024-11-06 15:00:00	SPY	ETF	590.54	591.66	590.45	591.115	2844220.0
2024-11-06 15:30:00	SPY	ETF	591.11	591.93	590.67	591.04	9342092.0
2024-11-06 16:00:00	SPY	ETF	591.03	591.51	590.65	591.29	4059992.0
2024-11-06 16:30:00	SPY	ETF	591.23	591.87	591.1	591.79	370345.0
2024-11-06 17:00:00	SPY	ETF	591.8199	591.87	591.04	591.65	109654.0
2024-11-06 17:30:00	SPY	ETF	591.57	591.57	591.1	591.45	92300.0
2024-11-06 18:00:00	SPY	ETF	591.55	591.55	590.99	591.17	427402.0
2024-11-06 18:30:00	SPY	ETF	591.1981	591.2	590.79	590.84	30630.0
2024-11-06 19:00:00	SPY	ETF	590.89	591.33	590.54	590.64	19961.0
2024-11-06 19:30:00	SPY	ETF	590.61	590.78	590.3599	590.46	35731.0
2024-11-06 04:00:00	QQQ	ETF	501.0	501.5	498.22	500.9	93702.0
2024-11-06 04:30:00	QQQ	ETF	500.96	501.6	500.91	501.56	58541.0
2024-11-06 05:00:00	QQQ	ETF	501.59	501.6	500.71	501.15	25897.0
2024-11-06 05:30:00	QQQ	ETF	501.19	501.39	500.43	500.49	57824.0
2024-11-06 06:00:00	QQQ	ETF	500.51	500.74	500.14	500.42	66545.0
2024-11-06 06:30:00	QQQ	ETF	500.41	500.48	498.09	498.61	374715.0
2024-11-06 07:00:00	QQQ	ETF	498.63	500.21	498.49	499.94	258298.0
2024-11-06 07:30:00	QQQ	ETF	499.92	501.11	499.64	500.64	174262.0
2024-11-06 08:00:00	QQQ	ETF	498.68	501.5604	495.13	501.01	381882.0
2024-11-06 08:30:00	QQQ	ETF	500.96	501.36	500.4	500.65	205864.0
2024-11-06 09:00:00	QQQ	ETF	500.6	500.84	499.82	500.6	419005.0
2024-11-06 09:30:00	QQQ	ETF	500.56	503.46	499.6	500.33	6455242.0
2024-11-06 10:00:00	QQQ	ETF	500.35	503.36	500.07	503.19	2245677.0
2024-11-06 10:30:00	QQQ	ETF	503.2	503.7894	501.04	501.46	1657577.0
2024-11-06 11:00:00	QQQ	ETF	501.43	502.87	500.72	502.69	1264803.0
2024-11-06 11:30:00	QQQ	ETF	502.74	503.41	502.57	503.17	1430702.0
2024-11-06 12:00:00	QQQ	ETF	503.18	503.6	502.74	503.24	777805.0
2024-11-06 12:30:00	QQQ	ETF	503.26	503.82	502.944	503.62	660701.0

> showing 50 of 39,249 rows — these rows as CSV

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