PREVIEW / etf_1hour / 2007-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-20.parquet
  size:    96 KB
  rows:    3,157

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-20 04:00:00	SPY	ETF	144.34	144.66	144.34	144.66	5000.0
2007-11-20 05:00:00	SPY	ETF	144.59	144.79	144.58	144.72	10000.0
2007-11-20 06:00:00	SPY	ETF	144.61	145.0	144.6	144.87	66300.0
2007-11-20 07:00:00	SPY	ETF	144.86	144.87	144.12	144.37	2218500.0
2007-11-20 08:00:00	SPY	ETF	144.35	144.86	143.74	143.95	8846300.0
2007-11-20 09:00:00	SPY	ETF	143.97	144.96	143.6	144.81	48017845.0
2007-11-20 10:00:00	SPY	ETF	144.8	145.51	144.64	145.29	57737497.0
2007-11-20 11:00:00	SPY	ETF	145.29	145.53	144.68	144.71	24596882.0
2007-11-20 12:00:00	SPY	ETF	144.72	144.73	143.52	143.84	39337934.0
2007-11-20 13:00:00	SPY	ETF	143.85	144.13	142.62	143.39	43092649.0
2007-11-20 14:00:00	SPY	ETF	143.39	145.46	142.11	142.65	89098365.0
2007-11-20 15:00:00	SPY	ETF	142.65	144.86	142.31	144.2	86793504.0
2007-11-20 16:00:00	SPY	ETF	144.25	144.86	143.01	144.45	9804300.0
2007-11-20 17:00:00	SPY	ETF	144.46	144.47	144.4	144.46	258700.0
2007-11-20 18:00:00	SPY	ETF	144.46	144.47	144.17	144.4	485700.0
2007-11-20 19:00:00	SPY	ETF	144.34	144.34	144.01	144.09	30500.0
2007-11-20 04:00:00	QQQ	ETF	49.97	50.04	49.97	50.04	10000.0
2007-11-20 06:00:00	QQQ	ETF	50.05	50.18	50.01	50.18	19800.0
2007-11-20 07:00:00	QQQ	ETF	50.16	50.31	50.11	50.16	1312474.0
2007-11-20 08:00:00	QQQ	ETF	50.15	50.22	49.97	50.04	5726325.0
2007-11-20 09:00:00	QQQ	ETF	50.04	50.43	49.92	50.35	18473167.0
2007-11-20 10:00:00	QQQ	ETF	50.36	50.75	50.25	50.69	37376819.0
2007-11-20 11:00:00	QQQ	ETF	50.69	50.78	50.41	50.44	28010814.0
2007-11-20 12:00:00	QQQ	ETF	50.44	50.45	49.84	49.95	36111254.0
2007-11-20 13:00:00	QQQ	ETF	49.94	50.06	49.4	49.81	38936044.0
2007-11-20 14:00:00	QQQ	ETF	49.82	50.04	49.0	49.2	60662068.0
2007-11-20 15:00:00	QQQ	ETF	49.19	50.12	48.93	49.93	66946975.0
2007-11-20 16:00:00	QQQ	ETF	49.94	50.7273	49.17	49.95	8241697.0
2007-11-20 17:00:00	QQQ	ETF	49.95	49.95	49.88	49.9	118657.0
2007-11-20 18:00:00	QQQ	ETF	49.93	49.96	49.86	49.92	28654.0
2007-11-20 19:00:00	QQQ	ETF	49.9	49.9	49.8	49.81	46834.0
2007-11-20 05:00:00	IWM	ETF	75.3	75.3	75.3	75.3	3000.0
2007-11-20 06:00:00	IWM	ETF	75.18	75.18	75.18	75.18	2000.0
2007-11-20 07:00:00	IWM	ETF	75.38	75.38	75.01	75.08	142900.0
2007-11-20 08:00:00	IWM	ETF	75.07	75.43	74.74	74.79	1269500.0
2007-11-20 09:00:00	IWM	ETF	74.84	75.46	74.63	75.34	14310697.0
2007-11-20 10:00:00	IWM	ETF	75.33	75.5	75.02	75.36	11316251.0
2007-11-20 11:00:00	IWM	ETF	75.37	75.56	75.22	75.24	12285982.0
2007-11-20 12:00:00	IWM	ETF	75.24	75.24	74.09	74.26	18965546.0
2007-11-20 13:00:00	IWM	ETF	74.26	74.26	73.35	73.97	18556665.0
2007-11-20 14:00:00	IWM	ETF	73.96	74.44	73.35	73.6	23555544.0
2007-11-20 15:00:00	IWM	ETF	73.61	74.8	73.35	74.58	24078265.0
2007-11-20 16:00:00	IWM	ETF	74.58	75.09	74.38	75.0	5292429.0
2007-11-20 17:00:00	IWM	ETF	75.04	75.08	74.97	75.08	12800.0
2007-11-20 18:00:00	IWM	ETF	75.06	75.06	74.86	74.86	22100.0
2007-11-20 19:00:00	IWM	ETF	74.94	74.94	74.9	74.9	9000.0
2007-11-20 06:00:00	DIA	ETF	130.21	130.21	130.21	130.21	100.0
2007-11-20 07:00:00	DIA	ETF	130.66	130.66	130.2	130.2	8200.0
2007-11-20 08:00:00	DIA	ETF	130.24	130.34	129.84	129.95	125600.0
2007-11-20 09:00:00	DIA	ETF	130.0	130.54	129.79	130.43	2315495.0

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

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