PREVIEW / etf_1hour / 2014-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-04.parquet
  size:    214 KB
  rows:    6,774

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-06-04 04:00:00	SPY	ETF	192.77	192.81	192.44	192.44	52662.0
2014-06-04 05:00:00	SPY	ETF	192.46	192.48	192.35	192.44	9692.0
2014-06-04 06:00:00	SPY	ETF	192.43	192.62	192.43	192.59	39726.0
2014-06-04 07:00:00	SPY	ETF	192.63	192.63	192.5	192.56	104452.0
2014-06-04 08:00:00	SPY	ETF	192.59	192.84	192.23	192.35	882306.0
2014-06-04 09:00:00	SPY	ETF	192.35	192.69	192.265	192.67	7474080.0
2014-06-04 10:00:00	SPY	ETF	192.67	193.0	192.58	192.99	8408979.0
2014-06-04 11:00:00	SPY	ETF	192.98	193.22	192.95	193.08	7252829.0
2014-06-04 12:00:00	SPY	ETF	193.08	193.27	193.06	193.24	2804933.0
2014-06-04 13:00:00	SPY	ETF	193.24	193.3	193.16	193.2501	3874692.0
2014-06-04 14:00:00	SPY	ETF	193.2599	193.28	193.01	193.11	7216709.0
2014-06-04 15:00:00	SPY	ETF	193.105	193.27	193.08	193.17	12846656.0
2014-06-04 16:00:00	SPY	ETF	193.17	193.27	193.12	193.2	3630822.0
2014-06-04 17:00:00	SPY	ETF	193.21	193.26	193.19	193.26	119547.0
2014-06-04 18:00:00	SPY	ETF	193.27	193.27	193.1	193.12	376235.0
2014-06-04 19:00:00	SPY	ETF	193.13	193.2	193.11	193.17	27283.0
2014-06-04 04:00:00	QQQ	ETF	91.1	91.1	91.03	91.03	3900.0
2014-06-04 05:00:00	QQQ	ETF	91.03	91.03	91.03	91.03	60000.0
2014-06-04 07:00:00	QQQ	ETF	91.12	91.12	91.07	91.07	2000.0
2014-06-04 08:00:00	QQQ	ETF	91.09	91.18	90.88	90.95	157477.0
2014-06-04 09:00:00	QQQ	ETF	90.94	91.18	90.81	91.1699	3421764.0
2014-06-04 10:00:00	QQQ	ETF	91.17	91.37	91.09	91.37	4008612.0
2014-06-04 11:00:00	QQQ	ETF	91.37	91.5	91.32	91.43	1761401.0
2014-06-04 12:00:00	QQQ	ETF	91.44	91.65	91.42	91.62	2119497.0
2014-06-04 13:00:00	QQQ	ETF	91.62	91.67	91.57	91.65	1005887.0
2014-06-04 14:00:00	QQQ	ETF	91.65	91.66	91.45	91.52	1743204.0
2014-06-04 15:00:00	QQQ	ETF	91.52	91.55	91.44	91.51	3723805.0
2014-06-04 16:00:00	QQQ	ETF	91.505	91.57	91.1837	91.55	1799644.0
2014-06-04 17:00:00	QQQ	ETF	91.53	91.55	91.52	91.55	12800.0
2014-06-04 18:00:00	QQQ	ETF	91.52	91.52	91.47	91.49	4200.0
2014-06-04 19:00:00	QQQ	ETF	91.5	91.5	91.48	91.49	5700.0
2014-06-04 04:00:00	IWM	ETF	111.98	111.98	111.98	111.98	1100.0
2014-06-04 06:00:00	IWM	ETF	111.6	111.64	111.58	111.58	1800.0
2014-06-04 07:00:00	IWM	ETF	111.59	111.63	111.53	111.58	3600.0
2014-06-04 08:00:00	IWM	ETF	111.6	111.98	111.26	111.31	240256.0
2014-06-04 09:00:00	IWM	ETF	111.32	111.77	111.16	111.71	4908918.0
2014-06-04 10:00:00	IWM	ETF	111.72	112.29	111.605	112.26	5542084.0
2014-06-04 11:00:00	IWM	ETF	112.26	112.44	112.05	112.33	3827697.0
2014-06-04 12:00:00	IWM	ETF	112.34	112.43	112.18	112.37	1133232.0
2014-06-04 13:00:00	IWM	ETF	112.37	112.565	112.29	112.53	1122322.0
2014-06-04 14:00:00	IWM	ETF	112.53	112.56	112.11	112.25	2774295.0
2014-06-04 15:00:00	IWM	ETF	112.24	112.55	112.2	112.41	5090999.0
2014-06-04 16:00:00	IWM	ETF	112.42	112.54	111.32	112.51	1058179.0
2014-06-04 17:00:00	IWM	ETF	112.51	112.51	112.47	112.47	3900.0
2014-06-04 18:00:00	IWM	ETF	112.43	112.43	112.43	112.43	100.0
2014-06-04 08:00:00	DIA	ETF	166.95	166.95	166.8	166.82	47693.0
2014-06-04 09:00:00	DIA	ETF	166.79	166.92	166.58	166.87	404292.0
2014-06-04 10:00:00	DIA	ETF	166.85	166.97	166.643	166.96	294680.0
2014-06-04 11:00:00	DIA	ETF	166.98	167.17	166.9499	167.08	241835.0
2014-06-04 12:00:00	DIA	ETF	167.1	167.25	167.06	167.24	202828.0

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

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