PREVIEW / etf_1hour / 2007-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-08.parquet
  size:    97 KB
  rows:    3,204

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-08 06:00:00	SPY	ETF	147.88	148.5	147.65	148.35	602700.0
2007-11-08 07:00:00	SPY	ETF	148.35	148.77	148.05	148.35	2169100.0
2007-11-08 08:00:00	SPY	ETF	148.35	148.7	146.15	148.22	5595600.0
2007-11-08 09:00:00	SPY	ETF	148.27	149.3	147.06	147.81	52020051.0
2007-11-08 10:00:00	SPY	ETF	147.8	148.36	146.9	147.94	57222293.0
2007-11-08 11:00:00	SPY	ETF	147.93	148.17	146.91	147.23	30801458.0
2007-11-08 12:00:00	SPY	ETF	147.23	147.41	145.42	145.93	65441099.0
2007-11-08 13:00:00	SPY	ETF	145.93	146.56	145.07	146.53	48940490.0
2007-11-08 14:00:00	SPY	ETF	146.53	146.62	145.38	146.41	31196781.0
2007-11-08 15:00:00	SPY	ETF	146.41	148.15	146.12	147.53	68587041.0
2007-11-08 16:00:00	SPY	ETF	147.43	147.99	145.82	147.06	6060400.0
2007-11-08 17:00:00	SPY	ETF	147.09	147.21	146.78	147.18	470300.0
2007-11-08 18:00:00	SPY	ETF	147.2	147.29	147.02	147.26	122100.0
2007-11-08 19:00:00	SPY	ETF	147.28	147.5	147.22	147.5	80100.0
2007-11-08 04:00:00	QQQ	ETF	52.94	53.02	52.94	53.02	4800.0
2007-11-08 05:00:00	QQQ	ETF	53.0	53.12	53.0	53.12	300.0
2007-11-08 06:00:00	QQQ	ETF	53.03	53.22	53.03	53.22	191208.0
2007-11-08 07:00:00	QQQ	ETF	53.16	53.35	53.05	53.2	1834546.0
2007-11-08 08:00:00	QQQ	ETF	53.2	53.3	52.5	53.2	4147281.0
2007-11-08 09:00:00	QQQ	ETF	53.21	53.33	52.59	52.81	37141631.0
2007-11-08 10:00:00	QQQ	ETF	52.81	52.95	52.45	52.72	45369079.0
2007-11-08 11:00:00	QQQ	ETF	52.71	52.83	52.22	52.33	30256122.0
2007-11-08 12:00:00	QQQ	ETF	52.32	52.42	51.2	51.46	72445670.0
2007-11-08 13:00:00	QQQ	ETF	51.46	51.68	50.8	51.6601	61017274.0
2007-11-08 14:00:00	QQQ	ETF	51.66	51.72	51.03	51.51	35926651.0
2007-11-08 15:00:00	QQQ	ETF	51.5195	52.32	51.3799	51.76	76488906.0
2007-11-08 16:00:00	QQQ	ETF	51.77	53.3367	51.4	51.43	13911998.0
2007-11-08 17:00:00	QQQ	ETF	51.45	51.76	51.43	51.76	3024895.0
2007-11-08 18:00:00	QQQ	ETF	51.72	51.75	51.61	51.63	546779.0
2007-11-08 19:00:00	QQQ	ETF	51.71	51.77	51.7	51.77	46189.0
2007-11-08 04:00:00	IWM	ETF	77.28	77.28	77.28	77.28	100.0
2007-11-08 06:00:00	IWM	ETF	77.53	77.82	77.53	77.82	1300.0
2007-11-08 07:00:00	IWM	ETF	77.85	78.22	77.77	78.05	327100.0
2007-11-08 08:00:00	IWM	ETF	78.1	78.19	75.12	78.12	3689800.0
2007-11-08 09:00:00	IWM	ETF	78.13	78.16	77.04	77.42	12091896.0
2007-11-08 10:00:00	IWM	ETF	77.43	78.0	77.0	77.71	16361169.0
2007-11-08 11:00:00	IWM	ETF	77.72	77.91	77.05	77.31	9212201.0
2007-11-08 12:00:00	IWM	ETF	77.3	77.42	76.29	76.63	16237287.0
2007-11-08 13:00:00	IWM	ETF	76.64	76.79	75.82	76.74	21514082.0
2007-11-08 14:00:00	IWM	ETF	76.74	76.96	76.28	76.94	11418865.0
2007-11-08 15:00:00	IWM	ETF	76.94	78.8	76.76	77.84	28615063.0
2007-11-08 16:00:00	IWM	ETF	77.85	77.88	77.55	77.6	1457600.0
2007-11-08 17:00:00	IWM	ETF	77.55	77.8	77.55	77.65	400500.0
2007-11-08 18:00:00	IWM	ETF	77.75	77.75	77.6	77.75	7000.0
2007-11-08 19:00:00	IWM	ETF	77.75	77.81	77.75	77.81	1900.0
2007-11-08 07:00:00	DIA	ETF	133.7	134.04	133.7	133.77	15600.0
2007-11-08 08:00:00	DIA	ETF	133.84	133.84	133.58	133.71	56700.0
2007-11-08 09:00:00	DIA	ETF	133.66	133.72	132.53	132.9	7823255.0
2007-11-08 10:00:00	DIA	ETF	132.89	133.25	132.06	133.01	5560829.0
2007-11-08 11:00:00	DIA	ETF	133.01	133.21	132.09	132.4	2292071.0

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

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