PREVIEW / etf_1hour / 2017-10-03

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-03.parquet
  size:    283 KB
  rows:    9,241

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
2017-10-03 04:00:00	SPY	ETF	252.45	252.46	252.4	252.46	2610.0
2017-10-03 05:00:00	SPY	ETF	252.45	252.45	252.43	252.43	4200.0
2017-10-03 06:00:00	SPY	ETF	252.38	252.5	252.38	252.43	3900.0
2017-10-03 07:00:00	SPY	ETF	252.43	252.45	252.38	252.45	43714.0
2017-10-03 08:00:00	SPY	ETF	252.42	252.53	252.4	252.5	188334.0
2017-10-03 09:00:00	SPY	ETF	252.5	252.58	252.27	252.52	5013826.0
2017-10-03 10:00:00	SPY	ETF	252.525	252.55	252.27	252.39	12269587.0
2017-10-03 11:00:00	SPY	ETF	252.385	252.5	252.23	252.47	6117112.0
2017-10-03 12:00:00	SPY	ETF	252.47	252.58	252.46	252.58	4216259.0
2017-10-03 13:00:00	SPY	ETF	252.58	252.62	252.51	252.575	3181745.0
2017-10-03 14:00:00	SPY	ETF	252.58	252.735	252.5734	252.72	6012371.0
2017-10-03 15:00:00	SPY	ETF	252.71	252.89	252.63	252.85	10992075.0
2017-10-03 16:00:00	SPY	ETF	252.85	252.99	252.77	252.94	17356351.0
2017-10-03 17:00:00	SPY	ETF	252.93	252.96	252.92	252.96	157199.0
2017-10-03 18:00:00	SPY	ETF	252.95	252.98	252.8	252.84	109621.0
2017-10-03 19:00:00	SPY	ETF	252.86	252.88	252.82	252.82	47511.0
2017-10-03 04:00:00	QQQ	ETF	145.7	145.7	145.68	145.68	320.0
2017-10-03 05:00:00	QQQ	ETF	145.69	145.69	145.69	145.69	400.0
2017-10-03 06:00:00	QQQ	ETF	145.55	145.62	145.55	145.62	5300.0
2017-10-03 07:00:00	QQQ	ETF	145.64	145.64	145.53	145.61	9720.0
2017-10-03 08:00:00	QQQ	ETF	145.61	145.76	145.58	145.71	87054.0
2017-10-03 09:00:00	QQQ	ETF	145.72	146.06	145.64	145.93	2947843.0
2017-10-03 10:00:00	QQQ	ETF	145.94	145.96	145.45	145.8	3083450.0
2017-10-03 11:00:00	QQQ	ETF	145.79	145.86	145.63	145.74	1436664.0
2017-10-03 12:00:00	QQQ	ETF	145.75	145.93	145.74	145.825	1233397.0
2017-10-03 13:00:00	QQQ	ETF	145.83	145.89	145.77	145.841	1045200.0
2017-10-03 14:00:00	QQQ	ETF	145.84	145.9	145.8	145.87	796843.0
2017-10-03 15:00:00	QQQ	ETF	145.87	145.96	145.775	145.92	3518816.0
2017-10-03 16:00:00	QQQ	ETF	145.91	145.95	145.83	145.9	508396.0
2017-10-03 17:00:00	QQQ	ETF	145.97	145.97	145.87	145.9	4825.0
2017-10-03 18:00:00	QQQ	ETF	145.89	145.89	145.81	145.82	12050.0
2017-10-03 19:00:00	QQQ	ETF	145.81	145.83	145.81	145.83	17000.0
2017-10-03 04:00:00	IWM	ETF	150.0	150.0	149.99	149.99	503.0
2017-10-03 05:00:00	IWM	ETF	150.04	150.08	150.04	150.07	4265.0
2017-10-03 06:00:00	IWM	ETF	150.06	150.06	150.0	150.04	5655.0
2017-10-03 07:00:00	IWM	ETF	150.03	150.09	150.01	150.09	21425.0
2017-10-03 08:00:00	IWM	ETF	150.1	150.25	150.09	150.23	104734.0
2017-10-03 09:00:00	IWM	ETF	150.24	150.27	149.83	149.99	3213700.0
2017-10-03 10:00:00	IWM	ETF	149.985	150.0	149.43	149.68	6264933.0
2017-10-03 11:00:00	IWM	ETF	149.67	149.7256	149.33	149.585	2279893.0
2017-10-03 12:00:00	IWM	ETF	149.59	149.75	149.46	149.595	1139438.0
2017-10-03 13:00:00	IWM	ETF	149.6	149.71	149.53	149.66	1091034.0
2017-10-03 14:00:00	IWM	ETF	149.66	149.94	149.66	149.87	2236702.0
2017-10-03 15:00:00	IWM	ETF	149.875	150.32	149.83	150.32	4742871.0
2017-10-03 16:00:00	IWM	ETF	150.31	150.48	150.1829	150.47	1219001.0
2017-10-03 17:00:00	IWM	ETF	150.47	150.47	150.38	150.4	10784.0
2017-10-03 18:00:00	IWM	ETF	150.45	150.45	150.38	150.38	10403.0
2017-10-03 19:00:00	IWM	ETF	150.37	150.4	150.3	150.3	36965.0
2017-10-03 07:00:00	DIA	ETF	225.9	225.9	225.71	225.71	1416.0
2017-10-03 08:00:00	DIA	ETF	225.75	225.92	225.75	225.75	4325.0

> showing 50 of 9,241 rows — these rows as CSV

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