PREVIEW / etf_1hour / 2001-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-04-09.parquet
  size:    11 KB
  rows:    221

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-04-09 09:00:00	SPY	ETF	114.0	114.65	113.62	114.31	1639200.0
2001-04-09 10:00:00	SPY	ETF	114.34	114.99	114.15	114.4	2228200.0
2001-04-09 11:00:00	SPY	ETF	114.35	114.5	113.64	114.08	1032500.0
2001-04-09 12:00:00	SPY	ETF	114.12	114.28	113.28	113.6	606900.0
2001-04-09 13:00:00	SPY	ETF	113.51	113.73	112.81	113.13	905700.0
2001-04-09 14:00:00	SPY	ETF	113.15	113.85	112.78	113.6	686300.0
2001-04-09 15:00:00	SPY	ETF	113.6	114.1	113.11	114.0	1225400.0
2001-04-09 16:00:00	SPY	ETF	114.1	114.56	114.0	114.45	671300.0
2001-04-09 17:00:00	SPY	ETF	114.56	114.68	114.52	114.62	7400.0
2001-04-09 18:00:00	SPY	ETF	114.51	114.6	114.51	114.6	2600.0
2001-04-09 09:00:00	QQQ	ETF	36.79	37.39	36.5	36.95	8958000.0
2001-04-09 10:00:00	QQQ	ETF	36.99	37.24	36.56	36.61	9680400.0
2001-04-09 11:00:00	QQQ	ETF	36.62	36.72	36.25	36.47	6937800.0
2001-04-09 12:00:00	QQQ	ETF	36.46	36.61	36.18	36.39	3723400.0
2001-04-09 13:00:00	QQQ	ETF	36.31	36.41	35.85	36.0	5144900.0
2001-04-09 14:00:00	QQQ	ETF	35.99	36.55	35.86	36.36	5762600.0
2001-04-09 15:00:00	QQQ	ETF	36.36	36.99	36.24	36.95	8219300.0
2001-04-09 16:00:00	QQQ	ETF	36.93	37.19	36.8	37.12	2428500.0
2001-04-09 17:00:00	QQQ	ETF	37.11	37.5	37.1	37.3	99700.0
2001-04-09 18:00:00	QQQ	ETF	37.22	37.28	37.16	37.23	8500.0
2001-04-09 09:00:00	IWM	ETF	43.8	43.95	43.55	43.935	80200.0
2001-04-09 10:00:00	IWM	ETF	43.95	44.275	43.9	44.125	98800.0
2001-04-09 11:00:00	IWM	ETF	44.3	44.3	43.95	44.08	151800.0
2001-04-09 12:00:00	IWM	ETF	44.08	44.175	43.91	43.925	46600.0
2001-04-09 13:00:00	IWM	ETF	44.0	44.025	43.75	43.75	105000.0
2001-04-09 14:00:00	IWM	ETF	43.75	43.975	43.65	43.95	21600.0
2001-04-09 15:00:00	IWM	ETF	43.955	44.085	43.765	44.025	53400.0
2001-04-09 16:00:00	IWM	ETF	44.0	44.25	44.0	44.15	11400.0
2001-04-09 09:00:00	DIA	ETF	99.44	99.49	98.3	98.73	486300.0
2001-04-09 10:00:00	DIA	ETF	98.73	99.49	98.61	98.9	1015800.0
2001-04-09 11:00:00	DIA	ETF	98.95	99.0	98.58	98.74	420200.0
2001-04-09 12:00:00	DIA	ETF	98.89	98.99	98.4	98.47	305100.0
2001-04-09 13:00:00	DIA	ETF	98.42	98.52	97.8	98.17	586200.0
2001-04-09 14:00:00	DIA	ETF	98.1	98.58	97.71	98.31	410800.0
2001-04-09 15:00:00	DIA	ETF	98.49	98.63	97.9	98.56	414200.0
2001-04-09 16:00:00	DIA	ETF	98.68	98.95	98.05	98.75	54300.0
2001-04-09 17:00:00	DIA	ETF	99.05	99.05	99.05	99.05	200.0
2001-04-09 18:00:00	DIA	ETF	99.05	99.05	99.05	99.05	100.0

> showing 38 of 221 rows — these rows as CSV

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