PREVIEW / etf_1hour / 2001-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-09-25.parquet
  size:    12 KB
  rows:    259

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-25 09:00:00	SPY	ETF	100.75	101.34	100.42	101.3	3291600.0
2001-09-25 10:00:00	SPY	ETF	101.2	102.0	100.2	101.37	5609000.0
2001-09-25 11:00:00	SPY	ETF	101.41	101.98	101.2	101.54	3514000.0
2001-09-25 12:00:00	SPY	ETF	101.51	101.55	100.5	100.79	2457000.0
2001-09-25 13:00:00	SPY	ETF	100.79	100.98	100.0	100.29	2363300.0
2001-09-25 14:00:00	SPY	ETF	100.3	101.0	99.9	100.9	3222000.0
2001-09-25 15:00:00	SPY	ETF	100.9	101.49	100.69	101.48	3331800.0
2001-09-25 16:00:00	SPY	ETF	101.4	101.82	101.0	101.7	667600.0
2001-09-25 17:00:00	SPY	ETF	101.72	101.72	101.62	101.62	1400.0
2001-09-25 09:00:00	QQQ	ETF	29.71	30.0	29.44	29.99	9936300.0
2001-09-25 10:00:00	QQQ	ETF	29.98	30.43	29.5	29.82	19289100.0
2001-09-25 11:00:00	QQQ	ETF	29.82	30.17	29.76	29.86	6934400.0
2001-09-25 12:00:00	QQQ	ETF	29.86	29.88	29.26	29.53	15054600.0
2001-09-25 13:00:00	QQQ	ETF	29.51	29.6	29.0	29.14	9668900.0
2001-09-25 14:00:00	QQQ	ETF	29.15	29.48	28.95	29.4	8870600.0
2001-09-25 15:00:00	QQQ	ETF	29.45	29.66	29.29	29.5	9540200.0
2001-09-25 16:00:00	QQQ	ETF	29.55	29.74	29.3	29.7	2004000.0
2001-09-25 17:00:00	QQQ	ETF	29.7	29.73	29.65	29.7	57000.0
2001-09-25 18:00:00	QQQ	ETF	29.7	29.7	29.6	29.6	13600.0
2001-09-25 09:00:00	IWM	ETF	39.12	39.425	39.12	39.225	66800.0
2001-09-25 10:00:00	IWM	ETF	39.2	39.55	38.875	39.49	214800.0
2001-09-25 11:00:00	IWM	ETF	39.37	39.75	39.255	39.565	320600.0
2001-09-25 12:00:00	IWM	ETF	39.55	39.56	39.255	39.26	12600.0
2001-09-25 13:00:00	IWM	ETF	39.375	39.445	39.25	39.325	30800.0
2001-09-25 14:00:00	IWM	ETF	39.325	39.425	39.16	39.335	16800.0
2001-09-25 15:00:00	IWM	ETF	39.43	39.65	39.355	39.5	200600.0
2001-09-25 16:00:00	IWM	ETF	39.475	39.475	39.475	39.475	200.0
2001-09-25 09:00:00	DIA	ETF	86.25	86.45	85.6	86.4	1626100.0
2001-09-25 10:00:00	DIA	ETF	86.4	87.2	85.7	86.51	1430100.0
2001-09-25 11:00:00	DIA	ETF	86.52	86.89	86.31	86.6	942200.0
2001-09-25 12:00:00	DIA	ETF	86.5	86.5	85.57	85.84	733300.0
2001-09-25 13:00:00	DIA	ETF	85.88	85.99	85.1	85.3	1082500.0
2001-09-25 14:00:00	DIA	ETF	85.3	86.12	85.05	85.85	646400.0
2001-09-25 15:00:00	DIA	ETF	86.01	86.64	85.87	86.6	570300.0
2001-09-25 16:00:00	DIA	ETF	86.65	87.0	86.62	86.8	65500.0
2001-09-25 17:00:00	DIA	ETF	86.9	86.95	86.75	86.75	1400.0
2001-09-25 18:00:00	DIA	ETF	86.75	86.75	86.75	86.75	300.0

> showing 37 of 259 rows — these rows as CSV

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