PREVIEW / etf_1hour / 2014-03-21

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-21.parquet
  size:    217 KB
  rows:    6,769

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-21 04:00:00	SPY	ETF	187.3	187.8	187.27	187.64	71772.0
2014-03-21 05:00:00	SPY	ETF	187.62	187.63	187.47	187.61	27854.0
2014-03-21 06:00:00	SPY	ETF	187.6	187.65	187.46	187.53	83640.0
2014-03-21 07:00:00	SPY	ETF	187.53	187.62	187.46	187.48	188927.0
2014-03-21 08:00:00	SPY	ETF	187.5	187.62	187.36	187.58	745895.0
2014-03-21 09:00:00	SPY	ETF	187.58	189.0239	187.46	187.71	35758919.0
2014-03-21 10:00:00	SPY	ETF	187.71	187.825	187.29	187.77	22896687.0
2014-03-21 11:00:00	SPY	ETF	187.775	188.025	187.65	187.76	11589400.0
2014-03-21 12:00:00	SPY	ETF	187.76	187.88	187.43	187.47	8711481.0
2014-03-21 13:00:00	SPY	ETF	187.468	187.51	186.72	186.81	14011244.0
2014-03-21 14:00:00	SPY	ETF	186.81	186.97	186.17	186.6499	17282489.0
2014-03-21 15:00:00	SPY	ETF	186.65	186.695	186.03	186.21	28001851.0
2014-03-21 16:00:00	SPY	ETF	186.2	187.8	186.1	186.34	13970268.0
2014-03-21 17:00:00	SPY	ETF	186.33	187.6862	186.09	186.11	4527899.0
2014-03-21 18:00:00	SPY	ETF	186.11	186.14	186.07	186.13	49942.0
2014-03-21 19:00:00	SPY	ETF	186.13	186.16	186.1	186.13	13484.0
2014-03-21 04:00:00	QQQ	ETF	90.36	90.55	90.36	90.55	2200.0
2014-03-21 05:00:00	QQQ	ETF	90.46	90.51	90.46	90.51	12600.0
2014-03-21 06:00:00	QQQ	ETF	90.5	90.52	90.42	90.44	9600.0
2014-03-21 07:00:00	QQQ	ETF	90.42	90.52	90.42	90.44	12800.0
2014-03-21 08:00:00	QQQ	ETF	90.5	90.5	90.42	90.46	50000.0
2014-03-21 09:00:00	QQQ	ETF	90.45	90.73	89.89	89.89	11001795.0
2014-03-21 10:00:00	QQQ	ETF	89.9	89.9899	89.381	89.77	11645782.0
2014-03-21 11:00:00	QQQ	ETF	89.77	89.93	89.62	89.81	4050747.0
2014-03-21 12:00:00	QQQ	ETF	89.81	89.93	89.68	89.69	2377680.0
2014-03-21 13:00:00	QQQ	ETF	89.69	89.6985	89.31	89.34	5195107.0
2014-03-21 14:00:00	QQQ	ETF	89.35	89.45	88.89	89.0801	6202719.0
2014-03-21 15:00:00	QQQ	ETF	89.08	89.11	88.825	88.99	9316034.0
2014-03-21 16:00:00	QQQ	ETF	88.99	90.0682	88.95	89.02	4768579.0
2014-03-21 17:00:00	QQQ	ETF	89.02	89.1	88.96	89.1	721264.0
2014-03-21 18:00:00	QQQ	ETF	89.1	89.12	89.05	89.08	48266.0
2014-03-21 19:00:00	QQQ	ETF	89.05	89.11	89.05	89.11	2912.0
2014-03-21 07:00:00	IWM	ETF	119.68	119.77	119.68	119.7	26950.0
2014-03-21 08:00:00	IWM	ETF	119.66	119.71	119.56	119.61	128344.0
2014-03-21 09:00:00	IWM	ETF	119.63	119.87	119.24	119.46	5849351.0
2014-03-21 10:00:00	IWM	ETF	119.46	119.73	119.06	119.69	7407792.0
2014-03-21 11:00:00	IWM	ETF	119.7	120.26	119.62	120.07	5013688.0
2014-03-21 12:00:00	IWM	ETF	120.07	120.105	119.68	119.69	2151227.0
2014-03-21 13:00:00	IWM	ETF	119.7	119.75	119.02	119.11	3956721.0
2014-03-21 14:00:00	IWM	ETF	119.11	119.35	118.68	119.05	5495016.0
2014-03-21 15:00:00	IWM	ETF	119.05	119.11	118.56	118.61	9363669.0
2014-03-21 16:00:00	IWM	ETF	118.61	120.1111	118.57	118.65	1793855.0
2014-03-21 17:00:00	IWM	ETF	118.67	118.67	118.55	118.56	54180.0
2014-03-21 18:00:00	IWM	ETF	118.61	118.64	118.6	118.62	748862.0
2014-03-21 19:00:00	IWM	ETF	118.67	118.67	118.5	118.51	6946.0
2014-03-21 08:00:00	DIA	ETF	163.3	163.3	163.3	163.3	1400.0
2014-03-21 09:00:00	DIA	ETF	163.33	164.08	163.33	163.65	1136780.0
2014-03-21 10:00:00	DIA	ETF	163.64	164.04	163.33	163.93	1768433.0
2014-03-21 11:00:00	DIA	ETF	163.93	164.2	163.83	163.86	875652.0
2014-03-21 12:00:00	DIA	ETF	163.86	164.12	163.65	163.71	471083.0

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

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