PREVIEW / etf_1hour / 2024-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-01-04.parquet
  size:    522 KB
  rows:    19,305

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-04 04:00:00	SPY	ETF	469.4	469.81	469.26	469.71	10267.0
2024-01-04 05:00:00	SPY	ETF	469.72	469.78	469.24	469.52	33631.0
2024-01-04 06:00:00	SPY	ETF	469.46	469.74	468.95	469.1	42106.0
2024-01-04 07:00:00	SPY	ETF	469.07	469.74	468.68	469.35	125724.0
2024-01-04 08:00:00	SPY	ETF	469.08	469.89	468.5	468.66	346907.0
2024-01-04 09:00:00	SPY	ETF	468.66	469.26	468.1	468.92	5983542.0
2024-01-04 10:00:00	SPY	ETF	468.9	470.24	468.685	469.851	7342636.0
2024-01-04 11:00:00	SPY	ETF	469.87	470.96	469.46	469.72	6042437.0
2024-01-04 12:00:00	SPY	ETF	469.72	469.8382	468.665	469.132	4845696.0
2024-01-04 13:00:00	SPY	ETF	469.13	469.47	468.97	469.07	3275852.0
2024-01-04 14:00:00	SPY	ETF	469.08	469.33	468.17	468.68	7345987.0
2024-01-04 15:00:00	SPY	ETF	468.6832	469.04	467.05	467.27	18689796.0
2024-01-04 16:00:00	SPY	ETF	467.27	467.8	467.07	467.57	4862214.0
2024-01-04 17:00:00	SPY	ETF	467.57	467.73	467.28	467.73	64538.0
2024-01-04 18:00:00	SPY	ETF	467.67	467.96	467.6	467.75	48896.0
2024-01-04 19:00:00	SPY	ETF	467.74	467.96	467.71	467.8	45678.0
2024-01-04 04:00:00	QQQ	ETF	398.81	399.47	398.67	399.41	20049.0
2024-01-04 05:00:00	QQQ	ETF	399.42	399.42	398.9	399.02	27675.0
2024-01-04 06:00:00	QQQ	ETF	399.08	399.32	398.25	398.25	47201.0
2024-01-04 07:00:00	QQQ	ETF	398.27	398.4	397.71	398.0	139935.0
2024-01-04 08:00:00	QQQ	ETF	398.3205	399.66	396.43	396.581	388440.0
2024-01-04 09:00:00	QQQ	ETF	396.58	397.56	396.12	396.61	4512005.0
2024-01-04 10:00:00	QQQ	ETF	396.6	398.59	396.26	398.175	5998909.0
2024-01-04 11:00:00	QQQ	ETF	398.19	399.59	397.94	398.1501	4459224.0
2024-01-04 12:00:00	QQQ	ETF	398.16	398.28	397.17	397.76	2765246.0
2024-01-04 13:00:00	QQQ	ETF	397.75	398.31	397.45	397.741	1852133.0
2024-01-04 14:00:00	QQQ	ETF	397.75	397.98	396.79	397.2982	2778001.0
2024-01-04 15:00:00	QQQ	ETF	397.305	397.885	396.06	396.24	6319875.0
2024-01-04 16:00:00	QQQ	ETF	396.22	396.54	396.09	396.36	1093669.0
2024-01-04 17:00:00	QQQ	ETF	396.37	396.44	396.2	396.41	31231.0
2024-01-04 18:00:00	QQQ	ETF	396.42	396.79	396.42	396.54	55008.0
2024-01-04 19:00:00	QQQ	ETF	396.5	396.75	396.48	396.58	37016.0
2024-01-04 04:00:00	IWM	ETF	195.13	195.4	195.0	195.34	18234.0
2024-01-04 05:00:00	IWM	ETF	195.33	195.49	195.03	195.34	14361.0
2024-01-04 06:00:00	IWM	ETF	195.4	195.51	194.64	194.64	125824.0
2024-01-04 07:00:00	IWM	ETF	194.61	195.37	194.3	195.08	112939.0
2024-01-04 08:00:00	IWM	ETF	194.86	195.52	193.3	193.325	282552.0
2024-01-04 09:00:00	IWM	ETF	193.51	195.33	193.11	194.31	4261477.0
2024-01-04 10:00:00	IWM	ETF	194.3	195.13	194.14	194.59	4963201.0
2024-01-04 11:00:00	IWM	ETF	194.59	195.49	194.26	194.545	4002915.0
2024-01-04 12:00:00	IWM	ETF	194.54	194.72	193.905	194.27	2541979.0
2024-01-04 13:00:00	IWM	ETF	194.26	194.92	194.17	194.64	1732119.0
2024-01-04 14:00:00	IWM	ETF	194.64	194.815	193.955	194.35	2747753.0
2024-01-04 15:00:00	IWM	ETF	194.34	194.73	193.69	193.86	7245046.0
2024-01-04 16:00:00	IWM	ETF	193.82	194.4084	193.82	194.19	3625966.0
2024-01-04 17:00:00	IWM	ETF	194.17	194.25	194.0503	194.21	43744.0
2024-01-04 18:00:00	IWM	ETF	194.17	194.45	194.14	194.14	19807.0
2024-01-04 19:00:00	IWM	ETF	194.13	194.2799	194.02	194.2	9013.0
2024-01-04 04:00:00	DIA	ETF	374.87	374.87	374.87	374.87	250.0
2024-01-04 05:00:00	DIA	ETF	374.82	374.95	374.74	374.95	350.0

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

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