PREVIEW / etf_1hour / 2012-05-31

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-31.parquet
  size:    187 KB
  rows:    5,789

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-31 04:00:00	SPY	ETF	131.76	132.17	131.76	132.07	45367.0
2012-05-31 05:00:00	SPY	ETF	132.15	132.17	132.03	132.1	20034.0
2012-05-31 06:00:00	SPY	ETF	132.02	132.07	131.83	131.99	92198.0
2012-05-31 07:00:00	SPY	ETF	131.96	132.05	131.86	132.0	337161.0
2012-05-31 08:00:00	SPY	ETF	132.0	132.03	131.15	131.78	1903212.0
2012-05-31 09:00:00	SPY	ETF	131.78	131.87	130.795	130.97	25714310.0
2012-05-31 10:00:00	SPY	ETF	130.97	131.07	130.48	130.62	28677631.0
2012-05-31 11:00:00	SPY	ETF	130.62	131.12	130.34	130.84	26025875.0
2012-05-31 12:00:00	SPY	ETF	130.84	131.73	130.77	131.47	24044521.0
2012-05-31 13:00:00	SPY	ETF	131.47	131.94	131.2	131.31	22509638.0
2012-05-31 14:00:00	SPY	ETF	131.31	131.74	131.25	131.63	13636142.0
2012-05-31 15:00:00	SPY	ETF	131.63	132.45	131.465	131.53	37286641.0
2012-05-31 16:00:00	SPY	ETF	131.53	131.8163	131.12	131.26	13465400.0
2012-05-31 17:00:00	SPY	ETF	131.25	131.25	131.15	131.19	621454.0
2012-05-31 18:00:00	SPY	ETF	131.21	131.3	131.18	131.24	208695.0
2012-05-31 19:00:00	SPY	ETF	131.24	131.32	131.21	131.32	150726.0
2012-05-31 04:00:00	QQQ	ETF	62.37	62.41	62.37	62.41	2900.0
2012-05-31 05:00:00	QQQ	ETF	62.42	62.43	62.42	62.43	1270.0
2012-05-31 06:00:00	QQQ	ETF	62.41	62.41	62.31	62.34	1622.0
2012-05-31 07:00:00	QQQ	ETF	62.39	62.42	62.34	62.35	9310.0
2012-05-31 08:00:00	QQQ	ETF	62.4	62.45	62.12	62.32	267171.0
2012-05-31 09:00:00	QQQ	ETF	62.28	62.33	61.785	61.85	8911237.0
2012-05-31 10:00:00	QQQ	ETF	61.85	61.93	61.59	61.71	9647320.0
2012-05-31 11:00:00	QQQ	ETF	61.71	61.98	61.59	61.82	7000987.0
2012-05-31 12:00:00	QQQ	ETF	61.8201	62.23	61.78	62.0892	6808539.0
2012-05-31 13:00:00	QQQ	ETF	62.08	62.33	61.86	61.9101	5407740.0
2012-05-31 14:00:00	QQQ	ETF	61.91	62.13	61.89	62.07	4185569.0
2012-05-31 15:00:00	QQQ	ETF	62.07	62.41	61.96	62.05	9488557.0
2012-05-31 16:00:00	QQQ	ETF	62.04	62.27	61.82	61.93	1606647.0
2012-05-31 17:00:00	QQQ	ETF	61.91	61.97	61.88	61.91	18609.0
2012-05-31 18:00:00	QQQ	ETF	61.9	61.94	61.88	61.92	12609.0
2012-05-31 19:00:00	QQQ	ETF	61.94	61.96	61.93	61.96	11350.0
2012-05-31 07:00:00	IWM	ETF	76.43	76.52	76.4	76.4	40224.0
2012-05-31 08:00:00	IWM	ETF	76.46	76.48	76.06	76.28	182629.0
2012-05-31 09:00:00	IWM	ETF	76.28	76.33	75.38	75.44	7132918.0
2012-05-31 10:00:00	IWM	ETF	75.44	75.5101	75.07	75.28	8806360.0
2012-05-31 11:00:00	IWM	ETF	75.29	75.6	75.08	75.41	6059283.0
2012-05-31 12:00:00	IWM	ETF	75.41	75.96	75.33	75.8	7675774.0
2012-05-31 13:00:00	IWM	ETF	75.8	76.1201	75.55	75.62	5279017.0
2012-05-31 14:00:00	IWM	ETF	75.62	76.01	75.57	75.93	3568510.0
2012-05-31 15:00:00	IWM	ETF	75.93	76.59	75.76	76.14	12697110.0
2012-05-31 16:00:00	IWM	ETF	76.14	76.499	75.81	75.86	1718717.0
2012-05-31 17:00:00	IWM	ETF	75.88	75.88	75.8	75.8	21250.0
2012-05-31 18:00:00	IWM	ETF	75.97	75.97	75.86	75.9	19400.0
2012-05-31 19:00:00	IWM	ETF	75.87	75.87	75.8	75.8	1600.0
2012-05-31 08:00:00	DIA	ETF	124.05	124.06	123.86	124.06	10399.0
2012-05-31 09:00:00	DIA	ETF	124.04	124.19	123.42	123.59	796709.0
2012-05-31 10:00:00	DIA	ETF	123.58	123.67	123.09	123.2	970289.0
2012-05-31 11:00:00	DIA	ETF	123.19	123.6901	123.011	123.49	960846.0
2012-05-31 12:00:00	DIA	ETF	123.48	124.27	123.42	124.03	968348.0

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

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