PREVIEW / etf_1hour / 2013-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-24.parquet
  size:    201 KB
  rows:    6,304

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-05-24 04:00:00	SPY	ETF	165.35	165.73	165.35	165.56	130430.0
2013-05-24 05:00:00	SPY	ETF	165.53	165.53	164.97	164.97	50700.0
2013-05-24 06:00:00	SPY	ETF	165.02	165.02	164.61	164.7	153470.0
2013-05-24 07:00:00	SPY	ETF	164.7	164.83	164.4	164.77	531873.0
2013-05-24 08:00:00	SPY	ETF	164.78	165.45	164.48	164.7	2240175.0
2013-05-24 09:00:00	SPY	ETF	164.7	164.76	164.19	164.32	22391750.0
2013-05-24 10:00:00	SPY	ETF	164.32	164.59	163.98	164.58	24888365.0
2013-05-24 11:00:00	SPY	ETF	164.58	164.88	164.35	164.79	16431763.0
2013-05-24 12:00:00	SPY	ETF	164.8	165.3805	164.54	164.73	12299161.0
2013-05-24 13:00:00	SPY	ETF	164.735	165.15	164.72	165.065	9228207.0
2013-05-24 14:00:00	SPY	ETF	165.065	165.3805	164.93	165.14	12354481.0
2013-05-24 15:00:00	SPY	ETF	165.14	165.33	164.82	165.32	21641618.0
2013-05-24 16:00:00	SPY	ETF	165.33	165.63	164.03	165.53	26439004.0
2013-05-24 17:00:00	SPY	ETF	165.51	165.59	165.3	165.37	1412571.0
2013-05-24 18:00:00	SPY	ETF	165.38	165.45	165.38	165.44	12714.0
2013-05-24 19:00:00	SPY	ETF	165.43	165.47	165.39	165.41	33676.0
2013-05-24 05:00:00	QQQ	ETF	73.5	73.5	73.29	73.29	1600.0
2013-05-24 06:00:00	QQQ	ETF	73.2	73.2	73.03	73.09	17200.0
2013-05-24 07:00:00	QQQ	ETF	73.08	73.13	72.95	73.11	50330.0
2013-05-24 08:00:00	QQQ	ETF	73.13	73.29	73.08	73.09	97266.0
2013-05-24 09:00:00	QQQ	ETF	73.08	73.15	72.8775	72.95	3821785.0
2013-05-24 10:00:00	QQQ	ETF	72.94	73.1	72.76	73.09	6043124.0
2013-05-24 11:00:00	QQQ	ETF	73.1	73.2	72.98	73.18	3877755.0
2013-05-24 12:00:00	QQQ	ETF	73.185	73.26	73.08	73.18	2109067.0
2013-05-24 13:00:00	QQQ	ETF	73.175	73.32	73.175	73.27	1635817.0
2013-05-24 14:00:00	QQQ	ETF	73.275	73.39	73.23	73.28	1662704.0
2013-05-24 15:00:00	QQQ	ETF	73.28	73.43	73.11	73.43	5084744.0
2013-05-24 16:00:00	QQQ	ETF	73.43	73.51	73.2645	73.47	1764780.0
2013-05-24 17:00:00	QQQ	ETF	73.45	73.48	73.39	73.4	19200.0
2013-05-24 18:00:00	QQQ	ETF	73.47	73.48	73.45	73.48	1475.0
2013-05-24 19:00:00	QQQ	ETF	73.46	73.52	73.46	73.51	4277.0
2013-05-24 05:00:00	IWM	ETF	97.7	97.7	97.7	97.7	1000.0
2013-05-24 06:00:00	IWM	ETF	97.63	97.66	97.4	97.4	20800.0
2013-05-24 07:00:00	IWM	ETF	97.4	97.53	97.26	97.53	38084.0
2013-05-24 08:00:00	IWM	ETF	97.51	97.81	97.33	97.53	391988.0
2013-05-24 09:00:00	IWM	ETF	97.43	97.46	96.99	97.01	3748130.0
2013-05-24 10:00:00	IWM	ETF	97.0	97.38	96.71	97.34	7285815.0
2013-05-24 11:00:00	IWM	ETF	97.34	97.53	97.17	97.47	3942022.0
2013-05-24 12:00:00	IWM	ETF	97.46	97.7	97.39	97.56	2533003.0
2013-05-24 13:00:00	IWM	ETF	97.55	97.8	97.52	97.76	2600234.0
2013-05-24 14:00:00	IWM	ETF	97.77	97.95	97.68	97.77	1809282.0
2013-05-24 15:00:00	IWM	ETF	97.77	97.92	97.55	97.89	6181524.0
2013-05-24 16:00:00	IWM	ETF	97.9	98.07	97.82	97.99	1715754.0
2013-05-24 17:00:00	IWM	ETF	97.96	98.0	97.94	97.96	25683.0
2013-05-24 18:00:00	IWM	ETF	97.96	97.96	97.92	97.92	2240.0
2013-05-24 19:00:00	IWM	ETF	97.95	97.95	97.82	97.82	3635.0
2013-05-24 04:00:00	DIA	ETF	152.76	152.76	152.76	152.76	1000.0
2013-05-24 07:00:00	DIA	ETF	152.31	152.31	152.25	152.25	3400.0
2013-05-24 08:00:00	DIA	ETF	152.54	152.74	152.33	152.38	15785.0
2013-05-24 09:00:00	DIA	ETF	152.26	152.38	151.93	152.02	888083.0

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

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