PREVIEW / etf_1hour / 2016-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-17.parquet
  size:    246 KB
  rows:    7,891

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-06-17 04:00:00	SPY	ETF	207.49	207.73	206.94	207.26	38637.0
2016-06-17 05:00:00	SPY	ETF	207.26	207.42	207.12	207.16	92077.0
2016-06-17 06:00:00	SPY	ETF	207.16	207.19	207.0	207.04	232845.0
2016-06-17 07:00:00	SPY	ETF	207.0	207.17	206.84	207.15	410526.0
2016-06-17 08:00:00	SPY	ETF	207.09	207.451	206.85	207.25	1400717.0
2016-06-17 09:00:00	SPY	ETF	207.25	207.26	206.56	206.91	16784620.0
2016-06-17 10:00:00	SPY	ETF	206.91	207.1	206.09	206.31	25974102.0
2016-06-17 11:00:00	SPY	ETF	206.31	206.345	205.75	206.13	13422533.0
2016-06-17 12:00:00	SPY	ETF	206.13	206.66	206.12	206.29	9673959.0
2016-06-17 13:00:00	SPY	ETF	206.281	206.72	206.035	206.58	7490817.0
2016-06-17 14:00:00	SPY	ETF	206.5762	207.02	206.34	206.86	15216075.0
2016-06-17 15:00:00	SPY	ETF	206.86	206.92	206.42	206.58	18040530.0
2016-06-17 16:00:00	SPY	ETF	206.58	206.66	206.17	206.42	5718568.0
2016-06-17 17:00:00	SPY	ETF	206.42	206.72	206.36	206.64	676977.0
2016-06-17 18:00:00	SPY	ETF	206.64	206.68	206.4	206.41	138861.0
2016-06-17 19:00:00	SPY	ETF	206.42	206.5	206.27	206.27	40817.0
2016-06-17 04:00:00	QQQ	ETF	107.75	107.75	107.61	107.63	5623.0
2016-06-17 05:00:00	QQQ	ETF	107.76	107.76	107.76	107.76	100.0
2016-06-17 06:00:00	QQQ	ETF	107.7	107.7	107.63	107.63	27100.0
2016-06-17 07:00:00	QQQ	ETF	107.62	107.71	107.55	107.71	91124.0
2016-06-17 08:00:00	QQQ	ETF	107.58	107.77	107.55	107.65	123591.0
2016-06-17 09:00:00	QQQ	ETF	107.62	107.62	106.77	106.91	5393413.0
2016-06-17 10:00:00	QQQ	ETF	106.91	106.959	106.36	106.44	4168164.0
2016-06-17 11:00:00	QQQ	ETF	106.43	106.5	106.24	106.37	3278961.0
2016-06-17 12:00:00	QQQ	ETF	106.38	106.68	106.38	106.51	2091099.0
2016-06-17 13:00:00	QQQ	ETF	106.51	106.81	106.38	106.69	2269796.0
2016-06-17 14:00:00	QQQ	ETF	106.68	106.8	106.53	106.66	2265796.0
2016-06-17 15:00:00	QQQ	ETF	106.68	106.69	106.37	106.52	5142495.0
2016-06-17 16:00:00	QQQ	ETF	106.51	106.57	106.33	106.48	1281933.0
2016-06-17 17:00:00	QQQ	ETF	106.44	106.49	106.4	106.47	361918.0
2016-06-17 18:00:00	QQQ	ETF	106.47	106.48	106.47	106.48	1298.0
2016-06-17 19:00:00	QQQ	ETF	106.41	106.48	106.39	106.39	7824.0
2016-06-17 07:00:00	IWM	ETF	114.36	114.56	114.34	114.56	53591.0
2016-06-17 08:00:00	IWM	ETF	114.59	114.79	114.56	114.71	224991.0
2016-06-17 09:00:00	IWM	ETF	114.6	114.6	113.92	114.53	4789921.0
2016-06-17 10:00:00	IWM	ETF	114.53	114.92	114.26	114.53	3482782.0
2016-06-17 11:00:00	IWM	ETF	114.525	114.56	113.89	114.2	3954129.0
2016-06-17 12:00:00	IWM	ETF	114.2	114.44	113.795	113.9	2644723.0
2016-06-17 13:00:00	IWM	ETF	113.8959	114.31	113.68	114.12	2442417.0
2016-06-17 14:00:00	IWM	ETF	114.12	114.505	113.96	114.295	2116099.0
2016-06-17 15:00:00	IWM	ETF	114.31	114.35	114.02	114.07	4486364.0
2016-06-17 16:00:00	IWM	ETF	114.07	114.1211	113.88	114.0	1732187.0
2016-06-17 17:00:00	IWM	ETF	114.0	114.09	113.98	114.09	89347.0
2016-06-17 18:00:00	IWM	ETF	114.03	114.03	114.0	114.0	328.0
2016-06-17 19:00:00	IWM	ETF	113.99	113.99	113.91	113.91	1058.0
2016-06-17 04:00:00	DIA	ETF	176.86	176.86	176.86	176.86	200.0
2016-06-17 07:00:00	DIA	ETF	177.08	177.08	176.93	176.94	1862.0
2016-06-17 08:00:00	DIA	ETF	177.0	177.15	176.99	177.11	1515.0
2016-06-17 09:00:00	DIA	ETF	176.98	177.15	176.52	176.78	498711.0
2016-06-17 10:00:00	DIA	ETF	176.78	177.01	176.17	176.27	416294.0

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

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