PREVIEW / etf_1hour / 2014-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-22.parquet
  size:    216 KB
  rows:    6,836

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
2014-08-22 04:00:00	SPY	ETF	199.64	199.66	199.57	199.57	4692.0
2014-08-22 05:00:00	SPY	ETF	199.58	199.58	199.42	199.49	29206.0
2014-08-22 06:00:00	SPY	ETF	199.4	199.44	198.9	199.27	119370.0
2014-08-22 07:00:00	SPY	ETF	199.28	199.55	199.19	199.48	218501.0
2014-08-22 08:00:00	SPY	ETF	199.22	199.52	199.14	199.34	370271.0
2014-08-22 09:00:00	SPY	ETF	199.34	199.46	199.0	199.31	7451975.0
2014-08-22 10:00:00	SPY	ETF	199.31	199.69	198.825	198.9	16994722.0
2014-08-22 11:00:00	SPY	ETF	198.88	199.38	198.74	199.24	10026945.0
2014-08-22 12:00:00	SPY	ETF	199.255	199.56	199.16	199.43	5937515.0
2014-08-22 13:00:00	SPY	ETF	199.4201	199.56	199.37	199.45	3869324.0
2014-08-22 14:00:00	SPY	ETF	199.4479	199.46	199.05	199.28	7028375.0
2014-08-22 15:00:00	SPY	ETF	199.27	199.54	199.04	199.16	15709119.0
2014-08-22 16:00:00	SPY	ETF	199.17	199.5422	199.148	199.36	7660277.0
2014-08-22 17:00:00	SPY	ETF	199.35	199.42	199.3	199.39	59663.0
2014-08-22 18:00:00	SPY	ETF	199.35	199.35	199.26	199.3	20179.0
2014-08-22 19:00:00	SPY	ETF	199.29	199.36	199.28	199.35	17107.0
2014-08-22 04:00:00	QQQ	ETF	98.96	98.96	98.96	98.96	5000.0
2014-08-22 05:00:00	QQQ	ETF	98.85	98.88	98.83	98.88	10600.0
2014-08-22 06:00:00	QQQ	ETF	98.87	98.87	98.68	98.81	32149.0
2014-08-22 07:00:00	QQQ	ETF	98.84	98.92	98.8	98.92	186221.0
2014-08-22 08:00:00	QQQ	ETF	98.81	98.94	98.8	98.91	199258.0
2014-08-22 09:00:00	QQQ	ETF	98.92	99.03	98.72	98.955	2631103.0
2014-08-22 10:00:00	QQQ	ETF	98.95	99.23	98.8	98.85	5792811.0
2014-08-22 11:00:00	QQQ	ETF	98.84	99.14	98.76	99.08	3070721.0
2014-08-22 12:00:00	QQQ	ETF	99.08	99.25	99.031	99.17	2152461.0
2014-08-22 13:00:00	QQQ	ETF	99.18	99.207	99.08	99.165	1268135.0
2014-08-22 14:00:00	QQQ	ETF	99.165	99.175	98.97	99.135	2046311.0
2014-08-22 15:00:00	QQQ	ETF	99.13	99.22	98.99	99.04	3259806.0
2014-08-22 16:00:00	QQQ	ETF	99.04	99.14	99.0159	99.13	2093723.0
2014-08-22 17:00:00	QQQ	ETF	99.14	99.15	99.08	99.14	35060.0
2014-08-22 18:00:00	QQQ	ETF	99.14	99.2	99.11	99.11	6250.0
2014-08-22 19:00:00	QQQ	ETF	99.11	99.12	99.07	99.07	5748.0
2014-08-22 04:00:00	IWM	ETF	115.18	115.19	115.18	115.19	899.0
2014-08-22 07:00:00	IWM	ETF	114.95	115.0	114.82	115.0	62900.0
2014-08-22 08:00:00	IWM	ETF	114.91	115.06	114.87	115.05	86911.0
2014-08-22 09:00:00	IWM	ETF	115.05	115.19	114.63	114.93	3719706.0
2014-08-22 10:00:00	IWM	ETF	114.92	115.35	114.71	114.78	6003430.0
2014-08-22 11:00:00	IWM	ETF	114.77	115.3	114.61	115.27	3504770.0
2014-08-22 12:00:00	IWM	ETF	115.27	115.595	115.26	115.48	2943479.0
2014-08-22 13:00:00	IWM	ETF	115.48	115.52	115.34	115.42	1610682.0
2014-08-22 14:00:00	IWM	ETF	115.42	115.47	115.21	115.429	2838007.0
2014-08-22 15:00:00	IWM	ETF	115.42	115.63	115.17	115.19	4668738.0
2014-08-22 16:00:00	IWM	ETF	115.19	115.4	115.17	115.38	522413.0
2014-08-22 17:00:00	IWM	ETF	115.48	115.48	115.32	115.32	1027.0
2014-08-22 18:00:00	IWM	ETF	115.34	115.34	115.34	115.34	100.0
2014-08-22 19:00:00	IWM	ETF	115.34	115.4	115.3	115.35	1727.0
2014-08-22 04:00:00	DIA	ETF	170.27	170.27	170.27	170.27	300.0
2014-08-22 07:00:00	DIA	ETF	170.09	170.09	170.09	170.09	700.0
2014-08-22 08:00:00	DIA	ETF	170.13	170.26	170.09	170.26	2344.0
2014-08-22 09:00:00	DIA	ETF	170.13	170.21	169.91	170.17	391491.0

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

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