PREVIEW / etf_1hour / 2018-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-19.parquet
  size:    313 KB
  rows:    10,223

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-10-19 04:00:00	SPY	ETF	276.96	277.04	276.55	276.9	50299.0
2018-10-19 05:00:00	SPY	ETF	276.96	277.2	276.7	276.74	74735.0
2018-10-19 06:00:00	SPY	ETF	276.76	277.29	276.64	276.92	64521.0
2018-10-19 07:00:00	SPY	ETF	276.89	277.72	276.89	277.55	730389.0
2018-10-19 08:00:00	SPY	ETF	277.55	277.99	276.92	277.51	795695.0
2018-10-19 09:00:00	SPY	ETF	277.5	278.79	277.09	278.44	13308811.0
2018-10-19 10:00:00	SPY	ETF	278.45	279.3	278.2	278.7175	24124994.0
2018-10-19 11:00:00	SPY	ETF	278.71	278.9964	277.24	277.98	13080453.0
2018-10-19 12:00:00	SPY	ETF	277.98	278.17	275.98	276.86	17062412.0
2018-10-19 13:00:00	SPY	ETF	276.86	277.61	276.175	276.73	9616575.0
2018-10-19 14:00:00	SPY	ETF	276.73	276.95	275.47	276.43	12971476.0
2018-10-19 15:00:00	SPY	ETF	276.43	277.11	275.89	276.19	27358684.0
2018-10-19 16:00:00	SPY	ETF	276.16	276.3605	275.7	276.01	17676369.0
2018-10-19 17:00:00	SPY	ETF	276.0	276.25	275.77	275.8	988384.0
2018-10-19 18:00:00	SPY	ETF	275.8	277.15	275.8	276.3	403125.0
2018-10-19 19:00:00	SPY	ETF	276.26	276.29	276.2	276.21	34384.0
2018-10-19 04:00:00	QQQ	ETF	173.94	174.03	173.51	173.85	21940.0
2018-10-19 05:00:00	QQQ	ETF	173.89	174.21	173.8	173.85	36377.0
2018-10-19 06:00:00	QQQ	ETF	173.83	174.34	173.82	174.07	70755.0
2018-10-19 07:00:00	QQQ	ETF	174.05	174.71	174.05	174.61	216486.0
2018-10-19 08:00:00	QQQ	ETF	173.18	174.86	173.18	174.49	377885.0
2018-10-19 09:00:00	QQQ	ETF	174.5	175.8	174.295	175.41	7336929.0
2018-10-19 10:00:00	QQQ	ETF	175.41	176.07	175.0101	175.3699	8766830.0
2018-10-19 11:00:00	QQQ	ETF	175.37	175.66	173.9	174.46	8487991.0
2018-10-19 12:00:00	QQQ	ETF	174.44	174.6	172.57	173.56	11388161.0
2018-10-19 13:00:00	QQQ	ETF	173.54	174.1	172.8901	173.25	6751141.0
2018-10-19 14:00:00	QQQ	ETF	173.25	173.5852	172.39	173.08	9835384.0
2018-10-19 15:00:00	QQQ	ETF	173.07	173.74	172.8	173.04	11639398.0
2018-10-19 16:00:00	QQQ	ETF	173.02	173.9992	172.52	172.68	2634075.0
2018-10-19 17:00:00	QQQ	ETF	172.59	173.02	172.51	172.59	905645.0
2018-10-19 18:00:00	QQQ	ETF	172.59	172.89	172.59	172.81	10671.0
2018-10-19 19:00:00	QQQ	ETF	172.66	172.78	172.52	172.63	5920.0
2018-10-19 04:00:00	IWM	ETF	155.28	155.29	155.15	155.28	5217.0
2018-10-19 05:00:00	IWM	ETF	155.26	155.37	155.2	155.2	1907.0
2018-10-19 06:00:00	IWM	ETF	155.24	155.4	155.24	155.31	4900.0
2018-10-19 07:00:00	IWM	ETF	155.42	155.73	155.42	155.66	23688.0
2018-10-19 08:00:00	IWM	ETF	155.2699	155.95	155.2699	155.8	29327.0
2018-10-19 09:00:00	IWM	ETF	155.69	156.36	154.88	156.0	3085173.0
2018-10-19 10:00:00	IWM	ETF	156.0	156.26	155.15	155.35	3061605.0
2018-10-19 11:00:00	IWM	ETF	155.35	155.61	154.47	155.08	3118888.0
2018-10-19 12:00:00	IWM	ETF	155.07	155.12	153.45	153.97	3860565.0
2018-10-19 13:00:00	IWM	ETF	153.94	154.15	153.45	153.45	2194052.0
2018-10-19 14:00:00	IWM	ETF	153.45	153.72	152.895	153.3	2993066.0
2018-10-19 15:00:00	IWM	ETF	153.29	153.51	152.74	153.35	6228667.0
2018-10-19 16:00:00	IWM	ETF	153.36	153.36	152.89	153.07	1148881.0
2018-10-19 17:00:00	IWM	ETF	153.11	153.36	153.11	153.36	1414926.0
2018-10-19 18:00:00	IWM	ETF	153.22	153.3	153.22	153.26	1756.0
2018-10-19 19:00:00	IWM	ETF	153.11	153.29	153.11	153.25	860.0
2018-10-19 04:00:00	DIA	ETF	253.98	253.98	253.98	253.98	100.0
2018-10-19 05:00:00	DIA	ETF	254.16	254.16	254.16	254.16	100.0

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

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