PREVIEW / etf_1hour / 2021-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-09.parquet
  size:    428 KB
  rows:    14,654

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-09 04:00:00	SPY	ETF	390.28	390.33	389.88	390.15	33199.0
2021-02-09 05:00:00	SPY	ETF	390.18	390.2	389.93	389.93	12293.0
2021-02-09 06:00:00	SPY	ETF	389.83	390.06	389.49	390.01	71623.0
2021-02-09 07:00:00	SPY	ETF	390.04	390.19	389.7	389.75	266869.0
2021-02-09 08:00:00	SPY	ETF	389.76	390.52	389.6	389.92	358335.0
2021-02-09 09:00:00	SPY	ETF	389.9	390.28	389.17	390.13	4118409.0
2021-02-09 10:00:00	SPY	ETF	390.12	390.46	389.82	390.045	3518814.0
2021-02-09 11:00:00	SPY	ETF	390.04	390.3	389.3901	390.05	2959681.0
2021-02-09 12:00:00	SPY	ETF	390.07	390.82	390.02	390.695	2525438.0
2021-02-09 13:00:00	SPY	ETF	390.6981	390.747	390.18	390.365	1901299.0
2021-02-09 14:00:00	SPY	ETF	390.36	390.88	390.36	390.79	2352325.0
2021-02-09 15:00:00	SPY	ETF	390.79	390.89	389.89	390.25	7473947.0
2021-02-09 16:00:00	SPY	ETF	390.25	390.77	390.1433	390.77	2325450.0
2021-02-09 17:00:00	SPY	ETF	390.78	390.85	390.25	390.84	136706.0
2021-02-09 18:00:00	SPY	ETF	390.84	390.89	390.25	390.6	73323.0
2021-02-09 19:00:00	SPY	ETF	390.6	390.7	390.41	390.68	36992.0
2021-02-09 04:00:00	QQQ	ETF	333.26	333.28	333.05	333.18	25535.0
2021-02-09 05:00:00	QQQ	ETF	333.22	333.33	333.1	333.1	17996.0
2021-02-09 06:00:00	QQQ	ETF	333.0	333.18	332.86	333.17	17300.0
2021-02-09 07:00:00	QQQ	ETF	333.18	333.39	333.08	333.16	54492.0
2021-02-09 08:00:00	QQQ	ETF	333.1601	333.6	332.8204	332.99	109609.0
2021-02-09 09:00:00	QQQ	ETF	332.89	334.14	332.35	334.02	2553834.0
2021-02-09 10:00:00	QQQ	ETF	334.07	334.81	333.9	334.18	2752012.0
2021-02-09 11:00:00	QQQ	ETF	334.17	334.19	333.1601	333.73	1687641.0
2021-02-09 12:00:00	QQQ	ETF	333.71	334.09	333.4328	333.8	1068833.0
2021-02-09 13:00:00	QQQ	ETF	333.8	333.85	333.04	333.27	1016773.0
2021-02-09 14:00:00	QQQ	ETF	333.28	334.14	333.28	334.0791	1020868.0
2021-02-09 15:00:00	QQQ	ETF	334.08	334.205	333.07	333.48	2488962.0
2021-02-09 16:00:00	QQQ	ETF	333.52	334.0	333.4428	333.88	519886.0
2021-02-09 17:00:00	QQQ	ETF	333.97	333.97	333.51	333.85	26868.0
2021-02-09 18:00:00	QQQ	ETF	333.85	333.98	333.65	333.691	64242.0
2021-02-09 19:00:00	QQQ	ETF	333.6199	333.68	333.46	333.58	52608.0
2021-02-09 04:00:00	IWM	ETF	226.98	227.06	226.48	226.81	19678.0
2021-02-09 05:00:00	IWM	ETF	226.85	227.01	226.83	226.86	22884.0
2021-02-09 06:00:00	IWM	ETF	226.76	227.14	226.54	227.07	27975.0
2021-02-09 07:00:00	IWM	ETF	226.91	227.25	226.83	226.95	38881.0
2021-02-09 08:00:00	IWM	ETF	226.95	227.44	226.76	227.4	90821.0
2021-02-09 09:00:00	IWM	ETF	227.4	227.54	226.31	227.12	2428507.0
2021-02-09 10:00:00	IWM	ETF	227.117	227.28	226.4	227.25	2066603.0
2021-02-09 11:00:00	IWM	ETF	227.27	228.2	226.51	228.02	1615125.0
2021-02-09 12:00:00	IWM	ETF	228.0	229.62	227.97	229.18	1659739.0
2021-02-09 13:00:00	IWM	ETF	229.16	229.189	228.27	228.57	1046399.0
2021-02-09 14:00:00	IWM	ETF	228.56	229.08	228.315	228.615	1851803.0
2021-02-09 15:00:00	IWM	ETF	228.62	228.745	227.805	228.42	3300043.0
2021-02-09 16:00:00	IWM	ETF	228.42	228.682	228.28	228.55	1922388.0
2021-02-09 17:00:00	IWM	ETF	228.5	228.67	228.44	228.44	21167.0
2021-02-09 18:00:00	IWM	ETF	228.51	228.52	228.34	228.46	24263.0
2021-02-09 19:00:00	IWM	ETF	228.33	228.5	228.27	228.5	16115.0
2021-02-09 04:00:00	DIA	ETF	313.39	313.39	313.38	313.39	6113.0
2021-02-09 06:00:00	DIA	ETF	313.12	313.12	313.12	313.12	100.0

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

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