PREVIEW / etf_1hour / 2009-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-05.parquet
  size:    126 KB
  rows:    3,863

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-02-05 04:00:00	SPY	ETF	83.11	83.26	83.11	83.14	2900.0
2009-02-05 06:00:00	SPY	ETF	83.21	83.4	83.17	83.27	152000.0
2009-02-05 07:00:00	SPY	ETF	83.27	83.35	82.69	82.89	560844.0
2009-02-05 08:00:00	SPY	ETF	82.87	83.47	82.5	82.71	4774410.0
2009-02-05 09:00:00	SPY	ETF	82.72	82.97	82.13	82.19	28567211.0
2009-02-05 10:00:00	SPY	ETF	82.19	84.08	82.12	83.79	55836117.0
2009-02-05 11:00:00	SPY	ETF	83.79	84.41	83.69	84.39	50680747.0
2009-02-05 12:00:00	SPY	ETF	84.39	85.18	84.35	84.77	57326594.0
2009-02-05 13:00:00	SPY	ETF	84.78	85.06	84.3	84.46	45172054.0
2009-02-05 14:00:00	SPY	ETF	84.45	85.29	84.38	84.49	55539697.0
2009-02-05 15:00:00	SPY	ETF	84.49	84.99	84.11	84.66	71738081.0
2009-02-05 16:00:00	SPY	ETF	84.61	84.72	81.7	84.57	22970109.0
2009-02-05 17:00:00	SPY	ETF	84.57	84.59	84.37	84.5	9177210.0
2009-02-05 18:00:00	SPY	ETF	84.5	84.52	84.38	84.51	83105.0
2009-02-05 19:00:00	SPY	ETF	84.53	84.71	84.4	84.49	101928.0
2009-02-05 05:00:00	QQQ	ETF	29.5	29.51	29.5	29.51	811.0
2009-02-05 06:00:00	QQQ	ETF	29.5	29.56	29.49	29.52	3800.0
2009-02-05 07:00:00	QQQ	ETF	29.53	29.55	29.37	29.49	331164.0
2009-02-05 08:00:00	QQQ	ETF	29.49	29.59	29.36	29.46	1429677.0
2009-02-05 09:00:00	QQQ	ETF	29.46	29.77	29.41	29.59	22527411.0
2009-02-05 10:00:00	QQQ	ETF	29.59	30.42	29.56	30.282	36474737.0
2009-02-05 11:00:00	QQQ	ETF	30.29	30.48	30.19	30.47	31703135.0
2009-02-05 12:00:00	QQQ	ETF	30.4717	30.75	30.36	30.51	34689295.0
2009-02-05 13:00:00	QQQ	ETF	30.52	30.59	30.4	30.4405	16397722.0
2009-02-05 14:00:00	QQQ	ETF	30.449	30.77	30.44	30.5001	26053472.0
2009-02-05 15:00:00	QQQ	ETF	30.51	30.6304	30.3118	30.58	33407206.0
2009-02-05 16:00:00	QQQ	ETF	30.58	30.7	30.36	30.41	9894117.0
2009-02-05 17:00:00	QQQ	ETF	30.42	30.45	30.3	30.35	2091191.0
2009-02-05 18:00:00	QQQ	ETF	30.34	30.44	30.34	30.44	107029.0
2009-02-05 19:00:00	QQQ	ETF	30.44	30.46	30.4	30.41	49858.0
2009-02-05 06:00:00	IWM	ETF	44.86	44.86	44.78	44.78	928.0
2009-02-05 07:00:00	IWM	ETF	44.77	44.8	44.45	44.61	15481.0
2009-02-05 08:00:00	IWM	ETF	44.65	44.79	44.38	44.46	250605.0
2009-02-05 09:00:00	IWM	ETF	44.45	44.78	44.2	44.24	4553817.0
2009-02-05 10:00:00	IWM	ETF	44.24	45.31	44.21	45.16	9739242.0
2009-02-05 11:00:00	IWM	ETF	45.16	45.52	45.07	45.46	8601272.0
2009-02-05 12:00:00	IWM	ETF	45.47	45.96	45.47	45.75	10323667.0
2009-02-05 13:00:00	IWM	ETF	45.76	45.84	45.34	45.42	5484876.0
2009-02-05 14:00:00	IWM	ETF	45.41	46.01	45.35	45.41	8550411.0
2009-02-05 15:00:00	IWM	ETF	45.41	45.74	45.13	45.32	13754190.0
2009-02-05 16:00:00	IWM	ETF	45.33	45.36	44.8031	45.18	5341121.0
2009-02-05 17:00:00	IWM	ETF	45.25	45.25	45.12	45.2	7368.0
2009-02-05 18:00:00	IWM	ETF	45.25	45.25	45.25	45.25	1900.0
2009-02-05 19:00:00	IWM	ETF	45.32	45.32	45.32	45.32	1440.0
2009-02-05 06:00:00	DIA	ETF	79.81	79.85	79.81	79.85	200.0
2009-02-05 07:00:00	DIA	ETF	79.74	79.74	79.29	79.35	2598.0
2009-02-05 08:00:00	DIA	ETF	79.45	79.71	79.09	79.22	98439.0
2009-02-05 09:00:00	DIA	ETF	79.23	79.39	78.55	78.6	3697028.0
2009-02-05 10:00:00	DIA	ETF	78.57	79.95	78.5	79.75	5828340.0
2009-02-05 11:00:00	DIA	ETF	79.7416	80.31	79.68	80.3	5368150.0

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

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