PREVIEW / etf_30min / 2024-11-08

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-08.parquet
  size:    912 KB
  rows:    36,236

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-08 04:00:00	SPY	ETF	596.37	596.68	596.25	596.6	12684.0
2024-11-08 04:30:00	SPY	ETF	596.57	596.67	596.34	596.42	10195.0
2024-11-08 05:00:00	SPY	ETF	596.29	596.29	595.87	595.91	42124.0
2024-11-08 05:30:00	SPY	ETF	595.8	595.8	594.8	595.1	31751.0
2024-11-08 06:00:00	SPY	ETF	595.03	595.28	594.72	595.21	25711.0
2024-11-08 06:30:00	SPY	ETF	595.27	595.41	595.19	595.39	13277.0
2024-11-08 07:00:00	SPY	ETF	595.35	595.75	595.3	595.54	64367.0
2024-11-08 07:30:00	SPY	ETF	595.59	595.95	595.59	595.9	146427.0
2024-11-08 08:00:00	SPY	ETF	595.88	596.67	594.9596	596.04	117513.0
2024-11-08 08:30:00	SPY	ETF	596.01	596.01	595.49	595.57	64367.0
2024-11-08 09:00:00	SPY	ETF	595.55	596.24	595.46	596.14	159168.0
2024-11-08 09:30:00	SPY	ETF	596.17	597.24	596.16	597.16	2874018.0
2024-11-08 10:00:00	SPY	ETF	597.2	597.5799	596.5708	597.335	1920259.0
2024-11-08 10:30:00	SPY	ETF	597.33	597.985	597.22	597.78	1747033.0
2024-11-08 11:00:00	SPY	ETF	597.785	598.08	597.34	597.99	1247147.0
2024-11-08 11:30:00	SPY	ETF	597.98	598.22	597.63	597.91	1430280.0
2024-11-08 12:00:00	SPY	ETF	597.9399	598.0154	597.44	597.64	1440228.0
2024-11-08 12:30:00	SPY	ETF	597.64	598.35	597.61	598.09	1006384.0
2024-11-08 13:00:00	SPY	ETF	598.09	598.28	597.96	598.175	855445.0
2024-11-08 13:30:00	SPY	ETF	598.16	599.21	598.14	599.01	1772646.0
2024-11-08 14:00:00	SPY	ETF	599.015	599.25	598.67	599.23	1418026.0
2024-11-08 14:30:00	SPY	ETF	599.21	599.64	598.91	598.91	1750666.0
2024-11-08 15:00:00	SPY	ETF	598.92	598.98	598.24	598.25	1977103.0
2024-11-08 15:30:00	SPY	ETF	598.28	598.3123	597.62	598.24	7195914.0
2024-11-08 16:00:00	SPY	ETF	598.24	598.43	597.8841	598.2	2338584.0
2024-11-08 16:30:00	SPY	ETF	598.19	598.21	597.8833	597.92	788463.0
2024-11-08 17:00:00	SPY	ETF	597.98	598.08	597.93	598.0	26540.0
2024-11-08 17:30:00	SPY	ETF	598.01	598.06	597.71	598.03	43117.0
2024-11-08 18:00:00	SPY	ETF	598.03	598.03	597.82	597.8607	5190.0
2024-11-08 18:30:00	SPY	ETF	597.9	598.04	597.9	598.03	2791.0
2024-11-08 19:00:00	SPY	ETF	597.95	598.0	597.95	597.96	3080.0
2024-11-08 19:30:00	SPY	ETF	598.03	598.04	597.95	598.0	7613.0
2024-11-08 04:00:00	QQQ	ETF	514.12	514.43	514.01	514.3	38997.0
2024-11-08 04:30:00	QQQ	ETF	514.33	514.45	514.02	514.02	4138.0
2024-11-08 05:00:00	QQQ	ETF	513.97	513.98	513.25	513.26	23958.0
2024-11-08 05:30:00	QQQ	ETF	513.27	513.27	511.71	512.0	116146.0
2024-11-08 06:00:00	QQQ	ETF	511.98	512.32	511.51	512.0	56213.0
2024-11-08 06:30:00	QQQ	ETF	512.09	512.56	512.09	512.42	29820.0
2024-11-08 07:00:00	QQQ	ETF	512.4	512.72	512.33	512.7	49808.0
2024-11-08 07:30:00	QQQ	ETF	512.72	513.08	512.72	512.97	47839.0
2024-11-08 08:00:00	QQQ	ETF	512.48	514.82	511.8596	512.91	169816.0
2024-11-08 08:30:00	QQQ	ETF	512.85	512.85	512.33	512.51	88711.0
2024-11-08 09:00:00	QQQ	ETF	512.49	513.11	512.31	513.06	94816.0
2024-11-08 09:30:00	QQQ	ETF	513.035	514.156	512.8	513.65	2077533.0
2024-11-08 10:00:00	QQQ	ETF	513.59	514.0	512.41	513.19	1395188.0
2024-11-08 10:30:00	QQQ	ETF	513.19	513.64	512.795	513.2925	885311.0
2024-11-08 11:00:00	QQQ	ETF	513.3	513.8225	512.67	513.5999	753149.0
2024-11-08 11:30:00	QQQ	ETF	513.63	514.23	513.24	513.79	743043.0
2024-11-08 12:00:00	QQQ	ETF	513.76	513.9099	513.2701	513.45	757105.0
2024-11-08 12:30:00	QQQ	ETF	513.44	514.04	513.39	513.8	584741.0

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

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