PREVIEW / etf_1hour / 2019-09-05

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-05.parquet
  size:    347 KB
  rows:    11,436

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-05 04:00:00	SPY	ETF	295.8	296.35	295.73	296.35	39502.0
2019-09-05 05:00:00	SPY	ETF	296.35	296.64	296.12	296.64	48183.0
2019-09-05 06:00:00	SPY	ETF	296.62	296.89	296.56	296.81	46615.0
2019-09-05 07:00:00	SPY	ETF	296.76	296.79	296.3	296.4	182241.0
2019-09-05 08:00:00	SPY	ETF	296.61	297.19	294.04	296.86	573732.0
2019-09-05 09:00:00	SPY	ETF	296.86	297.76	296.64	297.52	8084521.0
2019-09-05 10:00:00	SPY	ETF	297.81	298.83	297.55	298.05	19117781.0
2019-09-05 11:00:00	SPY	ETF	298.04	298.38	297.731	297.88	12661596.0
2019-09-05 12:00:00	SPY	ETF	297.87	298.13	297.56	297.83	7991538.0
2019-09-05 13:00:00	SPY	ETF	297.83	297.98	297.41	297.71	5169711.0
2019-09-05 14:00:00	SPY	ETF	297.705	298.0	297.53	297.9585	5633377.0
2019-09-05 15:00:00	SPY	ETF	297.96	298.305	297.69	297.82	14537950.0
2019-09-05 16:00:00	SPY	ETF	297.82	297.8934	297.2	297.21	8290208.0
2019-09-05 17:00:00	SPY	ETF	297.21	297.82	297.0	297.2	228878.0
2019-09-05 18:00:00	SPY	ETF	297.19	297.6	297.19	297.59	97699.0
2019-09-05 19:00:00	SPY	ETF	297.6	297.95	297.6	297.9	60285.0
2019-09-05 04:00:00	QQQ	ETF	189.97	190.38	189.8	190.34	60142.0
2019-09-05 05:00:00	QQQ	ETF	190.41	190.66	190.22	190.58	22888.0
2019-09-05 06:00:00	QQQ	ETF	190.58	190.73	190.53	190.71	33245.0
2019-09-05 07:00:00	QQQ	ETF	190.67	190.67	190.25	190.29	114936.0
2019-09-05 08:00:00	QQQ	ETF	190.45	190.99	189.63	190.61	293256.0
2019-09-05 09:00:00	QQQ	ETF	190.55	191.4	190.29	191.27	5152386.0
2019-09-05 10:00:00	QQQ	ETF	191.28	192.325	191.27	191.7	7132493.0
2019-09-05 11:00:00	QQQ	ETF	191.7	191.955	191.51	191.53	2442192.0
2019-09-05 12:00:00	QQQ	ETF	191.52	191.77	191.381	191.535	1929666.0
2019-09-05 13:00:00	QQQ	ETF	191.53	191.625	191.175	191.47	1587625.0
2019-09-05 14:00:00	QQQ	ETF	191.48	191.79	191.31	191.74	1768238.0
2019-09-05 15:00:00	QQQ	ETF	191.74	192.0	191.62	191.82	6482392.0
2019-09-05 16:00:00	QQQ	ETF	191.8	191.8473	191.46	191.46	2078664.0
2019-09-05 17:00:00	QQQ	ETF	191.57	191.58	191.42	191.53	26373.0
2019-09-05 18:00:00	QQQ	ETF	191.63	191.78	191.61	191.72	24268.0
2019-09-05 19:00:00	QQQ	ETF	191.72	192.0499	191.72	192.03	116847.0
2019-09-05 04:00:00	IWM	ETF	149.09	149.42	149.09	149.4	5061.0
2019-09-05 05:00:00	IWM	ETF	149.54	149.66	149.4	149.66	5900.0
2019-09-05 06:00:00	IWM	ETF	149.68	149.8	149.63	149.77	22800.0
2019-09-05 07:00:00	IWM	ETF	149.79	149.79	149.52	149.6	17550.0
2019-09-05 08:00:00	IWM	ETF	149.68	149.89	149.6	149.87	76450.0
2019-09-05 09:00:00	IWM	ETF	149.81	150.02	149.37	149.67	3206215.0
2019-09-05 10:00:00	IWM	ETF	149.68	151.91	149.68	151.15	7246849.0
2019-09-05 11:00:00	IWM	ETF	151.18	151.49	150.24	150.2601	1982686.0
2019-09-05 12:00:00	IWM	ETF	150.22	150.49	150.04	150.23	1070577.0
2019-09-05 13:00:00	IWM	ETF	150.24	150.52	150.05	150.46	1197151.0
2019-09-05 14:00:00	IWM	ETF	150.46	150.895	150.24	150.87	1026992.0
2019-09-05 15:00:00	IWM	ETF	150.88	151.09	150.4	150.55	3226768.0
2019-09-05 16:00:00	IWM	ETF	150.56	150.59	150.07	150.16	2132126.0
2019-09-05 17:00:00	IWM	ETF	150.24	150.24	150.15	150.19	7390.0
2019-09-05 18:00:00	IWM	ETF	150.15	150.35	150.15	150.35	12671.0
2019-09-05 19:00:00	IWM	ETF	150.39	150.55	150.39	150.55	12280.0
2019-09-05 04:00:00	DIA	ETF	265.9	266.24	265.9	266.24	1996.0
2019-09-05 05:00:00	DIA	ETF	266.24	266.36	266.24	266.36	1166.0

> showing 50 of 11,436 rows — these rows as CSV

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