PREVIEW / etf_1hour / 2023-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-12.parquet
  size:    484 KB
  rows:    17,601

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-12 04:00:00	SPY	ETF	437.5	438.0	437.45	438.0	29345.0
2023-10-12 05:00:00	SPY	ETF	438.06	438.3	438.03	438.25	21569.0
2023-10-12 06:00:00	SPY	ETF	438.23	438.54	438.23	438.28	45885.0
2023-10-12 07:00:00	SPY	ETF	438.24	438.34	438.03	438.23	101261.0
2023-10-12 08:00:00	SPY	ETF	438.21	438.6	436.42	437.06	1714458.0
2023-10-12 09:00:00	SPY	ETF	437.06	437.2	435.07	435.43	5366105.0
2023-10-12 10:00:00	SPY	ETF	435.44	436.7	434.98	436.14	8104185.0
2023-10-12 11:00:00	SPY	ETF	436.13	436.9	435.62	436.5371	5568577.0
2023-10-12 12:00:00	SPY	ETF	436.565	437.335	436.255	436.525	5426436.0
2023-10-12 13:00:00	SPY	ETF	436.535	436.545	432.35	432.4399	13206214.0
2023-10-12 14:00:00	SPY	ETF	432.44	433.3725	431.23	432.97	13346681.0
2023-10-12 15:00:00	SPY	ETF	432.99	434.29	432.92	433.7	13548157.0
2023-10-12 16:00:00	SPY	ETF	433.7	434.05	433.58	433.74	3303021.0
2023-10-12 17:00:00	SPY	ETF	433.75	433.83	433.7	433.78	47965.0
2023-10-12 18:00:00	SPY	ETF	433.79	433.89	433.51	433.81	75283.0
2023-10-12 19:00:00	SPY	ETF	433.76	434.06	433.71	433.97	39980.0
2023-10-12 04:00:00	QQQ	ETF	372.39	372.79	372.3	372.79	50748.0
2023-10-12 05:00:00	QQQ	ETF	372.81	372.91	372.56	372.79	13012.0
2023-10-12 06:00:00	QQQ	ETF	372.76	373.0	372.7	372.77	35610.0
2023-10-12 07:00:00	QQQ	ETF	372.76	372.91	372.47	372.74	123995.0
2023-10-12 08:00:00	QQQ	ETF	372.82	373.03	371.0	371.68	1625690.0
2023-10-12 09:00:00	QQQ	ETF	371.67	372.31	371.09	371.57	4467352.0
2023-10-12 10:00:00	QQQ	ETF	371.58	373.39	371.32	372.6213	6432377.0
2023-10-12 11:00:00	QQQ	ETF	372.63	373.74	371.93	372.945	3935498.0
2023-10-12 12:00:00	QQQ	ETF	372.95	373.56	372.53	372.76	2814367.0
2023-10-12 13:00:00	QQQ	ETF	372.77	372.82	368.95	369.0498	6940762.0
2023-10-12 14:00:00	QQQ	ETF	369.065	369.59	367.5	369.02	6729353.0
2023-10-12 15:00:00	QQQ	ETF	369.02	370.36	368.945	369.85	7226533.0
2023-10-12 16:00:00	QQQ	ETF	369.84	370.2	369.82	370.04	872349.0
2023-10-12 17:00:00	QQQ	ETF	370.05	370.1	369.89	369.93	52150.0
2023-10-12 18:00:00	QQQ	ETF	370.01	370.1	369.82	370.04	97606.0
2023-10-12 19:00:00	QQQ	ETF	370.05	370.33	369.93	370.22	80052.0
2023-10-12 04:00:00	IWM	ETF	176.51	176.89	176.49	176.89	7205.0
2023-10-12 05:00:00	IWM	ETF	176.95	177.14	176.94	177.09	11690.0
2023-10-12 06:00:00	IWM	ETF	177.05	177.16	176.9	176.95	7375.0
2023-10-12 07:00:00	IWM	ETF	176.93	176.96	176.73	176.85	47719.0
2023-10-12 08:00:00	IWM	ETF	176.9	177.06	175.82	176.15	552244.0
2023-10-12 09:00:00	IWM	ETF	176.2	176.22	173.47	173.59	3932183.0
2023-10-12 10:00:00	IWM	ETF	173.6	174.02	172.94	173.07	5200223.0
2023-10-12 11:00:00	IWM	ETF	173.07	173.275	172.849	173.13	3368225.0
2023-10-12 12:00:00	IWM	ETF	173.13	173.46	172.76	172.85	2491368.0
2023-10-12 13:00:00	IWM	ETF	172.85	172.855	171.235	171.26	4698856.0
2023-10-12 14:00:00	IWM	ETF	171.27	171.63	170.79	171.41	4136813.0
2023-10-12 15:00:00	IWM	ETF	171.42	172.015	171.415	171.77	6237499.0
2023-10-12 16:00:00	IWM	ETF	171.7	174.22	171.7	171.82	1220493.0
2023-10-12 17:00:00	IWM	ETF	171.81	171.84	171.75	171.75	12695.0
2023-10-12 18:00:00	IWM	ETF	171.781	171.85	171.7	171.78	32910.0
2023-10-12 19:00:00	IWM	ETF	171.83	171.95	171.75	171.88	45038.0
2023-10-12 04:00:00	DIA	ETF	338.7	339.16	338.7	339.16	2818.0
2023-10-12 05:00:00	DIA	ETF	339.19	339.39	339.19	339.39	1435.0

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

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