PREVIEW / etf_1hour / 2019-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-25.parquet
  size:    331 KB
  rows:    10,749

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-10-25 04:00:00	SPY	ETF	300.18	300.26	300.05	300.14	7271.0
2019-10-25 05:00:00	SPY	ETF	300.14	300.33	300.08	300.28	5310.0
2019-10-25 06:00:00	SPY	ETF	300.29	300.44	300.25	300.44	20135.0
2019-10-25 07:00:00	SPY	ETF	300.37	300.4	300.13	300.13	22719.0
2019-10-25 08:00:00	SPY	ETF	300.3	300.5	299.69	299.85	164582.0
2019-10-25 09:00:00	SPY	ETF	299.84	300.4688	299.62	300.37	2772698.0
2019-10-25 10:00:00	SPY	ETF	300.35	301.4	300.29	301.335	4986012.0
2019-10-25 11:00:00	SPY	ETF	301.33	302.2	301.19	302.0006	6095856.0
2019-10-25 12:00:00	SPY	ETF	302.0	302.07	301.55	301.7501	4259324.0
2019-10-25 13:00:00	SPY	ETF	301.76	301.9268	301.61	301.725	3409026.0
2019-10-25 14:00:00	SPY	ETF	301.72	301.82	301.25	301.67	5531085.0
2019-10-25 15:00:00	SPY	ETF	301.67	301.85	301.48	301.64	10782855.0
2019-10-25 16:00:00	SPY	ETF	301.66	301.6963	301.44	301.57	5736916.0
2019-10-25 17:00:00	SPY	ETF	301.51	301.77	301.48	301.75	299329.0
2019-10-25 18:00:00	SPY	ETF	301.73	301.82	301.73	301.78	29372.0
2019-10-25 19:00:00	SPY	ETF	301.76	301.85	301.7	301.85	26763.0
2019-10-25 04:00:00	QQQ	ETF	193.19	193.23	193.14	193.14	8100.0
2019-10-25 05:00:00	QQQ	ETF	193.3	193.35	193.2	193.25	7814.0
2019-10-25 06:00:00	QQQ	ETF	193.32	193.41	193.28	193.4	8648.0
2019-10-25 07:00:00	QQQ	ETF	193.41	193.41	193.25	193.27	19812.0
2019-10-25 08:00:00	QQQ	ETF	193.36	193.41	192.85	193.04	143665.0
2019-10-25 09:00:00	QQQ	ETF	193.01	194.06	192.95	193.9	2182549.0
2019-10-25 10:00:00	QQQ	ETF	193.89	194.95	193.86	194.89	3218804.0
2019-10-25 11:00:00	QQQ	ETF	194.89	195.71	194.85	195.52	3328437.0
2019-10-25 12:00:00	QQQ	ETF	195.52	195.5898	195.16	195.33	1307053.0
2019-10-25 13:00:00	QQQ	ETF	195.35	195.56	195.27	195.38	868446.0
2019-10-25 14:00:00	QQQ	ETF	195.3775	195.4868	195.06	195.35	1736513.0
2019-10-25 15:00:00	QQQ	ETF	195.34	195.74	195.23	195.61	4892300.0
2019-10-25 16:00:00	QQQ	ETF	195.61	195.73	195.48	195.7	962037.0
2019-10-25 17:00:00	QQQ	ETF	195.54	195.74	195.54	195.73	4715.0
2019-10-25 18:00:00	QQQ	ETF	195.7	195.8	195.7	195.8	4947.0
2019-10-25 19:00:00	QQQ	ETF	195.74	195.9	195.71	195.9	35154.0
2019-10-25 04:00:00	IWM	ETF	154.2	154.2	154.2	154.2	100.0
2019-10-25 06:00:00	IWM	ETF	154.26	154.37	154.26	154.35	12900.0
2019-10-25 07:00:00	IWM	ETF	154.31	154.31	154.15	154.18	600.0
2019-10-25 08:00:00	IWM	ETF	154.18	154.18	153.88	154.0	36822.0
2019-10-25 09:00:00	IWM	ETF	154.0	154.44	153.84	154.31	1210310.0
2019-10-25 10:00:00	IWM	ETF	154.35	155.0	154.25	154.825	1460639.0
2019-10-25 11:00:00	IWM	ETF	154.825	155.53	154.825	155.44	1575710.0
2019-10-25 12:00:00	IWM	ETF	155.44	155.48	155.2	155.3499	793428.0
2019-10-25 13:00:00	IWM	ETF	155.35	155.44	155.28	155.4	620650.0
2019-10-25 14:00:00	IWM	ETF	155.39	155.43	155.13	155.265	859027.0
2019-10-25 15:00:00	IWM	ETF	155.27	155.31	154.94	154.98	1991541.0
2019-10-25 16:00:00	IWM	ETF	154.98	155.11	154.95	154.98	822741.0
2019-10-25 17:00:00	IWM	ETF	154.98	155.04	154.92	155.04	24914.0
2019-10-25 18:00:00	IWM	ETF	155.04	155.04	154.99	155.0	9700.0
2019-10-25 19:00:00	IWM	ETF	155.0	155.08	155.0	155.08	4098.0
2019-10-25 07:00:00	DIA	ETF	268.26	268.26	268.26	268.26	150.0
2019-10-25 08:00:00	DIA	ETF	268.02	268.04	267.74	267.74	6236.0
2019-10-25 09:00:00	DIA	ETF	267.78	268.71	267.62	268.5	288083.0

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

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