PREVIEW / etf_1hour / 2001-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-03-14.parquet
  size:    11 KB
  rows:    226

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-03-14 09:00:00	SPY	ETF	117.05	117.96	115.99	117.66	2642900.0
2001-03-14 10:00:00	SPY	ETF	117.75	119.29	117.5	118.68	3252800.0
2001-03-14 11:00:00	SPY	ETF	118.65	118.94	117.16	117.16	1249600.0
2001-03-14 12:00:00	SPY	ETF	117.15	117.48	116.44	116.9	3135200.0
2001-03-14 13:00:00	SPY	ETF	116.85	117.64	115.75	117.04	2002500.0
2001-03-14 14:00:00	SPY	ETF	117.23	117.83	116.33	116.58	1470100.0
2001-03-14 15:00:00	SPY	ETF	116.7	117.8	116.1	117.2	2906000.0
2001-03-14 16:00:00	SPY	ETF	117.05	117.65	116.75	117.63	2783200.0
2001-03-14 17:00:00	SPY	ETF	117.25	117.25	117.25	117.25	1500.0
2001-03-14 09:00:00	QQQ	ETF	42.7	43.92	42.31	43.33	14779500.0
2001-03-14 10:00:00	QQQ	ETF	43.5	45.12	43.3	44.74	21545000.0
2001-03-14 11:00:00	QQQ	ETF	44.7	44.83	43.4	43.4	8990100.0
2001-03-14 12:00:00	QQQ	ETF	43.5	43.71	42.8	43.4	12205900.0
2001-03-14 13:00:00	QQQ	ETF	43.4	43.67	42.6	43.54	9207300.0
2001-03-14 14:00:00	QQQ	ETF	43.55	43.96	43.01	43.14	10276200.0
2001-03-14 15:00:00	QQQ	ETF	43.22	44.28	42.73	43.51	14302400.0
2001-03-14 16:00:00	QQQ	ETF	43.5	44.74	42.75	43.79	1717900.0
2001-03-14 17:00:00	QQQ	ETF	43.79	44.15	43.6	43.87	92500.0
2001-03-14 18:00:00	QQQ	ETF	43.81	43.91	43.7	43.75	7500.0
2001-03-14 09:00:00	IWM	ETF	44.875	45.275	44.85	45.275	66800.0
2001-03-14 10:00:00	IWM	ETF	45.25	46.15	45.05	46.15	371000.0
2001-03-14 11:00:00	IWM	ETF	46.12	46.125	45.55	45.55	63200.0
2001-03-14 12:00:00	IWM	ETF	45.525	45.525	45.325	45.325	8400.0
2001-03-14 13:00:00	IWM	ETF	45.175	45.375	45.125	45.375	33800.0
2001-03-14 14:00:00	IWM	ETF	45.405	45.575	45.25	45.34	5800.0
2001-03-14 15:00:00	IWM	ETF	45.2	45.52	45.05	45.2	98000.0
2001-03-14 09:00:00	DIA	ETF	100.25	101.1	99.5	100.69	1793000.0
2001-03-14 10:00:00	DIA	ETF	100.5	101.9	100.4	101.3	1594700.0
2001-03-14 11:00:00	DIA	ETF	101.35	101.5	100.05	100.11	935400.0
2001-03-14 12:00:00	DIA	ETF	100.1	100.49	99.55	100.0	888300.0
2001-03-14 13:00:00	DIA	ETF	99.95	100.45	99.13	100.12	1582600.0
2001-03-14 14:00:00	DIA	ETF	100.12	100.65	99.44	99.56	875400.0
2001-03-14 15:00:00	DIA	ETF	99.57	100.4	99.15	100.0	1222300.0
2001-03-14 16:00:00	DIA	ETF	99.97	100.19	99.82	100.0	103300.0

> showing 34 of 226 rows — these rows as CSV

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