PREVIEW / etf_1hour / 2021-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-22.parquet
  size:    415 KB
  rows:    14,456

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-03-22 04:00:00	SPY	ETF	389.75	390.4	388.34	389.28	71788.0
2021-03-22 05:00:00	SPY	ETF	389.4	389.57	388.9	389.37	67029.0
2021-03-22 06:00:00	SPY	ETF	389.48	389.86	389.48	389.85	12848.0
2021-03-22 07:00:00	SPY	ETF	389.76	390.72	389.76	390.53	228763.0
2021-03-22 08:00:00	SPY	ETF	389.96	390.7	388.48	390.21	174078.0
2021-03-22 09:00:00	SPY	ETF	390.18	391.49	389.97	391.3	7599334.0
2021-03-22 10:00:00	SPY	ETF	391.3	392.44	391.02	392.055	8028589.0
2021-03-22 11:00:00	SPY	ETF	392.055	392.61	391.86	392.37	4234859.0
2021-03-22 12:00:00	SPY	ETF	392.37	393.23	392.37	393.145	3789251.0
2021-03-22 13:00:00	SPY	ETF	393.15	393.33	392.71	393.31	3301754.0
2021-03-22 14:00:00	SPY	ETF	393.32	393.97	393.22	393.76	5216274.0
2021-03-22 15:00:00	SPY	ETF	393.76	394.07	392.39	392.54	12206423.0
2021-03-22 16:00:00	SPY	ETF	392.5298	392.96	392.52	392.85	6507967.0
2021-03-22 17:00:00	SPY	ETF	392.82	392.86	392.6	392.76	46409.0
2021-03-22 18:00:00	SPY	ETF	392.78	393.07	392.59	392.83	89649.0
2021-03-22 19:00:00	SPY	ETF	392.77	393.25	392.77	393.24	34571.0
2021-03-22 04:00:00	QQQ	ETF	314.11	315.0	313.93	314.59	73802.0
2021-03-22 05:00:00	QQQ	ETF	314.68	315.17	314.5	314.98	24181.0
2021-03-22 06:00:00	QQQ	ETF	314.98	315.95	314.95	315.63	102753.0
2021-03-22 07:00:00	QQQ	ETF	315.58	316.05	315.39	315.85	156743.0
2021-03-22 08:00:00	QQQ	ETF	315.86	316.07	314.0	315.4	361198.0
2021-03-22 09:00:00	QQQ	ETF	315.41	317.47	315.2	317.15	7274452.0
2021-03-22 10:00:00	QQQ	ETF	317.19	318.52	316.545	318.31	8003000.0
2021-03-22 11:00:00	QQQ	ETF	318.31	319.24	318.11	318.79	4018671.0
2021-03-22 12:00:00	QQQ	ETF	318.81	320.74	318.81	320.59	5121676.0
2021-03-22 13:00:00	QQQ	ETF	320.6	320.63	319.72	320.31	3626505.0
2021-03-22 14:00:00	QQQ	ETF	320.31	320.54	319.97	320.435	2918172.0
2021-03-22 15:00:00	QQQ	ETF	320.44	320.64	318.57	318.65	7947651.0
2021-03-22 16:00:00	QQQ	ETF	318.65	318.9737	318.44	318.46	2588351.0
2021-03-22 17:00:00	QQQ	ETF	318.73	318.73	318.4	318.52	30768.0
2021-03-22 18:00:00	QQQ	ETF	318.57	319.03	318.54	318.79	151939.0
2021-03-22 19:00:00	QQQ	ETF	318.75	319.02	318.72	319.02	80322.0
2021-03-22 04:00:00	IWM	ETF	225.75	226.51	225.75	226.41	16200.0
2021-03-22 05:00:00	IWM	ETF	226.41	226.51	226.23	226.27	19449.0
2021-03-22 06:00:00	IWM	ETF	226.35	226.42	226.27	226.27	18119.0
2021-03-22 07:00:00	IWM	ETF	226.3	227.7	226.3	227.34	68716.0
2021-03-22 08:00:00	IWM	ETF	226.4799	227.56	226.4799	227.24	117789.0
2021-03-22 09:00:00	IWM	ETF	227.25	228.1	225.24	225.3	3004835.0
2021-03-22 10:00:00	IWM	ETF	225.31	225.72	224.22	224.78	3629778.0
2021-03-22 11:00:00	IWM	ETF	224.77	225.48	224.1	225.24	1959570.0
2021-03-22 12:00:00	IWM	ETF	225.3	225.45	224.59	225.22	1710259.0
2021-03-22 13:00:00	IWM	ETF	225.25	226.29	224.77	226.2	1682502.0
2021-03-22 14:00:00	IWM	ETF	226.2	226.61	225.83	226.37	1963809.0
2021-03-22 15:00:00	IWM	ETF	226.38	226.75	225.0	225.24	3805772.0
2021-03-22 16:00:00	IWM	ETF	225.23	225.6	225.17	225.49	2976712.0
2021-03-22 17:00:00	IWM	ETF	225.68	225.7	225.26	225.55	5128.0
2021-03-22 18:00:00	IWM	ETF	225.49	225.77	225.45	225.6	11653.0
2021-03-22 19:00:00	IWM	ETF	225.5	225.85	225.5	225.83	12225.0
2021-03-22 04:00:00	DIA	ETF	325.74	325.74	324.37	325.3	2200.0
2021-03-22 05:00:00	DIA	ETF	325.26	325.31	325.1	325.24	1297.0

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

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