PREVIEW / etf_1hour / 2001-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-05-09.parquet
  size:    11 KB
  rows:    218

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-05-09 09:00:00	SPY	ETF	125.25	125.66	125.25	125.52	1759100.0
2001-05-09 10:00:00	SPY	ETF	125.6	125.74	125.06	125.6	1600400.0
2001-05-09 11:00:00	SPY	ETF	125.56	126.3	125.5	126.2	1879300.0
2001-05-09 12:00:00	SPY	ETF	126.2	126.55	126.01	126.38	1088300.0
2001-05-09 13:00:00	SPY	ETF	126.42	126.44	125.89	126.0	805200.0
2001-05-09 14:00:00	SPY	ETF	125.92	126.0	125.62	125.66	728600.0
2001-05-09 15:00:00	SPY	ETF	125.65	125.96	125.29	125.96	1119800.0
2001-05-09 16:00:00	SPY	ETF	125.83	126.5	125.65	125.65	394000.0
2001-05-09 17:00:00	SPY	ETF	125.59	125.7	125.59	125.62	10700.0
2001-05-09 09:00:00	QQQ	ETF	47.05	47.1	46.51	46.9	9666800.0
2001-05-09 10:00:00	QQQ	ETF	46.89	47.07	46.44	47.02	8957000.0
2001-05-09 11:00:00	QQQ	ETF	47.02	47.64	46.95	47.41	10876400.0
2001-05-09 12:00:00	QQQ	ETF	47.43	47.95	47.28	47.85	7602600.0
2001-05-09 13:00:00	QQQ	ETF	47.85	47.85	47.3	47.34	4370300.0
2001-05-09 14:00:00	QQQ	ETF	47.36	47.4	46.76	46.77	6393700.0
2001-05-09 15:00:00	QQQ	ETF	46.76	47.01	46.5	46.73	9740400.0
2001-05-09 16:00:00	QQQ	ETF	46.7	47.27	46.4	46.45	1491000.0
2001-05-09 17:00:00	QQQ	ETF	46.53	46.7	46.48	46.7	52500.0
2001-05-09 18:00:00	QQQ	ETF	46.66	46.72	46.65	46.71	3500.0
2001-05-09 09:00:00	IWM	ETF	48.55	48.85	48.55	48.675	20000.0
2001-05-09 10:00:00	IWM	ETF	48.73	48.99	48.675	48.855	43800.0
2001-05-09 11:00:00	IWM	ETF	48.825	49.125	48.825	48.975	16600.0
2001-05-09 12:00:00	IWM	ETF	48.975	49.2	48.95	49.045	49400.0
2001-05-09 13:00:00	IWM	ETF	49.045	49.165	48.95	48.95	18000.0
2001-05-09 14:00:00	IWM	ETF	48.9	49.05	48.825	49.025	21400.0
2001-05-09 15:00:00	IWM	ETF	48.875	48.925	48.675	48.925	61000.0
2001-05-09 16:00:00	IWM	ETF	48.7	48.73	48.7	48.73	5400.0
2001-05-09 09:00:00	DIA	ETF	108.3	108.59	108.16	108.4	274600.0
2001-05-09 10:00:00	DIA	ETF	108.4	108.7	108.1	108.56	389300.0
2001-05-09 11:00:00	DIA	ETF	108.5	109.14	108.45	109.14	490700.0
2001-05-09 12:00:00	DIA	ETF	109.12	109.32	108.98	109.1	191900.0
2001-05-09 13:00:00	DIA	ETF	109.1	109.15	108.62	108.65	207700.0
2001-05-09 14:00:00	DIA	ETF	108.79	109.04	108.52	108.52	246900.0
2001-05-09 15:00:00	DIA	ETF	108.51	108.8	108.3	108.7	627000.0
2001-05-09 16:00:00	DIA	ETF	108.65	108.79	108.61	108.75	97400.0

> showing 35 of 218 rows — these rows as CSV

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