PREVIEW / etf_1hour / 2014-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-12.parquet
  size:    215 KB
  rows:    6,764

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-12 04:00:00	SPY	ETF	186.95	187.12	186.89	186.98	11439.0
2014-03-12 05:00:00	SPY	ETF	186.97	186.97	186.67	186.78	19482.0
2014-03-12 06:00:00	SPY	ETF	186.74	186.77	186.4	186.43	171213.0
2014-03-12 07:00:00	SPY	ETF	186.43	186.7	186.42	186.69	359438.0
2014-03-12 08:00:00	SPY	ETF	186.68	186.73	186.26	186.42	1245944.0
2014-03-12 09:00:00	SPY	ETF	186.41	186.62	185.9	186.29	20626052.0
2014-03-12 10:00:00	SPY	ETF	186.29	187.01	186.23	186.961	20502238.0
2014-03-12 11:00:00	SPY	ETF	186.96	187.35	186.8	186.88	12592617.0
2014-03-12 12:00:00	SPY	ETF	186.88	187.2	186.7601	187.17	9216206.0
2014-03-12 13:00:00	SPY	ETF	187.169	187.18	186.75	187.0	5281432.0
2014-03-12 14:00:00	SPY	ETF	187.0	187.21	186.87	186.92	8033542.0
2014-03-12 15:00:00	SPY	ETF	186.92	187.33	186.77	187.26	18779036.0
2014-03-12 16:00:00	SPY	ETF	187.26	187.38	186.05	187.37	6903186.0
2014-03-12 17:00:00	SPY	ETF	187.38	187.39	187.28	187.31	72485.0
2014-03-12 18:00:00	SPY	ETF	187.32	187.34	187.22	187.3	47756.0
2014-03-12 19:00:00	SPY	ETF	187.31	187.48	187.31	187.48	74176.0
2014-03-12 04:00:00	QQQ	ETF	90.1	90.11	90.09	90.1	7500.0
2014-03-12 05:00:00	QQQ	ETF	90.05	90.05	90.01	90.01	2800.0
2014-03-12 06:00:00	QQQ	ETF	89.9	89.92	89.8	89.86	13000.0
2014-03-12 07:00:00	QQQ	ETF	89.84	89.955	89.81	89.9	19815.0
2014-03-12 08:00:00	QQQ	ETF	89.88	89.94	89.75	89.81	129812.0
2014-03-12 09:00:00	QQQ	ETF	89.82	89.98	89.48	89.71	4431962.0
2014-03-12 10:00:00	QQQ	ETF	89.71	90.29	89.68	90.28	5514162.0
2014-03-12 11:00:00	QQQ	ETF	90.28	90.6	90.2	90.36	3175868.0
2014-03-12 12:00:00	QQQ	ETF	90.36	90.52	90.291	90.5199	1686050.0
2014-03-12 13:00:00	QQQ	ETF	90.52	90.52	90.295	90.48	972252.0
2014-03-12 14:00:00	QQQ	ETF	90.47	90.61	90.38	90.39	1773102.0
2014-03-12 15:00:00	QQQ	ETF	90.39	90.6	90.2132	90.55	4636601.0
2014-03-12 16:00:00	QQQ	ETF	90.56	90.64	90.2132	90.63	1372601.0
2014-03-12 17:00:00	QQQ	ETF	90.63	90.66	90.62	90.65	18511.0
2014-03-12 18:00:00	QQQ	ETF	90.6	90.6	90.58	90.58	3700.0
2014-03-12 19:00:00	QQQ	ETF	90.64	90.72	90.63	90.72	14983.0
2014-03-12 06:00:00	IWM	ETF	117.55	117.55	117.45	117.5	7400.0
2014-03-12 07:00:00	IWM	ETF	117.51	117.7	117.46	117.7	17064.0
2014-03-12 08:00:00	IWM	ETF	117.71	117.73	117.23	117.38	432509.0
2014-03-12 09:00:00	IWM	ETF	117.37	117.7801	116.92	117.365	7354684.0
2014-03-12 10:00:00	IWM	ETF	117.36	117.95	117.24	117.93	7570501.0
2014-03-12 11:00:00	IWM	ETF	117.94	118.36	117.79	117.905	4100720.0
2014-03-12 12:00:00	IWM	ETF	117.9	118.16	117.84	118.13	2418151.0
2014-03-12 13:00:00	IWM	ETF	118.12	118.15	117.89	118.12	1083865.0
2014-03-12 14:00:00	IWM	ETF	118.13	118.28	118.04	118.115	1726111.0
2014-03-12 15:00:00	IWM	ETF	118.12	118.44	118.07	118.42	4933577.0
2014-03-12 16:00:00	IWM	ETF	118.43	118.55	118.108	118.55	1859440.0
2014-03-12 17:00:00	IWM	ETF	118.47	118.51	118.47	118.48	9400.0
2014-03-12 18:00:00	IWM	ETF	118.47	118.56	118.46	118.46	2585.0
2014-03-12 19:00:00	IWM	ETF	118.46	118.46	118.42	118.46	74051.0
2014-03-12 07:00:00	DIA	ETF	162.99	163.05	162.99	163.0	4500.0
2014-03-12 08:00:00	DIA	ETF	163.01	163.01	162.7	162.75	38538.0
2014-03-12 09:00:00	DIA	ETF	162.8	163.02	162.47	162.8	944328.0
2014-03-12 10:00:00	DIA	ETF	162.77	163.21	162.71	163.16	990217.0

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

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