PREVIEW / etf_1hour / 2021-02-12

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-12.parquet
  size:    418 KB
  rows:    14,315

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
2021-02-12 04:00:00	SPY	ETF	389.3	389.91	389.3	389.69	39871.0
2021-02-12 05:00:00	SPY	ETF	389.94	390.04	389.83	390.04	8390.0
2021-02-12 06:00:00	SPY	ETF	390.03	390.03	389.7	389.99	38716.0
2021-02-12 07:00:00	SPY	ETF	390.04	390.36	389.97	390.13	87923.0
2021-02-12 08:00:00	SPY	ETF	390.2701	390.36	389.59	389.69	131645.0
2021-02-12 09:00:00	SPY	ETF	389.67	390.64	389.61	390.35	3412562.0
2021-02-12 10:00:00	SPY	ETF	390.32	391.48	390.05	391.28	3934051.0
2021-02-12 11:00:00	SPY	ETF	391.2719	391.63	391.03	391.37	2571770.0
2021-02-12 12:00:00	SPY	ETF	391.37	391.62	390.965	391.185	1937372.0
2021-02-12 13:00:00	SPY	ETF	391.185	391.26	390.51	390.85	2536233.0
2021-02-12 14:00:00	SPY	ETF	390.8482	391.18	390.55	391.1	2638766.0
2021-02-12 15:00:00	SPY	ETF	391.1	392.9	391.03	392.69	13342238.0
2021-02-12 16:00:00	SPY	ETF	392.7	393.2	392.606	393.15	3750302.0
2021-02-12 17:00:00	SPY	ETF	393.15	393.16	392.64	393.01	758208.0
2021-02-12 18:00:00	SPY	ETF	393.01	393.1	392.73	393.08	115296.0
2021-02-12 19:00:00	SPY	ETF	393.1	393.2	392.98	393.1	18591.0
2021-02-12 04:00:00	QQQ	ETF	333.56	334.08	333.52	334.04	15552.0
2021-02-12 05:00:00	QQQ	ETF	334.08	334.17	334.0	334.1	11783.0
2021-02-12 06:00:00	QQQ	ETF	334.02	334.1	333.87	334.04	10741.0
2021-02-12 07:00:00	QQQ	ETF	334.19	334.36	334.06	334.19	88916.0
2021-02-12 08:00:00	QQQ	ETF	334.2	334.48	333.56	333.63	143551.0
2021-02-12 09:00:00	QQQ	ETF	333.55	334.07	332.63	333.79	2344705.0
2021-02-12 10:00:00	QQQ	ETF	333.76	334.81	333.09	334.509	2104834.0
2021-02-12 11:00:00	QQQ	ETF	334.52	335.19	334.39	334.91	1555786.0
2021-02-12 12:00:00	QQQ	ETF	334.94	335.28	334.62	334.955	1236299.0
2021-02-12 13:00:00	QQQ	ETF	334.96	335.05	334.22	334.45	1192649.0
2021-02-12 14:00:00	QQQ	ETF	334.46	335.04	334.17	334.955	1376883.0
2021-02-12 15:00:00	QQQ	ETF	334.955	336.62	334.79	336.455	4284997.0
2021-02-12 16:00:00	QQQ	ETF	336.46	336.84	335.7	336.84	1205365.0
2021-02-12 17:00:00	QQQ	ETF	336.84	336.84	336.62	336.78	12343.0
2021-02-12 18:00:00	QQQ	ETF	336.78	336.9	336.7	336.72	9412.0
2021-02-12 19:00:00	QQQ	ETF	336.81	336.91	336.7	336.75	11425.0
2021-02-12 04:00:00	IWM	ETF	225.46	226.01	225.4	226.01	17695.0
2021-02-12 05:00:00	IWM	ETF	225.99	226.2	225.99	226.17	7200.0
2021-02-12 06:00:00	IWM	ETF	226.14	226.18	225.76	225.98	6484.0
2021-02-12 07:00:00	IWM	ETF	226.2	226.45	226.01	226.13	21238.0
2021-02-12 08:00:00	IWM	ETF	226.31	226.41	225.94	226.04	125623.0
2021-02-12 09:00:00	IWM	ETF	225.98	226.44	224.64	226.19	2266852.0
2021-02-12 10:00:00	IWM	ETF	226.17	227.21	225.72	227.09	1796491.0
2021-02-12 11:00:00	IWM	ETF	227.11	227.6199	226.62	227.25	1495310.0
2021-02-12 12:00:00	IWM	ETF	227.26	227.74	225.8879	227.06	973663.0
2021-02-12 13:00:00	IWM	ETF	227.03	227.19	226.36	226.8899	1311509.0
2021-02-12 14:00:00	IWM	ETF	226.89	226.9399	226.33	226.63	993844.0
2021-02-12 15:00:00	IWM	ETF	226.63	227.48	226.44	227.26	3416957.0
2021-02-12 16:00:00	IWM	ETF	227.26	228.02	227.1	227.67	1274314.0
2021-02-12 17:00:00	IWM	ETF	227.62	227.91	227.0	227.76	75511.0
2021-02-12 18:00:00	IWM	ETF	227.78	227.9	227.67	227.9	2894.0
2021-02-12 19:00:00	IWM	ETF	227.75	228.07	227.75	227.92	10741.0
2021-02-12 05:00:00	DIA	ETF	314.06	314.06	314.06	314.06	300.0
2021-02-12 06:00:00	DIA	ETF	314.12	314.12	314.09	314.09	350.0

> showing 50 of 14,315 rows — these rows as CSV

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