PREVIEW / etf_1hour / 2019-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-08.parquet
  size:    324 KB
  rows:    10,914

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-08 04:00:00	SPY	ETF	297.61	297.77	297.51	297.51	8514.0
2019-07-08 05:00:00	SPY	ETF	297.51	297.51	297.17	297.37	8997.0
2019-07-08 06:00:00	SPY	ETF	297.35	297.45	297.2	297.2	3120.0
2019-07-08 07:00:00	SPY	ETF	297.22	297.52	297.22	297.22	81360.0
2019-07-08 08:00:00	SPY	ETF	297.4	297.49	296.92	297.1	305684.0
2019-07-08 09:00:00	SPY	ETF	297.09	297.16	296.45	296.57	5000462.0
2019-07-08 10:00:00	SPY	ETF	296.575	297.35	296.5	296.71	6184194.0
2019-07-08 11:00:00	SPY	ETF	296.72	297.0635	296.53	296.675	3175939.0
2019-07-08 12:00:00	SPY	ETF	296.68	296.7	296.34	296.595	3481880.0
2019-07-08 13:00:00	SPY	ETF	296.59	296.82	296.46	296.615	3073743.0
2019-07-08 14:00:00	SPY	ETF	296.62	298.2579	296.22	296.57	5787383.0
2019-07-08 15:00:00	SPY	ETF	296.57	297.1	296.48	296.86	10099094.0
2019-07-08 16:00:00	SPY	ETF	296.85	297.01	296.56	296.73	7031747.0
2019-07-08 17:00:00	SPY	ETF	296.73	296.82	296.6	296.7	138046.0
2019-07-08 18:00:00	SPY	ETF	296.69	296.79	296.56	296.75	73410.0
2019-07-08 19:00:00	SPY	ETF	296.75	296.82	296.4	296.48	48706.0
2019-07-08 04:00:00	QQQ	ETF	190.26	190.5	190.26	190.3	9440.0
2019-07-08 05:00:00	QQQ	ETF	190.24	190.24	189.92	190.01	18481.0
2019-07-08 06:00:00	QQQ	ETF	190.01	190.04	189.78	189.84	8643.0
2019-07-08 07:00:00	QQQ	ETF	189.8	190.07	189.8	189.93	43818.0
2019-07-08 08:00:00	QQQ	ETF	189.9101	190.15	189.77	189.89	75780.0
2019-07-08 09:00:00	QQQ	ETF	189.85	189.99	188.93	188.98	2720981.0
2019-07-08 10:00:00	QQQ	ETF	188.99	189.565	188.96	189.42	2785442.0
2019-07-08 11:00:00	QQQ	ETF	189.42	189.7099	189.12	189.275	1671487.0
2019-07-08 12:00:00	QQQ	ETF	189.27	189.45	189.03	189.4351	1323174.0
2019-07-08 13:00:00	QQQ	ETF	189.435	189.57	189.29	189.43	1040350.0
2019-07-08 14:00:00	QQQ	ETF	189.41	189.6974	189.175	189.5962	1319070.0
2019-07-08 15:00:00	QQQ	ETF	189.6	189.87	189.53	189.72	2979555.0
2019-07-08 16:00:00	QQQ	ETF	189.73	189.76	187.7651	189.54	524073.0
2019-07-08 17:00:00	QQQ	ETF	189.47	189.71	189.4	189.54	59098.0
2019-07-08 18:00:00	QQQ	ETF	189.53	189.57	189.4	189.55	26006.0
2019-07-08 19:00:00	QQQ	ETF	189.58	189.59	189.21	189.35	29327.0
2019-07-08 04:00:00	IWM	ETF	156.52	156.57	156.52	156.57	2200.0
2019-07-08 05:00:00	IWM	ETF	156.43	156.43	156.43	156.43	1000.0
2019-07-08 07:00:00	IWM	ETF	156.33	156.57	156.33	156.34	8300.0
2019-07-08 08:00:00	IWM	ETF	156.4901	156.52	156.25	156.25	27258.0
2019-07-08 09:00:00	IWM	ETF	156.28	156.29	155.65	156.12	1183123.0
2019-07-08 10:00:00	IWM	ETF	156.115	156.48	155.59	155.72	1342783.0
2019-07-08 11:00:00	IWM	ETF	155.71	155.835	155.33	155.505	1081215.0
2019-07-08 12:00:00	IWM	ETF	155.51	155.53	155.14	155.31	969306.0
2019-07-08 13:00:00	IWM	ETF	155.317	155.395	155.12	155.22	795485.0
2019-07-08 14:00:00	IWM	ETF	155.21	155.22	154.89	155.07	813989.0
2019-07-08 15:00:00	IWM	ETF	155.07	155.3671	155.06	155.23	2196900.0
2019-07-08 16:00:00	IWM	ETF	155.23	155.33	155.07	155.15	542877.0
2019-07-08 17:00:00	IWM	ETF	155.18	155.18	155.11	155.11	1324.0
2019-07-08 18:00:00	IWM	ETF	155.15	155.17	155.15	155.16	4330.0
2019-07-08 19:00:00	IWM	ETF	155.0699	155.0699	154.94	154.94	4062.0
2019-07-08 07:00:00	DIA	ETF	268.1	268.34	268.1	268.34	300.0
2019-07-08 08:00:00	DIA	ETF	268.18	268.21	267.96	267.98	1492.0
2019-07-08 09:00:00	DIA	ETF	267.93	268.0	267.47	267.73	319441.0

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

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