PREVIEW / etf_1hour / 2013-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-05.parquet
  size:    200 KB
  rows:    6,311

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-08-05 04:00:00	SPY	ETF	170.87	170.93	170.85	170.9	14550.0
2013-08-05 05:00:00	SPY	ETF	170.88	170.88	170.85	170.85	2000.0
2013-08-05 06:00:00	SPY	ETF	170.85	170.85	170.7	170.75	14200.0
2013-08-05 07:00:00	SPY	ETF	170.76	170.8	170.71	170.75	39135.0
2013-08-05 08:00:00	SPY	ETF	170.76	170.8	170.58	170.62	337261.0
2013-08-05 09:00:00	SPY	ETF	170.63	170.67	170.35	170.63	8951836.0
2013-08-05 10:00:00	SPY	ETF	170.64	170.96	170.58	170.85	9234922.0
2013-08-05 11:00:00	SPY	ETF	170.849	170.95	170.68	170.7399	4833452.0
2013-08-05 12:00:00	SPY	ETF	170.735	170.86	170.63	170.69	3196258.0
2013-08-05 13:00:00	SPY	ETF	170.69	170.74	170.44	170.66	5021767.0
2013-08-05 14:00:00	SPY	ETF	170.66	170.7	170.54	170.67	5407424.0
2013-08-05 15:00:00	SPY	ETF	170.67	170.83	170.59	170.73	9384727.0
2013-08-05 16:00:00	SPY	ETF	170.74	170.9882	170.63	170.69	5538263.0
2013-08-05 17:00:00	SPY	ETF	170.68	170.69	170.57	170.57	392219.0
2013-08-05 18:00:00	SPY	ETF	170.59	170.59	170.4	170.46	185701.0
2013-08-05 19:00:00	SPY	ETF	170.46	170.5	170.44	170.48	31790.0
2013-08-05 04:00:00	QQQ	ETF	77.02	77.05	77.01	77.03	12100.0
2013-08-05 05:00:00	QQQ	ETF	77.03	77.03	77.01	77.01	1900.0
2013-08-05 06:00:00	QQQ	ETF	77.02	77.03	76.97	76.98	3300.0
2013-08-05 07:00:00	QQQ	ETF	77.01	77.01	76.98	77.0	5865.0
2013-08-05 08:00:00	QQQ	ETF	76.97	76.97	76.91	76.91	46726.0
2013-08-05 09:00:00	QQQ	ETF	76.93	76.95	76.815	76.92	1666476.0
2013-08-05 10:00:00	QQQ	ETF	76.93	77.08	76.9	77.03	2435538.0
2013-08-05 11:00:00	QQQ	ETF	77.03	77.06	76.86	76.9001	1825190.0
2013-08-05 12:00:00	QQQ	ETF	76.91	76.979	76.83	76.9	1451109.0
2013-08-05 13:00:00	QQQ	ETF	76.91	77.0	76.78	76.97	1044836.0
2013-08-05 14:00:00	QQQ	ETF	76.96	76.96	76.87	76.91	972699.0
2013-08-05 15:00:00	QQQ	ETF	76.9	77.03	76.86	77.01	2309390.0
2013-08-05 16:00:00	QQQ	ETF	77.01	77.0393	76.916	77.0	1535556.0
2013-08-05 17:00:00	QQQ	ETF	77.0	77.02	76.92	76.93	23125.0
2013-08-05 18:00:00	QQQ	ETF	76.96	76.96	76.86	76.89	17070.0
2013-08-05 19:00:00	QQQ	ETF	76.9	76.94	76.88	76.94	4500.0
2013-08-05 07:00:00	IWM	ETF	105.13	105.15	105.11	105.14	1688.0
2013-08-05 08:00:00	IWM	ETF	105.13	105.13	105.06	105.08	12835.0
2013-08-05 09:00:00	IWM	ETF	105.1	105.24	104.9	105.21	1522521.0
2013-08-05 10:00:00	IWM	ETF	105.22	105.63	105.14	105.46	3323721.0
2013-08-05 11:00:00	IWM	ETF	105.46	105.565	105.41	105.49	1467310.0
2013-08-05 12:00:00	IWM	ETF	105.48	105.58	105.32	105.35	1132413.0
2013-08-05 13:00:00	IWM	ETF	105.35	105.38	105.2	105.29	1531989.0
2013-08-05 14:00:00	IWM	ETF	105.28	105.375	105.2	105.21	1081721.0
2013-08-05 15:00:00	IWM	ETF	105.21	105.53	105.17	105.5	2813790.0
2013-08-05 16:00:00	IWM	ETF	105.5	105.52	105.4189	105.5	730886.0
2013-08-05 17:00:00	IWM	ETF	105.5	105.61	105.46	105.46	3072.0
2013-08-05 18:00:00	IWM	ETF	105.48	105.48	105.41	105.41	6600.0
2013-08-05 19:00:00	IWM	ETF	105.46	105.46	105.4	105.41	1700.0
2013-08-05 08:00:00	DIA	ETF	156.07	156.07	155.93	155.93	4988.0
2013-08-05 09:00:00	DIA	ETF	155.95	155.95	155.5	155.7	481033.0
2013-08-05 10:00:00	DIA	ETF	155.66	156.0113	155.66	155.85	472761.0
2013-08-05 11:00:00	DIA	ETF	155.86	155.8999	155.69	155.73	245786.0
2013-08-05 12:00:00	DIA	ETF	155.75	155.8401	155.64	155.76	295396.0

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

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