PREVIEW / etf_1hour / 2014-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-12.parquet
  size:    214 KB
  rows:    6,788

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-12 04:00:00	SPY	ETF	194.11	194.29	194.09	194.29	10655.0
2014-08-12 05:00:00	SPY	ETF	194.2	194.34	194.17	194.26	27512.0
2014-08-12 06:00:00	SPY	ETF	194.33	194.36	194.15	194.18	26348.0
2014-08-12 07:00:00	SPY	ETF	194.17	194.25	193.83	193.96	389980.0
2014-08-12 08:00:00	SPY	ETF	194.04	194.07	193.84	193.9	512059.0
2014-08-12 09:00:00	SPY	ETF	193.9	194.11	193.41	193.99	9529716.0
2014-08-12 10:00:00	SPY	ETF	193.98	194.15	193.43	193.53	11770877.0
2014-08-12 11:00:00	SPY	ETF	193.53	193.535	193.05	193.325	10068373.0
2014-08-12 12:00:00	SPY	ETF	193.33	193.76	193.13	193.55	8672078.0
2014-08-12 13:00:00	SPY	ETF	193.55	193.73	193.28	193.45	6440958.0
2014-08-12 14:00:00	SPY	ETF	193.445	193.46	192.94	193.17	8904173.0
2014-08-12 15:00:00	SPY	ETF	193.185	193.7	193.17	193.54	11519245.0
2014-08-12 16:00:00	SPY	ETF	193.54	193.84	193.3701	193.83	3700694.0
2014-08-12 17:00:00	SPY	ETF	193.8	193.83	193.75	193.76	548160.0
2014-08-12 18:00:00	SPY	ETF	193.78	193.85	193.76	193.8	28551.0
2014-08-12 19:00:00	SPY	ETF	193.79	193.8	193.75	193.78	19000.0
2014-08-12 04:00:00	QQQ	ETF	95.54	95.79	95.54	95.79	1400.0
2014-08-12 05:00:00	QQQ	ETF	95.61	95.7	95.61	95.7	34700.0
2014-08-12 06:00:00	QQQ	ETF	95.72	95.72	95.64	95.65	25700.0
2014-08-12 07:00:00	QQQ	ETF	95.65	95.67	95.41	95.45	21500.0
2014-08-12 08:00:00	QQQ	ETF	95.55	95.56	95.45	95.5	183595.0
2014-08-12 09:00:00	QQQ	ETF	95.5	95.65	95.27	95.605	2965322.0
2014-08-12 10:00:00	QQQ	ETF	95.605	95.67	95.25	95.295	3740865.0
2014-08-12 11:00:00	QQQ	ETF	95.3	95.3	94.995	95.205	4357091.0
2014-08-12 12:00:00	QQQ	ETF	95.2	95.41	95.09	95.3	1673871.0
2014-08-12 13:00:00	QQQ	ETF	95.31	95.37	95.17	95.24	3173437.0
2014-08-12 14:00:00	QQQ	ETF	95.24	95.25	94.93	95.06	3278120.0
2014-08-12 15:00:00	QQQ	ETF	95.065	95.47	95.065	95.4	5632397.0
2014-08-12 16:00:00	QQQ	ETF	95.41	95.51	95.2813	95.5	1969631.0
2014-08-12 17:00:00	QQQ	ETF	95.48	95.53	95.44	95.47	17903.0
2014-08-12 18:00:00	QQQ	ETF	95.5	95.5	95.48	95.48	2500.0
2014-08-12 19:00:00	QQQ	ETF	95.48	95.48	95.45	95.45	4924.0
2014-08-12 05:00:00	IWM	ETF	113.36	113.36	113.36	113.36	200.0
2014-08-12 06:00:00	IWM	ETF	113.45	113.45	113.45	113.45	10000.0
2014-08-12 07:00:00	IWM	ETF	113.43	113.43	112.89	112.93	65666.0
2014-08-12 08:00:00	IWM	ETF	112.98	113.25	112.98	113.04	279580.0
2014-08-12 09:00:00	IWM	ETF	113.04	113.38	112.65	113.36	2711473.0
2014-08-12 10:00:00	IWM	ETF	113.36	113.47	112.81	112.88	3390659.0
2014-08-12 11:00:00	IWM	ETF	112.88	112.88	112.49	112.73	2918575.0
2014-08-12 12:00:00	IWM	ETF	112.73	112.965	112.56	112.73	2198202.0
2014-08-12 13:00:00	IWM	ETF	112.74	112.78	112.38	112.51	2615431.0
2014-08-12 14:00:00	IWM	ETF	112.51	112.51	112.04	112.08	3646748.0
2014-08-12 15:00:00	IWM	ETF	112.09	112.56	112.085	112.54	5015723.0
2014-08-12 16:00:00	IWM	ETF	112.55	112.65	112.45	112.63	1913247.0
2014-08-12 17:00:00	IWM	ETF	112.61	112.7	112.54	112.7	2199.0
2014-08-12 18:00:00	IWM	ETF	112.62	112.62	112.62	112.62	600.0
2014-08-12 19:00:00	IWM	ETF	112.69	112.69	112.69	112.69	1000.0
2014-08-12 09:00:00	DIA	ETF	165.42	165.67	165.15	165.61	585729.0
2014-08-12 10:00:00	DIA	ETF	165.6	165.77	165.28	165.36	569110.0
2014-08-12 11:00:00	DIA	ETF	165.36	165.36	165.0	165.19	382088.0

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

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