PREVIEW / etf_1hour / 2014-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-15.parquet
  size:    221 KB
  rows:    6,912

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-15 04:00:00	SPY	ETF	196.03	196.43	196.03	196.43	8108.0
2014-08-15 05:00:00	SPY	ETF	196.43	196.51	196.3	196.38	35779.0
2014-08-15 06:00:00	SPY	ETF	196.38	196.45	196.28	196.4	64920.0
2014-08-15 07:00:00	SPY	ETF	196.44	196.49	196.3	196.35	185519.0
2014-08-15 08:00:00	SPY	ETF	196.35	196.43	196.3	196.3	472246.0
2014-08-15 09:00:00	SPY	ETF	196.31	196.5	196.18	196.42	13907296.0
2014-08-15 10:00:00	SPY	ETF	196.42	196.65	194.74	195.39	35405972.0
2014-08-15 11:00:00	SPY	ETF	195.4	195.76	194.31	194.69	30474931.0
2014-08-15 12:00:00	SPY	ETF	194.7	195.37	194.43	195.1	14323799.0
2014-08-15 13:00:00	SPY	ETF	195.1	195.27	194.81	194.9	10960712.0
2014-08-15 14:00:00	SPY	ETF	194.9	195.75	194.89	195.5189	12146554.0
2014-08-15 15:00:00	SPY	ETF	195.51	195.87	195.35	195.73	15204764.0
2014-08-15 16:00:00	SPY	ETF	195.73	195.95	195.5134	195.83	5824907.0
2014-08-15 17:00:00	SPY	ETF	195.82	195.94	195.72	195.8	127266.0
2014-08-15 18:00:00	SPY	ETF	195.84	195.88	195.7	195.75	54680.0
2014-08-15 19:00:00	SPY	ETF	195.75	195.84	195.73	195.84	15762.0
2014-08-15 04:00:00	QQQ	ETF	97.1	97.22	97.1	97.22	2900.0
2014-08-15 05:00:00	QQQ	ETF	97.3	97.3	97.28	97.3	14600.0
2014-08-15 06:00:00	QQQ	ETF	97.26	97.34	97.25	97.3	34870.0
2014-08-15 07:00:00	QQQ	ETF	97.32	97.35	97.27	97.28	48805.0
2014-08-15 08:00:00	QQQ	ETF	97.28	97.35	97.26	97.29	244758.0
2014-08-15 09:00:00	QQQ	ETF	97.29	97.58	97.24	97.4689	6406894.0
2014-08-15 10:00:00	QQQ	ETF	97.46	97.63	96.745	97.02	10297966.0
2014-08-15 11:00:00	QQQ	ETF	97.01	97.22	96.48	96.66	8911227.0
2014-08-15 12:00:00	QQQ	ETF	96.65	97.0599	96.53	96.93	4446308.0
2014-08-15 13:00:00	QQQ	ETF	96.92	97.04	96.81	96.905	2436771.0
2014-08-15 14:00:00	QQQ	ETF	96.91	97.36	96.89	97.24	3553568.0
2014-08-15 15:00:00	QQQ	ETF	97.2499	97.43	97.13	97.37	11571157.0
2014-08-15 16:00:00	QQQ	ETF	97.37	97.46	96.9349	97.41	3837833.0
2014-08-15 17:00:00	QQQ	ETF	97.4	97.45	97.4	97.45	6400.0
2014-08-15 18:00:00	QQQ	ETF	97.37	97.42	97.37	97.4	600.0
2014-08-15 19:00:00	QQQ	ETF	97.4	97.42	97.37	97.42	11490.0
2014-08-15 04:00:00	IWM	ETF	114.25	114.53	114.25	114.53	13300.0
2014-08-15 05:00:00	IWM	ETF	114.6	114.65	114.59	114.59	4200.0
2014-08-15 06:00:00	IWM	ETF	114.58	114.67	114.58	114.67	10500.0
2014-08-15 07:00:00	IWM	ETF	114.63	114.65	114.4	114.4	84622.0
2014-08-15 08:00:00	IWM	ETF	114.44	114.58	114.36	114.37	110244.0
2014-08-15 09:00:00	IWM	ETF	114.36	114.47	114.01	114.17	5438461.0
2014-08-15 10:00:00	IWM	ETF	114.18	114.42	113.04	113.488	11241295.0
2014-08-15 11:00:00	IWM	ETF	113.48	113.4897	112.38	112.54	8935313.0
2014-08-15 12:00:00	IWM	ETF	112.55	112.92	112.26	112.75	6015983.0
2014-08-15 13:00:00	IWM	ETF	112.74	112.74	112.52	112.65	2635038.0
2014-08-15 14:00:00	IWM	ETF	112.65	113.44	112.65	113.22	3485599.0
2014-08-15 15:00:00	IWM	ETF	113.23	113.42	113.11	113.4	6039989.0
2014-08-15 16:00:00	IWM	ETF	113.41	113.64	113.39	113.58	1778291.0
2014-08-15 17:00:00	IWM	ETF	113.58	113.63	113.55	113.62	76551.0
2014-08-15 18:00:00	IWM	ETF	113.61	113.61	113.6	113.6	1150.0
2014-08-15 19:00:00	IWM	ETF	113.52	113.59	113.5	113.59	700.0
2014-08-15 04:00:00	DIA	ETF	167.28	167.28	167.28	167.28	400.0
2014-08-15 08:00:00	DIA	ETF	167.34	167.39	167.16	167.39	1682.0

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

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