PREVIEW / etf_1hour / 2024-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-05-01.parquet
  size:    532 KB
  rows:    19,985

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-05-01 04:00:00	SPY	ETF	500.76	501.09	500.64	500.64	20678.0
2024-05-01 05:00:00	SPY	ETF	500.75	500.75	499.64	500.12	20430.0
2024-05-01 06:00:00	SPY	ETF	499.95	500.34	499.5	500.34	93160.0
2024-05-01 07:00:00	SPY	ETF	500.28	500.65	499.91	500.08	167973.0
2024-05-01 08:00:00	SPY	ETF	500.27	502.1	499.4896	500.95	1202872.0
2024-05-01 09:00:00	SPY	ETF	500.88	501.98	500.4187	500.81	4125184.0
2024-05-01 10:00:00	SPY	ETF	500.83	501.61	500.08	501.345	5673788.0
2024-05-01 11:00:00	SPY	ETF	501.34	501.49	500.05	500.24	4468373.0
2024-05-01 12:00:00	SPY	ETF	500.24	501.15	499.865	500.425	2966247.0
2024-05-01 13:00:00	SPY	ETF	500.42	501.3903	499.925	500.99	3100581.0
2024-05-01 14:00:00	SPY	ETF	501.03	507.43	500.75	507.34	16535688.0
2024-05-01 15:00:00	SPY	ETF	507.35	508.19	500.08	500.25	23241350.0
2024-05-01 16:00:00	SPY	ETF	500.25	501.15	500.1	501.0	3162308.0
2024-05-01 17:00:00	SPY	ETF	500.98	501.33	500.95	501.33	95794.0
2024-05-01 18:00:00	SPY	ETF	501.33	501.75	501.31	501.63	84619.0
2024-05-01 19:00:00	SPY	ETF	501.68	502.37	501.6	502.29	103006.0
2024-05-01 04:00:00	QQQ	ETF	422.33	422.78	422.15	422.47	30732.0
2024-05-01 05:00:00	QQQ	ETF	422.46	422.47	421.09	421.53	54550.0
2024-05-01 06:00:00	QQQ	ETF	421.54	422.12	421.0	422.12	47383.0
2024-05-01 07:00:00	QQQ	ETF	422.13	422.44	421.65	421.81	132856.0
2024-05-01 08:00:00	QQQ	ETF	422.14	424.908	421.15	423.04	356464.0
2024-05-01 09:00:00	QQQ	ETF	423.03	423.5398	422.04	422.54	4106406.0
2024-05-01 10:00:00	QQQ	ETF	422.51	423.25	421.3	422.8	3693985.0
2024-05-01 11:00:00	QQQ	ETF	422.8	422.925	420.97	421.2	3343397.0
2024-05-01 12:00:00	QQQ	ETF	421.19	422.31	420.66	421.48	2352302.0
2024-05-01 13:00:00	QQQ	ETF	421.48	422.5	421.0	422.35	2037808.0
2024-05-01 14:00:00	QQQ	ETF	422.35	429.15	422.16	429.15	10147577.0
2024-05-01 15:00:00	QQQ	ETF	429.16	430.14	421.3	421.45	12458707.0
2024-05-01 16:00:00	QQQ	ETF	421.46	422.75	421.45	422.5	1517671.0
2024-05-01 17:00:00	QQQ	ETF	422.53	423.11	422.38	423.1	256881.0
2024-05-01 18:00:00	QQQ	ETF	423.1	423.45	421.52	423.16	363725.0
2024-05-01 19:00:00	QQQ	ETF	423.13	423.9	421.52	423.86	221159.0
2024-05-01 04:00:00	IWM	ETF	195.25	195.39	195.07	195.22	14383.0
2024-05-01 05:00:00	IWM	ETF	195.18	195.18	194.51	194.88	5207.0
2024-05-01 06:00:00	IWM	ETF	194.79	194.99	194.61	194.99	6274.0
2024-05-01 07:00:00	IWM	ETF	194.99	195.1	194.84	194.95	87679.0
2024-05-01 08:00:00	IWM	ETF	194.9	196.0	194.6704	195.65	289855.0
2024-05-01 09:00:00	IWM	ETF	195.72	196.88	195.62	196.0	2270149.0
2024-05-01 10:00:00	IWM	ETF	196.03	196.4	195.27	195.835	3338537.0
2024-05-01 11:00:00	IWM	ETF	195.835	195.86	195.025	195.25	2071343.0
2024-05-01 12:00:00	IWM	ETF	195.24	196.05	195.06	195.55	1454783.0
2024-05-01 13:00:00	IWM	ETF	195.56	196.21	195.34	195.83	1460836.0
2024-05-01 14:00:00	IWM	ETF	195.83	200.0	195.52	199.81	8416959.0
2024-05-01 15:00:00	IWM	ETF	199.82	200.32	196.16	196.265	8930515.0
2024-05-01 16:00:00	IWM	ETF	196.31	197.07	196.16	197.01	1527007.0
2024-05-01 17:00:00	IWM	ETF	196.97	197.05	196.87	197.0	29882.0
2024-05-01 18:00:00	IWM	ETF	197.02	197.2583	196.31	197.22	181228.0
2024-05-01 19:00:00	IWM	ETF	197.26	197.61	196.31	197.6	1088741.0
2024-05-01 04:00:00	DIA	ETF	377.82	377.86	377.82	377.86	400.0
2024-05-01 05:00:00	DIA	ETF	377.34	377.34	377.32	377.32	743.0

> showing 50 of 19,985 rows — these rows as CSV

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