PREVIEW / etf_1hour / 2014-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-29.parquet
  size:    224 KB
  rows:    7,327

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-07-29 04:00:00	SPY	ETF	197.58	197.58	197.33	197.49	6994.0
2014-07-29 05:00:00	SPY	ETF	197.5	197.65	197.44	197.56	4100.0
2014-07-29 06:00:00	SPY	ETF	197.6	197.95	197.6	197.95	35766.0
2014-07-29 07:00:00	SPY	ETF	197.96	198.16	197.96	198.04	291783.0
2014-07-29 08:00:00	SPY	ETF	198.11	198.25	197.59	198.06	557396.0
2014-07-29 09:00:00	SPY	ETF	198.05	198.345	197.83	198.19	8098267.0
2014-07-29 10:00:00	SPY	ETF	198.19	198.45	198.04	198.07	10925463.0
2014-07-29 11:00:00	SPY	ETF	198.07	198.11	197.24	197.64	13167235.0
2014-07-29 12:00:00	SPY	ETF	197.64	198.05	197.58	198.02	8021741.0
2014-07-29 13:00:00	SPY	ETF	198.025	198.09	197.84	197.9299	5738447.0
2014-07-29 14:00:00	SPY	ETF	197.93	198.01	197.35	197.485	7796111.0
2014-07-29 15:00:00	SPY	ETF	197.48	197.55	196.94	196.95	18761470.0
2014-07-29 16:00:00	SPY	ETF	196.94	197.8098	196.7	196.95	6165059.0
2014-07-29 17:00:00	SPY	ETF	196.95	196.97	196.85	196.92	97240.0
2014-07-29 18:00:00	SPY	ETF	196.91	197.03	196.89	196.92	40560.0
2014-07-29 19:00:00	SPY	ETF	196.94	196.97	196.92	196.97	20868.0
2014-07-29 04:00:00	QQQ	ETF	96.64	96.68	96.64	96.68	4500.0
2014-07-29 05:00:00	QQQ	ETF	96.75	96.78	96.75	96.78	1100.0
2014-07-29 06:00:00	QQQ	ETF	96.75	96.85	96.75	96.85	2600.0
2014-07-29 07:00:00	QQQ	ETF	96.85	97.07	96.84	96.93	32950.0
2014-07-29 08:00:00	QQQ	ETF	96.91	97.03	96.88	96.92	156343.0
2014-07-29 09:00:00	QQQ	ETF	96.93	97.13	96.82	97.02	3260987.0
2014-07-29 10:00:00	QQQ	ETF	97.03	97.2	96.96	97.0	3776798.0
2014-07-29 11:00:00	QQQ	ETF	97.0	97.048	96.52	96.818	4218060.0
2014-07-29 12:00:00	QQQ	ETF	96.819	96.98	96.79	96.9201	2202862.0
2014-07-29 13:00:00	QQQ	ETF	96.92	97.03	96.87	96.98	1787673.0
2014-07-29 14:00:00	QQQ	ETF	96.9801	97.08	96.7	96.835	3479616.0
2014-07-29 15:00:00	QQQ	ETF	96.82	96.875	96.57	96.6	5151735.0
2014-07-29 16:00:00	QQQ	ETF	96.6	96.973	96.49	96.71	1717713.0
2014-07-29 17:00:00	QQQ	ETF	96.71	96.75	96.68	96.72	111309.0
2014-07-29 18:00:00	QQQ	ETF	96.72	96.73	96.67	96.67	14200.0
2014-07-29 19:00:00	QQQ	ETF	96.69	96.71	96.68	96.69	8745.0
2014-07-29 06:00:00	IWM	ETF	112.9	112.99	112.9	112.99	1600.0
2014-07-29 07:00:00	IWM	ETF	113.35	113.36	113.25	113.26	44500.0
2014-07-29 08:00:00	IWM	ETF	113.26	113.54	113.26	113.43	155135.0
2014-07-29 09:00:00	IWM	ETF	113.44	113.77	113.1	113.62	3804045.0
2014-07-29 10:00:00	IWM	ETF	113.64	114.11	113.58	113.87	5144526.0
2014-07-29 11:00:00	IWM	ETF	113.87	113.95	113.03	113.491	5717642.0
2014-07-29 12:00:00	IWM	ETF	113.49	113.85	113.37	113.79	2038758.0
2014-07-29 13:00:00	IWM	ETF	113.785	113.91	113.66	113.81	1438387.0
2014-07-29 14:00:00	IWM	ETF	113.815	113.91	113.42	113.53	2927978.0
2014-07-29 15:00:00	IWM	ETF	113.535	113.74	113.29	113.34	4988280.0
2014-07-29 16:00:00	IWM	ETF	113.34	113.46	113.1037	113.46	1490501.0
2014-07-29 17:00:00	IWM	ETF	113.34	113.46	113.34	113.42	772409.0
2014-07-29 19:00:00	IWM	ETF	113.44	113.61	113.37	113.6	11457.0
2014-07-29 06:00:00	DIA	ETF	169.54	169.54	169.52	169.54	2100.0
2014-07-29 07:00:00	DIA	ETF	169.76	169.81	169.76	169.81	1150.0
2014-07-29 08:00:00	DIA	ETF	169.8	169.97	169.73	169.8	7190.0
2014-07-29 09:00:00	DIA	ETF	169.84	170.02	169.61	169.92	574405.0
2014-07-29 10:00:00	DIA	ETF	169.94	170.19	169.85	169.87	484857.0

> showing 50 of 7,327 rows — these rows as CSV

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