PREVIEW / etf_1hour / 2014-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-27.parquet
  size:    231 KB
  rows:    7,249

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-01-27 04:00:00	SPY	ETF	179.05	179.28	178.71	179.13	99551.0
2014-01-27 05:00:00	SPY	ETF	179.13	179.16	178.67	179.13	57479.0
2014-01-27 06:00:00	SPY	ETF	179.11	179.49	178.88	179.43	246097.0
2014-01-27 07:00:00	SPY	ETF	179.43	179.63	179.27	179.31	1587411.0
2014-01-27 08:00:00	SPY	ETF	179.28	179.5	178.73	179.35	1431534.0
2014-01-27 09:00:00	SPY	ETF	179.34	179.52	178.88	179.3	19281349.0
2014-01-27 10:00:00	SPY	ETF	179.3	179.4	178.07	178.36	30773395.0
2014-01-27 11:00:00	SPY	ETF	178.35	178.61	177.75	177.83	20896827.0
2014-01-27 12:00:00	SPY	ETF	177.8399	177.8495	177.12	177.58	24879461.0
2014-01-27 13:00:00	SPY	ETF	177.58	178.735	177.47	178.43	22104264.0
2014-01-27 14:00:00	SPY	ETF	178.44	179.27	178.435	179.2	18442236.0
2014-01-27 15:00:00	SPY	ETF	179.19	179.25	177.98	178.01	26346430.0
2014-01-27 16:00:00	SPY	ETF	178.01	179.0653	177.56	177.74	12471365.0
2014-01-27 17:00:00	SPY	ETF	177.73	177.77	177.43	177.56	473940.0
2014-01-27 18:00:00	SPY	ETF	177.56	178.08	177.54	177.96	601791.0
2014-01-27 19:00:00	SPY	ETF	177.97	178.05	177.88	178.04	280360.0
2014-01-27 04:00:00	QQQ	ETF	86.8	86.85	86.8	86.83	9398.0
2014-01-27 05:00:00	QQQ	ETF	86.83	86.83	86.65	86.74	7800.0
2014-01-27 06:00:00	QQQ	ETF	86.74	86.86	86.73	86.86	5220.0
2014-01-27 07:00:00	QQQ	ETF	86.85	86.95	86.79	86.8	79670.0
2014-01-27 08:00:00	QQQ	ETF	86.79	86.94	86.74	86.81	184609.0
2014-01-27 09:00:00	QQQ	ETF	86.81	86.89	86.49	86.68	7819716.0
2014-01-27 10:00:00	QQQ	ETF	86.68	86.78	85.68	86.07	12729992.0
2014-01-27 11:00:00	QQQ	ETF	86.06	86.23	85.8	85.84	6167030.0
2014-01-27 12:00:00	QQQ	ETF	85.83	85.84	85.25	85.6	11311782.0
2014-01-27 13:00:00	QQQ	ETF	85.6	86.27	85.53	86.16	5263437.0
2014-01-27 14:00:00	QQQ	ETF	86.16	86.62	86.16	86.56	5279402.0
2014-01-27 15:00:00	QQQ	ETF	86.56	86.6	85.91	85.93	6510301.0
2014-01-27 16:00:00	QQQ	ETF	85.92	86.756	85.24	85.34	3381809.0
2014-01-27 17:00:00	QQQ	ETF	85.33	85.33	85.05	85.13	147714.0
2014-01-27 18:00:00	QQQ	ETF	85.1	85.32	85.09	85.24	112999.0
2014-01-27 19:00:00	QQQ	ETF	85.25	85.33	85.22	85.33	18570.0
2014-01-27 04:00:00	IWM	ETF	113.88	113.92	113.81	113.81	2200.0
2014-01-27 05:00:00	IWM	ETF	113.81	113.81	113.72	113.8	300.0
2014-01-27 06:00:00	IWM	ETF	113.75	114.09	113.75	114.09	10100.0
2014-01-27 07:00:00	IWM	ETF	114.03	114.22	114.02	114.02	272900.0
2014-01-27 08:00:00	IWM	ETF	114.0	114.07	113.3	114.04	562294.0
2014-01-27 09:00:00	IWM	ETF	114.03	114.04	113.17	113.42	6346112.0
2014-01-27 10:00:00	IWM	ETF	113.4199	113.57	111.965	112.36	12487745.0
2014-01-27 11:00:00	IWM	ETF	112.35	112.48	111.645	111.75	5591626.0
2014-01-27 12:00:00	IWM	ETF	111.74	111.77	111.15	111.51	7074105.0
2014-01-27 13:00:00	IWM	ETF	111.5	112.37	111.47	112.2099	6176645.0
2014-01-27 14:00:00	IWM	ETF	112.21	112.99	112.21	112.95	6265200.0
2014-01-27 15:00:00	IWM	ETF	112.95	112.95	111.8	111.8	8168095.0
2014-01-27 16:00:00	IWM	ETF	111.81	113.5395	111.37	111.79	2966004.0
2014-01-27 17:00:00	IWM	ETF	111.78	111.79	111.6	111.65	51940.0
2014-01-27 18:00:00	IWM	ETF	111.74	111.83	111.72	111.81	11098.0
2014-01-27 19:00:00	IWM	ETF	111.86	111.89	111.71	111.84	3835.0
2014-01-27 07:00:00	DIA	ETF	158.92	159.12	158.92	159.0	13500.0
2014-01-27 08:00:00	DIA	ETF	158.861	159.12	158.74	159.02	18982.0

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

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