PREVIEW / etf_1hour / 2007-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-26.parquet
  size:    69 KB
  rows:    2,238

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
2007-04-26 04:00:00	SPY	ETF	149.59	149.59	149.59	149.59	100.0
2007-04-26 05:00:00	SPY	ETF	149.53	149.53	149.53	149.53	7000.0
2007-04-26 06:00:00	SPY	ETF	149.49	149.61	149.49	149.6	7000.0
2007-04-26 07:00:00	SPY	ETF	149.6	149.83	149.6	149.76	222200.0
2007-04-26 08:00:00	SPY	ETF	149.81	149.82	149.5339	149.62	2008800.0
2007-04-26 09:00:00	SPY	ETF	149.63	149.67	149.18	149.18	15940610.0
2007-04-26 10:00:00	SPY	ETF	149.19	149.59	149.1	149.5699	22594834.0
2007-04-26 11:00:00	SPY	ETF	149.56	149.67	149.27	149.35	10247964.0
2007-04-26 12:00:00	SPY	ETF	149.35	149.56	149.34	149.41	6853303.0
2007-04-26 13:00:00	SPY	ETF	149.41	149.5	149.18	149.34	7131744.0
2007-04-26 14:00:00	SPY	ETF	149.34	149.8	149.28	149.64	9561691.0
2007-04-26 15:00:00	SPY	ETF	149.64	149.78	149.38	149.39	10160009.0
2007-04-26 16:00:00	SPY	ETF	149.38	149.66	149.32	149.51	1960300.0
2007-04-26 17:00:00	SPY	ETF	149.53	149.55	149.45	149.46	220700.0
2007-04-26 18:00:00	SPY	ETF	149.46	149.5	149.45	149.5	6200.0
2007-04-26 19:00:00	SPY	ETF	149.5	149.51	149.48	149.49	8600.0
2007-04-26 04:00:00	QQQ	ETF	46.45	46.45	46.45	46.45	400.0
2007-04-26 07:00:00	QQQ	ETF	46.48	46.58	46.48	46.53	331705.0
2007-04-26 08:00:00	QQQ	ETF	46.53	46.53	46.44	46.44	2292534.0
2007-04-26 09:00:00	QQQ	ETF	46.45	46.51	46.34	46.35	21205242.0
2007-04-26 10:00:00	QQQ	ETF	46.36	46.51	46.33	46.49	21402527.0
2007-04-26 11:00:00	QQQ	ETF	46.49	46.54	46.39	46.42	11268934.0
2007-04-26 12:00:00	QQQ	ETF	46.427	46.51	46.42	46.49	5873527.0
2007-04-26 13:00:00	QQQ	ETF	46.49	46.5	46.39	46.457	8408224.0
2007-04-26 14:00:00	QQQ	ETF	46.45	46.65	46.44	46.5725	11416327.0
2007-04-26 15:00:00	QQQ	ETF	46.58	46.63	46.44	46.44	12325120.0
2007-04-26 16:00:00	QQQ	ETF	46.44	46.59	46.43	46.53	1820142.0
2007-04-26 17:00:00	QQQ	ETF	46.52	46.58	46.5	46.53	191267.0
2007-04-26 18:00:00	QQQ	ETF	46.53	46.53	46.48	46.52	63514.0
2007-04-26 19:00:00	QQQ	ETF	46.53	46.53	46.5	46.5	4324.0
2007-04-26 07:00:00	IWM	ETF	82.7	82.76	82.7	82.7	103900.0
2007-04-26 08:00:00	IWM	ETF	82.69	82.72	82.6	82.61	1308400.0
2007-04-26 09:00:00	IWM	ETF	82.6	82.61	82.18	82.22	8295780.0
2007-04-26 10:00:00	IWM	ETF	82.22	82.57	81.97	82.52	10420533.0
2007-04-26 11:00:00	IWM	ETF	82.52	82.6	82.41	82.46	4587010.0
2007-04-26 12:00:00	IWM	ETF	82.46	82.56	82.43	82.51	2170513.0
2007-04-26 13:00:00	IWM	ETF	82.51	82.56	82.29	82.4	4568122.0
2007-04-26 14:00:00	IWM	ETF	82.4	82.89	82.36	82.75	5436248.0
2007-04-26 15:00:00	IWM	ETF	82.75	82.97	82.69	82.76	7041966.0
2007-04-26 16:00:00	IWM	ETF	82.76	83.0	82.76	82.87	1857700.0
2007-04-26 17:00:00	IWM	ETF	82.88	82.9	82.85	82.85	2200.0
2007-04-26 07:00:00	DIA	ETF	130.75	131.0	130.75	131.0	4200.0
2007-04-26 08:00:00	DIA	ETF	131.0	131.06	130.91	130.91	53200.0
2007-04-26 09:00:00	DIA	ETF	130.93	131.08	130.71	130.73	2148750.0
2007-04-26 10:00:00	DIA	ETF	130.73	131.11	130.62	131.11	1657451.0
2007-04-26 11:00:00	DIA	ETF	131.1	131.1	130.84	130.88	655720.0
2007-04-26 12:00:00	DIA	ETF	130.8899	131.05	130.85	130.93	436350.0
2007-04-26 13:00:00	DIA	ETF	130.94	131.01	130.72	130.9	1058210.0
2007-04-26 14:00:00	DIA	ETF	130.915	131.22	130.87	131.09	880578.0
2007-04-26 15:00:00	DIA	ETF	131.1	131.21	130.94	130.95	1083386.0

> showing 50 of 2,238 rows — these rows as CSV

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