PREVIEW / etf_1hour / 2004-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-07.parquet
  size:    24 KB
  rows:    647

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-07 08:00:00	SPY	ETF	112.43	112.53	112.42	112.46	11600.0
2004-01-07 09:00:00	SPY	ETF	112.47	112.55	112.15	112.16	3708300.0
2004-01-07 10:00:00	SPY	ETF	112.15	112.2	111.89	112.16	6398900.0
2004-01-07 11:00:00	SPY	ETF	112.15	112.52	112.06	112.45	3386500.0
2004-01-07 12:00:00	SPY	ETF	112.44	112.78	112.43	112.67	3152300.0
2004-01-07 13:00:00	SPY	ETF	112.67	112.8	112.43	112.51	2447600.0
2004-01-07 14:00:00	SPY	ETF	112.51	112.6	112.29	112.58	3004100.0
2004-01-07 15:00:00	SPY	ETF	112.58	112.92	112.34	112.9	3884100.0
2004-01-07 16:00:00	SPY	ETF	112.89	113.06	112.86	112.98	2639500.0
2004-01-07 17:00:00	SPY	ETF	112.97	113.01	112.96	112.98	8000.0
2004-01-07 18:00:00	SPY	ETF	112.98	112.98	112.93	112.93	9400.0
2004-01-07 19:00:00	SPY	ETF	112.91	113.0	112.91	112.99	2100.0
2004-01-07 08:00:00	QQQ	ETF	37.24	37.3	37.24	37.26	55300.0
2004-01-07 09:00:00	QQQ	ETF	37.26	37.34	37.18	37.181	7721800.0
2004-01-07 10:00:00	QQQ	ETF	37.18	37.25	37.07	37.24	12448600.0
2004-01-07 11:00:00	QQQ	ETF	37.242	37.41	37.18	37.39	8438700.0
2004-01-07 12:00:00	QQQ	ETF	37.391	37.58	37.37	37.506	9107500.0
2004-01-07 13:00:00	QQQ	ETF	37.51	37.62	37.45	37.47	6750900.0
2004-01-07 14:00:00	QQQ	ETF	37.474	37.58	37.361	37.57	8267300.0
2004-01-07 15:00:00	QQQ	ETF	37.56	37.624	37.44	37.61	9320200.0
2004-01-07 16:00:00	QQQ	ETF	37.61	37.68	37.58	37.66	3449400.0
2004-01-07 17:00:00	QQQ	ETF	37.67	37.71	37.65	37.69	2366400.0
2004-01-07 18:00:00	QQQ	ETF	37.7	37.7	37.67	37.68	43500.0
2004-01-07 19:00:00	QQQ	ETF	37.67	37.69	37.67	37.67	8900.0
2004-01-07 08:00:00	IWM	ETF	56.6	56.6	56.6	56.6	4000.0
2004-01-07 09:00:00	IWM	ETF	56.54	56.995	56.525	56.695	560400.0
2004-01-07 10:00:00	IWM	ETF	56.685	56.75	56.481	56.685	1107400.0
2004-01-07 11:00:00	IWM	ETF	56.72	56.95	56.68	56.925	1005800.0
2004-01-07 12:00:00	IWM	ETF	56.915	57.045	56.91	56.965	585800.0
2004-01-07 13:00:00	IWM	ETF	56.96	57.02	56.84	56.88	449600.0
2004-01-07 14:00:00	IWM	ETF	56.885	57.035	56.775	57.035	497600.0
2004-01-07 15:00:00	IWM	ETF	57.015	57.19	56.9245	57.185	919400.0
2004-01-07 16:00:00	IWM	ETF	57.15	57.275	57.125	57.22	460800.0
2004-01-07 17:00:00	IWM	ETF	57.23	57.23	57.23	57.23	2000.0
2004-01-07 08:00:00	DIA	ETF	105.38	105.38	105.38	105.38	500.0
2004-01-07 09:00:00	DIA	ETF	105.4	105.44	105.03	105.03	964700.0
2004-01-07 10:00:00	DIA	ETF	105.02	105.07	104.808	105.01	1394900.0
2004-01-07 11:00:00	DIA	ETF	105.01	105.29	104.92	105.22	816400.0
2004-01-07 12:00:00	DIA	ETF	105.23	105.53	105.21	105.4	529600.0
2004-01-07 13:00:00	DIA	ETF	105.41	105.49	105.15	105.22	513800.0
2004-01-07 14:00:00	DIA	ETF	105.207	105.24	104.91	105.2	872800.0
2004-01-07 15:00:00	DIA	ETF	105.2	105.45	104.94	105.44	932000.0
2004-01-07 16:00:00	DIA	ETF	105.463	105.6	105.39	105.53	393300.0
2004-01-07 17:00:00	DIA	ETF	105.6	105.6	105.57	105.59	3300.0
2004-01-07 18:00:00	DIA	ETF	105.59	105.59	105.59	105.59	100.0
2004-01-07 19:00:00	DIA	ETF	105.55	105.55	105.5	105.5	1200.0
2004-01-07 09:00:00	TLT	ETF	85.1	85.13	84.89	85.0	12000.0
2004-01-07 10:00:00	TLT	ETF	85.05	85.4	85.0	85.28	90000.0
2004-01-07 11:00:00	TLT	ETF	85.27	85.39	85.18	85.22	37300.0
2004-01-07 12:00:00	TLT	ETF	85.21	85.35	85.18	85.27	23400.0

> showing 50 of 647 rows — these rows as CSV

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