PREVIEW / etf_1hour / 2014-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-06.parquet
  size:    223 KB
  rows:    7,064

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-06 04:00:00	SPY	ETF	192.2	192.57	191.73	192.56	117018.0
2014-08-06 05:00:00	SPY	ETF	191.69	191.76	191.44	191.6	45438.0
2014-08-06 06:00:00	SPY	ETF	191.62	191.62	190.85	191.15	403197.0
2014-08-06 07:00:00	SPY	ETF	191.17	191.43	191.1	191.18	519632.0
2014-08-06 08:00:00	SPY	ETF	191.39	192.1	191.02	191.14	1656583.0
2014-08-06 09:00:00	SPY	ETF	191.13	192.11	190.97	191.77	16345721.0
2014-08-06 10:00:00	SPY	ETF	191.76	192.74	191.74	192.71	19319357.0
2014-08-06 11:00:00	SPY	ETF	192.71	192.85	192.3	192.78	11600270.0
2014-08-06 12:00:00	SPY	ETF	192.78	192.89	192.31	192.41	10910872.0
2014-08-06 13:00:00	SPY	ETF	192.41	192.51	191.92	191.975	8274023.0
2014-08-06 14:00:00	SPY	ETF	191.96	192.29	191.84	192.1241	7899113.0
2014-08-06 15:00:00	SPY	ETF	192.12	192.33	191.96	192.05	13165709.0
2014-08-06 16:00:00	SPY	ETF	192.05	192.6806	191.2	192.06	3807935.0
2014-08-06 17:00:00	SPY	ETF	192.07	192.07	192.02	192.05	53632.0
2014-08-06 18:00:00	SPY	ETF	192.04	192.07	191.92	191.97	107900.0
2014-08-06 19:00:00	SPY	ETF	191.98	192.16	191.96	192.15	80726.0
2014-08-06 04:00:00	QQQ	ETF	94.77	94.77	94.55	94.55	21548.0
2014-08-06 05:00:00	QQQ	ETF	94.49	94.49	94.4	94.46	34100.0
2014-08-06 06:00:00	QQQ	ETF	94.46	94.46	93.99	94.15	86811.0
2014-08-06 07:00:00	QQQ	ETF	94.14	94.23	94.08	94.15	281161.0
2014-08-06 08:00:00	QQQ	ETF	94.16	94.245	94.04	94.09	819586.0
2014-08-06 09:00:00	QQQ	ETF	94.09	94.49	93.92	94.27	6692129.0
2014-08-06 10:00:00	QQQ	ETF	94.27	94.9	94.27	94.88	7802880.0
2014-08-06 11:00:00	QQQ	ETF	94.87	95.09	94.71	95.03	3908664.0
2014-08-06 12:00:00	QQQ	ETF	95.03	95.11	94.79	94.86	3361848.0
2014-08-06 13:00:00	QQQ	ETF	94.86	94.88	94.56	94.6	2156908.0
2014-08-06 14:00:00	QQQ	ETF	94.595	94.79	94.53	94.67	2222473.0
2014-08-06 15:00:00	QQQ	ETF	94.66	94.77	94.5	94.51	4101051.0
2014-08-06 16:00:00	QQQ	ETF	94.52	94.6965	94.49	94.56	1583928.0
2014-08-06 17:00:00	QQQ	ETF	94.57	94.6	94.57	94.57	3329.0
2014-08-06 18:00:00	QQQ	ETF	94.59	94.6	94.52	94.53	17639.0
2014-08-06 19:00:00	QQQ	ETF	94.55	94.65	94.54	94.63	50432.0
2014-08-06 06:00:00	IWM	ETF	110.74	110.74	110.74	110.74	200.0
2014-08-06 07:00:00	IWM	ETF	110.55	110.85	110.55	110.7	2300.0
2014-08-06 08:00:00	IWM	ETF	110.67	110.88	110.56	110.69	160388.0
2014-08-06 09:00:00	IWM	ETF	110.67	111.735	110.55	111.4	4659139.0
2014-08-06 10:00:00	IWM	ETF	111.41	112.15	111.41	112.09	5243097.0
2014-08-06 11:00:00	IWM	ETF	112.08	112.41	111.84	112.37	4564065.0
2014-08-06 12:00:00	IWM	ETF	112.38	112.47	112.09	112.12	3412832.0
2014-08-06 13:00:00	IWM	ETF	112.11	112.155	111.73	111.78	2779997.0
2014-08-06 14:00:00	IWM	ETF	111.78	111.98	111.67	111.87	1944499.0
2014-08-06 15:00:00	IWM	ETF	111.86	112.0	111.649	111.73	4652240.0
2014-08-06 16:00:00	IWM	ETF	111.73	111.8405	111.62	111.67	1889982.0
2014-08-06 17:00:00	IWM	ETF	111.66	111.92	111.64	111.66	11618.0
2014-08-06 19:00:00	IWM	ETF	111.75	111.75	111.6	111.6	400.0
2014-08-06 06:00:00	DIA	ETF	163.24	163.24	163.24	163.24	100.0
2014-08-06 07:00:00	DIA	ETF	163.2	163.25	163.2	163.24	700.0
2014-08-06 08:00:00	DIA	ETF	163.76	163.78	163.35	163.42	6551.0
2014-08-06 09:00:00	DIA	ETF	163.47	164.21	163.33	163.9	1013768.0
2014-08-06 10:00:00	DIA	ETF	163.9	164.64	163.87	164.6	1143096.0

> showing 50 of 7,064 rows — these rows as CSV

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