PREVIEW / etf_1hour / 2023-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-27.parquet
  size:    529 KB
  rows:    19,504

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-12-27 04:00:00	SPY	ETF	475.64	475.66	475.49	475.56	10274.0
2023-12-27 05:00:00	SPY	ETF	475.6	475.64	475.49	475.64	5772.0
2023-12-27 06:00:00	SPY	ETF	475.55	475.69	475.55	475.64	20406.0
2023-12-27 07:00:00	SPY	ETF	475.66	475.72	475.37	475.69	37112.0
2023-12-27 08:00:00	SPY	ETF	475.47	476.08	475.45	475.74	94543.0
2023-12-27 09:00:00	SPY	ETF	475.72	476.14	475.27	476.01	3800747.0
2023-12-27 10:00:00	SPY	ETF	476.01	476.14	475.08	475.41	5495989.0
2023-12-27 11:00:00	SPY	ETF	475.41	475.93	475.185	475.775	4017068.0
2023-12-27 12:00:00	SPY	ETF	475.77	476.07	475.29	475.55	2976122.0
2023-12-27 13:00:00	SPY	ETF	475.54	476.66	475.54	476.02	4385069.0
2023-12-27 14:00:00	SPY	ETF	476.02	476.0203	474.89	475.51	6258215.0
2023-12-27 15:00:00	SPY	ETF	475.51	476.57	475.16	476.51	12656002.0
2023-12-27 16:00:00	SPY	ETF	476.5	476.73	476.2344	476.6099	3759921.0
2023-12-27 17:00:00	SPY	ETF	476.58	476.64	476.51	476.54	893454.0
2023-12-27 18:00:00	SPY	ETF	476.56	476.66	476.43	476.55	53059.0
2023-12-27 19:00:00	SPY	ETF	476.5601	476.9	476.5601	476.9	29504.0
2023-12-27 04:00:00	QQQ	ETF	411.07	411.08	410.74	410.8	36201.0
2023-12-27 05:00:00	QQQ	ETF	410.81	410.91	410.7	410.8	17455.0
2023-12-27 06:00:00	QQQ	ETF	410.75	410.89	410.75	410.8	5690.0
2023-12-27 07:00:00	QQQ	ETF	410.85	410.93	410.6	410.87	47334.0
2023-12-27 08:00:00	QQQ	ETF	410.85	411.3	410.6196	411.18	75396.0
2023-12-27 09:00:00	QQQ	ETF	411.12	411.655	410.9	411.51	2120390.0
2023-12-27 10:00:00	QQQ	ETF	411.51	411.714	410.08	410.62	3568341.0
2023-12-27 11:00:00	QQQ	ETF	410.61	411.08	410.29	410.88	2587707.0
2023-12-27 12:00:00	QQQ	ETF	410.88	411.07	410.36	410.59	2100848.0
2023-12-27 13:00:00	QQQ	ETF	410.58	411.7875	410.58	411.275	3839176.0
2023-12-27 14:00:00	QQQ	ETF	411.27	411.32	410.225	410.68	4065004.0
2023-12-27 15:00:00	QQQ	ETF	410.69	411.52	410.54	411.5	4507308.0
2023-12-27 16:00:00	QQQ	ETF	411.49	411.84	411.31	411.79	745444.0
2023-12-27 17:00:00	QQQ	ETF	411.79	411.83	411.7	411.79	29678.0
2023-12-27 18:00:00	QQQ	ETF	411.72	411.72	411.52	411.62	17887.0
2023-12-27 19:00:00	QQQ	ETF	411.67	411.95	411.67	411.9	19076.0
2023-12-27 04:00:00	IWM	ETF	204.06	204.59	204.06	204.3	20464.0
2023-12-27 05:00:00	IWM	ETF	204.44	204.46	204.28	204.46	4421.0
2023-12-27 06:00:00	IWM	ETF	204.46	204.55	204.4	204.45	25080.0
2023-12-27 07:00:00	IWM	ETF	204.44	204.56	204.33	204.51	52740.0
2023-12-27 08:00:00	IWM	ETF	204.52	204.75	203.91	204.73	99984.0
2023-12-27 09:00:00	IWM	ETF	204.694	204.89	203.9725	204.75	3663701.0
2023-12-27 10:00:00	IWM	ETF	204.75	205.2	203.615	203.66	4465362.0
2023-12-27 11:00:00	IWM	ETF	203.66	204.48	203.395	204.33	3709960.0
2023-12-27 12:00:00	IWM	ETF	204.32	204.65	204.2	204.445	1822495.0
2023-12-27 13:00:00	IWM	ETF	204.44	205.49	204.44	204.56	3652972.0
2023-12-27 14:00:00	IWM	ETF	204.55	204.8	203.78	204.36	4643211.0
2023-12-27 15:00:00	IWM	ETF	204.37	204.8	204.075	204.73	5339070.0
2023-12-27 16:00:00	IWM	ETF	204.73	204.85	204.5259	204.77	1930922.0
2023-12-27 17:00:00	IWM	ETF	204.78	204.93	204.78	204.84	10891.0
2023-12-27 18:00:00	IWM	ETF	204.81	204.89	204.68	204.88	26108.0
2023-12-27 19:00:00	IWM	ETF	204.89	205.06	204.89	205.05	42874.0
2023-12-27 04:00:00	DIA	ETF	375.27	375.37	375.27	375.36	365.0
2023-12-27 05:00:00	DIA	ETF	375.38	375.47	375.34	375.47	2368.0

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

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