PREVIEW / etf_1hour / 2019-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-09.parquet
  size:    337 KB
  rows:    11,075

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-09 04:00:00	SPY	ETF	298.92	298.92	298.73	298.8	7384.0
2019-09-09 05:00:00	SPY	ETF	298.92	299.1	298.85	299.1	10250.0
2019-09-09 06:00:00	SPY	ETF	299.15	299.21	298.98	299.1	10158.0
2019-09-09 07:00:00	SPY	ETF	299.04	299.19	298.92	299.19	150356.0
2019-09-09 08:00:00	SPY	ETF	298.9999	299.32	298.85	299.25	149803.0
2019-09-09 09:00:00	SPY	ETF	299.22	299.35	298.3	298.32	5872163.0
2019-09-09 10:00:00	SPY	ETF	298.32	298.89	298.27	298.84	5919115.0
2019-09-09 11:00:00	SPY	ETF	298.85	298.91	298.42	298.515	5756425.0
2019-09-09 12:00:00	SPY	ETF	298.52	298.56	297.16	297.93	8691143.0
2019-09-09 13:00:00	SPY	ETF	297.92	297.99	297.39	297.8	4053241.0
2019-09-09 14:00:00	SPY	ETF	297.8001	297.91	297.42	297.61	4839957.0
2019-09-09 15:00:00	SPY	ETF	297.6	298.23	297.48	298.15	11242184.0
2019-09-09 16:00:00	SPY	ETF	298.14	298.22	297.99	298.18	3319136.0
2019-09-09 17:00:00	SPY	ETF	298.13	298.2	298.0	298.06	318154.0
2019-09-09 18:00:00	SPY	ETF	298.09	298.37	298.09	298.31	150058.0
2019-09-09 19:00:00	SPY	ETF	298.34	298.47	298.25	298.45	21216.0
2019-09-09 04:00:00	QQQ	ETF	192.09	192.1	191.88	191.98	63250.0
2019-09-09 05:00:00	QQQ	ETF	191.98	192.2	191.98	192.18	12500.0
2019-09-09 06:00:00	QQQ	ETF	192.15	192.22	192.05	192.1	11496.0
2019-09-09 07:00:00	QQQ	ETF	192.05	192.07	191.95	192.0	279597.0
2019-09-09 08:00:00	QQQ	ETF	192.01	192.23	191.95	192.19	83136.0
2019-09-09 09:00:00	QQQ	ETF	192.19	192.32	191.48	191.51	3147335.0
2019-09-09 10:00:00	QQQ	ETF	191.51	192.065	191.32	192.01	3801790.0
2019-09-09 11:00:00	QQQ	ETF	192.02	192.11	191.6559	191.77	1500247.0
2019-09-09 12:00:00	QQQ	ETF	191.78	191.81	190.302	190.98	3461520.0
2019-09-09 13:00:00	QQQ	ETF	190.98	191.07	190.4214	190.769	1867037.0
2019-09-09 14:00:00	QQQ	ETF	190.765	190.79	190.215	190.45	2229754.0
2019-09-09 15:00:00	QQQ	ETF	190.45	191.27	190.33	191.15	4313548.0
2019-09-09 16:00:00	QQQ	ETF	191.16	191.21	190.93	191.08	839529.0
2019-09-09 17:00:00	QQQ	ETF	191.07	191.16	191.02	191.08	7971.0
2019-09-09 18:00:00	QQQ	ETF	191.1	191.26	191.07	191.21	18953.0
2019-09-09 19:00:00	QQQ	ETF	191.22	191.33	191.14	191.33	14232.0
2019-09-09 04:00:00	IWM	ETF	151.0	151.0	150.2	150.2	698.0
2019-09-09 05:00:00	IWM	ETF	150.46	150.48	150.46	150.48	480.0
2019-09-09 06:00:00	IWM	ETF	150.48	150.48	150.48	150.48	1000.0
2019-09-09 07:00:00	IWM	ETF	150.47	150.5	150.47	150.5	6037.0
2019-09-09 08:00:00	IWM	ETF	150.51	150.6	150.48	150.5701	16883.0
2019-09-09 09:00:00	IWM	ETF	150.54	150.74	150.06	150.18	2020639.0
2019-09-09 10:00:00	IWM	ETF	150.17	151.46	150.07	151.35	2853294.0
2019-09-09 11:00:00	IWM	ETF	151.36	151.89	151.194	151.87	3475212.0
2019-09-09 12:00:00	IWM	ETF	151.87	152.24	150.73	151.2334	2742602.0
2019-09-09 13:00:00	IWM	ETF	151.24	151.34	150.95	151.24	1407659.0
2019-09-09 14:00:00	IWM	ETF	151.25	151.619	151.11	151.619	1533566.0
2019-09-09 15:00:00	IWM	ETF	151.61	151.9	151.48	151.89	4014571.0
2019-09-09 16:00:00	IWM	ETF	151.89	151.92	151.55	151.66	2206819.0
2019-09-09 17:00:00	IWM	ETF	151.66	151.91	151.65	151.68	61552.0
2019-09-09 18:00:00	IWM	ETF	151.7	151.91	151.67	151.79	15053.0
2019-09-09 19:00:00	IWM	ETF	151.81	151.86	151.78	151.86	2600.0
2019-09-09 07:00:00	DIA	ETF	268.9	268.9	268.85	268.85	610.0
2019-09-09 08:00:00	DIA	ETF	268.98	269.0	268.94	269.0	1379.0

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

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