PREVIEW / etf_1hour / 2001-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-07.parquet
  size:    11 KB
  rows:    230

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-07 09:00:00	SPY	ETF	120.27	120.46	119.91	120.42	780400.0
2001-08-07 10:00:00	SPY	ETF	120.43	121.2	120.36	120.97	1794700.0
2001-08-07 11:00:00	SPY	ETF	121.01	121.02	120.8	120.9	1360400.0
2001-08-07 12:00:00	SPY	ETF	120.91	120.96	120.35	120.38	440900.0
2001-08-07 13:00:00	SPY	ETF	120.38	120.71	120.38	120.58	980300.0
2001-08-07 14:00:00	SPY	ETF	120.57	120.77	120.36	120.5	944500.0
2001-08-07 15:00:00	SPY	ETF	120.53	120.88	120.27	120.82	1560800.0
2001-08-07 16:00:00	SPY	ETF	120.82	120.87	120.64	120.77	850300.0
2001-08-07 17:00:00	SPY	ETF	121.3	121.5	120.5	120.6	3500.0
2001-08-07 09:00:00	QQQ	ETF	42.1	42.35	41.95	42.33	5831100.0
2001-08-07 10:00:00	QQQ	ETF	42.35	42.82	42.17	42.72	9148600.0
2001-08-07 11:00:00	QQQ	ETF	42.73	42.76	42.56	42.62	4165700.0
2001-08-07 12:00:00	QQQ	ETF	42.62	42.66	42.15	42.22	2935700.0
2001-08-07 13:00:00	QQQ	ETF	42.2	42.41	42.15	42.31	2464100.0
2001-08-07 14:00:00	QQQ	ETF	42.3	42.32	42.04	42.12	3453500.0
2001-08-07 15:00:00	QQQ	ETF	42.12	42.33	41.94	42.28	6539900.0
2001-08-07 16:00:00	QQQ	ETF	42.28	42.53	41.95	42.5	1876000.0
2001-08-07 17:00:00	QQQ	ETF	42.53	42.65	42.0	42.12	672700.0
2001-08-07 18:00:00	QQQ	ETF	42.15	42.24	42.1	42.16	56700.0
2001-08-07 09:00:00	IWM	ETF	47.9	47.9	47.65	47.745	16400.0
2001-08-07 10:00:00	IWM	ETF	47.805	48.0	47.75	47.995	10000.0
2001-08-07 11:00:00	IWM	ETF	47.98	48.05	47.83	47.995	79200.0
2001-08-07 12:00:00	IWM	ETF	47.95	47.95	47.7	47.7	44600.0
2001-08-07 13:00:00	IWM	ETF	47.75	47.85	47.725	47.795	38000.0
2001-08-07 14:00:00	IWM	ETF	47.795	47.825	47.775	47.8	33000.0
2001-08-07 15:00:00	IWM	ETF	47.705	47.975	47.7	47.975	171600.0
2001-08-07 16:00:00	IWM	ETF	48.0	48.0	47.95	47.95	28800.0
2001-08-07 09:00:00	DIA	ETF	104.1	104.2	103.73	104.1	532700.0
2001-08-07 10:00:00	DIA	ETF	104.16	104.88	104.07	104.7	545400.0
2001-08-07 11:00:00	DIA	ETF	104.7	104.71	104.44	104.54	197900.0
2001-08-07 12:00:00	DIA	ETF	104.6	104.6	104.19	104.19	114300.0
2001-08-07 13:00:00	DIA	ETF	104.27	104.5	104.24	104.46	114400.0
2001-08-07 14:00:00	DIA	ETF	104.49	104.56	104.27	104.38	452600.0
2001-08-07 15:00:00	DIA	ETF	104.29	104.67	104.19	104.65	434200.0
2001-08-07 16:00:00	DIA	ETF	104.65	104.67	104.54	104.56	76500.0
2001-08-07 17:00:00	DIA	ETF	105.01	105.01	105.01	105.01	1000.0

> showing 36 of 230 rows — these rows as CSV

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