PREVIEW / etf_1hour / 2001-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-09-07.parquet
  size:    12 KB
  rows:    247

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-09-07 09:00:00	SPY	ETF	110.02	110.53	109.65	110.21	4240600.0
2001-09-07 10:00:00	SPY	ETF	110.2	111.25	109.95	110.33	6193500.0
2001-09-07 11:00:00	SPY	ETF	110.3	110.4	109.48	109.9	4801000.0
2001-09-07 12:00:00	SPY	ETF	109.87	109.94	109.04	109.21	2116200.0
2001-09-07 13:00:00	SPY	ETF	109.24	109.42	108.69	109.22	3123100.0
2001-09-07 14:00:00	SPY	ETF	109.22	110.05	108.85	110.0	3876600.0
2001-09-07 15:00:00	SPY	ETF	110.0	110.05	109.02	109.13	4008300.0
2001-09-07 16:00:00	SPY	ETF	109.09	109.12	108.6	108.6	1499200.0
2001-09-07 17:00:00	SPY	ETF	108.71	108.9	108.71	108.9	500.0
2001-09-07 09:00:00	QQQ	ETF	33.62	34.3	33.35	34.15	18165900.0
2001-09-07 10:00:00	QQQ	ETF	34.16	34.66	33.87	34.0	16266300.0
2001-09-07 11:00:00	QQQ	ETF	33.98	34.14	33.62	33.94	8909200.0
2001-09-07 12:00:00	QQQ	ETF	33.94	34.05	33.49	33.55	8039100.0
2001-09-07 13:00:00	QQQ	ETF	33.57	33.87	33.35	33.75	11518700.0
2001-09-07 14:00:00	QQQ	ETF	33.77	34.4	33.61	34.38	13388600.0
2001-09-07 15:00:00	QQQ	ETF	34.38	34.4	33.66	33.78	12441400.0
2001-09-07 16:00:00	QQQ	ETF	33.77	33.79	33.5	33.6	1825400.0
2001-09-07 17:00:00	QQQ	ETF	33.6	33.65	33.5	33.6	50600.0
2001-09-07 18:00:00	QQQ	ETF	33.62	33.63	33.56	33.6	8500.0
2001-09-07 09:00:00	IWM	ETF	44.65	44.85	44.555	44.65	89400.0
2001-09-07 10:00:00	IWM	ETF	44.95	45.05	44.7	44.7	158200.0
2001-09-07 11:00:00	IWM	ETF	44.675	44.775	44.56	44.675	1014000.0
2001-09-07 12:00:00	IWM	ETF	44.675	44.745	44.45	44.45	118600.0
2001-09-07 13:00:00	IWM	ETF	44.4	44.515	44.085	44.225	3184000.0
2001-09-07 14:00:00	IWM	ETF	44.18	44.5	44.1	44.375	170000.0
2001-09-07 15:00:00	IWM	ETF	44.38	44.495	44.26	44.285	188600.0
2001-09-07 16:00:00	IWM	ETF	44.28	44.375	44.265	44.265	1800.0
2001-09-07 09:00:00	DIA	ETF	97.61	97.76	97.05	97.4	1175700.0
2001-09-07 10:00:00	DIA	ETF	97.45	98.23	97.05	97.44	1244800.0
2001-09-07 11:00:00	DIA	ETF	97.4	97.4	96.57	96.95	1203600.0
2001-09-07 12:00:00	DIA	ETF	96.96	97.0	96.1	96.25	613500.0
2001-09-07 13:00:00	DIA	ETF	96.22	96.45	95.77	96.19	1397500.0
2001-09-07 14:00:00	DIA	ETF	96.14	96.85	95.7	96.74	2001000.0
2001-09-07 15:00:00	DIA	ETF	96.85	96.99	96.15	96.26	1535000.0
2001-09-07 16:00:00	DIA	ETF	96.26	96.35	95.5	95.5	437600.0
2001-09-07 18:00:00	DIA	ETF	95.8	95.8	95.8	95.8	200.0

> showing 36 of 247 rows — these rows as CSV

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