PREVIEW / etf_1hour / 2024-02-08

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-02-08.parquet
  size:    533 KB
  rows:    19,578

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-02-08 04:00:00	SPY	ETF	497.98	498.07	497.88	498.02	14584.0
2024-02-08 05:00:00	SPY	ETF	497.96	498.0	497.69	497.76	13667.0
2024-02-08 06:00:00	SPY	ETF	497.77	497.79	497.2	497.44	30469.0
2024-02-08 07:00:00	SPY	ETF	497.51	497.68	497.37	497.44	134361.0
2024-02-08 08:00:00	SPY	ETF	497.5097	498.34	497.23	497.85	285989.0
2024-02-08 09:00:00	SPY	ETF	497.85	498.35	497.66	497.9975	3443468.0
2024-02-08 10:00:00	SPY	ETF	498.0	498.23	497.33	498.17	5310861.0
2024-02-08 11:00:00	SPY	ETF	498.1621	498.21	497.26	497.82	4405601.0
2024-02-08 12:00:00	SPY	ETF	497.81	498.14	497.42	497.58	3365013.0
2024-02-08 13:00:00	SPY	ETF	497.59	498.34	497.53	498.13	4729091.0
2024-02-08 14:00:00	SPY	ETF	498.14	498.34	497.5801	498.25	4348437.0
2024-02-08 15:00:00	SPY	ETF	498.24	498.71	497.86	498.4	10968939.0
2024-02-08 16:00:00	SPY	ETF	498.42	498.42	497.6882	498.22	4105565.0
2024-02-08 17:00:00	SPY	ETF	498.21	498.39	498.21	498.25	124028.0
2024-02-08 18:00:00	SPY	ETF	498.25	498.32	498.12	498.29	79029.0
2024-02-08 19:00:00	SPY	ETF	498.32	498.45	498.06	498.06	62619.0
2024-02-08 04:00:00	QQQ	ETF	432.14	432.55	432.14	432.4	53837.0
2024-02-08 05:00:00	QQQ	ETF	432.48	432.48	432.03	432.19	50297.0
2024-02-08 06:00:00	QQQ	ETF	432.19	432.19	431.31	431.5	31257.0
2024-02-08 07:00:00	QQQ	ETF	431.54	431.78	431.37	431.42	78350.0
2024-02-08 08:00:00	QQQ	ETF	431.61	432.63	431.1	431.84	188073.0
2024-02-08 09:00:00	QQQ	ETF	431.78	432.5	431.42	432.475	2955551.0
2024-02-08 10:00:00	QQQ	ETF	432.49	433.46	431.84	433.39	3404848.0
2024-02-08 11:00:00	QQQ	ETF	433.39	433.5	432.66	433.32	2408386.0
2024-02-08 12:00:00	QQQ	ETF	433.31	433.56	432.43	432.6	2203796.0
2024-02-08 13:00:00	QQQ	ETF	432.6	433.47	432.49	432.909	2701600.0
2024-02-08 14:00:00	QQQ	ETF	432.91	433.07	431.9012	432.7699	2390296.0
2024-02-08 15:00:00	QQQ	ETF	432.77	433.15	432.4	432.8	4010429.0
2024-02-08 16:00:00	QQQ	ETF	432.8	432.8	432.5	432.7	587364.0
2024-02-08 17:00:00	QQQ	ETF	432.76	432.81	432.65	432.73	33551.0
2024-02-08 18:00:00	QQQ	ETF	432.62	432.9	432.54	432.87	31565.0
2024-02-08 19:00:00	QQQ	ETF	432.9	433.1	432.65	432.68	41068.0
2024-02-08 04:00:00	IWM	ETF	192.56	192.66	192.42	192.53	11814.0
2024-02-08 05:00:00	IWM	ETF	192.59	192.84	192.48	192.74	8372.0
2024-02-08 06:00:00	IWM	ETF	192.73	192.73	192.32	192.58	14055.0
2024-02-08 07:00:00	IWM	ETF	192.67	192.99	192.65	192.96	24294.0
2024-02-08 08:00:00	IWM	ETF	192.6692	193.61	192.5004	193.25	215532.0
2024-02-08 09:00:00	IWM	ETF	193.15	194.22	192.71	194.17	3233114.0
2024-02-08 10:00:00	IWM	ETF	194.16	195.515	194.08	195.27	5490239.0
2024-02-08 11:00:00	IWM	ETF	195.27	195.41	194.49	195.08	3942232.0
2024-02-08 12:00:00	IWM	ETF	195.075	195.26	194.77	195.02	1978601.0
2024-02-08 13:00:00	IWM	ETF	195.01	196.185	194.98	196.1	3546670.0
2024-02-08 14:00:00	IWM	ETF	196.11	196.37	195.78	196.13	2509830.0
2024-02-08 15:00:00	IWM	ETF	196.12	196.34	195.88	196.21	5331236.0
2024-02-08 16:00:00	IWM	ETF	196.15	196.34	196.0333	196.11	1978893.0
2024-02-08 17:00:00	IWM	ETF	196.14	196.25	196.12	196.2	13124.0
2024-02-08 18:00:00	IWM	ETF	196.16	196.32	196.1	196.28	30868.0
2024-02-08 19:00:00	IWM	ETF	196.32	196.42	196.15	196.18	31249.0
2024-02-08 05:00:00	DIA	ETF	386.67	386.67	386.67	386.67	100.0
2024-02-08 06:00:00	DIA	ETF	386.62	386.62	386.56	386.56	700.0

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

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