PREVIEW / etf_1hour / 2023-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-12.parquet
  size:    519 KB
  rows:    18,852

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-12 04:00:00	SPY	ETF	462.98	462.98	462.24	462.8	33795.0
2023-12-12 05:00:00	SPY	ETF	462.72	462.72	462.2	462.29	27029.0
2023-12-12 06:00:00	SPY	ETF	462.21	462.39	462.11	462.16	94670.0
2023-12-12 07:00:00	SPY	ETF	462.17	462.81	462.14	462.68	175117.0
2023-12-12 08:00:00	SPY	ETF	462.27	463.93	461.63	461.74	1496199.0
2023-12-12 09:00:00	SPY	ETF	461.76	462.19	460.6	461.495	5625552.0
2023-12-12 10:00:00	SPY	ETF	461.5	462.6866	461.315	462.66	6508678.0
2023-12-12 11:00:00	SPY	ETF	462.66	462.835	462.385	462.59	4866671.0
2023-12-12 12:00:00	SPY	ETF	462.59	463.12	462.24	462.62	4659956.0
2023-12-12 13:00:00	SPY	ETF	462.62	463.28	462.51	463.21	3849528.0
2023-12-12 14:00:00	SPY	ETF	463.21	463.61	463.04	463.565	3862458.0
2023-12-12 15:00:00	SPY	ETF	463.57	464.2	463.51	464.16	12414261.0
2023-12-12 16:00:00	SPY	ETF	464.17	464.48	462.7076	464.41	3526724.0
2023-12-12 17:00:00	SPY	ETF	464.46	464.46	464.1363	464.38	121905.0
2023-12-12 18:00:00	SPY	ETF	464.38	464.77	464.37	464.66	166191.0
2023-12-12 19:00:00	SPY	ETF	464.66	464.74	464.56	464.72	49533.0
2023-12-12 04:00:00	QQQ	ETF	396.2	396.46	396.05	396.46	41007.0
2023-12-12 05:00:00	QQQ	ETF	396.4	396.4	396.12	396.12	8326.0
2023-12-12 06:00:00	QQQ	ETF	396.11	396.32	396.06	396.12	15123.0
2023-12-12 07:00:00	QQQ	ETF	396.15	396.82	396.09	396.72	149808.0
2023-12-12 08:00:00	QQQ	ETF	396.46	398.06	395.56	395.76	1410374.0
2023-12-12 09:00:00	QQQ	ETF	395.79	396.17	394.41	396.11	4484467.0
2023-12-12 10:00:00	QQQ	ETF	396.12	396.88	395.81	396.85	3750646.0
2023-12-12 11:00:00	QQQ	ETF	396.845	397.32	396.4793	396.59	2988995.0
2023-12-12 12:00:00	QQQ	ETF	396.6	397.015	396.09	396.85	2302390.0
2023-12-12 13:00:00	QQQ	ETF	396.855	397.73	396.7	397.64	2953068.0
2023-12-12 14:00:00	QQQ	ETF	397.63	398.1184	397.4603	398.06	2384051.0
2023-12-12 15:00:00	QQQ	ETF	398.07	398.79	397.94	398.75	6218154.0
2023-12-12 16:00:00	QQQ	ETF	398.75	399.3	398.65	399.22	1306632.0
2023-12-12 17:00:00	QQQ	ETF	399.21	399.22	399.09	399.1	62322.0
2023-12-12 18:00:00	QQQ	ETF	399.16	399.58	399.05	399.481	85280.0
2023-12-12 19:00:00	QQQ	ETF	399.47	399.5	399.22	399.41	59657.0
2023-12-12 04:00:00	IWM	ETF	187.5	187.92	187.5	187.82	8315.0
2023-12-12 05:00:00	IWM	ETF	187.84	187.84	187.6	187.73	5038.0
2023-12-12 06:00:00	IWM	ETF	187.62	187.72	187.57	187.66	7461.0
2023-12-12 07:00:00	IWM	ETF	187.62	187.88	187.6	187.73	44068.0
2023-12-12 08:00:00	IWM	ETF	187.68	189.0	187.09	187.16	728548.0
2023-12-12 09:00:00	IWM	ETF	187.17	187.25	185.335	186.04	5027228.0
2023-12-12 10:00:00	IWM	ETF	186.04	186.89	185.74	186.89	3100565.0
2023-12-12 11:00:00	IWM	ETF	186.89	186.89	185.98	186.3	2292652.0
2023-12-12 12:00:00	IWM	ETF	186.28	186.53	186.085	186.169	1277607.0
2023-12-12 13:00:00	IWM	ETF	186.16	187.1599	186.09	187.12	2249386.0
2023-12-12 14:00:00	IWM	ETF	187.12	187.465	186.97	187.45	1663657.0
2023-12-12 15:00:00	IWM	ETF	187.46	187.655	186.78	186.98	5553028.0
2023-12-12 16:00:00	IWM	ETF	187.0	187.16	186.94	187.01	640526.0
2023-12-12 17:00:00	IWM	ETF	187.05	187.15	187.0	187.05	23573.0
2023-12-12 18:00:00	IWM	ETF	187.07	187.25	187.06	187.23	16929.0
2023-12-12 19:00:00	IWM	ETF	187.24	187.3	187.15	187.18	36030.0
2023-12-12 05:00:00	DIA	ETF	365.49	365.49	365.49	365.49	120.0
2023-12-12 06:00:00	DIA	ETF	365.3	365.3	365.19	365.21	2200.0

> showing 50 of 18,852 rows — these rows as CSV

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