PREVIEW / etf_1hour / 2005-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-29.parquet
  size:    33 KB
  rows:    990

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-09-29 07:00:00	SPY	ETF	121.76	121.8	121.76	121.8	1400.0
2005-09-29 08:00:00	SPY	ETF	121.74	121.81	121.58	121.71	613800.0
2005-09-29 09:00:00	SPY	ETF	121.69	121.69	121.17	121.26	6380800.0
2005-09-29 10:00:00	SPY	ETF	121.26	121.68	121.2	121.28	9899600.0
2005-09-29 11:00:00	SPY	ETF	121.28	122.07	121.08	121.91	12872600.0
2005-09-29 12:00:00	SPY	ETF	121.91	121.97	121.67	121.87	4551700.0
2005-09-29 13:00:00	SPY	ETF	121.86	122.4	121.85	122.27	9078000.0
2005-09-29 14:00:00	SPY	ETF	122.27	122.75	122.25	122.57	8522400.0
2005-09-29 15:00:00	SPY	ETF	122.57	122.86	122.47	122.81	9010400.0
2005-09-29 16:00:00	SPY	ETF	122.79	122.8	121.6	122.64	1452600.0
2005-09-29 17:00:00	SPY	ETF	122.64	122.69	122.64	122.66	8900.0
2005-09-29 18:00:00	SPY	ETF	122.67	122.69	122.67	122.67	13200.0
2005-09-29 19:00:00	SPY	ETF	122.67	122.67	122.67	122.67	1000.0
2005-09-29 09:00:00	QQQ	ETF	38.63	38.65	38.45	38.47	12494200.0
2005-09-29 10:00:00	QQQ	ETF	38.47	38.77	38.44	38.59	19374000.0
2005-09-29 11:00:00	QQQ	ETF	38.59	38.9	38.54	38.86	14550400.0
2005-09-29 12:00:00	QQQ	ETF	38.85	38.91	38.73	38.85	8674300.0
2005-09-29 13:00:00	QQQ	ETF	38.85	39.12	38.85	39.02	18656400.0
2005-09-29 14:00:00	QQQ	ETF	39.03	39.13	38.97	39.05	18018300.0
2005-09-29 15:00:00	QQQ	ETF	39.06	39.21	39.02	39.19	21551300.0
2005-09-29 08:00:00	IWM	ETF	65.25	65.31	65.25	65.28	72900.0
2005-09-29 09:00:00	IWM	ETF	65.24	65.3	64.83	64.84	2113700.0
2005-09-29 10:00:00	IWM	ETF	64.84	65.19	64.81	64.96	3001000.0
2005-09-29 11:00:00	IWM	ETF	64.96	65.45	64.84	65.35	3045000.0
2005-09-29 12:00:00	IWM	ETF	65.35	65.43	65.26	65.41	998200.0
2005-09-29 13:00:00	IWM	ETF	65.41	65.9	65.4	65.8	2539000.0
2005-09-29 14:00:00	IWM	ETF	65.81	66.03	65.76	65.85	4754700.0
2005-09-29 15:00:00	IWM	ETF	65.84	66.15	65.75	66.13	6112400.0
2005-09-29 16:00:00	IWM	ETF	66.13	66.13	65.2179	66.01	1434800.0
2005-09-29 17:00:00	IWM	ETF	66.01	66.01	66.01	66.01	5300.0
2005-09-29 08:00:00	DIA	ETF	104.68	104.69	104.65	104.69	3900.0
2005-09-29 09:00:00	DIA	ETF	104.71	104.71	104.28	104.32	379100.0
2005-09-29 10:00:00	DIA	ETF	104.35	104.63	104.25	104.31	1442000.0
2005-09-29 11:00:00	DIA	ETF	104.31	104.93	104.1	104.8	1568200.0
2005-09-29 12:00:00	DIA	ETF	104.82	104.86	104.61	104.68	808500.0
2005-09-29 13:00:00	DIA	ETF	104.7	105.07	104.65	104.9	1041800.0
2005-09-29 14:00:00	DIA	ETF	104.94	105.45	104.94	105.32	2346900.0
2005-09-29 15:00:00	DIA	ETF	105.31	105.55	105.24	105.51	1221000.0
2005-09-29 16:00:00	DIA	ETF	105.45	105.51	105.36	105.37	52800.0
2005-09-29 17:00:00	DIA	ETF	105.4	105.4	105.4	105.4	200.0
2005-09-29 07:00:00	GLD	ETF	47.0	47.0	47.0	47.0	100.0
2005-09-29 08:00:00	GLD	ETF	47.3	47.3	46.7	46.7	3600.0
2005-09-29 09:00:00	GLD	ETF	46.72	47.06	46.72	47.02	281500.0
2005-09-29 10:00:00	GLD	ETF	47.03	47.23	46.97	47.06	406300.0
2005-09-29 11:00:00	GLD	ETF	47.06	47.12	46.9	46.91	393600.0
2005-09-29 12:00:00	GLD	ETF	46.93	47.11	46.89	47.08	1293800.0
2005-09-29 13:00:00	GLD	ETF	47.08	47.19	47.05	47.18	308500.0
2005-09-29 14:00:00	GLD	ETF	47.17	47.2	47.14	47.14	128000.0
2005-09-29 15:00:00	GLD	ETF	47.13	47.15	47.08	47.08	130300.0
2005-09-29 16:00:00	GLD	ETF	47.08	47.08	47.08	47.08	1000.0

> showing 50 of 990 rows — these rows as CSV

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