PREVIEW / etf_1hour / 2017-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-07.parquet
  size:    276 KB
  rows:    8,928

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-02-07 04:00:00	SPY	ETF	228.97	229.26	228.95	229.22	6220.0
2017-02-07 05:00:00	SPY	ETF	229.2	229.28	229.15	229.15	16760.0
2017-02-07 06:00:00	SPY	ETF	229.2	229.55	229.2	229.49	66724.0
2017-02-07 07:00:00	SPY	ETF	229.5	229.56	229.37	229.4	73400.0
2017-02-07 08:00:00	SPY	ETF	229.46	229.55	229.31	229.34	272360.0
2017-02-07 09:00:00	SPY	ETF	229.34	229.6556	229.2	229.47	5385316.0
2017-02-07 10:00:00	SPY	ETF	229.47	229.62	229.369	229.5	7218170.0
2017-02-07 11:00:00	SPY	ETF	229.495	229.62	229.08	229.25	9720304.0
2017-02-07 12:00:00	SPY	ETF	229.245	229.4	228.72	228.81	10147395.0
2017-02-07 13:00:00	SPY	ETF	228.8	229.25	228.72	228.9925	4117231.0
2017-02-07 14:00:00	SPY	ETF	229.0	229.08	228.865	229.0	4851299.0
2017-02-07 15:00:00	SPY	ETF	229.005	229.175	228.79	228.97	10236238.0
2017-02-07 16:00:00	SPY	ETF	228.97	229.04	228.77	228.78	2525869.0
2017-02-07 17:00:00	SPY	ETF	228.8	228.94	228.7	228.74	2127668.0
2017-02-07 18:00:00	SPY	ETF	228.76	228.81	228.61	228.72	74265.0
2017-02-07 19:00:00	SPY	ETF	228.77	228.83	228.77	228.83	28920.0
2017-02-07 04:00:00	QQQ	ETF	125.83	125.92	125.79	125.92	2576.0
2017-02-07 05:00:00	QQQ	ETF	125.96	125.96	125.91	125.95	10340.0
2017-02-07 06:00:00	QQQ	ETF	125.98	126.09	125.98	126.09	19127.0
2017-02-07 07:00:00	QQQ	ETF	126.02	126.07	125.99	126.02	6950.0
2017-02-07 08:00:00	QQQ	ETF	126.0	126.02	125.98	125.99	14254.0
2017-02-07 09:00:00	QQQ	ETF	126.01	126.2899	125.97	126.23	1896167.0
2017-02-07 10:00:00	QQQ	ETF	126.23	126.51	126.2064	126.472	2121463.0
2017-02-07 11:00:00	QQQ	ETF	126.47	126.55	126.28	126.4059	1227588.0
2017-02-07 12:00:00	QQQ	ETF	126.4	126.46	126.07	126.151	1158708.0
2017-02-07 13:00:00	QQQ	ETF	126.15	126.36	126.11	126.31	1180754.0
2017-02-07 14:00:00	QQQ	ETF	126.301	126.36	126.15	126.218	1601681.0
2017-02-07 15:00:00	QQQ	ETF	126.2158	126.31	126.12	126.28	2793858.0
2017-02-07 16:00:00	QQQ	ETF	126.28	126.2945	126.12	126.16	1064920.0
2017-02-07 17:00:00	QQQ	ETF	126.13	126.24	126.13	126.16	6772.0
2017-02-07 18:00:00	QQQ	ETF	126.16	126.16	126.08	126.11	9080.0
2017-02-07 19:00:00	QQQ	ETF	126.21	126.21	126.21	126.21	500.0
2017-02-07 05:00:00	IWM	ETF	135.89	135.91	135.88	135.91	10000.0
2017-02-07 06:00:00	IWM	ETF	136.08	136.08	136.08	136.08	800.0
2017-02-07 07:00:00	IWM	ETF	136.11	136.18	135.98	136.02	26377.0
2017-02-07 08:00:00	IWM	ETF	136.15	136.15	135.9	135.94	51475.0
2017-02-07 09:00:00	IWM	ETF	135.9	136.33	135.6	136.2456	1777291.0
2017-02-07 10:00:00	IWM	ETF	136.25	136.465	136.0799	136.18	2069927.0
2017-02-07 11:00:00	IWM	ETF	136.17	136.26	135.7361	135.81	1680813.0
2017-02-07 12:00:00	IWM	ETF	135.81	135.87	134.775	134.9	3541234.0
2017-02-07 13:00:00	IWM	ETF	134.91	135.45	134.77	135.33	2926421.0
2017-02-07 14:00:00	IWM	ETF	135.35	135.49	135.0	135.15	1749109.0
2017-02-07 15:00:00	IWM	ETF	135.16	135.38	135.0	135.26	3987597.0
2017-02-07 16:00:00	IWM	ETF	135.26	135.7994	135.04	135.04	2060306.0
2017-02-07 17:00:00	IWM	ETF	135.14	135.14	135.1	135.1	3800.0
2017-02-07 18:00:00	IWM	ETF	135.08	135.08	135.01	135.01	4440.0
2017-02-07 19:00:00	IWM	ETF	135.04	135.12	135.04	135.11	2330.0
2017-02-07 06:00:00	DIA	ETF	200.59	200.81	200.59	200.8	950.0
2017-02-07 08:00:00	DIA	ETF	200.71	200.72	200.71	200.72	2550.0
2017-02-07 09:00:00	DIA	ETF	200.8	201.3001	200.75	201.1	518460.0

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

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