PREVIEW / etf_1hour / 2019-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-10.parquet
  size:    333 KB
  rows:    10,961

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
2019-07-10 04:00:00	SPY	ETF	296.83	296.89	296.6	296.62	8872.0
2019-07-10 05:00:00	SPY	ETF	296.7	296.87	296.33	296.48	15527.0
2019-07-10 06:00:00	SPY	ETF	296.43	296.43	296.06	296.39	21371.0
2019-07-10 07:00:00	SPY	ETF	296.41	296.59	296.36	296.5	87717.0
2019-07-10 08:00:00	SPY	ETF	296.5	298.54	296.41	298.35	1617560.0
2019-07-10 09:00:00	SPY	ETF	298.37	299.66	298.22	299.38	8069279.0
2019-07-10 10:00:00	SPY	ETF	299.39	299.48	298.28	298.32	8838459.0
2019-07-10 11:00:00	SPY	ETF	298.31	298.69	297.78	298.61	7178387.0
2019-07-10 12:00:00	SPY	ETF	298.62	298.77	298.295	298.7599	3476035.0
2019-07-10 13:00:00	SPY	ETF	298.755	299.09	298.68	298.92	4185446.0
2019-07-10 14:00:00	SPY	ETF	298.93	299.25	298.29	298.5489	7745979.0
2019-07-10 15:00:00	SPY	ETF	298.55	298.77	298.27	298.61	8685469.0
2019-07-10 16:00:00	SPY	ETF	298.61	298.72	298.54	298.54	7005736.0
2019-07-10 17:00:00	SPY	ETF	298.61	298.61	298.38	298.47	364475.0
2019-07-10 18:00:00	SPY	ETF	298.49	298.85	298.46	298.74	140474.0
2019-07-10 19:00:00	SPY	ETF	298.75	298.75	298.56	298.62	33071.0
2019-07-10 04:00:00	QQQ	ETF	190.36	190.45	190.17	190.37	13930.0
2019-07-10 05:00:00	QQQ	ETF	190.23	190.43	189.95	190.1	61427.0
2019-07-10 06:00:00	QQQ	ETF	190.07	190.07	189.81	190.07	56504.0
2019-07-10 07:00:00	QQQ	ETF	190.08	190.3	190.08	190.21	114553.0
2019-07-10 08:00:00	QQQ	ETF	190.12	192.16	190.03	191.96	865232.0
2019-07-10 09:00:00	QQQ	ETF	191.99	193.09	191.62	192.98	4746858.0
2019-07-10 10:00:00	QQQ	ETF	192.97	193.09	191.85	191.9	3928936.0
2019-07-10 11:00:00	QQQ	ETF	191.91	192.4	191.47	192.34	3317639.0
2019-07-10 12:00:00	QQQ	ETF	192.34	192.47	192.0833	192.34	1098727.0
2019-07-10 13:00:00	QQQ	ETF	192.35	192.74	192.3	192.5921	1724518.0
2019-07-10 14:00:00	QQQ	ETF	192.59	192.81	191.99	192.27	2285159.0
2019-07-10 15:00:00	QQQ	ETF	192.27	192.71	192.13	192.55	4456967.0
2019-07-10 16:00:00	QQQ	ETF	192.55	192.8696	192.47	192.52	1277044.0
2019-07-10 17:00:00	QQQ	ETF	192.53	192.58	192.42	192.48	36244.0
2019-07-10 18:00:00	QQQ	ETF	192.48	192.7	192.41	192.67	28310.0
2019-07-10 19:00:00	QQQ	ETF	192.58	192.63	192.51	192.57	44346.0
2019-07-10 04:00:00	IWM	ETF	155.18	155.21	155.18	155.21	200.0
2019-07-10 06:00:00	IWM	ETF	154.8	154.89	154.8	154.86	1600.0
2019-07-10 07:00:00	IWM	ETF	155.0	155.05	155.0	155.05	3400.0
2019-07-10 08:00:00	IWM	ETF	155.0	156.31	154.99	156.17	224123.0
2019-07-10 09:00:00	IWM	ETF	156.2	156.53	156.05	156.48	2580850.0
2019-07-10 10:00:00	IWM	ETF	156.48	156.56	155.18	155.2169	3028794.0
2019-07-10 11:00:00	IWM	ETF	155.2	155.63	154.85	155.61	2047387.0
2019-07-10 12:00:00	IWM	ETF	155.6316	156.21	155.6	156.08	1267394.0
2019-07-10 13:00:00	IWM	ETF	156.1	156.13	155.76	155.78	1060369.0
2019-07-10 14:00:00	IWM	ETF	155.78	155.92	155.61	155.78	1030615.0
2019-07-10 15:00:00	IWM	ETF	155.78	155.85	155.51	155.67	2493076.0
2019-07-10 16:00:00	IWM	ETF	155.67	155.68	155.53	155.58	2302520.0
2019-07-10 17:00:00	IWM	ETF	155.65	155.65	155.65	155.65	100.0
2019-07-10 18:00:00	IWM	ETF	155.56	155.76	155.53	155.66	23824.0
2019-07-10 19:00:00	IWM	ETF	155.6	155.62	155.5401	155.6	7950.0
2019-07-10 07:00:00	DIA	ETF	267.36	267.36	267.28	267.3	1601.0
2019-07-10 08:00:00	DIA	ETF	267.28	269.0	267.28	269.0	10241.0
2019-07-10 09:00:00	DIA	ETF	268.9	269.88	268.76	269.71	512350.0

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

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