PREVIEW / etf_1hour / 2023-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-29.parquet
  size:    527 KB
  rows:    19,482

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-29 04:00:00	SPY	ETF	477.4	477.46	477.11	477.11	19202.0
2023-12-29 05:00:00	SPY	ETF	477.12	477.23	476.97	477.23	18395.0
2023-12-29 06:00:00	SPY	ETF	477.1	477.36	477.1	477.26	9292.0
2023-12-29 07:00:00	SPY	ETF	477.19	477.24	476.54	476.7	74643.0
2023-12-29 08:00:00	SPY	ETF	477.0	477.63	476.48	476.51	156216.0
2023-12-29 09:00:00	SPY	ETF	476.53	476.93	476.41	476.76	4025048.0
2023-12-29 10:00:00	SPY	ETF	476.76	477.03	475.04	475.4403	9958379.0
2023-12-29 11:00:00	SPY	ETF	475.45	475.685	473.77	474.2	10796245.0
2023-12-29 12:00:00	SPY	ETF	474.2	474.58	473.3	474.48	6857159.0
2023-12-29 13:00:00	SPY	ETF	474.48	475.32	474.305	475.05	6994152.0
2023-12-29 14:00:00	SPY	ETF	475.06	475.695	474.89	475.565	6980431.0
2023-12-29 15:00:00	SPY	ETF	475.565	475.89	474.49	475.35	22788666.0
2023-12-29 16:00:00	SPY	ETF	475.35	476.481	474.8	474.88	5941339.0
2023-12-29 17:00:00	SPY	ETF	474.92	475.25	474.71	475.25	116943.0
2023-12-29 18:00:00	SPY	ETF	475.2	475.31	475.01	475.112	670148.0
2023-12-29 19:00:00	SPY	ETF	475.11	475.24	474.9	475.07	15256.0
2023-12-29 04:00:00	QQQ	ETF	411.93	412.07	411.75	411.75	13648.0
2023-12-29 05:00:00	QQQ	ETF	411.72	411.89	411.66	411.81	5526.0
2023-12-29 06:00:00	QQQ	ETF	411.82	412.04	411.79	411.93	3395.0
2023-12-29 07:00:00	QQQ	ETF	411.92	411.95	411.01	411.2	46094.0
2023-12-29 08:00:00	QQQ	ETF	411.55	412.23	410.82	411.18	115490.0
2023-12-29 09:00:00	QQQ	ETF	411.2	411.64	410.9	411.375	2095020.0
2023-12-29 10:00:00	QQQ	ETF	411.375	411.591	409.08	409.51	4208949.0
2023-12-29 11:00:00	QQQ	ETF	409.52	409.71	407.58	408.51	5471905.0
2023-12-29 12:00:00	QQQ	ETF	408.51	408.97	407.7	408.91	3313821.0
2023-12-29 13:00:00	QQQ	ETF	408.9	409.915	408.75	409.62	2859608.0
2023-12-29 14:00:00	QQQ	ETF	409.625	410.13	409.41	410.04	2379134.0
2023-12-29 15:00:00	QQQ	ETF	410.045	410.23	408.72	409.46	7252720.0
2023-12-29 16:00:00	QQQ	ETF	409.47	410.5	408.975	409.17	1063692.0
2023-12-29 17:00:00	QQQ	ETF	409.17	409.48	409.17	409.48	27103.0
2023-12-29 18:00:00	QQQ	ETF	409.37	409.4	409.23	409.23	15471.0
2023-12-29 19:00:00	QQQ	ETF	409.19	409.19	409.0	409.06	8980.0
2023-12-29 04:00:00	IWM	ETF	204.38	204.44	204.06	204.06	5748.0
2023-12-29 05:00:00	IWM	ETF	204.08	204.13	203.91	204.1	4441.0
2023-12-29 06:00:00	IWM	ETF	204.12	204.39	204.12	204.27	3461.0
2023-12-29 07:00:00	IWM	ETF	204.24	204.25	203.58	203.82	43290.0
2023-12-29 08:00:00	IWM	ETF	204.0005	204.63	203.68	203.6905	92149.0
2023-12-29 09:00:00	IWM	ETF	203.76	204.0301	202.94	203.33	2882727.0
2023-12-29 10:00:00	IWM	ETF	203.33	203.35	201.35	201.62	5691396.0
2023-12-29 11:00:00	IWM	ETF	201.63	201.87	200.865	201.26	4687427.0
2023-12-29 12:00:00	IWM	ETF	201.2601	201.74	200.97	201.66	2905808.0
2023-12-29 13:00:00	IWM	ETF	201.66	201.93	201.34	201.57	2843163.0
2023-12-29 14:00:00	IWM	ETF	201.57	201.8499	201.48	201.82	1718642.0
2023-12-29 15:00:00	IWM	ETF	201.815	201.98	200.72	200.76	7204705.0
2023-12-29 16:00:00	IWM	ETF	200.71	201.7	200.3	200.53	2563427.0
2023-12-29 17:00:00	IWM	ETF	200.55	200.72	200.45	200.68	67896.0
2023-12-29 18:00:00	IWM	ETF	200.64	200.7	200.54	200.69	18583.0
2023-12-29 19:00:00	IWM	ETF	200.55	200.59	200.43	200.59	6206.0
2023-12-29 04:00:00	DIA	ETF	377.63	377.64	377.63	377.64	250.0
2023-12-29 07:00:00	DIA	ETF	377.34	377.34	377.03	377.05	2659.0

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

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