PREVIEW / etf_1hour / 2007-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-30.parquet
  size:    94 KB
  rows:    3,142

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-11-30 04:00:00	SPY	ETF	148.01	148.01	148.01	148.01	500.0
2007-11-30 05:00:00	SPY	ETF	148.15	148.15	148.01	148.01	3000.0
2007-11-30 06:00:00	SPY	ETF	148.03	148.39	148.03	148.33	100300.0
2007-11-30 07:00:00	SPY	ETF	148.3	149.0	148.25	148.65	1970200.0
2007-11-30 08:00:00	SPY	ETF	148.64	149.04	147.12	148.84	5521200.0
2007-11-30 09:00:00	SPY	ETF	148.84	149.87	148.2	148.89	33397694.0
2007-11-30 10:00:00	SPY	ETF	148.89	149.13	148.5	148.67	31645108.0
2007-11-30 11:00:00	SPY	ETF	148.67	149.13	147.91	148.47	38099118.0
2007-11-30 12:00:00	SPY	ETF	148.46	148.54	147.9	148.34	14523609.0
2007-11-30 13:00:00	SPY	ETF	148.33	148.8	148.06	148.56	13380645.0
2007-11-30 14:00:00	SPY	ETF	148.56	148.6	148.01	148.15	17034552.0
2007-11-30 15:00:00	SPY	ETF	148.15	148.49	147.33	148.44	53184171.0
2007-11-30 16:00:00	SPY	ETF	148.441	148.67	148.35	148.59	8096700.0
2007-11-30 17:00:00	SPY	ETF	148.57	148.57	148.47	148.5	60800.0
2007-11-30 18:00:00	SPY	ETF	148.6	148.7	148.55	148.58	12500.0
2007-11-30 19:00:00	SPY	ETF	148.58	148.58	148.53	148.53	19200.0
2007-11-30 05:00:00	QQQ	ETF	51.9	51.91	51.9	51.91	10200.0
2007-11-30 06:00:00	QQQ	ETF	51.9	52.05	51.9	52.05	227550.0
2007-11-30 07:00:00	QQQ	ETF	52.05	52.25	52.02	52.07	1694666.0
2007-11-30 08:00:00	QQQ	ETF	52.08	52.2	51.7	52.15	2020910.0
2007-11-30 09:00:00	QQQ	ETF	52.15	52.26	51.92	52.06	23496902.0
2007-11-30 10:00:00	QQQ	ETF	52.06	52.115	51.72	51.79	25800619.0
2007-11-30 11:00:00	QQQ	ETF	51.79	51.79	51.34	51.6	30385966.0
2007-11-30 12:00:00	QQQ	ETF	51.6	51.61	51.27	51.52	13167315.0
2007-11-30 13:00:00	QQQ	ETF	51.52	51.59	51.31	51.5	12950504.0
2007-11-30 14:00:00	QQQ	ETF	51.5	51.56	51.31	51.38	16164539.0
2007-11-30 15:00:00	QQQ	ETF	51.38	51.4	50.96	51.33	41480502.0
2007-11-30 16:00:00	QQQ	ETF	51.33	51.52	51.24	51.5	3946425.0
2007-11-30 17:00:00	QQQ	ETF	51.5	51.54	51.47	51.48	49096.0
2007-11-30 18:00:00	QQQ	ETF	51.46	51.5	51.46	51.48	12207.0
2007-11-30 19:00:00	QQQ	ETF	51.49	51.53	51.48	51.53	9927.0
2007-11-30 06:00:00	IWM	ETF	76.75	76.88	76.75	76.88	12700.0
2007-11-30 07:00:00	IWM	ETF	76.92	77.3	76.88	77.0	704300.0
2007-11-30 08:00:00	IWM	ETF	77.03	78.61	76.75	77.22	1363200.0
2007-11-30 09:00:00	IWM	ETF	77.29	77.95	77.29	77.53	14452722.0
2007-11-30 10:00:00	IWM	ETF	77.52	77.65	77.15	77.3	10432500.0
2007-11-30 11:00:00	IWM	ETF	77.32	77.35	76.7	76.98	8084284.0
2007-11-30 12:00:00	IWM	ETF	76.98	77.05	76.71	76.98	4209300.0
2007-11-30 13:00:00	IWM	ETF	76.98	77.25	76.87	77.17	5008900.0
2007-11-30 14:00:00	IWM	ETF	77.18	77.29	76.73	76.78	10729800.0
2007-11-30 15:00:00	IWM	ETF	76.77	76.79	76.15	76.41	26326500.0
2007-11-30 16:00:00	IWM	ETF	76.41	77.1	76.36	76.65	3671700.0
2007-11-30 17:00:00	IWM	ETF	76.58	76.58	76.58	76.58	500.0
2007-11-30 19:00:00	IWM	ETF	76.58	76.58	76.58	76.58	1000.0
2007-11-30 07:00:00	DIA	ETF	134.22	134.6	134.22	134.4	213100.0
2007-11-30 08:00:00	DIA	ETF	134.4	134.5	134.2	134.4	122700.0
2007-11-30 09:00:00	DIA	ETF	134.47	134.7	134.25	134.49	2235942.0
2007-11-30 10:00:00	DIA	ETF	134.5	134.67	134.2	134.32	2041900.0
2007-11-30 11:00:00	DIA	ETF	134.33	134.33	133.55	133.92	6450600.0
2007-11-30 12:00:00	DIA	ETF	133.91	133.97	133.44	133.81	1051300.0

> showing 50 of 3,142 rows — these rows as CSV

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