PREVIEW / etf_1hour / 2013-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-02.parquet
  size:    205 KB
  rows:    6,408

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-07-02 04:00:00	SPY	ETF	161.38	161.65	161.19	161.55	53550.0
2013-07-02 05:00:00	SPY	ETF	161.6	161.7	161.31	161.45	14000.0
2013-07-02 06:00:00	SPY	ETF	161.5	161.78	161.49	161.6	28200.0
2013-07-02 07:00:00	SPY	ETF	161.6	161.65	161.39	161.4	98886.0
2013-07-02 08:00:00	SPY	ETF	161.43	161.62	160.96	161.03	1218892.0
2013-07-02 09:00:00	SPY	ETF	161.03	162.08	160.99	161.88	15682311.0
2013-07-02 10:00:00	SPY	ETF	161.88	162.23	161.69	162.19	20629422.0
2013-07-02 11:00:00	SPY	ETF	162.19	162.3	161.94	162.18	13899547.0
2013-07-02 12:00:00	SPY	ETF	162.17	162.21	161.67	161.97	11447060.0
2013-07-02 13:00:00	SPY	ETF	161.97	161.98	161.18	161.41	11272341.0
2013-07-02 14:00:00	SPY	ETF	161.41	161.415	160.5	160.941	25098628.0
2013-07-02 15:00:00	SPY	ETF	160.94	161.37	160.68	161.16	23101795.0
2013-07-02 16:00:00	SPY	ETF	161.14	161.3467	160.5	161.19	12164605.0
2013-07-02 17:00:00	SPY	ETF	161.2	161.24	161.17	161.19	1595979.0
2013-07-02 18:00:00	SPY	ETF	161.18	161.26	161.15	161.17	107555.0
2013-07-02 19:00:00	SPY	ETF	161.19	161.29	161.19	161.25	21485.0
2013-07-02 04:00:00	QQQ	ETF	71.76	71.9	71.74	71.88	13300.0
2013-07-02 05:00:00	QQQ	ETF	71.9	71.94	71.74	71.8	12400.0
2013-07-02 06:00:00	QQQ	ETF	71.82	71.96	71.82	71.86	13000.0
2013-07-02 07:00:00	QQQ	ETF	71.84	71.86	71.79	71.8	11865.0
2013-07-02 08:00:00	QQQ	ETF	71.78	71.8	71.63	71.65	36634.0
2013-07-02 09:00:00	QQQ	ETF	71.68	72.09	71.62	71.9799	2696251.0
2013-07-02 10:00:00	QQQ	ETF	71.98	72.14	71.84	72.12	3734013.0
2013-07-02 11:00:00	QQQ	ETF	72.12	72.1796	71.96	72.125	2541084.0
2013-07-02 12:00:00	QQQ	ETF	72.12	72.13	71.85	72.01	1972809.0
2013-07-02 13:00:00	QQQ	ETF	72.01	72.01	71.59	71.739	3598016.0
2013-07-02 14:00:00	QQQ	ETF	71.74	71.74	71.35	71.52	3349880.0
2013-07-02 15:00:00	QQQ	ETF	71.53	71.82	71.47	71.73	3720894.0
2013-07-02 16:00:00	QQQ	ETF	71.73	72.008	71.56	71.76	1168078.0
2013-07-02 17:00:00	QQQ	ETF	71.76	71.76	71.76	71.76	3693.0
2013-07-02 18:00:00	QQQ	ETF	71.73	71.73	71.73	71.73	100.0
2013-07-02 19:00:00	QQQ	ETF	71.75	71.75	71.74	71.74	1672.0
2013-07-02 04:00:00	IWM	ETF	98.4	98.4	98.38	98.38	11286.0
2013-07-02 06:00:00	IWM	ETF	98.52	98.52	98.44	98.44	1000.0
2013-07-02 07:00:00	IWM	ETF	98.43	98.49	98.36	98.39	41636.0
2013-07-02 08:00:00	IWM	ETF	98.41	98.41	98.07	98.08	136006.0
2013-07-02 09:00:00	IWM	ETF	98.06	98.63	98.05	98.44	4258785.0
2013-07-02 10:00:00	IWM	ETF	98.44	98.74	98.1499	98.68	5257463.0
2013-07-02 11:00:00	IWM	ETF	98.69	98.85	98.578	98.73	2713166.0
2013-07-02 12:00:00	IWM	ETF	98.72	98.75	98.27	98.39	2733636.0
2013-07-02 13:00:00	IWM	ETF	98.385	98.4	97.93	98.048	2644916.0
2013-07-02 14:00:00	IWM	ETF	98.05	98.05	97.45	97.75	5743634.0
2013-07-02 15:00:00	IWM	ETF	97.75	98.2	97.65	98.18	4831455.0
2013-07-02 16:00:00	IWM	ETF	98.17	98.65	97.77	97.77	3254518.0
2013-07-02 17:00:00	IWM	ETF	98.13	98.15	98.13	98.15	2559.0
2013-07-02 18:00:00	IWM	ETF	98.2	98.2	98.2	98.2	100.0
2013-07-02 19:00:00	IWM	ETF	98.15	98.15	98.15	98.15	875.0
2013-07-02 05:00:00	DIA	ETF	149.58	149.58	149.58	149.58	100.0
2013-07-02 06:00:00	DIA	ETF	149.63	149.63	149.63	149.63	100.0
2013-07-02 08:00:00	DIA	ETF	149.36	149.36	149.28	149.28	1700.0

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

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