PREVIEW / etf_1hour / 2013-04-10

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-10.parquet
  size:    202 KB
  rows:    6,285

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-10 04:00:00	SPY	ETF	157.06	157.1	157.04	157.04	9139.0
2013-04-10 05:00:00	SPY	ETF	157.04	157.18	157.04	157.17	25700.0
2013-04-10 06:00:00	SPY	ETF	157.19	157.3	157.16	157.25	49018.0
2013-04-10 07:00:00	SPY	ETF	157.25	157.27	157.15	157.2	212633.0
2013-04-10 08:00:00	SPY	ETF	157.17	157.28	156.82	157.03	1521008.0
2013-04-10 09:00:00	SPY	ETF	157.03	157.64	156.94	157.63	15046637.0
2013-04-10 10:00:00	SPY	ETF	157.62	158.35	157.62	158.35	23485833.0
2013-04-10 11:00:00	SPY	ETF	158.35	158.6	158.22	158.47	19965273.0
2013-04-10 12:00:00	SPY	ETF	158.47	158.8	158.37	158.75	10472473.0
2013-04-10 13:00:00	SPY	ETF	158.75	158.84	158.61	158.68	13324979.0
2013-04-10 14:00:00	SPY	ETF	158.69	158.84	158.52	158.655	10990423.0
2013-04-10 15:00:00	SPY	ETF	158.66	158.87	158.45	158.7	24257452.0
2013-04-10 16:00:00	SPY	ETF	158.71	158.83	156.7929	158.78	12332212.0
2013-04-10 17:00:00	SPY	ETF	158.8	158.82	158.77	158.79	134242.0
2013-04-10 18:00:00	SPY	ETF	158.77	158.77	158.65	158.67	106441.0
2013-04-10 19:00:00	SPY	ETF	158.68	158.7	158.62	158.63	118837.0
2013-04-10 05:00:00	QQQ	ETF	68.9	68.9	68.9	68.9	3000.0
2013-04-10 06:00:00	QQQ	ETF	68.93	68.95	68.92	68.92	12040.0
2013-04-10 07:00:00	QQQ	ETF	68.93	68.95	68.9	68.9	17100.0
2013-04-10 08:00:00	QQQ	ETF	68.9	68.96	68.81	68.89	82968.0
2013-04-10 09:00:00	QQQ	ETF	68.88	69.24	68.68	69.22	4505009.0
2013-04-10 10:00:00	QQQ	ETF	69.22	70.17	69.22	69.85	8163944.0
2013-04-10 11:00:00	QQQ	ETF	69.855	69.96	69.77	69.9216	5264590.0
2013-04-10 12:00:00	QQQ	ETF	69.93	70.12	69.861	70.06	3779393.0
2013-04-10 13:00:00	QQQ	ETF	70.065	70.11	70.0	70.01	2252926.0
2013-04-10 14:00:00	QQQ	ETF	70.01	70.07	69.87	69.99	4262066.0
2013-04-10 15:00:00	QQQ	ETF	69.99	70.1	69.9	70.02	8431418.0
2013-04-10 16:00:00	QQQ	ETF	70.01	70.03	68.6924	69.98	7089144.0
2013-04-10 17:00:00	QQQ	ETF	69.99	70.02	69.92	69.96	48630.0
2013-04-10 18:00:00	QQQ	ETF	69.94	69.95	69.87	69.94	30153.0
2013-04-10 19:00:00	QQQ	ETF	69.91	69.92	69.88	69.9	19480.0
2013-04-10 05:00:00	IWM	ETF	92.55	92.55	92.55	92.55	4000.0
2013-04-10 06:00:00	IWM	ETF	92.55	92.65	92.55	92.62	2600.0
2013-04-10 07:00:00	IWM	ETF	92.64	92.72	92.6	92.63	164556.0
2013-04-10 08:00:00	IWM	ETF	92.67	92.7	92.44	92.55	130325.0
2013-04-10 09:00:00	IWM	ETF	92.54	92.88	92.45	92.84	4202624.0
2013-04-10 10:00:00	IWM	ETF	92.84	93.32	92.84	93.32	9864587.0
2013-04-10 11:00:00	IWM	ETF	93.32	93.81	93.26	93.72	6010312.0
2013-04-10 12:00:00	IWM	ETF	93.72	93.8	93.59	93.67	3462399.0
2013-04-10 13:00:00	IWM	ETF	93.67	93.91	93.66	93.84	2689144.0
2013-04-10 14:00:00	IWM	ETF	93.84	93.97	93.77	93.9423	3453479.0
2013-04-10 15:00:00	IWM	ETF	93.95	94.1	93.83	93.91	8200702.0
2013-04-10 16:00:00	IWM	ETF	93.91	94.0	93.4612	93.96	2207059.0
2013-04-10 17:00:00	IWM	ETF	93.95	93.95	93.89	93.89	9100.0
2013-04-10 18:00:00	IWM	ETF	93.88	93.89	93.85	93.85	3320.0
2013-04-10 05:00:00	DIA	ETF	146.85	146.85	146.85	146.85	100.0
2013-04-10 07:00:00	DIA	ETF	146.96	146.99	146.96	146.99	1400.0
2013-04-10 08:00:00	DIA	ETF	146.86	147.04	146.67	147.04	122473.0
2013-04-10 09:00:00	DIA	ETF	146.84	147.26	146.79	147.2	986836.0
2013-04-10 10:00:00	DIA	ETF	147.2	147.74	147.19	147.73	1085662.0

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

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