PREVIEW / etf_1hour / 2012-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-02.parquet
  size:    182 KB
  rows:    5,704

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-05-02 04:00:00	SPY	ETF	140.5	140.63	140.46	140.5	79604.0
2012-05-02 05:00:00	SPY	ETF	140.66	140.67	140.31	140.39	15717.0
2012-05-02 06:00:00	SPY	ETF	140.42	140.46	140.18	140.19	14451.0
2012-05-02 07:00:00	SPY	ETF	140.2	140.31	140.11	140.2	1415388.0
2012-05-02 08:00:00	SPY	ETF	140.21	140.23	139.72	139.79	3999059.0
2012-05-02 09:00:00	SPY	ETF	139.79	140.06	139.75	139.905	16667017.0
2012-05-02 10:00:00	SPY	ETF	139.91	140.1	139.46	139.99	23624077.0
2012-05-02 11:00:00	SPY	ETF	139.99	140.11	139.88	139.966	12978975.0
2012-05-02 12:00:00	SPY	ETF	139.97	140.34	139.9	140.225	12237254.0
2012-05-02 13:00:00	SPY	ETF	140.23	140.32	140.01	140.27	10823826.0
2012-05-02 14:00:00	SPY	ETF	140.26	140.46	140.21	140.26	11227942.0
2012-05-02 15:00:00	SPY	ETF	140.26	140.46	140.05	140.34	16783213.0
2012-05-02 16:00:00	SPY	ETF	140.33	140.6973	139.9426	140.32	5707712.0
2012-05-02 17:00:00	SPY	ETF	140.32	140.32	140.23	140.26	72649.0
2012-05-02 18:00:00	SPY	ETF	140.27	140.35	140.24	140.32	71266.0
2012-05-02 19:00:00	SPY	ETF	140.31	140.36	140.29	140.3	27220.0
2012-05-02 04:00:00	QQQ	ETF	66.76	66.76	66.76	66.76	150.0
2012-05-02 05:00:00	QQQ	ETF	66.8	66.8	66.8	66.8	2000.0
2012-05-02 06:00:00	QQQ	ETF	66.69	66.7	66.63	66.64	16200.0
2012-05-02 07:00:00	QQQ	ETF	66.65	66.67	66.59	66.64	215352.0
2012-05-02 08:00:00	QQQ	ETF	66.62	66.63	66.39	66.42	1385267.0
2012-05-02 09:00:00	QQQ	ETF	66.42	66.77	66.4	66.73	6506672.0
2012-05-02 10:00:00	QQQ	ETF	66.73	66.77	66.38	66.68	6499889.0
2012-05-02 11:00:00	QQQ	ETF	66.68	66.91	66.61	66.8	4873154.0
2012-05-02 12:00:00	QQQ	ETF	66.81	67.02	66.76	66.94	3347015.0
2012-05-02 13:00:00	QQQ	ETF	66.94	67.0	66.8	66.96	1754319.0
2012-05-02 14:00:00	QQQ	ETF	66.96	67.09	66.94	66.95	2452026.0
2012-05-02 15:00:00	QQQ	ETF	66.955	67.11	66.85	67.06	3599086.0
2012-05-02 16:00:00	QQQ	ETF	67.05	67.061	66.8758	67.05	1336388.0
2012-05-02 17:00:00	QQQ	ETF	67.07	67.07	67.01	67.01	7679.0
2012-05-02 18:00:00	QQQ	ETF	67.02	67.05	67.02	67.04	4600.0
2012-05-02 19:00:00	QQQ	ETF	67.04	67.08	67.02	67.04	18450.0
2012-05-02 06:00:00	IWM	ETF	81.1	81.1	80.96	81.0	14400.0
2012-05-02 07:00:00	IWM	ETF	81.04	81.12	80.95	81.1	50999.0
2012-05-02 08:00:00	IWM	ETF	81.1	81.15	80.73	80.79	517692.0
2012-05-02 09:00:00	IWM	ETF	80.81	81.15	80.73	81.06	4492323.0
2012-05-02 10:00:00	IWM	ETF	81.07	81.16	80.57	80.979	8877061.0
2012-05-02 11:00:00	IWM	ETF	80.98	81.21	80.95	81.11	5255273.0
2012-05-02 12:00:00	IWM	ETF	81.12	81.6682	81.03	81.608	6470679.0
2012-05-02 13:00:00	IWM	ETF	81.6	81.77	81.34	81.73	4524162.0
2012-05-02 14:00:00	IWM	ETF	81.73	81.815	81.53	81.57	5110656.0
2012-05-02 15:00:00	IWM	ETF	81.57	81.77	81.42	81.77	7737490.0
2012-05-02 16:00:00	IWM	ETF	81.76	81.77	81.35	81.61	2734967.0
2012-05-02 17:00:00	IWM	ETF	81.62	81.7	81.6	81.6	31160.0
2012-05-02 18:00:00	IWM	ETF	81.6	81.61	81.6	81.6	2180.0
2012-05-02 19:00:00	IWM	ETF	81.6	81.63	81.59	81.59	970.0
2012-05-02 04:00:00	DIA	ETF	132.41	132.41	132.41	132.41	1300.0
2012-05-02 05:00:00	DIA	ETF	132.41	132.52	132.35	132.35	18985.0
2012-05-02 06:00:00	DIA	ETF	132.37	132.37	132.3	132.3	28000.0
2012-05-02 07:00:00	DIA	ETF	132.17	132.26	132.17	132.21	1300.0

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

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