PREVIEW / etf_1hour / 2015-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-02-27.parquet
  size:    238 KB
  rows:    7,596

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
2015-02-27 04:00:00	SPY	ETF	211.16	211.17	211.09	211.09	2859.0
2015-02-27 05:00:00	SPY	ETF	211.14	211.18	211.05	211.05	14412.0
2015-02-27 06:00:00	SPY	ETF	211.08	211.23	211.08	211.2	4517.0
2015-02-27 07:00:00	SPY	ETF	211.18	211.25	211.08	211.21	87494.0
2015-02-27 08:00:00	SPY	ETF	211.24	211.4	211.1	211.18	315246.0
2015-02-27 09:00:00	SPY	ETF	211.19	211.44	210.84	211.07	10808889.0
2015-02-27 10:00:00	SPY	ETF	211.06	211.55	211.02	211.52	10267662.0
2015-02-27 11:00:00	SPY	ETF	211.52	211.5399	211.17	211.39	8538803.0
2015-02-27 12:00:00	SPY	ETF	211.38	211.58	211.3	211.36	6581827.0
2015-02-27 13:00:00	SPY	ETF	211.36	211.4	211.1	211.27	6129993.0
2015-02-27 14:00:00	SPY	ETF	211.28	211.35	210.78	210.91	10974431.0
2015-02-27 15:00:00	SPY	ETF	210.9132	211.06	210.64	210.69	28787950.0
2015-02-27 16:00:00	SPY	ETF	210.69	211.5	210.6	211.0	17445584.0
2015-02-27 17:00:00	SPY	ETF	211.01	211.03	210.66	210.93	2174426.0
2015-02-27 18:00:00	SPY	ETF	210.93	210.93	210.76	210.81	72682.0
2015-02-27 19:00:00	SPY	ETF	210.83	210.86	210.82	210.83	22200.0
2015-02-27 06:00:00	QQQ	ETF	108.8	108.8	108.8	108.8	100.0
2015-02-27 07:00:00	QQQ	ETF	108.8	108.8	108.73	108.78	21700.0
2015-02-27 08:00:00	QQQ	ETF	108.79	108.81	108.72	108.74	46526.0
2015-02-27 09:00:00	QQQ	ETF	108.77	108.91	108.52	108.78	3381131.0
2015-02-27 10:00:00	QQQ	ETF	108.78	108.9	108.62	108.8751	2450238.0
2015-02-27 11:00:00	QQQ	ETF	108.87	108.8751	108.661	108.77	1704408.0
2015-02-27 12:00:00	QQQ	ETF	108.76	108.82	108.67	108.685	1361993.0
2015-02-27 13:00:00	QQQ	ETF	108.68	108.72	108.48	108.61	2089994.0
2015-02-27 14:00:00	QQQ	ETF	108.61	108.65	108.25	108.365	2122927.0
2015-02-27 15:00:00	QQQ	ETF	108.37	108.48	108.23	108.38	5383033.0
2015-02-27 16:00:00	QQQ	ETF	108.38	108.888	108.3427	108.5	2989581.0
2015-02-27 17:00:00	QQQ	ETF	108.48	108.51	108.4	108.4	1742607.0
2015-02-27 18:00:00	QQQ	ETF	108.48	108.48	108.45	108.46	2600.0
2015-02-27 19:00:00	QQQ	ETF	108.46	108.5	108.46	108.49	7154.0
2015-02-27 07:00:00	IWM	ETF	122.96	122.98	122.92	122.95	11400.0
2015-02-27 08:00:00	IWM	ETF	122.95	123.03	122.9	122.97	56962.0
2015-02-27 09:00:00	IWM	ETF	122.95	123.18	122.8	122.92	2160918.0
2015-02-27 10:00:00	IWM	ETF	122.91	123.36	122.85	123.295	2337219.0
2015-02-27 11:00:00	IWM	ETF	123.281	123.2972	123.03	123.13	1574982.0
2015-02-27 12:00:00	IWM	ETF	123.134	123.27	123.1	123.14	1116932.0
2015-02-27 13:00:00	IWM	ETF	123.13	123.17	122.94	123.13	1707029.0
2015-02-27 14:00:00	IWM	ETF	123.14	123.19	122.93	122.98	1436326.0
2015-02-27 15:00:00	IWM	ETF	122.98	123.1	122.55	122.56	5712525.0
2015-02-27 16:00:00	IWM	ETF	122.55	122.86	122.55	122.82	1864629.0
2015-02-27 17:00:00	IWM	ETF	122.82	122.83	122.58	122.65	893569.0
2015-02-27 18:00:00	IWM	ETF	122.75	122.89	122.75	122.89	12577.0
2015-02-27 07:00:00	DIA	ETF	181.89	181.94	181.84	181.94	900.0
2015-02-27 08:00:00	DIA	ETF	181.9	181.94	181.83	181.83	11800.0
2015-02-27 09:00:00	DIA	ETF	181.94	181.94	181.47	181.66	483440.0
2015-02-27 10:00:00	DIA	ETF	181.62	181.92	181.59	181.88	465106.0
2015-02-27 11:00:00	DIA	ETF	181.87	181.87	181.57	181.77	291082.0
2015-02-27 12:00:00	DIA	ETF	181.77	181.87	181.67	181.71	162945.0
2015-02-27 13:00:00	DIA	ETF	181.72	181.77	181.56	181.68	209778.0
2015-02-27 14:00:00	DIA	ETF	181.685	181.76	181.28	181.35	299899.0

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

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