PREVIEW / etf_1hour / 2018-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-31.parquet
  size:    302 KB
  rows:    9,853

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-31 04:00:00	SPY	ETF	289.86	290.11	289.86	290.06	18530.0
2018-08-31 05:00:00	SPY	ETF	290.14	290.17	289.8	289.87	21257.0
2018-08-31 06:00:00	SPY	ETF	289.77	289.99	289.7	289.91	38241.0
2018-08-31 07:00:00	SPY	ETF	289.94	289.95	289.66	289.67	159888.0
2018-08-31 08:00:00	SPY	ETF	289.7301	290.0	289.6	289.63	154963.0
2018-08-31 09:00:00	SPY	ETF	289.65	290.291	289.6	290.19	3520291.0
2018-08-31 10:00:00	SPY	ETF	290.185	290.81	290.17	290.47	7150574.0
2018-08-31 11:00:00	SPY	ETF	290.47	290.635	289.69	289.71	7748564.0
2018-08-31 12:00:00	SPY	ETF	289.71	289.77	289.29	289.74	6420940.0
2018-08-31 13:00:00	SPY	ETF	289.75	289.88	289.54	289.8	4153714.0
2018-08-31 14:00:00	SPY	ETF	289.81	289.83	289.33	289.58	5014289.0
2018-08-31 15:00:00	SPY	ETF	289.59	290.48	289.5	290.22	16214434.0
2018-08-31 16:00:00	SPY	ETF	290.23	290.76	290.0	290.76	12464385.0
2018-08-31 17:00:00	SPY	ETF	290.74	290.79	290.31	290.79	913547.0
2018-08-31 18:00:00	SPY	ETF	290.79	290.98	290.79	290.87	52591.0
2018-08-31 19:00:00	SPY	ETF	290.94	291.0	290.31	291.0	30634.0
2018-08-31 04:00:00	QQQ	ETF	186.12	186.26	186.12	186.25	8505.0
2018-08-31 05:00:00	QQQ	ETF	186.37	186.39	186.16	186.16	1600.0
2018-08-31 06:00:00	QQQ	ETF	186.1	186.28	186.07	186.2	5150.0
2018-08-31 07:00:00	QQQ	ETF	186.22	186.3	186.08	186.145	74264.0
2018-08-31 08:00:00	QQQ	ETF	186.1001	186.64	186.06	186.07	106639.0
2018-08-31 09:00:00	QQQ	ETF	186.11	186.91	186.03	186.72	2925636.0
2018-08-31 10:00:00	QQQ	ETF	186.73	187.18	186.69	186.96	2980836.0
2018-08-31 11:00:00	QQQ	ETF	186.95	187.1185	186.265	186.34	3692176.0
2018-08-31 12:00:00	QQQ	ETF	186.33	186.58	186.19	186.5401	2709201.0
2018-08-31 13:00:00	QQQ	ETF	186.54	186.59	186.25	186.42	1266564.0
2018-08-31 14:00:00	QQQ	ETF	186.4201	186.44	185.98	186.23	2324874.0
2018-08-31 15:00:00	QQQ	ETF	186.24	186.73	186.08	186.61	5780407.0
2018-08-31 16:00:00	QQQ	ETF	186.6	186.94	186.53	186.91	877454.0
2018-08-31 17:00:00	QQQ	ETF	186.87	186.92	186.65	186.9	211402.0
2018-08-31 18:00:00	QQQ	ETF	186.89	187.0	186.89	186.9	3749.0
2018-08-31 19:00:00	QQQ	ETF	186.92	187.77	186.92	187.03	17525.0
2018-08-31 04:00:00	IWM	ETF	172.36	172.36	172.36	172.36	300.0
2018-08-31 06:00:00	IWM	ETF	172.16	172.16	172.14	172.14	600.0
2018-08-31 07:00:00	IWM	ETF	172.2	172.2	172.05	172.06	27800.0
2018-08-31 08:00:00	IWM	ETF	172.0599	172.46	171.89	171.89	53260.0
2018-08-31 09:00:00	IWM	ETF	171.89	172.616	171.8	172.41	908552.0
2018-08-31 10:00:00	IWM	ETF	172.4	172.65	172.14	172.33	1189020.0
2018-08-31 11:00:00	IWM	ETF	172.335	172.61	172.18	172.21	875840.0
2018-08-31 12:00:00	IWM	ETF	172.2	172.78	172.045	172.72	1146272.0
2018-08-31 13:00:00	IWM	ETF	172.72	172.72	172.44	172.66	635578.0
2018-08-31 14:00:00	IWM	ETF	172.67	172.84	172.38	172.77	833711.0
2018-08-31 15:00:00	IWM	ETF	172.77	173.39	172.69	173.02	3829469.0
2018-08-31 16:00:00	IWM	ETF	173.03	173.35	173.01	173.35	1485198.0
2018-08-31 17:00:00	IWM	ETF	173.34	173.39	173.02	173.36	444046.0
2018-08-31 19:00:00	IWM	ETF	173.35	173.49	173.35	173.38	3424.0
2018-08-31 06:00:00	DIA	ETF	259.55	259.55	259.55	259.55	100.0
2018-08-31 07:00:00	DIA	ETF	259.6	259.6	259.48	259.48	1000.0
2018-08-31 08:00:00	DIA	ETF	259.62	259.62	259.43	259.43	2813.0
2018-08-31 09:00:00	DIA	ETF	259.44	259.97	259.44	259.9	349973.0

> showing 50 of 9,853 rows — these rows as CSV

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