PREVIEW / etf_1hour / 2018-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-09-18.parquet
  size:    309 KB
  rows:    10,126

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-18 04:00:00	SPY	ETF	289.6	289.94	289.51	289.86	34693.0
2018-09-18 05:00:00	SPY	ETF	289.84	290.13	289.84	290.0	50655.0
2018-09-18 06:00:00	SPY	ETF	290.03	290.07	289.9	290.04	36976.0
2018-09-18 07:00:00	SPY	ETF	289.99	290.1	289.77	289.96	233226.0
2018-09-18 08:00:00	SPY	ETF	289.95	290.21	289.11	290.08	289828.0
2018-09-18 09:00:00	SPY	ETF	290.07	290.57	289.4	290.2799	6552612.0
2018-09-18 10:00:00	SPY	ETF	290.28	290.84	289.97	290.8	8385534.0
2018-09-18 11:00:00	SPY	ETF	290.8	291.24	290.65	291.19	5302517.0
2018-09-18 12:00:00	SPY	ETF	291.19	291.46	290.95	291.015	5420315.0
2018-09-18 13:00:00	SPY	ETF	291.02	291.255	290.88	291.225	4189417.0
2018-09-18 14:00:00	SPY	ETF	291.225	291.58	291.17	291.28	7871722.0
2018-09-18 15:00:00	SPY	ETF	291.28	291.44	290.85	290.9	11468972.0
2018-09-18 16:00:00	SPY	ETF	290.9	291.245	289.3158	291.06	9936707.0
2018-09-18 17:00:00	SPY	ETF	291.06	291.09	291.03	291.05	17061.0
2018-09-18 18:00:00	SPY	ETF	291.09	291.31	291.08	291.25	63694.0
2018-09-18 19:00:00	SPY	ETF	291.21	291.27	291.01	291.01	21027.0
2018-09-18 04:00:00	QQQ	ETF	181.51	181.81	181.51	181.69	55986.0
2018-09-18 05:00:00	QQQ	ETF	181.7	181.93	181.7	181.93	35595.0
2018-09-18 06:00:00	QQQ	ETF	181.94	181.96	181.76	181.88	32983.0
2018-09-18 07:00:00	QQQ	ETF	181.84	181.89	181.39	181.68	130424.0
2018-09-18 08:00:00	QQQ	ETF	181.83	181.95	181.03	181.83	347656.0
2018-09-18 09:00:00	QQQ	ETF	181.8	182.9	181.38	182.73	5003631.0
2018-09-18 10:00:00	QQQ	ETF	182.74	183.31	182.64	183.27	4643015.0
2018-09-18 11:00:00	QQQ	ETF	183.27	183.68	183.09	183.52	3200354.0
2018-09-18 12:00:00	QQQ	ETF	183.53	183.73	182.97	183.11	2557611.0
2018-09-18 13:00:00	QQQ	ETF	183.12	183.33	182.855	183.2515	2046907.0
2018-09-18 14:00:00	QQQ	ETF	183.25	183.47	183.07	183.12	2159831.0
2018-09-18 15:00:00	QQQ	ETF	183.11	183.28	182.79	182.8207	5077308.0
2018-09-18 16:00:00	QQQ	ETF	182.84	182.89	182.4	182.85	1617424.0
2018-09-18 17:00:00	QQQ	ETF	182.85	183.0	182.82	182.84	4679.0
2018-09-18 18:00:00	QQQ	ETF	182.84	183.12	182.84	183.02	46378.0
2018-09-18 19:00:00	QQQ	ETF	183.02	183.09	182.83	182.83	15391.0
2018-09-18 04:00:00	IWM	ETF	169.96	170.0	169.96	170.0	1775.0
2018-09-18 05:00:00	IWM	ETF	170.1	170.17	170.06	170.17	12339.0
2018-09-18 06:00:00	IWM	ETF	170.2	170.2	170.2	170.2	1000.0
2018-09-18 07:00:00	IWM	ETF	170.18	170.24	169.94	170.12	25427.0
2018-09-18 08:00:00	IWM	ETF	170.15	170.23	169.95	170.19	89907.0
2018-09-18 09:00:00	IWM	ETF	170.13	170.38	169.75	169.78	1200191.0
2018-09-18 10:00:00	IWM	ETF	169.79	170.42	169.63	170.28	2233756.0
2018-09-18 11:00:00	IWM	ETF	170.29	170.59	170.06	170.49	1349820.0
2018-09-18 12:00:00	IWM	ETF	170.49	170.67	170.17	170.2425	1085472.0
2018-09-18 13:00:00	IWM	ETF	170.26	170.71	170.25	170.51	861167.0
2018-09-18 14:00:00	IWM	ETF	170.5133	170.705	170.5	170.52	739641.0
2018-09-18 15:00:00	IWM	ETF	170.53	170.7	170.215	170.23	3415086.0
2018-09-18 16:00:00	IWM	ETF	170.23	170.53	170.2	170.53	729549.0
2018-09-18 17:00:00	IWM	ETF	170.46	170.47	170.46	170.47	4508.0
2018-09-18 18:00:00	IWM	ETF	170.47	170.62	170.47	170.57	18100.0
2018-09-18 19:00:00	IWM	ETF	170.6	170.62	170.5	170.5	3200.0
2018-09-18 05:00:00	DIA	ETF	261.62	261.64	261.62	261.64	3000.0
2018-09-18 06:00:00	DIA	ETF	261.64	261.64	261.64	261.64	1155.0

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

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