PREVIEW / etf_1hour / 2017-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-06.parquet
  size:    270 KB
  rows:    8,777

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-06 04:00:00	SPY	ETF	234.23	234.45	234.15	234.44	10372.0
2017-04-06 05:00:00	SPY	ETF	234.52	234.52	234.45	234.5	1925.0
2017-04-06 06:00:00	SPY	ETF	234.54	234.91	234.53	234.88	46791.0
2017-04-06 07:00:00	SPY	ETF	234.81	234.9	234.69	234.72	334912.0
2017-04-06 08:00:00	SPY	ETF	234.84	234.97	234.54	234.94	574322.0
2017-04-06 09:00:00	SPY	ETF	234.94	235.34	234.425	235.3	9881409.0
2017-04-06 10:00:00	SPY	ETF	235.31	235.53	234.91	235.24	9865342.0
2017-04-06 11:00:00	SPY	ETF	235.25	235.7	235.2403	235.59	5530924.0
2017-04-06 12:00:00	SPY	ETF	235.59	235.68	235.2	235.38	4140464.0
2017-04-06 13:00:00	SPY	ETF	235.38	236.04	235.33	235.655	6670585.0
2017-04-06 14:00:00	SPY	ETF	235.65	235.74	234.88	234.98	9281458.0
2017-04-06 15:00:00	SPY	ETF	234.985	235.44	234.95	235.39	14083742.0
2017-04-06 16:00:00	SPY	ETF	235.39	235.44	235.17	235.41	7310355.0
2017-04-06 17:00:00	SPY	ETF	235.39	235.5	235.38	235.46	94947.0
2017-04-06 18:00:00	SPY	ETF	235.46	235.54	235.41	235.46	85858.0
2017-04-06 19:00:00	SPY	ETF	235.48	235.51	235.4	235.44	57639.0
2017-04-06 04:00:00	QQQ	ETF	131.74	131.79	131.67	131.72	2532.0
2017-04-06 05:00:00	QQQ	ETF	131.83	131.85	131.79	131.84	26095.0
2017-04-06 06:00:00	QQQ	ETF	131.87	132.09	131.87	132.09	11056.0
2017-04-06 07:00:00	QQQ	ETF	132.04	132.08	132.0	132.01	80050.0
2017-04-06 08:00:00	QQQ	ETF	131.99	132.1	131.93	132.09	151095.0
2017-04-06 09:00:00	QQQ	ETF	132.08	132.3	131.74	132.2573	3177815.0
2017-04-06 10:00:00	QQQ	ETF	132.28	132.34	131.84	132.12	2978115.0
2017-04-06 11:00:00	QQQ	ETF	132.13	132.39	132.075	132.2147	1481530.0
2017-04-06 12:00:00	QQQ	ETF	132.215	132.27	131.92	132.0	1707853.0
2017-04-06 13:00:00	QQQ	ETF	131.999	132.35	131.96	132.159	1769399.0
2017-04-06 14:00:00	QQQ	ETF	132.16	132.21	131.7	131.745	2400412.0
2017-04-06 15:00:00	QQQ	ETF	131.7446	132.05	131.7401	132.05	3201419.0
2017-04-06 16:00:00	QQQ	ETF	132.04	132.1374	131.96	132.11	803538.0
2017-04-06 17:00:00	QQQ	ETF	132.12	132.18	132.12	132.16	16724.0
2017-04-06 18:00:00	QQQ	ETF	132.15	132.19	132.14	132.14	18248.0
2017-04-06 19:00:00	QQQ	ETF	132.11	132.13	132.08	132.08	24617.0
2017-04-06 04:00:00	IWM	ETF	133.6	133.79	133.6	133.7	8650.0
2017-04-06 05:00:00	IWM	ETF	133.81	133.86	133.78	133.86	3020.0
2017-04-06 06:00:00	IWM	ETF	133.93	134.25	133.93	134.23	11551.0
2017-04-06 07:00:00	IWM	ETF	134.14	134.36	134.08	134.11	103613.0
2017-04-06 08:00:00	IWM	ETF	134.1	134.32	133.94	134.27	142565.0
2017-04-06 09:00:00	IWM	ETF	134.29	134.7	133.83	134.285	5336308.0
2017-04-06 10:00:00	IWM	ETF	134.31	134.56	133.99	134.3	4231474.0
2017-04-06 11:00:00	IWM	ETF	134.3	135.14	134.3	135.04	3468647.0
2017-04-06 12:00:00	IWM	ETF	135.04	135.23	134.73	135.02	2422535.0
2017-04-06 13:00:00	IWM	ETF	135.02	135.63	134.98	135.4601	2933223.0
2017-04-06 14:00:00	IWM	ETF	135.47	135.58	134.89	134.935	3557748.0
2017-04-06 15:00:00	IWM	ETF	134.935	135.61	134.81	135.56	6394997.0
2017-04-06 16:00:00	IWM	ETF	135.58	135.75	135.47	135.75	3929406.0
2017-04-06 17:00:00	IWM	ETF	135.77	135.83	135.74	135.75	4627.0
2017-04-06 18:00:00	IWM	ETF	135.75	135.75	135.58	135.67	1180610.0
2017-04-06 19:00:00	IWM	ETF	135.8	135.8	135.65	135.74	2300.0
2017-04-06 05:00:00	DIA	ETF	206.04	206.04	206.04	206.04	100.0
2017-04-06 06:00:00	DIA	ETF	206.1	206.1	206.1	206.1	100.0

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

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