PREVIEW / etf_1hour / 2001-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-11-07.parquet
  size:    13 KB
  rows:    267

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
2001-11-07 09:00:00	SPY	ETF	111.77	112.4	111.7	112.12	2521300.0
2001-11-07 10:00:00	SPY	ETF	112.14	112.7	111.75	112.3	3054900.0
2001-11-07 11:00:00	SPY	ETF	112.28	112.63	112.0	112.1	2362200.0
2001-11-07 12:00:00	SPY	ETF	112.07	112.68	112.03	112.59	1610600.0
2001-11-07 13:00:00	SPY	ETF	112.53	113.12	112.5	112.58	2183900.0
2001-11-07 14:00:00	SPY	ETF	112.57	112.65	111.83	112.45	3121300.0
2001-11-07 15:00:00	SPY	ETF	112.42	112.45	111.64	111.96	2885100.0
2001-11-07 16:00:00	SPY	ETF	111.87	112.3	111.82	112.25	1257700.0
2001-11-07 17:00:00	SPY	ETF	112.24	112.24	112.2	112.2	900.0
2001-11-07 18:00:00	SPY	ETF	112.1	112.1	112.1	112.1	1000.0
2001-11-07 09:00:00	QQQ	ETF	37.61	38.29	37.53	38.1	15077800.0
2001-11-07 10:00:00	QQQ	ETF	38.07	38.43	37.63	38.05	19791300.0
2001-11-07 11:00:00	QQQ	ETF	38.08	38.36	37.91	37.97	9174500.0
2001-11-07 12:00:00	QQQ	ETF	37.99	38.49	37.93	38.4	5333700.0
2001-11-07 13:00:00	QQQ	ETF	38.43	38.84	38.39	38.53	11654100.0
2001-11-07 14:00:00	QQQ	ETF	38.57	38.6	37.95	38.37	13498300.0
2001-11-07 15:00:00	QQQ	ETF	38.37	38.42	37.7	37.95	13856300.0
2001-11-07 16:00:00	QQQ	ETF	37.97	38.21	37.9	38.1	4076800.0
2001-11-07 17:00:00	QQQ	ETF	38.1	38.11	37.94	37.95	86900.0
2001-11-07 18:00:00	QQQ	ETF	37.95	38.2	37.95	37.96	20700.0
2001-11-07 09:00:00	IWM	ETF	43.85	44.25	43.805	44.125	113000.0
2001-11-07 10:00:00	IWM	ETF	44.125	44.325	44.0	44.12	43200.0
2001-11-07 11:00:00	IWM	ETF	44.105	44.2	44.015	44.065	157200.0
2001-11-07 12:00:00	IWM	ETF	44.0	44.225	43.965	44.225	136600.0
2001-11-07 13:00:00	IWM	ETF	44.215	44.29	44.1	44.155	34800.0
2001-11-07 14:00:00	IWM	ETF	44.19	44.2	43.895	44.13	46000.0
2001-11-07 15:00:00	IWM	ETF	44.11	44.11	43.935	44.0	45400.0
2001-11-07 16:00:00	IWM	ETF	43.805	43.95	43.805	43.95	8000.0
2001-11-07 09:00:00	DIA	ETF	95.38	96.0	95.35	95.71	680700.0
2001-11-07 10:00:00	DIA	ETF	95.77	96.49	95.55	96.08	634800.0
2001-11-07 11:00:00	DIA	ETF	96.09	96.38	95.82	95.91	268500.0
2001-11-07 12:00:00	DIA	ETF	95.9	96.36	95.86	96.34	99000.0
2001-11-07 13:00:00	DIA	ETF	96.25	96.6	96.17	96.17	308700.0
2001-11-07 14:00:00	DIA	ETF	96.2	96.2	95.56	96.01	383400.0
2001-11-07 15:00:00	DIA	ETF	96.0	96.0	95.26	95.55	453100.0
2001-11-07 16:00:00	DIA	ETF	95.59	95.8	95.5	95.8	68100.0
2001-11-07 17:00:00	DIA	ETF	95.75	95.75	95.75	95.75	200.0

> showing 37 of 267 rows — these rows as CSV

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