PREVIEW / etf_1hour / 2013-04-24

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-24.parquet
  size:    198 KB
  rows:    6,179

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-04-24 04:00:00	SPY	ETF	158.26	158.32	158.14	158.14	24770.0
2013-04-24 05:00:00	SPY	ETF	158.13	158.26	158.1	158.26	12300.0
2013-04-24 06:00:00	SPY	ETF	158.26	158.29	157.98	158.02	52199.0
2013-04-24 07:00:00	SPY	ETF	158.04	158.18	158.0	158.0	260166.0
2013-04-24 08:00:00	SPY	ETF	158.0	158.11	157.68	157.73	2285127.0
2013-04-24 09:00:00	SPY	ETF	157.73	158.15	157.71	157.961	14398798.0
2013-04-24 10:00:00	SPY	ETF	157.97	158.13	157.54	157.99	18851529.0
2013-04-24 11:00:00	SPY	ETF	157.991	158.08	157.691	157.939	7992291.0
2013-04-24 12:00:00	SPY	ETF	157.94	158.02	157.66	157.8	6262848.0
2013-04-24 13:00:00	SPY	ETF	157.8	158.07	157.78	157.971	5923394.0
2013-04-24 14:00:00	SPY	ETF	157.97	158.3	157.96	158.29	11296067.0
2013-04-24 15:00:00	SPY	ETF	158.29	158.29	157.75	157.88	18025563.0
2013-04-24 16:00:00	SPY	ETF	157.87	158.21	157.77	157.87	8933111.0
2013-04-24 17:00:00	SPY	ETF	157.85	157.88	157.75	157.78	170747.0
2013-04-24 18:00:00	SPY	ETF	157.75	157.77	157.69	157.75	165395.0
2013-04-24 19:00:00	SPY	ETF	157.75	157.77	157.72	157.76	35620.0
2013-04-24 04:00:00	QQQ	ETF	69.49	69.51	69.49	69.51	300.0
2013-04-24 05:00:00	QQQ	ETF	69.55	69.55	69.55	69.55	1000.0
2013-04-24 06:00:00	QQQ	ETF	69.5	69.54	69.41	69.41	38890.0
2013-04-24 07:00:00	QQQ	ETF	69.44	69.48	69.33	69.35	84810.0
2013-04-24 08:00:00	QQQ	ETF	69.33	69.49	69.18	69.21	2537085.0
2013-04-24 09:00:00	QQQ	ETF	69.21	69.67	69.19	69.46	6150950.0
2013-04-24 10:00:00	QQQ	ETF	69.46	69.54	69.12	69.32	7006730.0
2013-04-24 11:00:00	QQQ	ETF	69.33	69.385	69.17	69.311	2641485.0
2013-04-24 12:00:00	QQQ	ETF	69.32	69.38	69.19	69.25	1574356.0
2013-04-24 13:00:00	QQQ	ETF	69.242	69.51	69.24	69.43	1416934.0
2013-04-24 14:00:00	QQQ	ETF	69.42	69.66	69.42	69.6599	2092781.0
2013-04-24 15:00:00	QQQ	ETF	69.66	69.66	69.37	69.43	4366481.0
2013-04-24 16:00:00	QQQ	ETF	69.42	69.55	69.28	69.29	4668251.0
2013-04-24 17:00:00	QQQ	ETF	69.29	69.3	69.27	69.29	96872.0
2013-04-24 18:00:00	QQQ	ETF	69.27	69.27	69.15	69.22	109256.0
2013-04-24 19:00:00	QQQ	ETF	69.22	69.24	69.21	69.24	8760.0
2013-04-24 04:00:00	IWM	ETF	92.58	92.59	92.57	92.59	300.0
2013-04-24 06:00:00	IWM	ETF	92.57	92.57	92.46	92.46	2200.0
2013-04-24 07:00:00	IWM	ETF	92.45	92.52	92.37	92.38	32300.0
2013-04-24 08:00:00	IWM	ETF	92.35	92.35	92.11	92.15	388844.0
2013-04-24 09:00:00	IWM	ETF	92.16	92.5	92.13	92.42	3995124.0
2013-04-24 10:00:00	IWM	ETF	92.42	92.58	91.93	92.47	7866903.0
2013-04-24 11:00:00	IWM	ETF	92.47	92.54	92.14	92.49	4084096.0
2013-04-24 12:00:00	IWM	ETF	92.49	92.51	92.26	92.36	2509610.0
2013-04-24 13:00:00	IWM	ETF	92.36	92.63	92.34	92.55	1878681.0
2013-04-24 14:00:00	IWM	ETF	92.5501	92.86	92.55	92.8	3176392.0
2013-04-24 15:00:00	IWM	ETF	92.805	92.86	92.67	92.8	7130366.0
2013-04-24 16:00:00	IWM	ETF	92.8	92.9	92.68	92.7	1637211.0
2013-04-24 17:00:00	IWM	ETF	92.73	92.75	92.62	92.62	12398.0
2013-04-24 18:00:00	IWM	ETF	92.69	92.72	92.67	92.67	5240.0
2013-04-24 19:00:00	IWM	ETF	92.7	92.72	92.7	92.72	2100.0
2013-04-24 07:00:00	DIA	ETF	146.88	147.1	146.88	147.1	1500.0
2013-04-24 08:00:00	DIA	ETF	147.05	147.05	146.8	146.92	11853.0
2013-04-24 09:00:00	DIA	ETF	146.9	147.21	146.74	146.83	804209.0

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

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