PREVIEW / etf_1hour / 2017-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-19.parquet
  size:    275 KB
  rows:    8,820

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-04-19 04:00:00	SPY	ETF	234.05	234.34	234.05	234.34	2250.0
2017-04-19 05:00:00	SPY	ETF	234.33	234.49	234.33	234.43	10571.0
2017-04-19 06:00:00	SPY	ETF	234.48	234.5	234.27	234.35	150056.0
2017-04-19 07:00:00	SPY	ETF	234.37	234.52	234.33	234.5	146576.0
2017-04-19 08:00:00	SPY	ETF	234.5	234.69	234.33	234.51	322412.0
2017-04-19 09:00:00	SPY	ETF	234.5	234.95	234.41	234.89	7528212.0
2017-04-19 10:00:00	SPY	ETF	234.9	234.93	234.32	234.49	6978211.0
2017-04-19 11:00:00	SPY	ETF	234.48	234.7399	234.4	234.4399	4941160.0
2017-04-19 12:00:00	SPY	ETF	234.435	234.46	234.05	234.29	5081199.0
2017-04-19 13:00:00	SPY	ETF	234.29	234.3	233.88	234.0965	5491879.0
2017-04-19 14:00:00	SPY	ETF	234.1	234.18	233.39	233.5365	8315653.0
2017-04-19 15:00:00	SPY	ETF	233.535	233.74	233.18	233.47	20080844.0
2017-04-19 16:00:00	SPY	ETF	233.48	233.58	233.27	233.27	6975353.0
2017-04-19 17:00:00	SPY	ETF	233.28	233.44	233.26	233.36	836826.0
2017-04-19 18:00:00	SPY	ETF	233.36	233.64	233.3	233.6	150486.0
2017-04-19 19:00:00	SPY	ETF	233.58	233.63	233.49	233.52	69766.0
2017-04-19 04:00:00	QQQ	ETF	131.49	131.58	131.49	131.55	5530.0
2017-04-19 05:00:00	QQQ	ETF	131.59	131.73	131.59	131.72	17040.0
2017-04-19 06:00:00	QQQ	ETF	131.74	131.76	131.66	131.67	6050.0
2017-04-19 07:00:00	QQQ	ETF	131.69	131.75	131.66	131.75	18600.0
2017-04-19 08:00:00	QQQ	ETF	131.68	131.9	131.68	131.85	101287.0
2017-04-19 09:00:00	QQQ	ETF	131.85	132.24	131.81	132.19	3405845.0
2017-04-19 10:00:00	QQQ	ETF	132.195	132.22	131.98	132.08	2459477.0
2017-04-19 11:00:00	QQQ	ETF	132.07	132.29	132.07	132.12	1669395.0
2017-04-19 12:00:00	QQQ	ETF	132.12	132.165	131.93	131.99	1331043.0
2017-04-19 13:00:00	QQQ	ETF	131.99	132.01	131.7	131.83	1620074.0
2017-04-19 14:00:00	QQQ	ETF	131.83	131.88	131.47	131.55	2293519.0
2017-04-19 15:00:00	QQQ	ETF	131.54	131.679	131.31	131.49	3812503.0
2017-04-19 16:00:00	QQQ	ETF	131.49	131.54	131.41	131.41	348969.0
2017-04-19 17:00:00	QQQ	ETF	131.38	131.49	131.38	131.48	3722.0
2017-04-19 18:00:00	QQQ	ETF	131.45	131.58	131.45	131.58	18198.0
2017-04-19 19:00:00	QQQ	ETF	131.57	131.6	131.54	131.54	6254.0
2017-04-19 04:00:00	IWM	ETF	135.39	135.47	135.39	135.47	500.0
2017-04-19 05:00:00	IWM	ETF	135.77	135.79	135.76	135.76	6100.0
2017-04-19 06:00:00	IWM	ETF	135.65	135.65	135.65	135.65	100.0
2017-04-19 07:00:00	IWM	ETF	135.72	135.76	135.63	135.73	44054.0
2017-04-19 08:00:00	IWM	ETF	135.69	135.9	135.62	135.65	39000.0
2017-04-19 09:00:00	IWM	ETF	135.66	136.52	135.6	136.48	4343613.0
2017-04-19 10:00:00	IWM	ETF	136.48	136.62	136.16	136.415	4606944.0
2017-04-19 11:00:00	IWM	ETF	136.41	136.9628	136.34	136.595	3929840.0
2017-04-19 12:00:00	IWM	ETF	136.59	136.64	136.2	136.335	2308006.0
2017-04-19 13:00:00	IWM	ETF	136.339	136.45	135.96	136.29	3358708.0
2017-04-19 14:00:00	IWM	ETF	136.28	136.37	135.8	135.86	3428682.0
2017-04-19 15:00:00	IWM	ETF	135.86	136.13	135.54	135.84	5858172.0
2017-04-19 16:00:00	IWM	ETF	135.79	135.96	135.67	135.69	2672605.0
2017-04-19 17:00:00	IWM	ETF	135.72	135.75	135.63	135.63	28492.0
2017-04-19 18:00:00	IWM	ETF	135.79	135.92	135.79	135.92	9200.0
2017-04-19 19:00:00	IWM	ETF	135.9	135.93	135.86	135.86	7345.0
2017-04-19 06:00:00	DIA	ETF	205.04	205.05	205.04	205.05	210.0
2017-04-19 07:00:00	DIA	ETF	205.11	205.11	205.11	205.11	100.0

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

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