PREVIEW / etf_1hour / 2004-01-05

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-05.parquet
  size:    24 KB
  rows:    667

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
2004-01-05 08:00:00	SPY	ETF	111.61	111.75	111.6	111.67	71200.0
2004-01-05 09:00:00	SPY	ETF	111.71	112.13	111.65	112.08	4477400.0
2004-01-05 10:00:00	SPY	ETF	112.08	112.16	111.8	111.95	5854300.0
2004-01-05 11:00:00	SPY	ETF	111.94	112.0	111.66	111.83	2717900.0
2004-01-05 12:00:00	SPY	ETF	111.84	111.91	111.59	111.8	2165900.0
2004-01-05 13:00:00	SPY	ETF	111.8	112.05	111.77	112.01	1769400.0
2004-01-05 14:00:00	SPY	ETF	111.98	112.15	111.93	112.01	2551500.0
2004-01-05 15:00:00	SPY	ETF	111.97	112.45	111.97	112.37	5325300.0
2004-01-05 16:00:00	SPY	ETF	112.37	112.52	112.35	112.36	1742800.0
2004-01-05 17:00:00	SPY	ETF	112.37	112.37	112.32	112.36	8000.0
2004-01-05 18:00:00	SPY	ETF	112.38	112.42	112.36	112.38	3500.0
2004-01-05 19:00:00	SPY	ETF	112.38	112.39	112.38	112.39	3300.0
2004-01-05 08:00:00	QQQ	ETF	36.59	36.64	36.55	36.6	73400.0
2004-01-05 09:00:00	QQQ	ETF	36.6	36.87	36.57	36.81	13596200.0
2004-01-05 10:00:00	QQQ	ETF	36.809	36.95	36.74	36.899	12509200.0
2004-01-05 11:00:00	QQQ	ETF	36.907	36.92	36.77	36.85	6823600.0
2004-01-05 12:00:00	QQQ	ETF	36.856	36.95	36.81	36.892	5973200.0
2004-01-05 13:00:00	QQQ	ETF	36.9	37.04	36.88	36.96	6467300.0
2004-01-05 14:00:00	QQQ	ETF	36.969	37.09	36.948	37.0	6646500.0
2004-01-05 15:00:00	QQQ	ETF	37.0	37.158	36.99	37.13	9932000.0
2004-01-05 16:00:00	QQQ	ETF	37.13	37.21	37.08	37.105	4381200.0
2004-01-05 17:00:00	QQQ	ETF	37.11	37.12	37.09	37.12	94400.0
2004-01-05 18:00:00	QQQ	ETF	37.12	37.12	37.09	37.09	13000.0
2004-01-05 19:00:00	QQQ	ETF	37.1	37.14	37.1	37.13	8000.0
2004-01-05 08:00:00	IWM	ETF	56.285	56.29	56.265	56.29	28000.0
2004-01-05 09:00:00	IWM	ETF	56.3	56.635	56.2915	56.535	1233000.0
2004-01-05 10:00:00	IWM	ETF	56.53	56.55	56.235	56.355	1542000.0
2004-01-05 11:00:00	IWM	ETF	56.367	56.38	56.2	56.29	655400.0
2004-01-05 12:00:00	IWM	ETF	56.335	56.38	56.155	56.23	501800.0
2004-01-05 13:00:00	IWM	ETF	56.255	56.45	56.255	56.44	424800.0
2004-01-05 14:00:00	IWM	ETF	56.45	56.575	56.41	56.485	612200.0
2004-01-05 15:00:00	IWM	ETF	56.48	56.775	56.48	56.7665	2130600.0
2004-01-05 16:00:00	IWM	ETF	56.755	56.77	56.635	56.6625	504600.0
2004-01-05 17:00:00	IWM	ETF	56.6	56.6	56.6	56.6	600.0
2004-01-05 08:00:00	DIA	ETF	104.78	104.86	104.78	104.8	13500.0
2004-01-05 09:00:00	DIA	ETF	104.81	105.16	104.71	105.08	1650200.0
2004-01-05 10:00:00	DIA	ETF	105.1	105.16	104.86	104.978	905700.0
2004-01-05 11:00:00	DIA	ETF	104.98	105.03	104.84	105.0	597400.0
2004-01-05 12:00:00	DIA	ETF	105.0	105.06	104.81	104.98	523600.0
2004-01-05 13:00:00	DIA	ETF	104.98	105.27	104.94	105.19	641300.0
2004-01-05 14:00:00	DIA	ETF	105.19	105.3	105.09	105.16	490400.0
2004-01-05 15:00:00	DIA	ETF	105.15	105.59	105.142	105.53	1609900.0
2004-01-05 16:00:00	DIA	ETF	105.573	105.631	105.52	105.56	222500.0
2004-01-05 17:00:00	DIA	ETF	105.55	105.56	105.55	105.55	300.0
2004-01-05 09:00:00	TLT	ETF	84.01	84.16	83.98	84.0	75900.0
2004-01-05 10:00:00	TLT	ETF	83.99	84.21	83.9	84.1	196700.0
2004-01-05 11:00:00	TLT	ETF	84.15	84.17	84.05	84.08	81200.0
2004-01-05 12:00:00	TLT	ETF	84.1	84.38	84.1	84.38	94800.0
2004-01-05 13:00:00	TLT	ETF	84.38	84.38	84.15	84.26	11800.0
2004-01-05 14:00:00	TLT	ETF	84.2	84.33	84.2	84.31	27500.0

> showing 50 of 667 rows — these rows as CSV

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