PREVIEW / etf_1hour / 2018-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-09-28.parquet
  size:    306 KB
  rows:    10,132

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
2018-09-28 04:00:00	SPY	ETF	290.41	290.86	290.41	290.81	8332.0
2018-09-28 05:00:00	SPY	ETF	290.81	290.81	290.43	290.46	14850.0
2018-09-28 06:00:00	SPY	ETF	290.46	290.46	289.99	290.14	43578.0
2018-09-28 07:00:00	SPY	ETF	290.17	290.17	289.6	289.63	337529.0
2018-09-28 08:00:00	SPY	ETF	290.69	291.0	289.54	289.98	824727.0
2018-09-28 09:00:00	SPY	ETF	289.95	290.42	289.8	290.38	6619580.0
2018-09-28 10:00:00	SPY	ETF	290.3701	291.105	290.18	291.0	6512005.0
2018-09-28 11:00:00	SPY	ETF	291.01	291.28	290.85	290.87	4878397.0
2018-09-28 12:00:00	SPY	ETF	290.8725	291.04	290.28	290.71	4789912.0
2018-09-28 13:00:00	SPY	ETF	290.7	291.11	290.57	290.86	4283037.0
2018-09-28 14:00:00	SPY	ETF	290.86	290.87	290.48	290.57	6252943.0
2018-09-28 15:00:00	SPY	ETF	290.58	290.8	290.32	290.61	20819545.0
2018-09-28 16:00:00	SPY	ETF	290.62	290.94	290.5563	290.89	12371901.0
2018-09-28 17:00:00	SPY	ETF	290.84	291.0	290.81	291.0	52060.0
2018-09-28 18:00:00	SPY	ETF	290.95	290.99	290.93	290.94	5151.0
2018-09-28 19:00:00	SPY	ETF	290.91	291.0	290.91	291.0	15927.0
2018-09-28 04:00:00	QQQ	ETF	185.77	185.82	185.66	185.77	2597.0
2018-09-28 05:00:00	QQQ	ETF	185.75	185.75	185.55	185.57	5048.0
2018-09-28 06:00:00	QQQ	ETF	185.57	185.57	185.25	185.38	29428.0
2018-09-28 07:00:00	QQQ	ETF	185.33	185.34	184.79	184.88	134689.0
2018-09-28 08:00:00	QQQ	ETF	185.33	185.83	184.83	185.19	215499.0
2018-09-28 09:00:00	QQQ	ETF	185.15	185.68	184.97	185.309	3340825.0
2018-09-28 10:00:00	QQQ	ETF	185.31	185.93	185.05	185.81	3560354.0
2018-09-28 11:00:00	QQQ	ETF	185.8107	186.28	185.79	185.84	2537133.0
2018-09-28 12:00:00	QQQ	ETF	185.84	186.0	185.24	185.61	1936829.0
2018-09-28 13:00:00	QQQ	ETF	185.6	185.8576	185.41	185.665	1568913.0
2018-09-28 14:00:00	QQQ	ETF	185.66	185.69	185.31	185.54	2254407.0
2018-09-28 15:00:00	QQQ	ETF	185.54	185.82	185.47	185.77	6467496.0
2018-09-28 16:00:00	QQQ	ETF	185.78	186.06	185.7281	186.02	1568909.0
2018-09-28 17:00:00	QQQ	ETF	185.95	186.09	185.79	185.96	328582.0
2018-09-28 18:00:00	QQQ	ETF	185.99	186.05	185.96	186.04	3433.0
2018-09-28 19:00:00	QQQ	ETF	186.04	186.09	186.0	186.09	3704.0
2018-09-28 06:00:00	IWM	ETF	167.92	167.92	167.62	167.75	11632.0
2018-09-28 07:00:00	IWM	ETF	167.71	167.71	167.36	167.38	20700.0
2018-09-28 08:00:00	IWM	ETF	168.04	168.04	167.13	167.49	24525.0
2018-09-28 09:00:00	IWM	ETF	167.39	168.31	167.33	168.11	1030552.0
2018-09-28 10:00:00	IWM	ETF	168.1	168.98	168.015	168.87	3004225.0
2018-09-28 11:00:00	IWM	ETF	168.87	169.0	168.58	168.61	1753314.0
2018-09-28 12:00:00	IWM	ETF	168.59	168.82	168.41	168.72	1062639.0
2018-09-28 13:00:00	IWM	ETF	168.73	168.81	168.42	168.45	1073838.0
2018-09-28 14:00:00	IWM	ETF	168.44	168.62	168.335	168.37	2011996.0
2018-09-28 15:00:00	IWM	ETF	168.38	168.63	168.21	168.57	5696145.0
2018-09-28 16:00:00	IWM	ETF	168.58	168.88	167.917	168.8	2168804.0
2018-09-28 17:00:00	IWM	ETF	168.55	168.78	168.55	168.75	76250.0
2018-09-28 18:00:00	IWM	ETF	168.79	168.79	168.79	168.79	2000.0
2018-09-28 19:00:00	IWM	ETF	168.79	168.86	168.79	168.86	3184.0
2018-09-28 04:00:00	DIA	ETF	263.98	263.98	263.98	263.98	400.0
2018-09-28 06:00:00	DIA	ETF	263.98	263.98	263.8	263.8	300.0
2018-09-28 07:00:00	DIA	ETF	263.55	263.55	263.24	263.25	2756.0
2018-09-28 08:00:00	DIA	ETF	263.25	263.59	263.06	263.55	10205.0

> showing 50 of 10,132 rows — these rows as CSV

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