PREVIEW / etf_1hour / 2017-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-22.parquet
  size:    276 KB
  rows:    8,983

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-03-22 04:00:00	SPY	ETF	233.33	233.76	233.13	233.46	35622.0
2017-03-22 05:00:00	SPY	ETF	233.33	233.9	233.2	233.84	33928.0
2017-03-22 06:00:00	SPY	ETF	233.84	233.88	233.63	233.88	23976.0
2017-03-22 07:00:00	SPY	ETF	233.81	233.95	233.58	233.77	515526.0
2017-03-22 08:00:00	SPY	ETF	233.74	233.97	233.6	233.83	592469.0
2017-03-22 09:00:00	SPY	ETF	233.81	233.965	233.23	233.28	12190895.0
2017-03-22 10:00:00	SPY	ETF	233.27	233.96	233.05	233.94	18970597.0
2017-03-22 11:00:00	SPY	ETF	233.93	234.555	233.63	234.265	14668517.0
2017-03-22 12:00:00	SPY	ETF	234.265	234.38	233.68	233.89	8061221.0
2017-03-22 13:00:00	SPY	ETF	233.88	234.22	233.42	233.65	9902759.0
2017-03-22 14:00:00	SPY	ETF	233.655	234.29	233.64	234.21	6577486.0
2017-03-22 15:00:00	SPY	ETF	234.19	234.61	234.08	234.27	15293848.0
2017-03-22 16:00:00	SPY	ETF	234.27	234.28	233.9	233.97	8656443.0
2017-03-22 17:00:00	SPY	ETF	233.95	234.28	233.89	233.97	1353251.0
2017-03-22 18:00:00	SPY	ETF	233.97	234.42	233.97	234.36	154760.0
2017-03-22 19:00:00	SPY	ETF	234.39	234.58	234.37	234.51	69236.0
2017-03-22 04:00:00	QQQ	ETF	129.6	129.77	129.52	129.61	9346.0
2017-03-22 05:00:00	QQQ	ETF	129.56	129.77	129.5	129.77	20940.0
2017-03-22 06:00:00	QQQ	ETF	129.8	129.83	129.73	129.83	8050.0
2017-03-22 07:00:00	QQQ	ETF	129.83	129.88	129.74	129.81	45569.0
2017-03-22 08:00:00	QQQ	ETF	129.79	129.89	129.77	129.85	71497.0
2017-03-22 09:00:00	QQQ	ETF	129.87	130.3	129.8	129.89	4047758.0
2017-03-22 10:00:00	QQQ	ETF	129.89	130.32	129.68	130.32	4863850.0
2017-03-22 11:00:00	QQQ	ETF	130.31	130.715	130.14	130.559	3042060.0
2017-03-22 12:00:00	QQQ	ETF	130.555	130.6053	130.27	130.39	1931282.0
2017-03-22 13:00:00	QQQ	ETF	130.39	130.569	130.14	130.25	3226227.0
2017-03-22 14:00:00	QQQ	ETF	130.25	130.65	130.25	130.62	2064769.0
2017-03-22 15:00:00	QQQ	ETF	130.61	130.82	130.53	130.68	3683698.0
2017-03-22 16:00:00	QQQ	ETF	130.68	130.69	129.95	130.55	1239079.0
2017-03-22 17:00:00	QQQ	ETF	130.55	130.55	130.45	130.51	107130.0
2017-03-22 18:00:00	QQQ	ETF	130.55	130.79	130.55	130.77	85137.0
2017-03-22 19:00:00	QQQ	ETF	130.78	130.84	130.77	130.84	8494.0
2017-03-22 04:00:00	IWM	ETF	133.8	133.88	133.4	133.44	3160.0
2017-03-22 05:00:00	IWM	ETF	133.35	134.01	133.35	134.01	6340.0
2017-03-22 06:00:00	IWM	ETF	133.77	133.97	133.77	133.97	10366.0
2017-03-22 07:00:00	IWM	ETF	133.98	134.01	133.6	133.73	68551.0
2017-03-22 08:00:00	IWM	ETF	133.93	133.93	133.6	133.82	92053.0
2017-03-22 09:00:00	IWM	ETF	133.85	134.31	133.08	133.54	5293960.0
2017-03-22 10:00:00	IWM	ETF	133.53	133.76	133.08	133.6	6043026.0
2017-03-22 11:00:00	IWM	ETF	133.59	133.76	133.11	133.455	4721614.0
2017-03-22 12:00:00	IWM	ETF	133.455	133.47	132.931	133.17	4048855.0
2017-03-22 13:00:00	IWM	ETF	133.16	133.54	132.78	133.14	3653069.0
2017-03-22 14:00:00	IWM	ETF	133.1447	133.6	133.12	133.555	2555142.0
2017-03-22 15:00:00	IWM	ETF	133.55	134.04	133.45	134.0	6524991.0
2017-03-22 16:00:00	IWM	ETF	134.0	134.05	133.75	133.79	2024113.0
2017-03-22 17:00:00	IWM	ETF	133.78	134.0	133.71	134.0	192249.0
2017-03-22 18:00:00	IWM	ETF	133.82	133.98	133.82	133.92	14014.0
2017-03-22 19:00:00	IWM	ETF	133.98	134.1	133.94	134.08	10920.0
2017-03-22 04:00:00	DIA	ETF	205.99	205.99	205.99	205.99	200.0
2017-03-22 07:00:00	DIA	ETF	206.05	206.05	206.04	206.04	1200.0

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

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