PREVIEW / etf_1hour / 2001-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-28.parquet
  size:    12 KB
  rows:    235

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-06-28 09:00:00	SPY	ETF	122.0	122.85	121.93	122.75	1824000.0
2001-06-28 10:00:00	SPY	ETF	122.69	123.27	122.6	122.87	1615600.0
2001-06-28 11:00:00	SPY	ETF	122.87	123.8	122.73	123.62	1420300.0
2001-06-28 12:00:00	SPY	ETF	123.72	123.88	123.35	123.65	584100.0
2001-06-28 13:00:00	SPY	ETF	123.68	123.94	123.45	123.85	900000.0
2001-06-28 14:00:00	SPY	ETF	123.9	123.94	123.15	123.36	1416400.0
2001-06-28 15:00:00	SPY	ETF	123.35	123.5	122.6	122.89	1574600.0
2001-06-28 16:00:00	SPY	ETF	122.83	122.9	122.06	122.15	559500.0
2001-06-28 09:00:00	QQQ	ETF	44.4	45.16	44.4	45.05	10908100.0
2001-06-28 10:00:00	QQQ	ETF	45.04	45.4	44.95	45.16	15137500.0
2001-06-28 11:00:00	QQQ	ETF	45.16	46.0	45.08	45.96	15727100.0
2001-06-28 12:00:00	QQQ	ETF	45.95	46.08	45.58	45.79	8713700.0
2001-06-28 13:00:00	QQQ	ETF	45.79	46.29	45.65	46.25	7295200.0
2001-06-28 14:00:00	QQQ	ETF	46.25	46.36	45.6	45.8	12059800.0
2001-06-28 15:00:00	QQQ	ETF	45.76	45.86	44.78	45.07	13431300.0
2001-06-28 16:00:00	QQQ	ETF	45.09	45.6	44.35	44.76	3368300.0
2001-06-28 17:00:00	QQQ	ETF	44.73	45.7	44.72	44.88	142300.0
2001-06-28 18:00:00	QQQ	ETF	44.9	45.2	44.72	45.0	44500.0
2001-06-28 09:00:00	IWM	ETF	49.75	50.025	49.75	50.0	63400.0
2001-06-28 10:00:00	IWM	ETF	50.175	50.325	49.95	50.0	119200.0
2001-06-28 11:00:00	IWM	ETF	50.0	50.35	50.0	50.175	87600.0
2001-06-28 12:00:00	IWM	ETF	50.175	50.375	50.135	50.175	391400.0
2001-06-28 13:00:00	IWM	ETF	50.15	50.375	50.15	50.345	61600.0
2001-06-28 14:00:00	IWM	ETF	50.345	50.355	50.15	50.25	90600.0
2001-06-28 15:00:00	IWM	ETF	50.2	50.275	49.935	50.245	85200.0
2001-06-28 16:00:00	IWM	ETF	50.35	50.35	50.075	50.1	12400.0
2001-06-28 09:00:00	DIA	ETF	105.07	105.85	105.0	105.74	207300.0
2001-06-28 10:00:00	DIA	ETF	105.74	106.2	105.54	105.71	344100.0
2001-06-28 11:00:00	DIA	ETF	105.77	106.6	105.7	106.53	573900.0
2001-06-28 12:00:00	DIA	ETF	106.52	106.57	106.16	106.45	114500.0
2001-06-28 13:00:00	DIA	ETF	106.41	106.78	106.31	106.63	371600.0
2001-06-28 14:00:00	DIA	ETF	106.74	106.83	105.95	106.25	445400.0
2001-06-28 15:00:00	DIA	ETF	106.11	106.28	105.61	105.75	443000.0
2001-06-28 16:00:00	DIA	ETF	105.75	105.8	105.25	105.25	228600.0
2001-06-28 18:00:00	DIA	ETF	105.3	105.3	105.3	105.3	200.0

> showing 35 of 235 rows — these rows as CSV

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