PREVIEW / etf_1hour / 2018-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-30.parquet
  size:    306 KB
  rows:    10,021

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-08-30 04:00:00	SPY	ETF	291.19	291.19	290.74	290.84	65573.0
2018-08-30 05:00:00	SPY	ETF	290.95	291.0	290.86	290.91	19352.0
2018-08-30 06:00:00	SPY	ETF	290.96	291.17	290.81	290.97	52152.0
2018-08-30 07:00:00	SPY	ETF	291.07	291.17	290.93	290.99	183861.0
2018-08-30 08:00:00	SPY	ETF	291.0001	291.26	290.92	291.01	298439.0
2018-08-30 09:00:00	SPY	ETF	291.02	291.2	290.78	290.88	5088034.0
2018-08-30 10:00:00	SPY	ETF	290.87	291.36	290.86	291.11	5978167.0
2018-08-30 11:00:00	SPY	ETF	291.11	291.32	290.48	290.66	7697413.0
2018-08-30 12:00:00	SPY	ETF	290.67	291.18	290.59	291.14	4814583.0
2018-08-30 13:00:00	SPY	ETF	291.14	291.34	291.1	291.23	4762368.0
2018-08-30 14:00:00	SPY	ETF	291.24	291.34	289.88	290.083	11734968.0
2018-08-30 15:00:00	SPY	ETF	290.09	290.37	289.63	290.24	13932092.0
2018-08-30 16:00:00	SPY	ETF	290.26	290.4	289.96	289.97	5366599.0
2018-08-30 17:00:00	SPY	ETF	290.02	290.03	289.9	289.96	61569.0
2018-08-30 18:00:00	SPY	ETF	289.92	289.99	289.69	289.8	70707.0
2018-08-30 19:00:00	SPY	ETF	289.84	290.0	289.84	289.86	20792.0
2018-08-30 04:00:00	QQQ	ETF	186.6	186.6	186.33	186.42	12012.0
2018-08-30 05:00:00	QQQ	ETF	186.41	186.48	186.37	186.38	48728.0
2018-08-30 06:00:00	QQQ	ETF	186.41	186.56	186.32	186.45	37647.0
2018-08-30 07:00:00	QQQ	ETF	186.53	186.54	186.44	186.45	73308.0
2018-08-30 08:00:00	QQQ	ETF	186.5001	186.67	186.42	186.44	196977.0
2018-08-30 09:00:00	QQQ	ETF	186.43	186.67	186.18	186.33	2663185.0
2018-08-30 10:00:00	QQQ	ETF	186.33	187.12	186.32	186.9063	3016976.0
2018-08-30 11:00:00	QQQ	ETF	186.91	187.115	186.54	186.84	4052803.0
2018-08-30 12:00:00	QQQ	ETF	186.85	187.41	186.83	187.361	1942606.0
2018-08-30 13:00:00	QQQ	ETF	187.37	187.5199	187.22	187.2999	1519942.0
2018-08-30 14:00:00	QQQ	ETF	187.3	187.46	186.2	186.2	5464455.0
2018-08-30 15:00:00	QQQ	ETF	186.21	186.38	185.79	186.35	5698938.0
2018-08-30 16:00:00	QQQ	ETF	186.37	186.44	186.2	186.2	1399747.0
2018-08-30 17:00:00	QQQ	ETF	186.27	186.27	186.06	186.16	29337.0
2018-08-30 18:00:00	QQQ	ETF	186.15	186.2	186.03	186.14	17131.0
2018-08-30 19:00:00	QQQ	ETF	186.13	186.28	186.12	186.12	22690.0
2018-08-30 04:00:00	IWM	ETF	172.34	172.34	172.34	172.34	500.0
2018-08-30 05:00:00	IWM	ETF	172.24	172.26	172.24	172.26	500.0
2018-08-30 06:00:00	IWM	ETF	172.26	172.36	172.15	172.36	8300.0
2018-08-30 07:00:00	IWM	ETF	172.3	172.41	172.27	172.32	52647.0
2018-08-30 08:00:00	IWM	ETF	172.3	172.37	172.21	172.21	68310.0
2018-08-30 09:00:00	IWM	ETF	172.22	172.6	171.97	172.06	1195287.0
2018-08-30 10:00:00	IWM	ETF	172.05	172.61	172.04	172.38	1113364.0
2018-08-30 11:00:00	IWM	ETF	172.39	172.55	171.82	172.02	1466941.0
2018-08-30 12:00:00	IWM	ETF	172.02	172.82	172.01	172.8	1456474.0
2018-08-30 13:00:00	IWM	ETF	172.8	173.23	172.79	173.11	1554688.0
2018-08-30 14:00:00	IWM	ETF	173.11	173.2	172.47	172.51	2488310.0
2018-08-30 15:00:00	IWM	ETF	172.5	172.51	172.09	172.37	3079944.0
2018-08-30 16:00:00	IWM	ETF	172.38	172.5	172.3	172.32	565675.0
2018-08-30 17:00:00	IWM	ETF	172.34	172.34	172.34	172.34	191.0
2018-08-30 18:00:00	IWM	ETF	172.25	172.25	172.15	172.22	1800.0
2018-08-30 19:00:00	IWM	ETF	172.3	172.33	172.25	172.25	800.0
2018-08-30 04:00:00	DIA	ETF	260.81	260.81	260.81	260.81	200.0
2018-08-30 06:00:00	DIA	ETF	260.56	260.56	260.56	260.56	250.0

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

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