PREVIEW / etf_1hour / 2020-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-18.parquet
  size:    377 KB
  rows:    13,055

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
2020-05-18 04:00:00	SPY	ETF	289.1	289.97	289.1	289.57	124179.0
2020-05-18 05:00:00	SPY	ETF	289.5	289.61	288.76	289.29	50564.0
2020-05-18 06:00:00	SPY	ETF	289.17	289.7	288.99	289.7	101118.0
2020-05-18 07:00:00	SPY	ETF	289.78	291.94	289.43	291.78	1271725.0
2020-05-18 08:00:00	SPY	ETF	291.76	293.76	287.9	293.68	2790695.0
2020-05-18 09:00:00	SPY	ETF	293.63	294.19	292.7	293.28	15599131.0
2020-05-18 10:00:00	SPY	ETF	293.28	294.69	292.87	294.53	14682057.0
2020-05-18 11:00:00	SPY	ETF	294.525	295.58	294.48	295.04	14087316.0
2020-05-18 12:00:00	SPY	ETF	295.03	295.25	294.53	294.81	10372021.0
2020-05-18 13:00:00	SPY	ETF	294.82	295.79	294.7638	295.585	6796909.0
2020-05-18 14:00:00	SPY	ETF	295.592	296.07	295.39	295.68	8424146.0
2020-05-18 15:00:00	SPY	ETF	295.68	296.75	294.94	294.995	31484343.0
2020-05-18 16:00:00	SPY	ETF	294.99	295.28	294.63	294.79	12692819.0
2020-05-18 17:00:00	SPY	ETF	294.82	295.0	294.66	294.71	431485.0
2020-05-18 18:00:00	SPY	ETF	294.8	295.63	294.45	295.49	371735.0
2020-05-18 19:00:00	SPY	ETF	295.47	295.52	294.82	295.46	224612.0
2020-05-18 04:00:00	QQQ	ETF	224.85	225.59	224.85	225.31	30838.0
2020-05-18 05:00:00	QQQ	ETF	225.4	225.4	224.57	224.92	16858.0
2020-05-18 06:00:00	QQQ	ETF	224.82	225.17	224.5	225.17	27159.0
2020-05-18 07:00:00	QQQ	ETF	225.22	226.49	224.99	226.43	378083.0
2020-05-18 08:00:00	QQQ	ETF	226.43	226.88	224.37	226.76	547386.0
2020-05-18 09:00:00	QQQ	ETF	226.66	226.9314	225.47	226.08	6174548.0
2020-05-18 10:00:00	QQQ	ETF	226.08	227.79	225.85	227.775	6972223.0
2020-05-18 11:00:00	QQQ	ETF	227.76	228.1	227.3512	227.6701	4022819.0
2020-05-18 12:00:00	QQQ	ETF	227.67	227.79	227.13	227.53	2318381.0
2020-05-18 13:00:00	QQQ	ETF	227.53	228.475	227.4701	228.04	3204331.0
2020-05-18 14:00:00	QQQ	ETF	228.05	228.36	227.42	227.605	4213027.0
2020-05-18 15:00:00	QQQ	ETF	227.585	228.68	227.23	227.49	7417350.0
2020-05-18 16:00:00	QQQ	ETF	227.47	227.81	227.3	227.44	1032750.0
2020-05-18 17:00:00	QQQ	ETF	227.3	227.5	227.26	227.42	15741.0
2020-05-18 18:00:00	QQQ	ETF	227.45	228.17	227.32	228.09	121226.0
2020-05-18 19:00:00	QQQ	ETF	228.06	228.12	227.6	228.07	71024.0
2020-05-18 04:00:00	IWM	ETF	127.85	128.78	127.71	128.57	12607.0
2020-05-18 05:00:00	IWM	ETF	128.52	128.52	128.0	128.3	26662.0
2020-05-18 06:00:00	IWM	ETF	128.4	128.48	128.15	128.47	17740.0
2020-05-18 07:00:00	IWM	ETF	128.66	130.29	128.4	130.11	174726.0
2020-05-18 08:00:00	IWM	ETF	128.6499	131.66	126.69	131.3	1496491.0
2020-05-18 09:00:00	IWM	ETF	131.42	132.51	130.86	131.645	10499607.0
2020-05-18 10:00:00	IWM	ETF	131.66	131.94	130.83	131.525	5061495.0
2020-05-18 11:00:00	IWM	ETF	131.52	133.07	131.515	132.23	4415826.0
2020-05-18 12:00:00	IWM	ETF	132.23	132.57	131.63	131.795	2599375.0
2020-05-18 13:00:00	IWM	ETF	131.8	132.72	131.79	132.35	3074326.0
2020-05-18 14:00:00	IWM	ETF	132.36	132.725	131.75	132.38	2688566.0
2020-05-18 15:00:00	IWM	ETF	132.36	133.39	132.34	132.74	9013756.0
2020-05-18 16:00:00	IWM	ETF	132.74	133.2	132.59	132.68	2286380.0
2020-05-18 17:00:00	IWM	ETF	132.7	132.78	132.61	132.7	105629.0
2020-05-18 18:00:00	IWM	ETF	132.75	133.1	132.68	132.97	29720.0
2020-05-18 19:00:00	IWM	ETF	132.9701	133.0	132.6	132.98	70409.0
2020-05-18 04:00:00	DIA	ETF	237.7	239.94	237.7	239.94	900.0
2020-05-18 05:00:00	DIA	ETF	239.44	239.44	239.44	239.44	600.0

> showing 50 of 13,055 rows — these rows as CSV

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