PREVIEW / etf_1hour / 2024-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-01-08.parquet
  size:    535 KB
  rows:    19,544

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-01-08 04:00:00	SPY	ETF	467.7	467.7	466.13	467.04	25614.0
2024-01-08 05:00:00	SPY	ETF	467.18	467.44	466.91	467.0	7068.0
2024-01-08 06:00:00	SPY	ETF	466.81	467.79	466.61	467.59	55035.0
2024-01-08 07:00:00	SPY	ETF	467.67	468.07	467.47	468.07	87458.0
2024-01-08 08:00:00	SPY	ETF	467.79	468.43	466.86	468.02	216827.0
2024-01-08 09:00:00	SPY	ETF	468.05	469.78	467.82	469.73	5921655.0
2024-01-08 10:00:00	SPY	ETF	469.73	470.745	469.35	470.36	8134554.0
2024-01-08 11:00:00	SPY	ETF	470.38	470.9	469.97	470.8799	5308143.0
2024-01-08 12:00:00	SPY	ETF	470.88	471.635	470.56	471.47	4977389.0
2024-01-08 13:00:00	SPY	ETF	471.47	472.09	471.245	472.02	3907502.0
2024-01-08 14:00:00	SPY	ETF	472.03	474.0	471.91	473.7599	8194608.0
2024-01-08 15:00:00	SPY	ETF	473.76	474.75	473.38	474.56	18850055.0
2024-01-08 16:00:00	SPY	ETF	474.55	474.6062	470.34	474.18	4060100.0
2024-01-08 17:00:00	SPY	ETF	474.24	474.39	474.18	474.25	28591.0
2024-01-08 18:00:00	SPY	ETF	474.21	474.21	474.07	474.2	30626.0
2024-01-08 19:00:00	SPY	ETF	474.17	474.29	474.14	474.21	32453.0
2024-01-08 04:00:00	QQQ	ETF	396.0	396.14	394.82	395.81	47404.0
2024-01-08 05:00:00	QQQ	ETF	395.79	396.33	395.79	395.87	29165.0
2024-01-08 06:00:00	QQQ	ETF	395.93	396.89	395.55	396.78	96627.0
2024-01-08 07:00:00	QQQ	ETF	396.73	397.38	396.61	397.34	123669.0
2024-01-08 08:00:00	QQQ	ETF	396.76	397.68	394.9604	397.19	245934.0
2024-01-08 09:00:00	QQQ	ETF	397.29	400.92	397.1	400.81	5286516.0
2024-01-08 10:00:00	QQQ	ETF	400.815	401.8194	400.43	401.49	4427720.0
2024-01-08 11:00:00	QQQ	ETF	401.5	402.02	401.08	401.97	3037380.0
2024-01-08 12:00:00	QQQ	ETF	401.97	402.96	401.89	402.915	2804931.0
2024-01-08 13:00:00	QQQ	ETF	402.92	403.55	402.66	403.5	2233119.0
2024-01-08 14:00:00	QQQ	ETF	403.5	404.78	403.27	404.56	4078249.0
2024-01-08 15:00:00	QQQ	ETF	404.55	405.24	404.255	405.01	8553835.0
2024-01-08 16:00:00	QQQ	ETF	405.015	405.12	404.6599	404.68	2034810.0
2024-01-08 17:00:00	QQQ	ETF	404.68	404.84	404.68	404.8	31296.0
2024-01-08 18:00:00	QQQ	ETF	404.75	404.75	404.5	404.63	91209.0
2024-01-08 19:00:00	QQQ	ETF	404.62	404.81	404.57	404.67	109331.0
2024-01-08 04:00:00	IWM	ETF	193.02	193.17	192.11	192.75	30719.0
2024-01-08 05:00:00	IWM	ETF	192.71	192.86	192.51	192.51	4625.0
2024-01-08 06:00:00	IWM	ETF	192.57	193.28	192.38	192.94	31568.0
2024-01-08 07:00:00	IWM	ETF	192.96	193.23	192.8	193.16	31227.0
2024-01-08 08:00:00	IWM	ETF	192.96	193.4	192.7813	192.88	95688.0
2024-01-08 09:00:00	IWM	ETF	193.11	193.82	192.26	193.77	4275224.0
2024-01-08 10:00:00	IWM	ETF	193.745	195.205	193.26	194.86	4566761.0
2024-01-08 11:00:00	IWM	ETF	194.87	195.3	194.611	195.28	3590048.0
2024-01-08 12:00:00	IWM	ETF	195.27	195.59	194.69	195.5	2744777.0
2024-01-08 13:00:00	IWM	ETF	195.5	196.18	195.44	196.15	2591523.0
2024-01-08 14:00:00	IWM	ETF	196.16	196.73	195.92	196.55	2200484.0
2024-01-08 15:00:00	IWM	ETF	196.56	196.97	196.2801	196.93	5114421.0
2024-01-08 16:00:00	IWM	ETF	196.94	196.95	196.68	196.73	944368.0
2024-01-08 17:00:00	IWM	ETF	196.75	196.85	196.72	196.8	8027.0
2024-01-08 18:00:00	IWM	ETF	196.77	196.79	196.54	196.65	30687.0
2024-01-08 19:00:00	IWM	ETF	196.62	196.75	196.51	196.51	70583.0
2024-01-08 04:00:00	DIA	ETF	373.59	373.59	372.44	372.45	2560.0
2024-01-08 05:00:00	DIA	ETF	372.97	372.98	372.81	372.81	1000.0

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

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