PREVIEW / etf_1hour / 2024-10-30

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-10-30.parquet
  size:    578 KB
  rows:    21,599

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-10-30 04:00:00	SPY	ETF	582.89	583.23	582.5	582.66	18846.0
2024-10-30 05:00:00	SPY	ETF	582.58	583.13	582.5	582.92	7474.0
2024-10-30 06:00:00	SPY	ETF	582.95	583.05	582.0	582.16	105078.0
2024-10-30 07:00:00	SPY	ETF	582.13	582.65	581.77	581.91	162536.0
2024-10-30 08:00:00	SPY	ETF	582.37	583.06	581.39	581.55	272808.0
2024-10-30 09:00:00	SPY	ETF	581.52	581.91	579.29	581.85	3982922.0
2024-10-30 10:00:00	SPY	ETF	581.84	582.96	581.7401	582.3799	3112807.0
2024-10-30 11:00:00	SPY	ETF	582.3799	583.32	581.59	583.105	2010851.0
2024-10-30 12:00:00	SPY	ETF	583.1	583.21	581.99	582.0	1390322.0
2024-10-30 13:00:00	SPY	ETF	581.99	582.305	580.29	580.64	2628298.0
2024-10-30 14:00:00	SPY	ETF	580.624	581.81	580.624	581.18	2346476.0
2024-10-30 15:00:00	SPY	ETF	581.17	581.17	579.38	579.97	8461771.0
2024-10-30 16:00:00	SPY	ETF	579.94	580.61	578.75	579.22	2925634.0
2024-10-30 17:00:00	SPY	ETF	579.2501	579.37	578.43	578.45	95880.0
2024-10-30 18:00:00	SPY	ETF	578.61	579.08	577.87	578.13	230274.0
2024-10-30 19:00:00	SPY	ETF	578.1198	578.3	577.8	577.9	69291.0
2024-10-30 04:00:00	QQQ	ETF	501.44	501.9	500.7	500.86	60562.0
2024-10-30 05:00:00	QQQ	ETF	500.7	501.48	500.55	501.06	26497.0
2024-10-30 06:00:00	QQQ	ETF	501.08	501.23	500.8	501.22	112470.0
2024-10-30 07:00:00	QQQ	ETF	501.26	501.63	500.67	500.67	163184.0
2024-10-30 08:00:00	QQQ	ETF	501.19	501.78	499.7401	500.02	270410.0
2024-10-30 09:00:00	QQQ	ETF	500.02	500.05	496.6	498.77	3282697.0
2024-10-30 10:00:00	QQQ	ETF	498.72	500.35	498.41	499.1975	2795173.0
2024-10-30 11:00:00	QQQ	ETF	499.15	499.99	498.15	499.66	1959819.0
2024-10-30 12:00:00	QQQ	ETF	499.63	499.92	498.87	499.04	1010916.0
2024-10-30 13:00:00	QQQ	ETF	499.03	499.24	496.98	497.39	2286791.0
2024-10-30 14:00:00	QQQ	ETF	497.38	498.46	497.38	498.03	2038713.0
2024-10-30 15:00:00	QQQ	ETF	498.03	498.035	495.89	496.4	4292922.0
2024-10-30 16:00:00	QQQ	ETF	496.37	497.7	494.86	495.71	1554452.0
2024-10-30 17:00:00	QQQ	ETF	495.63	495.92	494.48	494.56	159269.0
2024-10-30 18:00:00	QQQ	ETF	494.56	495.31	493.75	493.93	592352.0
2024-10-30 19:00:00	QQQ	ETF	493.9	494.16	493.65	493.7	80899.0
2024-10-30 04:00:00	IWM	ETF	221.86	222.23	221.77	221.81	15553.0
2024-10-30 05:00:00	IWM	ETF	221.75	221.75	221.25	221.49	15043.0
2024-10-30 06:00:00	IWM	ETF	221.5	221.55	221.21	221.42	75106.0
2024-10-30 07:00:00	IWM	ETF	221.42	221.61	220.97	221.03	75085.0
2024-10-30 08:00:00	IWM	ETF	220.99	222.04	220.94	221.07	235783.0
2024-10-30 09:00:00	IWM	ETF	221.0	223.6	220.81	223.54	2213161.0
2024-10-30 10:00:00	IWM	ETF	223.52	224.48	223.16	223.22	2429920.0
2024-10-30 11:00:00	IWM	ETF	223.23	223.64	222.88	223.3	1330947.0
2024-10-30 12:00:00	IWM	ETF	223.28	223.28	222.71	222.73	1192779.0
2024-10-30 13:00:00	IWM	ETF	222.72	223.2	222.31	222.58	1325077.0
2024-10-30 14:00:00	IWM	ETF	222.61	223.09	222.5101	222.595	1107670.0
2024-10-30 15:00:00	IWM	ETF	222.6	222.6	221.36	221.49	3172304.0
2024-10-30 16:00:00	IWM	ETF	221.49	221.62	221.0	221.44	1642556.0
2024-10-30 17:00:00	IWM	ETF	221.06	221.44	221.02	221.2101	330421.0
2024-10-30 18:00:00	IWM	ETF	221.31	222.06	221.31	221.88	87413.0
2024-10-30 19:00:00	IWM	ETF	221.86	222.14	221.8	221.8199	16598.0
2024-10-30 04:00:00	DIA	ETF	422.83	422.89	422.72	422.89	1830.0
2024-10-30 05:00:00	DIA	ETF	422.77	422.8	422.62	422.62	2199.0

> showing 50 of 21,599 rows — these rows as CSV

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