PREVIEW / etf_1hour / 2005-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-18.parquet
  size:    31 KB
  rows:    945

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
2005-08-18 07:00:00	SPY	ETF	121.99	122.03	121.97	122.01	105000.0
2005-08-18 08:00:00	SPY	ETF	121.95	122.02	121.95	122.0	583200.0
2005-08-18 09:00:00	SPY	ETF	121.99	122.11	121.84	122.05	7805100.0
2005-08-18 10:00:00	SPY	ETF	122.06	122.32	121.96	122.04	9709500.0
2005-08-18 11:00:00	SPY	ETF	122.02	122.18	121.93	121.96	4579200.0
2005-08-18 12:00:00	SPY	ETF	121.98	122.3	121.98	122.15	4961100.0
2005-08-18 13:00:00	SPY	ETF	122.16	122.56	122.14	122.35	6505000.0
2005-08-18 14:00:00	SPY	ETF	122.35	122.36	121.96	122.24	7386100.0
2005-08-18 15:00:00	SPY	ETF	122.23	122.45	122.08	122.11	9133500.0
2005-08-18 16:00:00	SPY	ETF	122.1	122.25	122.03	122.14	1586300.0
2005-08-18 17:00:00	SPY	ETF	122.18	122.19	122.16	122.16	27200.0
2005-08-18 18:00:00	SPY	ETF	122.22	122.28	122.22	122.25	6000.0
2005-08-18 19:00:00	SPY	ETF	122.26	122.26	122.26	122.26	100.0
2005-08-18 09:00:00	QQQ	ETF	38.87	38.89	38.79	38.84	6929600.0
2005-08-18 10:00:00	QQQ	ETF	38.84	38.92	38.77	38.82	11695000.0
2005-08-18 11:00:00	QQQ	ETF	38.82	38.89	38.77	38.8	8416500.0
2005-08-18 12:00:00	QQQ	ETF	38.8	38.9	38.78	38.84	5884600.0
2005-08-18 13:00:00	QQQ	ETF	38.85	39.09	38.84	38.98	13595400.0
2005-08-18 14:00:00	QQQ	ETF	38.98	39.1	38.78	38.84	8807000.0
2005-08-18 15:00:00	QQQ	ETF	38.85	38.92	38.79	38.84	11683800.0
2005-08-18 08:00:00	IWM	ETF	64.84	64.86	64.83	64.85	16500.0
2005-08-18 09:00:00	IWM	ETF	64.84	64.85	64.47	64.61	4021500.0
2005-08-18 10:00:00	IWM	ETF	64.61	64.98	64.552	64.76	3985800.0
2005-08-18 11:00:00	IWM	ETF	64.75	64.87	64.66	64.74	1522900.0
2005-08-18 12:00:00	IWM	ETF	64.75	64.92	64.74	64.87	2080100.0
2005-08-18 13:00:00	IWM	ETF	64.87	65.15	64.86	65.07	1948700.0
2005-08-18 14:00:00	IWM	ETF	65.07	65.1	64.69	64.76	5496200.0
2005-08-18 15:00:00	IWM	ETF	64.76	64.98	64.74	64.89	3341200.0
2005-08-18 16:00:00	IWM	ETF	64.9	64.9	64.7	64.71	600300.0
2005-08-18 17:00:00	IWM	ETF	64.77	64.77	64.73	64.73	700.0
2005-08-18 19:00:00	IWM	ETF	64.81	64.81	64.81	64.81	100.0
2005-08-18 07:00:00	DIA	ETF	105.46	105.47	105.46	105.47	900.0
2005-08-18 08:00:00	DIA	ETF	105.41	105.46	105.37	105.46	12900.0
2005-08-18 09:00:00	DIA	ETF	105.41	105.57	105.37	105.52	579500.0
2005-08-18 10:00:00	DIA	ETF	105.52	105.83	105.4	105.58	1315500.0
2005-08-18 11:00:00	DIA	ETF	105.59	105.7	105.49	105.57	1043400.0
2005-08-18 12:00:00	DIA	ETF	105.57	105.91	105.57	105.77	880900.0
2005-08-18 13:00:00	DIA	ETF	105.77	106.17	105.77	105.98	1483000.0
2005-08-18 14:00:00	DIA	ETF	105.98	105.99	105.65	105.88	548200.0
2005-08-18 15:00:00	DIA	ETF	105.86	105.97	105.7	105.73	828300.0
2005-08-18 16:00:00	DIA	ETF	105.7	105.79	105.7	105.78	1200.0
2005-08-18 17:00:00	DIA	ETF	105.78	105.78	105.78	105.78	600.0
2005-08-18 18:00:00	DIA	ETF	105.85	105.85	105.85	105.85	100.0
2005-08-18 19:00:00	DIA	ETF	105.85	105.85	105.85	105.85	300.0
2005-08-18 09:00:00	GLD	ETF	43.94	43.99	43.91	43.91	143500.0
2005-08-18 10:00:00	GLD	ETF	43.9	44.12	43.84	44.09	342600.0
2005-08-18 11:00:00	GLD	ETF	44.084	44.14	44.03	44.09	197500.0
2005-08-18 12:00:00	GLD	ETF	44.06	44.12	43.95	43.97	87600.0
2005-08-18 13:00:00	GLD	ETF	43.99	44.0	43.83	43.84	69800.0
2005-08-18 14:00:00	GLD	ETF	43.84	43.88	43.82	43.85	47600.0

> showing 50 of 945 rows — these rows as CSV

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