PREVIEW / etf_1hour / 2014-03-19

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-19.parquet
  size:    214 KB
  rows:    6,765

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-03-19 04:00:00	SPY	ETF	187.75	187.75	187.55	187.7	13600.0
2014-03-19 05:00:00	SPY	ETF	187.66	187.92	187.66	187.69	9910.0
2014-03-19 06:00:00	SPY	ETF	187.7	187.82	187.68	187.75	22364.0
2014-03-19 07:00:00	SPY	ETF	187.71	187.9	187.67	187.87	175750.0
2014-03-19 08:00:00	SPY	ETF	187.87	187.94	187.75	187.82	554915.0
2014-03-19 09:00:00	SPY	ETF	187.82	187.9	187.44	187.84	10072669.0
2014-03-19 10:00:00	SPY	ETF	187.85	187.94	187.63	187.72	9320010.0
2014-03-19 11:00:00	SPY	ETF	187.73	187.83	187.55	187.63	4547774.0
2014-03-19 12:00:00	SPY	ETF	187.62	187.8	187.545	187.791	13727062.0
2014-03-19 13:00:00	SPY	ETF	187.79	187.89	187.711	187.86	8629948.0
2014-03-19 14:00:00	SPY	ETF	187.86	187.88	186.78	187.27	45315087.0
2014-03-19 15:00:00	SPY	ETF	187.27	187.31	185.47	186.68	55459798.0
2014-03-19 16:00:00	SPY	ETF	186.69	187.8054	186.24	186.66	18601612.0
2014-03-19 17:00:00	SPY	ETF	186.28	186.66	186.26	186.37	746418.0
2014-03-19 18:00:00	SPY	ETF	186.37	187.71	186.37	186.45	94712.0
2014-03-19 19:00:00	SPY	ETF	186.46	186.65	186.44	186.59	67599.0
2014-03-19 04:00:00	QQQ	ETF	90.62	90.62	90.62	90.62	300.0
2014-03-19 06:00:00	QQQ	ETF	90.65	90.65	90.6	90.6	28400.0
2014-03-19 07:00:00	QQQ	ETF	90.65	90.66	90.62	90.64	211450.0
2014-03-19 08:00:00	QQQ	ETF	90.65	90.67	90.58	90.62	49803.0
2014-03-19 09:00:00	QQQ	ETF	90.6	90.64	90.3	90.61	3357090.0
2014-03-19 10:00:00	QQQ	ETF	90.61	90.66	90.23	90.4	4702792.0
2014-03-19 11:00:00	QQQ	ETF	90.39	90.53	90.35	90.46	1603748.0
2014-03-19 12:00:00	QQQ	ETF	90.465	90.58	90.41	90.56	1418666.0
2014-03-19 13:00:00	QQQ	ETF	90.55	90.62	90.53	90.62	1098972.0
2014-03-19 14:00:00	QQQ	ETF	90.6199	90.6199	90.121	90.26	9110453.0
2014-03-19 15:00:00	QQQ	ETF	90.261	90.2801	89.45	90.05	11882650.0
2014-03-19 16:00:00	QQQ	ETF	90.05	90.5847	89.88	89.88	3037668.0
2014-03-19 17:00:00	QQQ	ETF	89.89	90.04	89.87	89.97	678984.0
2014-03-19 18:00:00	QQQ	ETF	89.99	90.02	89.95	89.97	12650.0
2014-03-19 19:00:00	QQQ	ETF	89.98	90.07	89.98	90.05	7677.0
2014-03-19 07:00:00	IWM	ETF	119.76	119.87	119.7	119.81	89399.0
2014-03-19 08:00:00	IWM	ETF	119.78	119.91	119.74	119.74	149869.0
2014-03-19 09:00:00	IWM	ETF	119.75	119.75	119.31	119.67	3328815.0
2014-03-19 10:00:00	IWM	ETF	119.68	119.74	119.26	119.49	3578492.0
2014-03-19 11:00:00	IWM	ETF	119.49	119.64	119.3	119.37	1594399.0
2014-03-19 12:00:00	IWM	ETF	119.38	119.56	119.26	119.47	1934389.0
2014-03-19 13:00:00	IWM	ETF	119.47	119.51	119.3	119.42	2606574.0
2014-03-19 14:00:00	IWM	ETF	119.41	119.53	118.93	119.16	7556064.0
2014-03-19 15:00:00	IWM	ETF	119.17	119.19	118.1	119.01	14460630.0
2014-03-19 16:00:00	IWM	ETF	119.02	119.827	118.71	119.0	1780653.0
2014-03-19 17:00:00	IWM	ETF	118.8	118.85	118.8	118.8	4400.0
2014-03-19 18:00:00	IWM	ETF	118.84	118.87	118.84	118.87	3200.0
2014-03-19 19:00:00	IWM	ETF	118.94	118.94	118.83	118.83	7100.0
2014-03-19 08:00:00	DIA	ETF	163.5	163.5	163.4	163.4	1500.0
2014-03-19 09:00:00	DIA	ETF	163.35	163.46	163.06	163.41	370427.0
2014-03-19 10:00:00	DIA	ETF	163.43	163.5672	163.33	163.41	509200.0
2014-03-19 11:00:00	DIA	ETF	163.42	163.46	163.17	163.26	268025.0
2014-03-19 12:00:00	DIA	ETF	163.27	163.39	163.14	163.32	301882.0
2014-03-19 13:00:00	DIA	ETF	163.32	163.39	163.24	163.36	216855.0

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

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