PREVIEW / etf_1hour / 2001-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-03.parquet
  size:    11 KB
  rows:    227

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-08-03 09:00:00	SPY	ETF	122.36	122.36	121.51	121.6	1607800.0
2001-08-03 10:00:00	SPY	ETF	121.63	121.63	120.9	121.2	1393900.0
2001-08-03 11:00:00	SPY	ETF	121.18	121.48	121.15	121.21	1629000.0
2001-08-03 12:00:00	SPY	ETF	121.22	121.49	121.16	121.39	1328700.0
2001-08-03 13:00:00	SPY	ETF	121.37	121.49	121.06	121.32	1059800.0
2001-08-03 14:00:00	SPY	ETF	121.32	121.47	121.15	121.2	623300.0
2001-08-03 15:00:00	SPY	ETF	121.21	121.98	121.2	121.87	2083300.0
2001-08-03 16:00:00	SPY	ETF	121.92	122.01	121.27	121.78	720700.0
2001-08-03 17:00:00	SPY	ETF	121.75	121.75	121.75	121.75	200.0
2001-08-03 18:00:00	SPY	ETF	121.75	121.75	121.75	121.75	1400.0
2001-08-03 09:00:00	QQQ	ETF	43.53	43.53	43.0	43.2	15107300.0
2001-08-03 10:00:00	QQQ	ETF	43.14	43.25	42.56	42.79	10613700.0
2001-08-03 11:00:00	QQQ	ETF	42.77	42.99	42.68	42.8	5927200.0
2001-08-03 12:00:00	QQQ	ETF	42.8	42.9	42.66	42.82	2639900.0
2001-08-03 13:00:00	QQQ	ETF	42.78	42.89	42.62	42.78	3128100.0
2001-08-03 14:00:00	QQQ	ETF	42.78	42.96	42.66	42.82	3343600.0
2001-08-03 15:00:00	QQQ	ETF	42.81	43.18	42.79	43.05	6179300.0
2001-08-03 16:00:00	QQQ	ETF	43.03	43.2	42.99	43.1	1677900.0
2001-08-03 17:00:00	QQQ	ETF	43.1	43.12	43.0	43.05	39200.0
2001-08-03 18:00:00	QQQ	ETF	43.05	43.08	43.03	43.07	4300.0
2001-08-03 09:00:00	IWM	ETF	48.75	48.75	48.255	48.325	28800.0
2001-08-03 10:00:00	IWM	ETF	48.155	48.295	48.05	48.245	120400.0
2001-08-03 11:00:00	IWM	ETF	48.245	48.4	48.245	48.365	33000.0
2001-08-03 12:00:00	IWM	ETF	48.42	48.49	48.305	48.375	8400.0
2001-08-03 13:00:00	IWM	ETF	48.395	48.5	48.33	48.42	17600.0
2001-08-03 14:00:00	IWM	ETF	48.375	48.42	48.375	48.4	2600.0
2001-08-03 15:00:00	IWM	ETF	48.42	48.895	48.42	48.575	79200.0
2001-08-03 09:00:00	DIA	ETF	105.7	105.7	104.88	104.88	317100.0
2001-08-03 10:00:00	DIA	ETF	104.83	104.85	104.36	104.65	327900.0
2001-08-03 11:00:00	DIA	ETF	104.63	104.83	104.54	104.61	358400.0
2001-08-03 12:00:00	DIA	ETF	104.65	104.87	104.65	104.81	69900.0
2001-08-03 13:00:00	DIA	ETF	104.84	104.93	104.54	104.75	148700.0
2001-08-03 14:00:00	DIA	ETF	104.73	104.87	104.59	104.59	355600.0
2001-08-03 15:00:00	DIA	ETF	104.59	105.29	104.59	105.27	238700.0
2001-08-03 16:00:00	DIA	ETF	105.27	105.38	105.25	105.38	74600.0

> showing 35 of 227 rows — these rows as CSV

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