PREVIEW / etf_1hour / 2019-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-21.parquet
  size:    328 KB
  rows:    10,814

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-21 04:00:00	SPY	ETF	298.82	299.07	298.82	298.88	22271.0
2019-10-21 05:00:00	SPY	ETF	298.8	299.06	298.73	298.99	48625.0
2019-10-21 06:00:00	SPY	ETF	298.97	299.18	298.88	298.95	16447.0
2019-10-21 07:00:00	SPY	ETF	298.93	299.12	298.87	299.1	88011.0
2019-10-21 08:00:00	SPY	ETF	299.08	299.7	298.51	299.48	503400.0
2019-10-21 09:00:00	SPY	ETF	299.49	299.86	299.04	299.17	4832551.0
2019-10-21 10:00:00	SPY	ETF	299.15	299.61	298.935	299.58	3687008.0
2019-10-21 11:00:00	SPY	ETF	299.58	299.79	299.45	299.63	3641703.0
2019-10-21 12:00:00	SPY	ETF	299.63	299.95	299.41	299.84	3294142.0
2019-10-21 13:00:00	SPY	ETF	299.84	299.9	299.59	299.68	2259258.0
2019-10-21 14:00:00	SPY	ETF	299.68	300.09	299.66	299.959	3898026.0
2019-10-21 15:00:00	SPY	ETF	299.96	300.21	299.83	300.05	9458561.0
2019-10-21 16:00:00	SPY	ETF	300.05	300.16	298.0299	300.1	6551675.0
2019-10-21 17:00:00	SPY	ETF	300.14	300.2	299.99	300.11	113437.0
2019-10-21 18:00:00	SPY	ETF	300.14	300.15	300.0	300.0	37663.0
2019-10-21 19:00:00	SPY	ETF	300.0	300.08	300.0	300.04	25370.0
2019-10-21 04:00:00	QQQ	ETF	192.35	192.44	192.24	192.24	19329.0
2019-10-21 05:00:00	QQQ	ETF	192.26	192.47	192.2	192.36	7603.0
2019-10-21 06:00:00	QQQ	ETF	192.45	192.53	192.28	192.45	8675.0
2019-10-21 07:00:00	QQQ	ETF	192.4	192.48	192.31	192.47	46629.0
2019-10-21 08:00:00	QQQ	ETF	192.39	192.91	191.69	192.71	303508.0
2019-10-21 09:00:00	QQQ	ETF	192.73	193.16	192.38	192.49	2195501.0
2019-10-21 10:00:00	QQQ	ETF	192.5	193.06	192.14	192.91	1699047.0
2019-10-21 11:00:00	QQQ	ETF	192.94	193.22	192.87	193.0	1297123.0
2019-10-21 12:00:00	QQQ	ETF	192.99	193.32	192.9	193.15	1391708.0
2019-10-21 13:00:00	QQQ	ETF	193.15	193.27	193.09	193.16	712357.0
2019-10-21 14:00:00	QQQ	ETF	193.15	193.3718	193.13	193.28	1136271.0
2019-10-21 15:00:00	QQQ	ETF	193.28	193.52	193.2	193.42	3713290.0
2019-10-21 16:00:00	QQQ	ETF	193.42	193.49	192.35	193.45	832731.0
2019-10-21 17:00:00	QQQ	ETF	193.44	193.56	193.42	193.5	9944.0
2019-10-21 18:00:00	QQQ	ETF	193.44	193.45	193.39	193.42	15034.0
2019-10-21 19:00:00	QQQ	ETF	193.42	193.45	193.37	193.42	12704.0
2019-10-21 06:00:00	IWM	ETF	153.55	153.55	153.53	153.53	3500.0
2019-10-21 07:00:00	IWM	ETF	153.59	153.84	153.57	153.84	44321.0
2019-10-21 08:00:00	IWM	ETF	153.59	154.29	153.16	154.16	166870.0
2019-10-21 09:00:00	IWM	ETF	154.15	154.98	154.13	154.34	2903880.0
2019-10-21 10:00:00	IWM	ETF	154.37	154.59	153.905	154.46	2130005.0
2019-10-21 11:00:00	IWM	ETF	154.48	154.73	154.4	154.6499	1471962.0
2019-10-21 12:00:00	IWM	ETF	154.63	154.93	154.53	154.66	1195968.0
2019-10-21 13:00:00	IWM	ETF	154.66	154.73	153.98	154.2	1210545.0
2019-10-21 14:00:00	IWM	ETF	154.19	154.54	154.11	154.26	718401.0
2019-10-21 15:00:00	IWM	ETF	154.27	154.398	154.05	154.09	2614519.0
2019-10-21 16:00:00	IWM	ETF	154.04	154.2	154.01	154.2	784232.0
2019-10-21 17:00:00	IWM	ETF	154.08	154.11	154.08	154.11	6210.0
2019-10-21 18:00:00	IWM	ETF	154.2	154.2	154.14	154.14	3500.0
2019-10-21 19:00:00	IWM	ETF	154.15	154.15	154.1	154.15	1700.0
2019-10-21 04:00:00	DIA	ETF	268.4	268.4	268.4	268.4	200.0
2019-10-21 07:00:00	DIA	ETF	268.18	268.3	268.15	268.3	1650.0
2019-10-21 08:00:00	DIA	ETF	268.3	268.46	268.1001	268.32	9188.0
2019-10-21 09:00:00	DIA	ETF	268.3	268.36	267.6	267.72	288475.0

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

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