PREVIEW / etf_1hour / 2019-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-23.parquet
  size:    331 KB
  rows:    10,888

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-09-23 04:00:00	SPY	ETF	298.22	298.22	297.16	297.24	57498.0
2019-09-23 05:00:00	SPY	ETF	297.25	298.0	297.25	297.89	41420.0
2019-09-23 06:00:00	SPY	ETF	297.92	298.14	297.79	298.07	29920.0
2019-09-23 07:00:00	SPY	ETF	298.05	298.14	297.8	297.82	126596.0
2019-09-23 08:00:00	SPY	ETF	298.0501	299.4	297.55	297.92	783213.0
2019-09-23 09:00:00	SPY	ETF	297.92	298.39	297.27	298.05	7324187.0
2019-09-23 10:00:00	SPY	ETF	298.06	298.17	297.44	297.6875	5589714.0
2019-09-23 11:00:00	SPY	ETF	297.705	298.59	297.68	298.435	4212043.0
2019-09-23 12:00:00	SPY	ETF	298.44	298.71	298.3	298.4461	3027961.0
2019-09-23 13:00:00	SPY	ETF	298.45	298.79	298.37	298.72	2298531.0
2019-09-23 14:00:00	SPY	ETF	298.72	298.75	298.47	298.6	2915893.0
2019-09-23 15:00:00	SPY	ETF	298.6	299.0	298.18	298.25	9367549.0
2019-09-23 16:00:00	SPY	ETF	298.29	299.04	298.2	298.96	10426039.0
2019-09-23 17:00:00	SPY	ETF	298.99	299.04	298.9	298.98	338688.0
2019-09-23 18:00:00	SPY	ETF	299.0	299.16	298.95	299.16	246647.0
2019-09-23 19:00:00	SPY	ETF	299.17	300.01	299.17	299.64	155126.0
2019-09-23 04:00:00	QQQ	ETF	190.54	190.54	189.88	189.95	29980.0
2019-09-23 05:00:00	QQQ	ETF	189.98	190.54	189.96	190.46	36629.0
2019-09-23 06:00:00	QQQ	ETF	190.46	190.66	190.41	190.65	15268.0
2019-09-23 07:00:00	QQQ	ETF	190.58	190.69	190.38	190.4	67008.0
2019-09-23 08:00:00	QQQ	ETF	190.63	191.55	190.18	190.51	203205.0
2019-09-23 09:00:00	QQQ	ETF	190.48	190.69	190.0	190.38	2999681.0
2019-09-23 10:00:00	QQQ	ETF	190.385	190.54	189.72	189.98	3082184.0
2019-09-23 11:00:00	QQQ	ETF	190.0	190.8	189.968	190.59	1891147.0
2019-09-23 12:00:00	QQQ	ETF	190.61	190.905	190.51	190.64	1569116.0
2019-09-23 13:00:00	QQQ	ETF	190.64	190.98	190.575	190.85	1577882.0
2019-09-23 14:00:00	QQQ	ETF	190.86	190.89	190.63	190.78	876983.0
2019-09-23 15:00:00	QQQ	ETF	190.78	191.07	190.42	190.46	2993118.0
2019-09-23 16:00:00	QQQ	ETF	190.47	191.15	190.43	191.13	870870.0
2019-09-23 17:00:00	QQQ	ETF	191.2	191.2	190.5	191.01	158097.0
2019-09-23 18:00:00	QQQ	ETF	191.07	191.25	191.06	191.24	92469.0
2019-09-23 19:00:00	QQQ	ETF	191.24	191.86	191.24	191.55	74863.0
2019-09-23 04:00:00	IWM	ETF	155.53	155.53	154.89	154.89	2900.0
2019-09-23 05:00:00	IWM	ETF	154.97	155.13	154.97	155.13	8200.0
2019-09-23 06:00:00	IWM	ETF	155.06	155.16	155.05	155.16	17250.0
2019-09-23 07:00:00	IWM	ETF	155.16	155.16	154.92	154.95	16669.0
2019-09-23 08:00:00	IWM	ETF	155.08	155.75	154.82	154.98	74087.0
2019-09-23 09:00:00	IWM	ETF	155.0	155.69	154.56	155.23	1920425.0
2019-09-23 10:00:00	IWM	ETF	155.22	155.24	154.6	154.83	1709834.0
2019-09-23 11:00:00	IWM	ETF	154.84	155.67	154.82	155.53	1605551.0
2019-09-23 12:00:00	IWM	ETF	155.54	155.84	155.43	155.64	836031.0
2019-09-23 13:00:00	IWM	ETF	155.64	155.88	155.62	155.84	1111683.0
2019-09-23 14:00:00	IWM	ETF	155.85	155.89	155.5	155.555	643003.0
2019-09-23 15:00:00	IWM	ETF	155.55	155.95	155.26	155.31	3037064.0
2019-09-23 16:00:00	IWM	ETF	155.32	155.68	155.27	155.67	1047703.0
2019-09-23 17:00:00	IWM	ETF	155.51	155.73	155.31	155.61	469000.0
2019-09-23 18:00:00	IWM	ETF	155.7	155.8	155.7	155.8	3713.0
2019-09-23 19:00:00	IWM	ETF	155.82	156.21	155.82	156.1	12075.0
2019-09-23 04:00:00	DIA	ETF	269.05	269.05	268.35	268.4	1000.0
2019-09-23 06:00:00	DIA	ETF	268.78	268.78	268.78	268.78	100.0

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

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