PREVIEW / etf_1hour / 2006-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-06.parquet
  size:    39 KB
  rows:    1,227

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
2006-04-06 06:00:00	SPY	ETF	131.07	131.07	131.07	131.07	7000.0
2006-04-06 07:00:00	SPY	ETF	130.93	130.95	130.91	130.94	46900.0
2006-04-06 08:00:00	SPY	ETF	130.96	131.03	130.87	130.94	1065800.0
2006-04-06 09:00:00	SPY	ETF	130.96	131.01	130.75	130.89	5640000.0
2006-04-06 10:00:00	SPY	ETF	130.89	130.98	130.57	130.75	9677400.0
2006-04-06 11:00:00	SPY	ETF	130.75	130.93	130.42	130.44	4707400.0
2006-04-06 12:00:00	SPY	ETF	130.45	130.5	130.19	130.43	11620700.0
2006-04-06 13:00:00	SPY	ETF	130.43	131.05	130.39	130.97	8297500.0
2006-04-06 14:00:00	SPY	ETF	130.97	131.21	130.81	130.92	8091300.0
2006-04-06 15:00:00	SPY	ETF	130.91	130.94	130.68	130.83	6412900.0
2006-04-06 16:00:00	SPY	ETF	130.83	130.93	130.82	130.86	805000.0
2006-04-06 17:00:00	SPY	ETF	130.88	130.9	130.83	130.87	107600.0
2006-04-06 18:00:00	SPY	ETF	130.88	130.91	130.88	130.88	4300.0
2006-04-06 19:00:00	SPY	ETF	130.91	130.91	130.9	130.9	600.0
2006-04-06 09:00:00	QQQ	ETF	42.58	42.69	42.56	42.63	12725700.0
2006-04-06 10:00:00	QQQ	ETF	42.63	42.68	42.51	42.63	15454900.0
2006-04-06 11:00:00	QQQ	ETF	42.62	42.73	42.5	42.51	10940400.0
2006-04-06 12:00:00	QQQ	ETF	42.51	42.65	40.53	42.61	14544300.0
2006-04-06 13:00:00	QQQ	ETF	42.61	42.9	42.58	42.86	12999500.0
2006-04-06 14:00:00	QQQ	ETF	42.86	42.94	42.75	42.79	12013400.0
2006-04-06 15:00:00	QQQ	ETF	42.79	42.8	42.66	42.74	7838600.0
2006-04-06 08:00:00	IWM	ETF	76.05	76.05	75.95	76.03	6700.0
2006-04-06 09:00:00	IWM	ETF	76.03	76.04	75.84	75.97	1612000.0
2006-04-06 10:00:00	IWM	ETF	75.97	75.98	75.73	75.8	4876000.0
2006-04-06 11:00:00	IWM	ETF	75.8	75.96	75.59	75.61	3022000.0
2006-04-06 12:00:00	IWM	ETF	75.61	75.75	75.55	75.69	4230800.0
2006-04-06 13:00:00	IWM	ETF	75.7	76.19	75.65	76.12	4194600.0
2006-04-06 14:00:00	IWM	ETF	76.12	76.22	75.95	75.98	2348800.0
2006-04-06 15:00:00	IWM	ETF	75.99	76.11	75.88	76.11	4898800.0
2006-04-06 16:00:00	IWM	ETF	76.1	76.23	76.07	76.18	288700.0
2006-04-06 17:00:00	IWM	ETF	76.19	76.21	76.19	76.21	400.0
2006-04-06 07:00:00	DIA	ETF	112.22	112.28	112.21	112.28	5000.0
2006-04-06 08:00:00	DIA	ETF	112.2	112.38	112.2	112.36	3300.0
2006-04-06 09:00:00	DIA	ETF	112.3	112.38	112.14	112.24	364500.0
2006-04-06 10:00:00	DIA	ETF	112.23	112.31	111.93	112.05	690500.0
2006-04-06 11:00:00	DIA	ETF	112.05	112.17	111.85	111.86	528500.0
2006-04-06 12:00:00	DIA	ETF	111.87	111.9	111.66	111.83	671900.0
2006-04-06 13:00:00	DIA	ETF	111.83	112.32	111.81	112.26	567500.0
2006-04-06 14:00:00	DIA	ETF	112.26	112.47	112.17	112.23	735300.0
2006-04-06 15:00:00	DIA	ETF	112.24	112.25	112.03	112.14	880300.0
2006-04-06 16:00:00	DIA	ETF	112.15	112.24	112.15	112.23	17800.0
2006-04-06 19:00:00	DIA	ETF	112.25	112.25	112.25	112.25	100.0
2006-04-06 07:00:00	GLD	ETF	59.35	59.36	59.2	59.25	6100.0
2006-04-06 08:00:00	GLD	ETF	59.32	60.2	58.95	59.01	562300.0
2006-04-06 09:00:00	GLD	ETF	59.01	59.15	58.89	59.05	944600.0
2006-04-06 10:00:00	GLD	ETF	59.02	59.24	58.85	59.08	1029300.0
2006-04-06 11:00:00	GLD	ETF	59.08	59.15	59.0201	59.05	572400.0
2006-04-06 12:00:00	GLD	ETF	59.06	59.12	58.864	59.1	431300.0
2006-04-06 13:00:00	GLD	ETF	59.1	59.25	59.1	59.19	872600.0
2006-04-06 14:00:00	GLD	ETF	59.19	59.3	59.17	59.3	389000.0

> showing 50 of 1,227 rows — these rows as CSV

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