PREVIEW / etf_1hour / 2013-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-25.parquet
  size:    208 KB
  rows:    6,520

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
2013-06-25 04:00:00	SPY	ETF	157.55	158.02	157.38	157.92	49725.0
2013-06-25 05:00:00	SPY	ETF	157.93	158.14	157.7	157.98	52010.0
2013-06-25 06:00:00	SPY	ETF	157.99	157.99	157.52	157.67	118171.0
2013-06-25 07:00:00	SPY	ETF	157.64	158.24	157.61	158.2	684623.0
2013-06-25 08:00:00	SPY	ETF	157.98	158.25	156.99	157.95	2862338.0
2013-06-25 09:00:00	SPY	ETF	157.93	158.64	157.72	157.99	23658929.0
2013-06-25 10:00:00	SPY	ETF	157.99	158.5	157.42	158.38	31724546.0
2013-06-25 11:00:00	SPY	ETF	158.385	158.63	158.001	158.41	15032024.0
2013-06-25 12:00:00	SPY	ETF	158.41	158.715	158.3	158.43	11228637.0
2013-06-25 13:00:00	SPY	ETF	158.44	158.56	158.04	158.29	13230113.0
2013-06-25 14:00:00	SPY	ETF	158.28	158.8	158.16	158.48	13592054.0
2013-06-25 15:00:00	SPY	ETF	158.48	160.1	158.47	158.59	35088504.0
2013-06-25 16:00:00	SPY	ETF	158.6	158.9	157.0689	158.51	9171692.0
2013-06-25 17:00:00	SPY	ETF	158.51	158.7294	158.44	158.46	221208.0
2013-06-25 18:00:00	SPY	ETF	158.46	158.51	158.35	158.45	99800.0
2013-06-25 19:00:00	SPY	ETF	158.45	158.46	158.08	158.1	176116.0
2013-06-25 04:00:00	QQQ	ETF	69.97	70.22	69.94	70.22	23640.0
2013-06-25 05:00:00	QQQ	ETF	70.2	70.29	70.12	70.21	16600.0
2013-06-25 06:00:00	QQQ	ETF	70.18	70.21	70.05	70.09	17100.0
2013-06-25 07:00:00	QQQ	ETF	70.1	70.35	70.09	70.33	78585.0
2013-06-25 08:00:00	QQQ	ETF	70.17	70.35	70.17	70.21	267559.0
2013-06-25 09:00:00	QQQ	ETF	70.2	70.52	70.0555	70.1712	4895827.0
2013-06-25 10:00:00	QQQ	ETF	70.17	70.2415	69.81	70.07	6808912.0
2013-06-25 11:00:00	QQQ	ETF	70.07	70.17	69.92	70.15	2537191.0
2013-06-25 12:00:00	QQQ	ETF	70.14	70.26	70.08	70.12	1552028.0
2013-06-25 13:00:00	QQQ	ETF	70.12	70.158	69.95	70.02	1842382.0
2013-06-25 14:00:00	QQQ	ETF	70.01	70.18	69.97	70.085	1849667.0
2013-06-25 15:00:00	QQQ	ETF	70.08	70.43	70.08	70.2	6078637.0
2013-06-25 16:00:00	QQQ	ETF	70.19	70.3	70.129	70.17	2117990.0
2013-06-25 17:00:00	QQQ	ETF	70.17	70.2	70.17	70.19	18000.0
2013-06-25 18:00:00	QQQ	ETF	70.16	70.18	70.12	70.16	3686.0
2013-06-25 19:00:00	QQQ	ETF	70.13	70.15	70.03	70.03	17159.0
2013-06-25 06:00:00	IWM	ETF	95.01	95.21	95.01	95.19	8941.0
2013-06-25 07:00:00	IWM	ETF	95.18	95.51	95.16	95.47	195389.0
2013-06-25 08:00:00	IWM	ETF	95.46	95.56	95.26	95.32	483227.0
2013-06-25 09:00:00	IWM	ETF	95.25	95.75	95.02	95.26	5268247.0
2013-06-25 10:00:00	IWM	ETF	95.24	95.54	94.8701	95.47	6809366.0
2013-06-25 11:00:00	IWM	ETF	95.465	95.53	95.11	95.33	2809905.0
2013-06-25 12:00:00	IWM	ETF	95.325	95.53	95.235	95.37	2166469.0
2013-06-25 13:00:00	IWM	ETF	95.37	95.44	95.12	95.27	1689337.0
2013-06-25 14:00:00	IWM	ETF	95.26	95.56	95.2	95.47	3052281.0
2013-06-25 15:00:00	IWM	ETF	95.48	95.84	95.46	95.63	7486576.0
2013-06-25 16:00:00	IWM	ETF	95.63	95.74	95.62	95.68	1293720.0
2013-06-25 19:00:00	IWM	ETF	95.55	95.55	95.48	95.48	2200.0
2013-06-25 04:00:00	DIA	ETF	146.85	146.85	146.85	146.85	100.0
2013-06-25 06:00:00	DIA	ETF	146.86	146.86	146.85	146.85	1084.0
2013-06-25 07:00:00	DIA	ETF	146.9	147.18	146.9	147.14	11800.0
2013-06-25 08:00:00	DIA	ETF	147.0	147.2	147.0	147.09	11150.0
2013-06-25 09:00:00	DIA	ETF	147.01	147.53	146.81	147.06	1130576.0
2013-06-25 10:00:00	DIA	ETF	147.01	147.46	146.62	147.38	1822928.0

> showing 50 of 6,520 rows — these rows as CSV

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