PREVIEW / etf_1hour / 2001-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-04-23.parquet
  size:    11 KB
  rows:    228

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-23 09:00:00	SPY	ETF	123.65	123.89	123.1	123.46	1236900.0
2001-04-23 10:00:00	SPY	ETF	123.49	123.63	122.73	122.95	1297200.0
2001-04-23 11:00:00	SPY	ETF	122.98	123.2	122.5	122.67	859100.0
2001-04-23 12:00:00	SPY	ETF	122.7	122.79	122.39	122.51	782300.0
2001-04-23 13:00:00	SPY	ETF	122.53	122.85	122.35	122.52	526000.0
2001-04-23 14:00:00	SPY	ETF	122.54	122.64	122.11	122.36	1663300.0
2001-04-23 15:00:00	SPY	ETF	122.35	122.8	121.91	122.7	1141200.0
2001-04-23 16:00:00	SPY	ETF	122.7	122.85	121.31	122.3	558100.0
2001-04-23 17:00:00	SPY	ETF	122.08	122.08	122.04	122.04	1500.0
2001-04-23 09:00:00	QQQ	ETF	46.99	47.7	46.2	46.47	14912600.0
2001-04-23 10:00:00	QQQ	ETF	46.48	46.6	45.81	46.13	15933400.0
2001-04-23 11:00:00	QQQ	ETF	46.05	46.25	45.57	45.67	7541700.0
2001-04-23 12:00:00	QQQ	ETF	45.73	45.76	45.45	45.58	6696200.0
2001-04-23 13:00:00	QQQ	ETF	45.59	45.94	45.34	45.45	6623900.0
2001-04-23 14:00:00	QQQ	ETF	45.39	45.47	45.0	45.21	10074000.0
2001-04-23 15:00:00	QQQ	ETF	45.2	45.33	44.89	45.13	9926000.0
2001-04-23 16:00:00	QQQ	ETF	45.13	45.22	44.8	45.0	1104000.0
2001-04-23 17:00:00	QQQ	ETF	44.95	45.0	44.65	44.79	217800.0
2001-04-23 18:00:00	QQQ	ETF	44.8	44.84	44.72	44.83	4800.0
2001-04-23 09:00:00	IWM	ETF	46.0	46.2	46.0	46.0	51000.0
2001-04-23 10:00:00	IWM	ETF	46.1	46.19	46.0	46.0	36000.0
2001-04-23 11:00:00	IWM	ETF	46.1	46.15	46.0	46.0	3800.0
2001-04-23 12:00:00	IWM	ETF	46.0	46.1	46.0	46.04	10400.0
2001-04-23 13:00:00	IWM	ETF	46.0	46.0	45.85	45.85	4000.0
2001-04-23 14:00:00	IWM	ETF	45.975	45.975	45.9	45.975	22000.0
2001-04-23 15:00:00	IWM	ETF	46.045	46.045	45.84	45.86	68600.0
2001-04-23 16:00:00	IWM	ETF	45.85	45.85	45.75	45.8	94600.0
2001-04-23 09:00:00	DIA	ETF	105.35	105.6	105.15	105.39	398900.0
2001-04-23 10:00:00	DIA	ETF	105.41	105.6	105.12	105.3	431400.0
2001-04-23 11:00:00	DIA	ETF	105.4	105.47	105.01	105.1	211100.0
2001-04-23 12:00:00	DIA	ETF	105.14	105.2	104.87	105.0	242300.0
2001-04-23 13:00:00	DIA	ETF	105.01	105.31	104.89	105.0	219200.0
2001-04-23 14:00:00	DIA	ETF	105.05	105.29	104.8	105.1	209300.0
2001-04-23 15:00:00	DIA	ETF	105.12	105.45	104.89	105.35	450500.0
2001-04-23 16:00:00	DIA	ETF	105.36	105.4	105.05	105.15	39100.0

> showing 35 of 228 rows — these rows as CSV

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