PREVIEW / etf_1hour / 2017-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-07.parquet
  size:    269 KB
  rows:    8,699

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-07 04:00:00	SPY	ETF	235.1	235.15	234.91	235.04	29200.0
2017-04-07 05:00:00	SPY	ETF	235.0	235.02	234.7	234.8	11350.0
2017-04-07 06:00:00	SPY	ETF	234.91	235.33	234.83	235.18	118884.0
2017-04-07 07:00:00	SPY	ETF	235.23	235.52	235.2	235.23	546159.0
2017-04-07 08:00:00	SPY	ETF	235.25	235.38	234.53	234.92	1673219.0
2017-04-07 09:00:00	SPY	ETF	234.92	235.7	234.66	234.73	10069167.0
2017-04-07 10:00:00	SPY	ETF	234.73	235.55	234.64	235.185	10293983.0
2017-04-07 11:00:00	SPY	ETF	235.185	235.36	234.91	235.28	6756331.0
2017-04-07 12:00:00	SPY	ETF	235.28	235.57	235.25	235.52	4800298.0
2017-04-07 13:00:00	SPY	ETF	235.52	236.0	235.345	235.7	6417630.0
2017-04-07 14:00:00	SPY	ETF	235.7	235.9	235.42	235.43	5540039.0
2017-04-07 15:00:00	SPY	ETF	235.42	235.62	235.1	235.17	13024186.0
2017-04-07 16:00:00	SPY	ETF	235.16	235.28	235.12	235.19	13232687.0
2017-04-07 17:00:00	SPY	ETF	235.19	235.26	235.1	235.2	131893.0
2017-04-07 18:00:00	SPY	ETF	235.16	235.29	235.16	235.22	29554.0
2017-04-07 19:00:00	SPY	ETF	235.26	235.26	235.16	235.19	14780.0
2017-04-07 05:00:00	QQQ	ETF	131.77	131.85	131.77	131.85	11000.0
2017-04-07 06:00:00	QQQ	ETF	131.85	132.04	131.85	131.98	8483.0
2017-04-07 07:00:00	QQQ	ETF	132.05	132.16	132.02	132.02	27932.0
2017-04-07 08:00:00	QQQ	ETF	132.04	132.06	131.63	131.89	268067.0
2017-04-07 09:00:00	QQQ	ETF	131.89	132.27	131.52	131.58	3359833.0
2017-04-07 10:00:00	QQQ	ETF	131.57	132.135	131.5	131.905	3104106.0
2017-04-07 11:00:00	QQQ	ETF	131.91	132.03	131.75	131.9634	1450672.0
2017-04-07 12:00:00	QQQ	ETF	131.96	132.22	131.96	132.1947	911188.0
2017-04-07 13:00:00	QQQ	ETF	132.19	132.37	132.09	132.201	1693880.0
2017-04-07 14:00:00	QQQ	ETF	132.2	132.3288	132.12	132.14	1268043.0
2017-04-07 15:00:00	QQQ	ETF	132.14	132.24	131.96	131.96	2960477.0
2017-04-07 16:00:00	QQQ	ETF	131.97	132.205	131.95	132.0	576254.0
2017-04-07 17:00:00	QQQ	ETF	132.03	132.03	131.99	131.99	16807.0
2017-04-07 18:00:00	QQQ	ETF	132.02	132.02	132.02	132.02	602.0
2017-04-07 19:00:00	QQQ	ETF	132.02	132.04	132.02	132.02	7330.0
2017-04-07 04:00:00	IWM	ETF	135.46	135.5	135.43	135.5	500.0
2017-04-07 05:00:00	IWM	ETF	135.36	135.36	135.08	135.08	1752.0
2017-04-07 06:00:00	IWM	ETF	135.19	135.6	135.14	135.5	6960.0
2017-04-07 07:00:00	IWM	ETF	135.5	135.69	135.48	135.48	101169.0
2017-04-07 08:00:00	IWM	ETF	135.52	135.59	134.9	135.0	562071.0
2017-04-07 09:00:00	IWM	ETF	134.99	135.79	134.77	134.84	3972011.0
2017-04-07 10:00:00	IWM	ETF	134.84	136.03	134.75	135.52	4608721.0
2017-04-07 11:00:00	IWM	ETF	135.53	135.64	135.24	135.4299	1502273.0
2017-04-07 12:00:00	IWM	ETF	135.426	135.84	135.41	135.78	1409003.0
2017-04-07 13:00:00	IWM	ETF	135.785	135.95	135.535	135.5935	1585186.0
2017-04-07 14:00:00	IWM	ETF	135.6	135.8	135.33	135.34	1662299.0
2017-04-07 15:00:00	IWM	ETF	135.33	135.74	135.32	135.54	4267565.0
2017-04-07 16:00:00	IWM	ETF	135.52	135.64	135.35	135.4	1383942.0
2017-04-07 17:00:00	IWM	ETF	135.4	135.4	135.35	135.35	12468.0
2017-04-07 18:00:00	IWM	ETF	135.4	135.4	135.4	135.4	182.0
2017-04-07 08:00:00	DIA	ETF	206.67	206.67	205.75	206.09	15587.0
2017-04-07 09:00:00	DIA	ETF	206.01	206.73	205.94	206.0	514470.0
2017-04-07 10:00:00	DIA	ETF	205.97	206.6199	205.89	206.325	282295.0
2017-04-07 11:00:00	DIA	ETF	206.33	206.52	206.14	206.43	330113.0

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

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