PREVIEW / etf_1hour / 2009-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-16.parquet
  size:    135 KB
  rows:    4,137

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
2009-04-16 04:00:00	SPY	ETF	84.56	84.88	84.55	84.88	9400.0
2009-04-16 05:00:00	SPY	ETF	84.83	85.01	84.8	84.81	5600.0
2009-04-16 06:00:00	SPY	ETF	84.77	85.61	84.76	84.9	184068.0
2009-04-16 07:00:00	SPY	ETF	84.88	85.06	84.69	85.06	1099194.0
2009-04-16 08:00:00	SPY	ETF	85.05	85.96	84.53	85.9	9166780.0
2009-04-16 09:00:00	SPY	ETF	85.89	85.97	85.07	85.45	28040213.0
2009-04-16 10:00:00	SPY	ETF	85.43	85.59	84.77	84.9601	46549584.0
2009-04-16 11:00:00	SPY	ETF	84.96	85.61	84.91	85.51	28139933.0
2009-04-16 12:00:00	SPY	ETF	85.51	85.89	85.38	85.73	15295051.0
2009-04-16 13:00:00	SPY	ETF	85.74	85.93	85.37	85.66	23293939.0
2009-04-16 14:00:00	SPY	ETF	85.66	86.78	85.65	86.66	45926889.0
2009-04-16 15:00:00	SPY	ETF	86.67	87.15	86.45	86.56	82047967.0
2009-04-16 16:00:00	SPY	ETF	86.55	87.2	85.0201	86.33	27143495.0
2009-04-16 17:00:00	SPY	ETF	86.32	86.38	85.2965	86.25	4389238.0
2009-04-16 18:00:00	SPY	ETF	86.25	86.4	86.25	86.38	66257.0
2009-04-16 19:00:00	SPY	ETF	86.39	86.41	86.35	86.41	70430.0
2009-04-16 04:00:00	QQQ	ETF	32.22	32.22	32.22	32.22	690.0
2009-04-16 06:00:00	QQQ	ETF	32.48	32.56	32.34	32.34	53300.0
2009-04-16 07:00:00	QQQ	ETF	32.38	32.5	32.31	32.49	982226.0
2009-04-16 08:00:00	QQQ	ETF	32.49	32.94	32.37	32.89	10797059.0
2009-04-16 09:00:00	QQQ	ETF	32.89	32.92	32.63	32.8099	18026492.0
2009-04-16 10:00:00	QQQ	ETF	32.8	32.87	32.51	32.58	25266274.0
2009-04-16 11:00:00	QQQ	ETF	32.58	32.82	32.5799	32.78	10423167.0
2009-04-16 12:00:00	QQQ	ETF	32.78	32.97	32.76	32.912	9411198.0
2009-04-16 13:00:00	QQQ	ETF	32.91	32.97	32.8	32.918	12150636.0
2009-04-16 14:00:00	QQQ	ETF	32.92	33.36	32.91	33.28	23774072.0
2009-04-16 15:00:00	QQQ	ETF	33.28	33.43	33.21	33.23	33775169.0
2009-04-16 16:00:00	QQQ	ETF	33.22	33.34	32.94	33.05	14669082.0
2009-04-16 17:00:00	QQQ	ETF	33.05	33.09	32.94	33.09	1762861.0
2009-04-16 18:00:00	QQQ	ETF	33.06	33.12	33.05	33.09	110941.0
2009-04-16 19:00:00	QQQ	ETF	33.09	33.12	33.09	33.1	16338.0
2009-04-16 06:00:00	IWM	ETF	46.05	46.05	45.7	45.7	400.0
2009-04-16 07:00:00	IWM	ETF	45.74	45.89	45.74	45.84	82598.0
2009-04-16 08:00:00	IWM	ETF	45.83	46.66	45.79	46.55	1062304.0
2009-04-16 09:00:00	IWM	ETF	46.58	46.7	45.88	46.22	6863399.0
2009-04-16 10:00:00	IWM	ETF	46.21	46.6	45.76	45.91	5483564.0
2009-04-16 11:00:00	IWM	ETF	45.9	46.32	45.87	46.21	3834762.0
2009-04-16 12:00:00	IWM	ETF	46.21	46.63	46.15	46.53	2577268.0
2009-04-16 13:00:00	IWM	ETF	46.53	46.61	46.25	46.48	3902924.0
2009-04-16 14:00:00	IWM	ETF	46.48	47.42	46.35	47.24	8546405.0
2009-04-16 15:00:00	IWM	ETF	47.25	47.69	47.0	47.28	14722607.0
2009-04-16 16:00:00	IWM	ETF	47.3	47.35	46.0	47.12	5657680.0
2009-04-16 17:00:00	IWM	ETF	47.09	47.17	46.1014	47.04	4032184.0
2009-04-16 18:00:00	IWM	ETF	47.14	47.14	46.96	46.96	600.0
2009-04-16 19:00:00	IWM	ETF	47.06	47.06	47.06	47.06	100.0
2009-04-16 05:00:00	DIA	ETF	79.96	79.96	79.96	79.96	300.0
2009-04-16 06:00:00	DIA	ETF	80.44	80.6	80.44	80.6	3600.0
2009-04-16 07:00:00	DIA	ETF	79.99	80.12	79.99	80.03	15445.0
2009-04-16 08:00:00	DIA	ETF	80.19	81.26	80.06	80.83	155465.0
2009-04-16 09:00:00	DIA	ETF	80.82	80.93	80.21	80.52	2027940.0

> showing 50 of 4,137 rows — these rows as CSV

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