PREVIEW / etf_1hour / 2023-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-05.parquet
  size:    477 KB
  rows:    17,512

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
2023-10-05 04:00:00	SPY	ETF	424.06	424.82	423.66	423.71	25979.0
2023-10-05 05:00:00	SPY	ETF	423.6	423.74	423.21	423.6	12954.0
2023-10-05 06:00:00	SPY	ETF	423.47	424.65	423.47	424.53	32188.0
2023-10-05 07:00:00	SPY	ETF	424.48	425.11	424.0	425.05	261500.0
2023-10-05 08:00:00	SPY	ETF	424.93	425.45	423.13	423.86	754858.0
2023-10-05 09:00:00	SPY	ETF	423.9	425.26	423.33	424.13	5650151.0
2023-10-05 10:00:00	SPY	ETF	424.14	424.15	421.645	421.9801	10174566.0
2023-10-05 11:00:00	SPY	ETF	421.98	422.6	421.1701	422.03	7757044.0
2023-10-05 12:00:00	SPY	ETF	422.0291	423.45	421.85	422.6199	6013792.0
2023-10-05 13:00:00	SPY	ETF	422.62	424.1999	421.87	424.07	7017792.0
2023-10-05 14:00:00	SPY	ETF	424.095	425.37	423.8908	425.04	7143437.0
2023-10-05 15:00:00	SPY	ETF	425.065	425.18	424.18	424.46	10317102.0
2023-10-05 16:00:00	SPY	ETF	424.46	425.0	421.7526	424.22	2188260.0
2023-10-05 17:00:00	SPY	ETF	424.26	424.27	423.84	424.11	67886.0
2023-10-05 18:00:00	SPY	ETF	424.1	424.29	424.1	424.27	17103.0
2023-10-05 19:00:00	SPY	ETF	424.17	424.22	423.91	423.96	22687.0
2023-10-05 04:00:00	QQQ	ETF	359.14	359.94	358.8	358.8	49744.0
2023-10-05 05:00:00	QQQ	ETF	358.8	359.1	358.41	358.92	44347.0
2023-10-05 06:00:00	QQQ	ETF	358.82	359.96	358.68	359.87	56517.0
2023-10-05 07:00:00	QQQ	ETF	359.84	360.63	359.4	360.59	198707.0
2023-10-05 08:00:00	QQQ	ETF	359.8	360.89	358.58	359.27	728066.0
2023-10-05 09:00:00	QQQ	ETF	359.28	360.15	357.57	358.0075	4682069.0
2023-10-05 10:00:00	QQQ	ETF	358.01	358.03	355.14	355.5754	7345830.0
2023-10-05 11:00:00	QQQ	ETF	355.575	357.0	355.18	356.363	5564345.0
2023-10-05 12:00:00	QQQ	ETF	356.37	357.91	356.1916	357.22	3708534.0
2023-10-05 13:00:00	QQQ	ETF	357.2301	358.61	356.45	358.46	3871003.0
2023-10-05 14:00:00	QQQ	ETF	358.47	359.68	358.3	359.492	3958199.0
2023-10-05 15:00:00	QQQ	ETF	359.5	359.6373	358.4	358.67	5191473.0
2023-10-05 16:00:00	QQQ	ETF	358.67	358.81	357.5971	358.58	1240863.0
2023-10-05 17:00:00	QQQ	ETF	358.56	358.59	358.3	358.39	31709.0
2023-10-05 18:00:00	QQQ	ETF	358.39	358.57	358.39	358.5	61114.0
2023-10-05 19:00:00	QQQ	ETF	358.46	358.56	358.31	358.32	19882.0
2023-10-05 04:00:00	IWM	ETF	170.79	171.28	170.62	170.62	25427.0
2023-10-05 05:00:00	IWM	ETF	170.56	170.67	170.34	170.67	30506.0
2023-10-05 06:00:00	IWM	ETF	170.51	171.01	170.51	170.95	36084.0
2023-10-05 07:00:00	IWM	ETF	170.99	171.36	170.85	171.32	44645.0
2023-10-05 08:00:00	IWM	ETF	171.07	171.61	170.5	170.8797	219696.0
2023-10-05 09:00:00	IWM	ETF	170.86	171.87	170.51	171.56	3688920.0
2023-10-05 10:00:00	IWM	ETF	171.57	171.58	170.09	170.385	4510587.0
2023-10-05 11:00:00	IWM	ETF	170.37	170.52	170.01	170.14	2917004.0
2023-10-05 12:00:00	IWM	ETF	170.12	170.8	170.07	170.32	2454660.0
2023-10-05 13:00:00	IWM	ETF	170.32	171.17	169.94	171.11	2625171.0
2023-10-05 14:00:00	IWM	ETF	171.12	171.81	170.925	171.795	3633656.0
2023-10-05 15:00:00	IWM	ETF	171.79	171.9	171.335	171.4	5045020.0
2023-10-05 16:00:00	IWM	ETF	171.35	171.45	171.2	171.27	1579127.0
2023-10-05 17:00:00	IWM	ETF	171.24	171.26	171.11	171.18	13819.0
2023-10-05 18:00:00	IWM	ETF	171.23	171.35	171.23	171.35	4232.0
2023-10-05 19:00:00	IWM	ETF	171.31	171.31	171.05	171.079	99130.0
2023-10-05 04:00:00	DIA	ETF	330.97	330.97	330.57	330.57	600.0
2023-10-05 05:00:00	DIA	ETF	329.99	330.01	329.99	330.01	700.0

> showing 50 of 17,512 rows — these rows as CSV

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