PREVIEW / etf_1hour / 2007-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-27.parquet
  size:    68 KB
  rows:    2,193

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-27 06:00:00	SPY	ETF	149.42	149.42	149.33	149.33	16000.0
2007-04-27 07:00:00	SPY	ETF	149.37	149.38	149.21	149.37	693900.0
2007-04-27 08:00:00	SPY	ETF	149.37	149.53	148.91	149.0	9202300.0
2007-04-27 09:00:00	SPY	ETF	149.02	149.23	148.9	149.11	16219915.0
2007-04-27 10:00:00	SPY	ETF	149.11	149.4203	148.84	149.05	20161324.0
2007-04-27 11:00:00	SPY	ETF	149.04	149.36	149.01	149.35	11769378.0
2007-04-27 12:00:00	SPY	ETF	149.36	149.47	149.18	149.3	7246050.0
2007-04-27 13:00:00	SPY	ETF	149.3	149.66	149.29	149.49	8659088.0
2007-04-27 14:00:00	SPY	ETF	149.48	149.74	149.44	149.63	8576281.0
2007-04-27 15:00:00	SPY	ETF	149.63	149.65	149.22	149.4	18296618.0
2007-04-27 16:00:00	SPY	ETF	149.4	149.6	149.28	149.6	4514200.0
2007-04-27 17:00:00	SPY	ETF	149.53	149.61	149.53	149.57	1212400.0
2007-04-27 18:00:00	SPY	ETF	149.55	149.6	149.55	149.6	600.0
2007-04-27 19:00:00	SPY	ETF	149.6	149.67	149.6	149.67	5300.0
2007-04-27 07:00:00	QQQ	ETF	46.47	46.5	46.41	46.47	1119664.0
2007-04-27 08:00:00	QQQ	ETF	46.47	46.51	46.31	46.32	4256859.0
2007-04-27 09:00:00	QQQ	ETF	46.32	46.49	46.32	46.45	15141333.0
2007-04-27 10:00:00	QQQ	ETF	46.46	46.7	46.29	46.38	24444983.0
2007-04-27 11:00:00	QQQ	ETF	46.38	46.51	46.37	46.5	8529089.0
2007-04-27 12:00:00	QQQ	ETF	46.5	46.5	46.38	46.38	4549186.0
2007-04-27 13:00:00	QQQ	ETF	46.38	46.48	46.37	46.39	7649118.0
2007-04-27 14:00:00	QQQ	ETF	46.3926	46.56	46.38	46.52	10793585.0
2007-04-27 15:00:00	QQQ	ETF	46.52	46.55	46.38	46.51	18220611.0
2007-04-27 16:00:00	QQQ	ETF	46.52	46.61	46.51	46.53	1226946.0
2007-04-27 17:00:00	QQQ	ETF	46.53	46.54	46.51	46.54	52345.0
2007-04-27 18:00:00	QQQ	ETF	46.54	46.61	46.53	46.6	36000.0
2007-04-27 19:00:00	QQQ	ETF	46.6	46.6	46.55	46.58	26700.0
2007-04-27 07:00:00	IWM	ETF	82.65	82.7	82.61	82.65	47900.0
2007-04-27 08:00:00	IWM	ETF	82.65	82.8	82.48	82.5	1241100.0
2007-04-27 09:00:00	IWM	ETF	82.51	82.58	82.3	82.39	8192911.0
2007-04-27 10:00:00	IWM	ETF	82.39	82.64	82.02	82.11	10680483.0
2007-04-27 11:00:00	IWM	ETF	82.11	82.36	82.09	82.34	4679140.0
2007-04-27 12:00:00	IWM	ETF	82.35	82.42	82.26	82.27	5421139.0
2007-04-27 13:00:00	IWM	ETF	82.27	82.6	82.24	82.43	8613698.0
2007-04-27 14:00:00	IWM	ETF	82.43	82.61	82.38	82.42	6772054.0
2007-04-27 15:00:00	IWM	ETF	82.42	82.46	82.22	82.3	6440001.0
2007-04-27 16:00:00	IWM	ETF	82.3	82.52	82.26	82.43	3139700.0
2007-04-27 17:00:00	IWM	ETF	82.46	82.46	82.46	82.46	165200.0
2007-04-27 19:00:00	IWM	ETF	82.46	82.46	82.46	82.46	500.0
2007-04-27 07:00:00	DIA	ETF	130.94	130.94	130.9	130.9	200.0
2007-04-27 08:00:00	DIA	ETF	130.95	131.07	130.65	130.7	222100.0
2007-04-27 09:00:00	DIA	ETF	130.68	130.91	130.63	130.81	830000.0
2007-04-27 10:00:00	DIA	ETF	130.82	131.11	130.69	130.84	2315180.0
2007-04-27 11:00:00	DIA	ETF	130.84	131.14	130.84	131.14	875136.0
2007-04-27 12:00:00	DIA	ETF	131.14	131.19	130.96	131.09	903274.0
2007-04-27 13:00:00	DIA	ETF	131.091	131.34	131.04	131.22	635682.0
2007-04-27 14:00:00	DIA	ETF	131.22	131.37	131.18	131.28	553880.0
2007-04-27 15:00:00	DIA	ETF	131.28	131.3	130.98	131.12	874974.0
2007-04-27 16:00:00	DIA	ETF	131.12	131.27	131.12	131.17	284800.0
2007-04-27 17:00:00	DIA	ETF	131.19	131.19	131.19	131.19	200.0

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

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