PREVIEW / etf_1hour / 2016-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-04.parquet
  size:    261 KB
  rows:    8,336

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
2016-10-04 04:00:00	SPY	ETF	216.03	216.23	216.03	216.19	5621.0
2016-10-04 05:00:00	SPY	ETF	216.16	216.34	216.08	216.09	18291.0
2016-10-04 06:00:00	SPY	ETF	216.0	216.01	215.7	215.74	25786.0
2016-10-04 07:00:00	SPY	ETF	215.79	215.88	215.71	215.86	124244.0
2016-10-04 08:00:00	SPY	ETF	215.86	215.89	215.59	215.77	227506.0
2016-10-04 09:00:00	SPY	ETF	215.76	216.17	215.66	216.02	8704449.0
2016-10-04 10:00:00	SPY	ETF	216.02	216.0792	215.15	215.82	20751741.0
2016-10-04 11:00:00	SPY	ETF	215.815	215.99	214.87	215.32	25183069.0
2016-10-04 12:00:00	SPY	ETF	215.31	215.63	215.01	215.06	8434718.0
2016-10-04 13:00:00	SPY	ETF	215.05	215.12	214.25	214.47	16399528.0
2016-10-04 14:00:00	SPY	ETF	214.47	214.74	213.99	214.02	11922107.0
2016-10-04 15:00:00	SPY	ETF	214.02	214.92	213.99	214.72	22348458.0
2016-10-04 16:00:00	SPY	ETF	214.72	215.7442	214.53	214.75	3771927.0
2016-10-04 17:00:00	SPY	ETF	214.75	214.83	214.75	214.8	164135.0
2016-10-04 18:00:00	SPY	ETF	214.8	214.85	214.75	214.8	104678.0
2016-10-04 19:00:00	SPY	ETF	214.81	214.83	214.65	214.66	70283.0
2016-10-04 04:00:00	QQQ	ETF	118.88	118.88	118.88	118.88	9960.0
2016-10-04 05:00:00	QQQ	ETF	118.95	119.0	118.9	118.9	39976.0
2016-10-04 06:00:00	QQQ	ETF	118.9	118.9	118.73	118.74	3545.0
2016-10-04 07:00:00	QQQ	ETF	118.79	118.81	118.74	118.81	13675.0
2016-10-04 08:00:00	QQQ	ETF	118.82	118.82	118.69	118.76	45369.0
2016-10-04 09:00:00	QQQ	ETF	118.75	119.16	118.75	119.11	2154988.0
2016-10-04 10:00:00	QQQ	ETF	119.1	119.11	118.5848	118.9	2600098.0
2016-10-04 11:00:00	QQQ	ETF	118.91	118.97	118.42	118.59	4633816.0
2016-10-04 12:00:00	QQQ	ETF	118.59	118.76	118.45	118.4955	2021016.0
2016-10-04 13:00:00	QQQ	ETF	118.49	118.539	118.06	118.19	2246021.0
2016-10-04 14:00:00	QQQ	ETF	118.19	118.31	117.92	117.95	1843720.0
2016-10-04 15:00:00	QQQ	ETF	117.94	118.505	117.928	118.38	3098324.0
2016-10-04 16:00:00	QQQ	ETF	118.38	118.45	118.29	118.38	519509.0
2016-10-04 17:00:00	QQQ	ETF	118.4	118.41	118.35	118.35	2400.0
2016-10-04 18:00:00	QQQ	ETF	118.37	118.39	118.37	118.39	3992.0
2016-10-04 19:00:00	QQQ	ETF	118.37	118.38	118.31	118.31	6750.0
2016-10-04 04:00:00	IWM	ETF	124.09	124.23	124.09	124.23	368.0
2016-10-04 05:00:00	IWM	ETF	124.19	124.19	124.19	124.19	1400.0
2016-10-04 06:00:00	IWM	ETF	124.0	124.0	123.87	123.87	1600.0
2016-10-04 07:00:00	IWM	ETF	123.97	123.97	123.93	123.93	4700.0
2016-10-04 08:00:00	IWM	ETF	123.96	123.96	123.79	123.87	19584.0
2016-10-04 09:00:00	IWM	ETF	123.86	124.27	123.81	124.01	2033516.0
2016-10-04 10:00:00	IWM	ETF	124.02	124.31	123.47	124.12	3378519.0
2016-10-04 11:00:00	IWM	ETF	124.13	124.15	123.31	123.76	4396861.0
2016-10-04 12:00:00	IWM	ETF	123.78	123.83	123.24	123.31	2483702.0
2016-10-04 13:00:00	IWM	ETF	123.31	123.36	122.72	122.82	3772975.0
2016-10-04 14:00:00	IWM	ETF	122.81	123.055	122.65	122.7	2456361.0
2016-10-04 15:00:00	IWM	ETF	122.69	123.31	122.68	123.22	3480779.0
2016-10-04 16:00:00	IWM	ETF	123.21	123.26	123.11	123.25	1093272.0
2016-10-04 17:00:00	IWM	ETF	123.23	123.24	123.19	123.24	3573.0
2016-10-04 18:00:00	IWM	ETF	123.3	123.3	123.3	123.3	13707.0
2016-10-04 19:00:00	IWM	ETF	123.3	123.3	123.22	123.23	1821.0
2016-10-04 09:00:00	DIA	ETF	182.51	182.9	182.48	182.82	201038.0
2016-10-04 10:00:00	DIA	ETF	182.83	182.93	181.88	182.66	575945.0

> showing 50 of 8,336 rows — these rows as CSV

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