PREVIEW / etf_1hour / 2007-11-28

all etf 1-hour files

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

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-28 05:00:00	SPY	ETF	142.62	142.62	142.62	142.62	12500.0
2007-11-28 06:00:00	SPY	ETF	142.84	143.16	142.75	143.07	118900.0
2007-11-28 07:00:00	SPY	ETF	143.11	143.78	143.06	143.57	1662300.0
2007-11-28 08:00:00	SPY	ETF	143.56	144.4	142.5	144.28	11997800.0
2007-11-28 09:00:00	SPY	ETF	144.27	145.26	143.97	145.19	29720461.0
2007-11-28 10:00:00	SPY	ETF	145.19	146.25	144.78	145.92	50731712.0
2007-11-28 11:00:00	SPY	ETF	145.93	146.05	145.61	145.91	20243667.0
2007-11-28 12:00:00	SPY	ETF	145.9122	146.28	145.9	146.07	21758396.0
2007-11-28 13:00:00	SPY	ETF	146.06	146.97	145.95	146.75	26135257.0
2007-11-28 14:00:00	SPY	ETF	146.75	147.2	146.64	146.92	30284447.0
2007-11-28 15:00:00	SPY	ETF	146.92	147.47	146.6	147.25	45072117.0
2007-11-28 16:00:00	SPY	ETF	147.26	147.26	142.09	146.9	16109400.0
2007-11-28 17:00:00	SPY	ETF	146.87	146.95	146.8	146.95	261300.0
2007-11-28 18:00:00	SPY	ETF	146.91	146.95	146.8	146.89	2032000.0
2007-11-28 19:00:00	SPY	ETF	146.99	147.09	146.91	147.09	20600.0
2007-11-28 06:00:00	QQQ	ETF	49.98	50.16	49.98	50.15	60300.0
2007-11-28 07:00:00	QQQ	ETF	50.12	50.47	50.12	50.43	964271.0
2007-11-28 08:00:00	QQQ	ETF	50.43	50.78	50.0	50.77	5299755.0
2007-11-28 09:00:00	QQQ	ETF	50.75	50.87	50.6	50.78	34968112.0
2007-11-28 10:00:00	QQQ	ETF	50.78	51.44	50.6	51.31	38680878.0
2007-11-28 11:00:00	QQQ	ETF	51.31	51.37	51.08	51.2399	19694823.0
2007-11-28 12:00:00	QQQ	ETF	51.24	51.42	51.22	51.28	13686985.0
2007-11-28 13:00:00	QQQ	ETF	51.28	51.59	51.23	51.52	22203882.0
2007-11-28 14:00:00	QQQ	ETF	51.52	51.58	51.32	51.47	28392645.0
2007-11-28 15:00:00	QQQ	ETF	51.47	51.7	51.2999	51.54	41674487.0
2007-11-28 16:00:00	QQQ	ETF	51.53	51.53	51.33	51.35	8499912.0
2007-11-28 17:00:00	QQQ	ETF	51.35	51.35	51.29	51.33	274311.0
2007-11-28 18:00:00	QQQ	ETF	51.32	51.33	51.29	51.3	316300.0
2007-11-28 19:00:00	QQQ	ETF	51.31	51.48	51.3	51.32	2152347.0
2007-11-28 07:00:00	IWM	ETF	74.36	74.71	74.32	74.59	219100.0
2007-11-28 08:00:00	IWM	ETF	74.6	75.03	74.59	74.94	729000.0
2007-11-28 09:00:00	IWM	ETF	74.93	75.69	74.8	75.6	15838495.0
2007-11-28 10:00:00	IWM	ETF	75.6	76.26	75.41	76.21	26080507.0
2007-11-28 11:00:00	IWM	ETF	76.21	76.3	75.84	75.95	9370800.0
2007-11-28 12:00:00	IWM	ETF	75.96	76.31	75.94	76.15	6647400.0
2007-11-28 13:00:00	IWM	ETF	76.15	76.65	76.02	76.55	11907500.0
2007-11-28 14:00:00	IWM	ETF	76.54	76.76	76.16	76.3	11922200.0
2007-11-28 15:00:00	IWM	ETF	76.3	76.89	76.24	76.82	26357900.0
2007-11-28 16:00:00	IWM	ETF	76.81	76.86	74.1	76.8	3438400.0
2007-11-28 17:00:00	IWM	ETF	76.8	76.8	76.71	76.73	157600.0
2007-11-28 18:00:00	IWM	ETF	76.73	76.78	76.73	76.75	30300.0
2007-11-28 19:00:00	IWM	ETF	76.78	76.81	76.78	76.81	3000.0
2007-11-28 07:00:00	DIA	ETF	130.04	130.08	129.98	129.98	18800.0
2007-11-28 08:00:00	DIA	ETF	129.98	130.53	129.55	130.46	867300.0
2007-11-28 09:00:00	DIA	ETF	130.44	131.3	130.29	131.27	2503383.0
2007-11-28 10:00:00	DIA	ETF	131.28	131.99	131.05	131.8	3137430.0
2007-11-28 11:00:00	DIA	ETF	131.78	132.04	131.68	131.97	1033600.0
2007-11-28 12:00:00	DIA	ETF	131.99	132.3	131.98	132.15	920100.0
2007-11-28 13:00:00	DIA	ETF	132.16	132.92	132.03	132.76	1601600.0
2007-11-28 14:00:00	DIA	ETF	132.79	133.06	132.63	132.84	1635300.0

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

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