PREVIEW / etf_1hour / 2024-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-04-19.parquet
  size:    534 KB
  rows:    19,791

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-04-19 04:00:00	SPY	ETF	497.0	497.88	494.97	497.19	70422.0
2024-04-19 05:00:00	SPY	ETF	497.11	498.17	497.1	497.63	132164.0
2024-04-19 06:00:00	SPY	ETF	497.63	498.36	497.0	497.77	271365.0
2024-04-19 07:00:00	SPY	ETF	497.78	499.5	497.38	499.15	752547.0
2024-04-19 08:00:00	SPY	ETF	497.73	500.35	495.0	499.45	779666.0
2024-04-19 09:00:00	SPY	ETF	499.34	500.455	498.6	499.64	6462075.0
2024-04-19 10:00:00	SPY	ETF	499.62	500.14	497.58	498.54	9676199.0
2024-04-19 11:00:00	SPY	ETF	498.53	498.9592	496.98	497.11	6926409.0
2024-04-19 12:00:00	SPY	ETF	497.09	497.77	495.08	497.1	8647406.0
2024-04-19 13:00:00	SPY	ETF	497.09	498.46	496.45	497.3	6638627.0
2024-04-19 14:00:00	SPY	ETF	497.29	497.3399	494.02	494.9197	10081319.0
2024-04-19 15:00:00	SPY	ETF	494.91	495.72	493.86	495.1	16460967.0
2024-04-19 16:00:00	SPY	ETF	495.09	495.35	494.71	495.07	5399945.0
2024-04-19 17:00:00	SPY	ETF	495.16	495.16	494.75	494.8	106222.0
2024-04-19 18:00:00	SPY	ETF	494.9	494.92	494.6	494.6	69221.0
2024-04-19 19:00:00	SPY	ETF	494.64	494.71	494.51	494.71	30810.0
2024-04-19 04:00:00	QQQ	ETF	420.71	421.48	419.68	420.19	144276.0
2024-04-19 05:00:00	QQQ	ETF	420.26	421.47	420.24	420.77	141990.0
2024-04-19 06:00:00	QQQ	ETF	420.84	421.52	420.27	420.96	93123.0
2024-04-19 07:00:00	QQQ	ETF	421.06	422.549	420.75	422.461	473046.0
2024-04-19 08:00:00	QQQ	ETF	421.0	423.727	418.27	422.8	712756.0
2024-04-19 09:00:00	QQQ	ETF	422.74	422.9	420.65	421.28	6314966.0
2024-04-19 10:00:00	QQQ	ETF	421.27	421.7	418.52	419.68	8349447.0
2024-04-19 11:00:00	QQQ	ETF	419.64	419.67	417.28	417.32	4632867.0
2024-04-19 12:00:00	QQQ	ETF	417.31	417.99	415.23	417.165	6595064.0
2024-04-19 13:00:00	QQQ	ETF	417.15	418.52	416.51	417.28	4497594.0
2024-04-19 14:00:00	QQQ	ETF	417.27	417.33	413.48	414.17	7305611.0
2024-04-19 15:00:00	QQQ	ETF	414.12	415.26	413.07	414.64	13452994.0
2024-04-19 16:00:00	QQQ	ETF	414.64	414.8	414.11	414.6	2211317.0
2024-04-19 17:00:00	QQQ	ETF	414.61	414.65	414.2	414.39	79084.0
2024-04-19 18:00:00	QQQ	ETF	414.4	414.65	414.06	414.0627	34216.0
2024-04-19 19:00:00	QQQ	ETF	414.06	414.1	413.8	413.85	50110.0
2024-04-19 04:00:00	IWM	ETF	191.68	191.88	191.34	191.66	61951.0
2024-04-19 05:00:00	IWM	ETF	191.73	191.74	191.41	191.41	63276.0
2024-04-19 06:00:00	IWM	ETF	191.4	191.81	191.2	191.8	153748.0
2024-04-19 07:00:00	IWM	ETF	191.79	192.83	191.68	192.63	766139.0
2024-04-19 08:00:00	IWM	ETF	191.8388	193.08	190.62	192.44	437851.0
2024-04-19 09:00:00	IWM	ETF	192.43	194.26	191.77	194.1	3985602.0
2024-04-19 10:00:00	IWM	ETF	194.1	194.39	192.71	193.105	4247932.0
2024-04-19 11:00:00	IWM	ETF	193.1	193.51	192.71	193.12	2342601.0
2024-04-19 12:00:00	IWM	ETF	193.1	193.385	192.0	192.88	3143186.0
2024-04-19 13:00:00	IWM	ETF	192.87	193.49	192.63	192.95	2561621.0
2024-04-19 14:00:00	IWM	ETF	192.95	192.96	191.34	191.95	3473389.0
2024-04-19 15:00:00	IWM	ETF	191.94	193.32	191.71	193.07	5877352.0
2024-04-19 16:00:00	IWM	ETF	193.14	193.4	193.0	193.31	1135305.0
2024-04-19 17:00:00	IWM	ETF	193.31	193.42	193.14	193.42	69771.0
2024-04-19 18:00:00	IWM	ETF	193.4	193.42	193.08	193.12	160414.0
2024-04-19 19:00:00	IWM	ETF	193.09	193.25	193.03	193.25	10574.0
2024-04-19 04:00:00	DIA	ETF	373.4	376.63	373.4	376.15	5714.0
2024-04-19 05:00:00	DIA	ETF	376.26	376.85	376.26	376.85	2849.0

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

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