PREVIEW / etf_1hour / 2012-03-13

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-13.parquet
  size:    190 KB
  rows:    5,844

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
2012-03-13 04:00:00	SPY	ETF	138.03	138.35	138.03	138.26	13136.0
2012-03-13 05:00:00	SPY	ETF	138.3	138.55	138.3	138.55	20777.0
2012-03-13 06:00:00	SPY	ETF	138.58	138.6	138.49	138.54	61200.0
2012-03-13 07:00:00	SPY	ETF	138.55	138.58	138.42	138.45	212868.0
2012-03-13 08:00:00	SPY	ETF	138.42	138.6385	138.23	138.27	1275375.0
2012-03-13 09:00:00	SPY	ETF	138.28	138.39	138.12	138.17	14805640.0
2012-03-13 10:00:00	SPY	ETF	138.17	138.53	138.09	138.49	19910890.0
2012-03-13 11:00:00	SPY	ETF	138.48	138.85	138.48	138.76	22330816.0
2012-03-13 12:00:00	SPY	ETF	138.76	138.91	138.72	138.9	12315107.0
2012-03-13 13:00:00	SPY	ETF	138.9	138.98	138.78	138.8	7690506.0
2012-03-13 14:00:00	SPY	ETF	138.81	139.04	138.6	138.77	20117355.0
2012-03-13 15:00:00	SPY	ETF	138.77	140.13	138.765	140.06	62326035.0
2012-03-13 16:00:00	SPY	ETF	140.07	140.35	138.64	140.26	16708392.0
2012-03-13 17:00:00	SPY	ETF	140.24	140.29	138.66	140.05	1375403.0
2012-03-13 18:00:00	SPY	ETF	140.06	140.2	140.01	140.16	936525.0
2012-03-13 19:00:00	SPY	ETF	140.17	140.17	140.04	140.04	148378.0
2012-03-13 04:00:00	QQQ	ETF	65.26	65.26	65.26	65.26	500.0
2012-03-13 05:00:00	QQQ	ETF	65.43	65.48	65.43	65.48	200.0
2012-03-13 06:00:00	QQQ	ETF	65.5	65.51	65.5	65.51	2100.0
2012-03-13 07:00:00	QQQ	ETF	65.48	65.52	65.44	65.45	52485.0
2012-03-13 08:00:00	QQQ	ETF	65.43	65.46	65.36	65.37	149284.0
2012-03-13 09:00:00	QQQ	ETF	65.38	65.5	65.31	65.41	7477291.0
2012-03-13 10:00:00	QQQ	ETF	65.4	65.56	65.27	65.54	8405534.0
2012-03-13 11:00:00	QQQ	ETF	65.532	65.77	65.51	65.7	6196823.0
2012-03-13 12:00:00	QQQ	ETF	65.7	65.81	65.675	65.79	5930285.0
2012-03-13 13:00:00	QQQ	ETF	65.8	65.83	65.77	65.79	2979544.0
2012-03-13 14:00:00	QQQ	ETF	65.79	65.87	65.68	65.7816	5950595.0
2012-03-13 15:00:00	QQQ	ETF	65.79	66.26	65.77	66.26	13400298.0
2012-03-13 16:00:00	QQQ	ETF	66.25	66.35	66.08	66.3	3423714.0
2012-03-13 17:00:00	QQQ	ETF	66.31	66.31	66.19	66.19	40796.0
2012-03-13 18:00:00	QQQ	ETF	66.2	66.25	66.19	66.25	36281.0
2012-03-13 19:00:00	QQQ	ETF	66.2	66.23	66.2	66.22	22880.0
2012-03-13 05:00:00	IWM	ETF	81.99	82.21	81.99	82.21	1100.0
2012-03-13 06:00:00	IWM	ETF	82.21	82.21	82.21	82.21	900.0
2012-03-13 07:00:00	IWM	ETF	82.0	82.26	82.0	82.17	24500.0
2012-03-13 08:00:00	IWM	ETF	82.14	82.2	82.01	82.02	182686.0
2012-03-13 09:00:00	IWM	ETF	82.03	82.1	81.8	81.9	5074321.0
2012-03-13 10:00:00	IWM	ETF	81.9	82.07	81.71	81.95	6951041.0
2012-03-13 11:00:00	IWM	ETF	81.955	82.3025	81.925	82.05	8140256.0
2012-03-13 12:00:00	IWM	ETF	82.05	82.255	82.05	82.23	3781596.0
2012-03-13 13:00:00	IWM	ETF	82.23	82.41	82.16	82.19	2674461.0
2012-03-13 14:00:00	IWM	ETF	82.195	82.37	82.025	82.2	7453407.0
2012-03-13 15:00:00	IWM	ETF	82.195	83.09	82.17	83.055	17204578.0
2012-03-13 16:00:00	IWM	ETF	83.09	83.23	81.4045	83.16	3743359.0
2012-03-13 17:00:00	IWM	ETF	83.16	83.16	83.02	83.03	24900.0
2012-03-13 18:00:00	IWM	ETF	83.01	83.03	82.97	83.02	7200.0
2012-03-13 19:00:00	IWM	ETF	83.05	83.1	83.02	83.05	12554.0
2012-03-13 05:00:00	DIA	ETF	130.28	130.28	130.28	130.28	200.0
2012-03-13 06:00:00	DIA	ETF	130.25	130.25	130.25	130.25	300.0
2012-03-13 07:00:00	DIA	ETF	130.3	130.33	130.29	130.29	480.0

> showing 50 of 5,844 rows — these rows as CSV

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