PREVIEW / etf_1hour / 2008-11-25

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-25.parquet
  size:    118 KB
  rows:    3,860

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
2008-11-25 04:00:00	SPY	ETF	84.33	84.77	84.33	84.77	800.0
2008-11-25 05:00:00	SPY	ETF	84.82	85.08	84.33	84.77	5425.0
2008-11-25 06:00:00	SPY	ETF	84.82	86.36	84.82	86.28	73692.0
2008-11-25 07:00:00	SPY	ETF	86.3	86.35	85.05	85.15	1144810.0
2008-11-25 08:00:00	SPY	ETF	85.13	87.75	84.7	87.27	17522698.0
2008-11-25 09:00:00	SPY	ETF	87.27	87.79	85.96	86.55	65310228.0
2008-11-25 10:00:00	SPY	ETF	86.38	87.36	85.02	85.42	75830037.0
2008-11-25 11:00:00	SPY	ETF	85.42	86.22	84.43	85.85	45034917.0
2008-11-25 12:00:00	SPY	ETF	85.85	86.15	84.08	84.48	48094442.0
2008-11-25 13:00:00	SPY	ETF	84.5	85.6	84.19	84.87	42455674.0
2008-11-25 14:00:00	SPY	ETF	84.878	85.9	83.82	85.73	47958938.0
2008-11-25 15:00:00	SPY	ETF	85.7725	86.86	85.2	86.05	98247792.0
2008-11-25 16:00:00	SPY	ETF	86.08	86.17	85.4	85.68	9797463.0
2008-11-25 17:00:00	SPY	ETF	85.66	85.68	85.37	85.4	149900.0
2008-11-25 18:00:00	SPY	ETF	85.36	85.42	85.2	85.41	101882.0
2008-11-25 19:00:00	SPY	ETF	85.43	85.58	85.24	85.36	26712.0
2008-11-25 04:00:00	QQQ	ETF	27.95	27.95	27.95	27.95	100.0
2008-11-25 06:00:00	QQQ	ETF	28.11	28.45	28.09	28.45	18660.0
2008-11-25 07:00:00	QQQ	ETF	28.48	28.48	28.1	28.16	121177.0
2008-11-25 08:00:00	QQQ	ETF	28.15	28.8	27.85	28.68	6628237.0
2008-11-25 09:00:00	QQQ	ETF	28.68	28.78	28.04	28.17	24857433.0
2008-11-25 10:00:00	QQQ	ETF	28.18	28.33	27.72	27.78	39377796.0
2008-11-25 11:00:00	QQQ	ETF	27.78	28.17	27.55	28.0799	27208024.0
2008-11-25 12:00:00	QQQ	ETF	28.08	28.11	27.53	27.65	17679409.0
2008-11-25 13:00:00	QQQ	ETF	27.66	28.0	27.6	27.78	17988448.0
2008-11-25 14:00:00	QQQ	ETF	27.79	28.13	27.52	28.05	24220303.0
2008-11-25 15:00:00	QQQ	ETF	28.06	28.43	27.9	28.13	38914788.0
2008-11-25 16:00:00	QQQ	ETF	28.12	28.19	27.8	28.01	4182177.0
2008-11-25 17:00:00	QQQ	ETF	27.97	28.0	27.92	27.98	99018.0
2008-11-25 18:00:00	QQQ	ETF	27.97	28.0	27.89	27.95	64762.0
2008-11-25 19:00:00	QQQ	ETF	27.95	28.02	27.93	27.98	52896.0
2008-11-25 07:00:00	IWM	ETF	43.71	43.71	43.29	43.29	2100.0
2008-11-25 08:00:00	IWM	ETF	43.36	44.81	43.0	44.58	1720737.0
2008-11-25 09:00:00	IWM	ETF	44.51	44.7	43.45	43.64	8468618.0
2008-11-25 10:00:00	IWM	ETF	43.61	44.15	43.02	43.31	13864288.0
2008-11-25 11:00:00	IWM	ETF	43.32	43.83	42.78	43.61	7901150.0
2008-11-25 12:00:00	IWM	ETF	43.61	43.68	42.87	43.1	6035559.0
2008-11-25 13:00:00	IWM	ETF	43.1	43.64	43.0	43.29	6624178.0
2008-11-25 14:00:00	IWM	ETF	43.29	43.64	42.66	43.52	8303761.0
2008-11-25 15:00:00	IWM	ETF	43.52	44.42	43.18	44.25	17260601.0
2008-11-25 16:00:00	IWM	ETF	44.25	44.29	42.76	43.87	8481105.0
2008-11-25 17:00:00	IWM	ETF	43.76	43.76	43.67	43.72	2069.0
2008-11-25 18:00:00	IWM	ETF	43.72	43.92	43.65	43.88	2200.0
2008-11-25 19:00:00	IWM	ETF	43.65	43.65	43.65	43.65	200.0
2008-11-25 06:00:00	DIA	ETF	84.78	84.78	84.78	84.78	100.0
2008-11-25 07:00:00	DIA	ETF	84.75	84.75	83.8	83.81	11278.0
2008-11-25 08:00:00	DIA	ETF	83.8	85.8	83.5	85.4	346077.0
2008-11-25 09:00:00	DIA	ETF	85.44	85.93	84.94	85.26	5143835.0
2008-11-25 10:00:00	DIA	ETF	85.35	86.07	84.08	84.43	8318496.0
2008-11-25 11:00:00	DIA	ETF	84.43	84.93	83.55	84.65	4479550.0

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

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