PREVIEW / etf_1hour / 2012-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-07.parquet
  size:    187 KB
  rows:    5,821

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-06-07 04:00:00	SPY	ETF	132.3	132.46	132.24	132.39	1800.0
2012-06-07 05:00:00	SPY	ETF	132.49	132.64	132.44	132.51	17297.0
2012-06-07 06:00:00	SPY	ETF	132.44	132.6	132.2	132.58	226895.0
2012-06-07 07:00:00	SPY	ETF	132.61	133.51	132.56	133.2	2290546.0
2012-06-07 08:00:00	SPY	ETF	133.18	133.3	132.48	132.97	2852892.0
2012-06-07 09:00:00	SPY	ETF	133.01	133.53	132.97	133.3	29781541.0
2012-06-07 10:00:00	SPY	ETF	133.29	133.39	132.26	132.49	42080044.0
2012-06-07 11:00:00	SPY	ETF	132.49	132.84	132.28	132.66	20637194.0
2012-06-07 12:00:00	SPY	ETF	132.655	132.96	132.46	132.6909	19969494.0
2012-06-07 13:00:00	SPY	ETF	132.7	133.09	132.64	132.77	14423944.0
2012-06-07 14:00:00	SPY	ETF	132.76	132.92	132.64	132.84	9607962.0
2012-06-07 15:00:00	SPY	ETF	132.84	132.84	131.78	132.02	29096068.0
2012-06-07 16:00:00	SPY	ETF	132.02	132.7413	131.9603	132.25	11179043.0
2012-06-07 17:00:00	SPY	ETF	132.25	132.35	132.17	132.21	236651.0
2012-06-07 18:00:00	SPY	ETF	132.21	132.32	132.18	132.29	61212.0
2012-06-07 19:00:00	SPY	ETF	132.29	132.35	132.22	132.23	114086.0
2012-06-07 04:00:00	QQQ	ETF	62.74	62.74	62.67	62.7	3000.0
2012-06-07 05:00:00	QQQ	ETF	62.79	62.79	62.79	62.79	100.0
2012-06-07 06:00:00	QQQ	ETF	62.77	62.84	62.71	62.84	9140.0
2012-06-07 07:00:00	QQQ	ETF	62.85	63.12	62.85	63.1	57473.0
2012-06-07 08:00:00	QQQ	ETF	63.1	63.13	62.78	62.97	504530.0
2012-06-07 09:00:00	QQQ	ETF	62.98	63.18	62.93	63.01	6108172.0
2012-06-07 10:00:00	QQQ	ETF	63.005	63.04	62.479	62.59	9671115.0
2012-06-07 11:00:00	QQQ	ETF	62.5995	62.81	62.54	62.7	3782470.0
2012-06-07 12:00:00	QQQ	ETF	62.69	62.84	62.58	62.72	3984440.0
2012-06-07 13:00:00	QQQ	ETF	62.72	62.9	62.64	62.66	2684525.0
2012-06-07 14:00:00	QQQ	ETF	62.6505	62.75	62.6	62.72	1751935.0
2012-06-07 15:00:00	QQQ	ETF	62.72	62.7295	62.22	62.28	6506189.0
2012-06-07 16:00:00	QQQ	ETF	62.285	62.6019	62.25	62.37	1003337.0
2012-06-07 17:00:00	QQQ	ETF	62.38	62.42	62.36	62.36	31750.0
2012-06-07 18:00:00	QQQ	ETF	62.36	62.41	62.36	62.4	9191.0
2012-06-07 19:00:00	QQQ	ETF	62.41	62.42	62.37	62.37	4000.0
2012-06-07 06:00:00	IWM	ETF	76.97	76.99	76.79	76.99	4500.0
2012-06-07 07:00:00	IWM	ETF	77.05	77.47	77.05	77.33	204382.0
2012-06-07 08:00:00	IWM	ETF	77.31	77.38	77.16	77.23	217208.0
2012-06-07 09:00:00	IWM	ETF	77.24	77.72	77.2	77.33	6616374.0
2012-06-07 10:00:00	IWM	ETF	77.33	77.39	76.34	76.49	12035727.0
2012-06-07 11:00:00	IWM	ETF	76.49	76.89	76.37	76.7	4180373.0
2012-06-07 12:00:00	IWM	ETF	76.7	76.98	76.51	76.68	4740347.0
2012-06-07 13:00:00	IWM	ETF	76.7	77.12	76.64	76.7	4292010.0
2012-06-07 14:00:00	IWM	ETF	76.69	76.825	76.55	76.71	2864418.0
2012-06-07 15:00:00	IWM	ETF	76.705	76.7177	75.96	75.97	8026411.0
2012-06-07 16:00:00	IWM	ETF	75.96	77.7	75.94	76.2	1660125.0
2012-06-07 17:00:00	IWM	ETF	76.23	76.28	76.05	76.05	62996.0
2012-06-07 18:00:00	IWM	ETF	76.1	76.28	76.1	76.25	89171.0
2012-06-07 19:00:00	IWM	ETF	76.25	76.25	76.22	76.22	3400.0
2012-06-07 06:00:00	DIA	ETF	124.17	124.17	124.17	124.17	100.0
2012-06-07 07:00:00	DIA	ETF	124.5	124.98	124.5	124.98	1782.0
2012-06-07 08:00:00	DIA	ETF	124.72	124.98	124.71	124.73	26890.0
2012-06-07 09:00:00	DIA	ETF	124.7	125.43	124.67	125.29	1363242.0

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

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