PREVIEW / etf_1hour / 2006-04-24

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-24.parquet
  size:    40 KB
  rows:    1,242

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-24 06:00:00	SPY	ETF	130.92	130.94	130.89	130.89	189500.0
2006-04-24 07:00:00	SPY	ETF	130.86	130.95	130.85	130.95	46500.0
2006-04-24 08:00:00	SPY	ETF	130.94	131.01	130.8	130.95	795700.0
2006-04-24 09:00:00	SPY	ETF	130.97	130.99	130.44	130.47	9872200.0
2006-04-24 10:00:00	SPY	ETF	130.48	130.9	130.42	130.69	12442600.0
2006-04-24 11:00:00	SPY	ETF	130.69	130.74	130.38	130.66	7253000.0
2006-04-24 12:00:00	SPY	ETF	130.66	130.95	130.51	130.87	4820600.0
2006-04-24 13:00:00	SPY	ETF	130.87	130.9	130.61	130.8	4375900.0
2006-04-24 14:00:00	SPY	ETF	130.8	130.95	130.66	130.72	4209700.0
2006-04-24 15:00:00	SPY	ETF	130.72	131.07	130.71	130.83	6488000.0
2006-04-24 16:00:00	SPY	ETF	130.82	131.0	130.82	131.0	1123000.0
2006-04-24 17:00:00	SPY	ETF	130.94	130.97	130.94	130.94	4000.0
2006-04-24 18:00:00	SPY	ETF	130.95	130.95	130.92	130.92	1300.0
2006-04-24 19:00:00	SPY	ETF	130.93	130.93	130.92	130.92	700.0
2006-04-24 09:00:00	QQQ	ETF	41.96	41.96	41.72	41.75	13112900.0
2006-04-24 10:00:00	QQQ	ETF	41.75	41.95	41.72	41.8	15473900.0
2006-04-24 11:00:00	QQQ	ETF	41.8	41.87	41.72	41.86	10127000.0
2006-04-24 12:00:00	QQQ	ETF	41.87	42.05	41.83	42.01	8188300.0
2006-04-24 13:00:00	QQQ	ETF	42.01	42.02	41.92	41.96	5516400.0
2006-04-24 14:00:00	QQQ	ETF	41.96	42.02	41.87	41.9	7714600.0
2006-04-24 15:00:00	QQQ	ETF	41.9	42.07	41.9	41.96	9930500.0
2006-04-24 08:00:00	IWM	ETF	76.69	76.69	76.57	76.59	4300.0
2006-04-24 09:00:00	IWM	ETF	76.59	76.7	75.93	75.98	7370200.0
2006-04-24 10:00:00	IWM	ETF	75.98	76.2	75.79	75.85	7908800.0
2006-04-24 11:00:00	IWM	ETF	75.85	76.08	75.73	76.07	5615700.0
2006-04-24 12:00:00	IWM	ETF	76.06	76.13	76.02	76.08	3275700.0
2006-04-24 13:00:00	IWM	ETF	76.08	76.13	75.98	76.04	2542500.0
2006-04-24 14:00:00	IWM	ETF	76.04	76.13	76.01	76.04	2822100.0
2006-04-24 15:00:00	IWM	ETF	76.04	76.16	76.03	76.03	5404500.0
2006-04-24 16:00:00	IWM	ETF	76.03	76.698	75.91	76.04	2935200.0
2006-04-24 19:00:00	IWM	ETF	76.06	76.06	76.06	76.06	100.0
2006-04-24 07:00:00	DIA	ETF	113.26	113.32	113.26	113.32	2200.0
2006-04-24 08:00:00	DIA	ETF	113.25	113.37	113.2	113.3	17300.0
2006-04-24 09:00:00	DIA	ETF	113.37	113.37	113.03	113.06	727300.0
2006-04-24 10:00:00	DIA	ETF	113.05	113.43	112.93	113.29	1216100.0
2006-04-24 11:00:00	DIA	ETF	113.29	113.34	113.02	113.24	417200.0
2006-04-24 12:00:00	DIA	ETF	113.25	113.38	113.03	113.28	793900.0
2006-04-24 13:00:00	DIA	ETF	113.28	113.32	113.06	113.25	329100.0
2006-04-24 14:00:00	DIA	ETF	113.25	113.44	113.19	113.21	845100.0
2006-04-24 15:00:00	DIA	ETF	113.21	113.47	113.2	113.29	733300.0
2006-04-24 16:00:00	DIA	ETF	113.26	113.44	113.26	113.44	17000.0
2006-04-24 17:00:00	DIA	ETF	113.42	113.45	113.42	113.45	600.0
2006-04-24 18:00:00	DIA	ETF	113.45	113.45	113.45	113.45	200.0
2006-04-24 07:00:00	GLD	ETF	62.65	62.66	62.51	62.51	2500.0
2006-04-24 08:00:00	GLD	ETF	62.5	62.62	61.9	62.53	206400.0
2006-04-24 09:00:00	GLD	ETF	62.5	62.51	61.75	61.77	1189300.0
2006-04-24 10:00:00	GLD	ETF	61.78	62.02	61.6	61.81	1039500.0
2006-04-24 11:00:00	GLD	ETF	61.83	62.53	61.81	62.4	877400.0
2006-04-24 12:00:00	GLD	ETF	62.4	62.48	62.24	62.3	458100.0
2006-04-24 13:00:00	GLD	ETF	62.33	62.4	61.7	61.73	2079500.0

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

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