PREVIEW / etf_1hour / 2016-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-09.parquet
  size:    256 KB
  rows:    8,232

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-02-09 04:00:00	SPY	ETF	185.52	186.21	185.3	185.38	87065.0
2016-02-09 05:00:00	SPY	ETF	185.12	185.92	185.1	185.63	47454.0
2016-02-09 06:00:00	SPY	ETF	185.6	185.65	184.73	185.0	158310.0
2016-02-09 07:00:00	SPY	ETF	185.06	185.15	184.0	184.21	832808.0
2016-02-09 08:00:00	SPY	ETF	183.99	186.04	183.38	183.59	2228339.0
2016-02-09 09:00:00	SPY	ETF	183.61	185.82	183.2	185.24	24375788.0
2016-02-09 10:00:00	SPY	ETF	185.23	186.29	183.99	184.115	31153975.0
2016-02-09 11:00:00	SPY	ETF	184.12	185.74	184.04	184.585	22086502.0
2016-02-09 12:00:00	SPY	ETF	184.58	185.06	184.21	184.38	15501628.0
2016-02-09 13:00:00	SPY	ETF	184.38	184.57	183.55	184.38	17901791.0
2016-02-09 14:00:00	SPY	ETF	184.38	185.96	184.3401	185.72	23001656.0
2016-02-09 15:00:00	SPY	ETF	185.72	186.94	185.0	185.38	36033664.0
2016-02-09 16:00:00	SPY	ETF	185.37	185.62	185.1165	185.2	8888614.0
2016-02-09 17:00:00	SPY	ETF	185.19	185.49	185.17	185.49	770552.0
2016-02-09 18:00:00	SPY	ETF	185.49	186.28	185.42	185.9	224874.0
2016-02-09 19:00:00	SPY	ETF	185.87	185.95	185.31	185.36	156044.0
2016-02-09 04:00:00	QQQ	ETF	96.99	97.09	96.63	96.64	600.0
2016-02-09 05:00:00	QQQ	ETF	96.77	96.83	96.62	96.82	5262.0
2016-02-09 06:00:00	QQQ	ETF	96.72	96.72	96.23	96.28	12180.0
2016-02-09 07:00:00	QQQ	ETF	96.43	96.43	95.89	96.04	220699.0
2016-02-09 08:00:00	QQQ	ETF	96.06	96.18	95.33	95.41	387426.0
2016-02-09 09:00:00	QQQ	ETF	95.41	97.352	95.18	96.885	11413059.0
2016-02-09 10:00:00	QQQ	ETF	96.88	97.78	95.93	95.99	12443362.0
2016-02-09 11:00:00	QQQ	ETF	95.99	97.01	95.94	96.24	6868210.0
2016-02-09 12:00:00	QQQ	ETF	96.24	96.57	95.77	95.85	5799177.0
2016-02-09 13:00:00	QQQ	ETF	95.845	95.92	95.25	95.81	6480131.0
2016-02-09 14:00:00	QQQ	ETF	95.81	96.93	95.79	96.78	7113939.0
2016-02-09 15:00:00	QQQ	ETF	96.77	97.54	96.16	96.31	11642212.0
2016-02-09 16:00:00	QQQ	ETF	96.31	96.47	96.21	96.26	1708973.0
2016-02-09 17:00:00	QQQ	ETF	96.29	96.29	96.19	96.29	9502.0
2016-02-09 18:00:00	QQQ	ETF	96.31	96.8	96.29	96.73	47913.0
2016-02-09 19:00:00	QQQ	ETF	96.66	96.7	96.38	96.4	23459.0
2016-02-09 04:00:00	IWM	ETF	96.06	96.85	96.06	96.38	7040.0
2016-02-09 05:00:00	IWM	ETF	96.34	96.53	96.34	96.52	2000.0
2016-02-09 06:00:00	IWM	ETF	96.45	96.45	95.98	96.1	8320.0
2016-02-09 07:00:00	IWM	ETF	96.09	96.09	95.25	95.44	194902.0
2016-02-09 08:00:00	IWM	ETF	95.46	95.62	94.97	95.15	189258.0
2016-02-09 09:00:00	IWM	ETF	95.15	96.96	95.01	96.466	9290646.0
2016-02-09 10:00:00	IWM	ETF	96.47	97.13	95.4179	95.45	8936230.0
2016-02-09 11:00:00	IWM	ETF	95.44	96.36	95.42	95.65	5798099.0
2016-02-09 12:00:00	IWM	ETF	95.64	96.06	95.551	95.64	3814886.0
2016-02-09 13:00:00	IWM	ETF	95.63	95.69	95.02	95.4	4682881.0
2016-02-09 14:00:00	IWM	ETF	95.4	96.31	95.38	96.22	6105219.0
2016-02-09 15:00:00	IWM	ETF	96.22	96.88	95.63	95.83	11287555.0
2016-02-09 16:00:00	IWM	ETF	95.84	95.9	95.59	95.59	1721088.0
2016-02-09 17:00:00	IWM	ETF	95.6	95.78	95.57	95.78	16852.0
2016-02-09 18:00:00	IWM	ETF	95.84	95.91	95.84	95.91	3839.0
2016-02-09 19:00:00	IWM	ETF	96.0	96.0	95.75	95.83	6100.0
2016-02-09 07:00:00	DIA	ETF	159.54	159.54	159.15	159.15	1503.0
2016-02-09 08:00:00	DIA	ETF	159.35	159.35	158.69	158.8	44494.0

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

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