PREVIEW / etf_1hour / 2022-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-06.parquet
  size:    462 KB
  rows:    16,917

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
2022-04-06 04:00:00	SPY	ETF	451.27	451.27	448.79	449.47	33198.0
2022-04-06 05:00:00	SPY	ETF	449.6	449.6	447.99	448.65	37601.0
2022-04-06 06:00:00	SPY	ETF	448.7	448.71	447.69	447.75	70593.0
2022-04-06 07:00:00	SPY	ETF	447.82	447.99	446.51	446.72	587471.0
2022-04-06 08:00:00	SPY	ETF	447.3199	451.55	446.43	447.07	503488.0
2022-04-06 09:00:00	SPY	ETF	447.01	447.59	445.44	445.59	10052301.0
2022-04-06 10:00:00	SPY	ETF	445.5801	445.86	444.5	444.965	11326052.0
2022-04-06 11:00:00	SPY	ETF	444.97	446.4284	444.6615	445.915	7201154.0
2022-04-06 12:00:00	SPY	ETF	445.9	446.1	444.62	445.2782	5117369.0
2022-04-06 13:00:00	SPY	ETF	445.26	446.88	444.935	446.06	5842387.0
2022-04-06 14:00:00	SPY	ETF	446.07	448.53	443.47	447.975	19486727.0
2022-04-06 15:00:00	SPY	ETF	447.99	448.93	445.3243	446.57	19048968.0
2022-04-06 16:00:00	SPY	ETF	446.56	446.75	446.12	446.14	2802978.0
2022-04-06 17:00:00	SPY	ETF	446.14	446.52	446.14	446.25	124132.0
2022-04-06 18:00:00	SPY	ETF	446.27	446.72	446.15	446.54	92623.0
2022-04-06 19:00:00	SPY	ETF	446.6	446.6	445.11	445.2	65481.0
2022-04-06 04:00:00	QQQ	ETF	359.46	359.46	358.2	358.84	105681.0
2022-04-06 05:00:00	QQQ	ETF	359.06	359.08	357.55	358.21	99560.0
2022-04-06 06:00:00	QQQ	ETF	358.2	358.24	356.97	357.0	158137.0
2022-04-06 07:00:00	QQQ	ETF	357.01	357.21	355.14	355.34	554893.0
2022-04-06 08:00:00	QQQ	ETF	356.112	361.37	355.13	355.68	739790.0
2022-04-06 09:00:00	QQQ	ETF	355.56	356.61	353.13	353.23	9761927.0
2022-04-06 10:00:00	QQQ	ETF	353.26	353.74	352.0	352.49	11000981.0
2022-04-06 11:00:00	QQQ	ETF	352.49	353.69	351.81	353.006	5808205.0
2022-04-06 12:00:00	QQQ	ETF	352.98	353.19	351.16	351.8	4586752.0
2022-04-06 13:00:00	QQQ	ETF	351.77	354.58	351.42	353.555	5570744.0
2022-04-06 14:00:00	QQQ	ETF	353.6	356.34	350.56	355.5199	16116857.0
2022-04-06 15:00:00	QQQ	ETF	355.54	356.78	352.28	353.17	13299552.0
2022-04-06 16:00:00	QQQ	ETF	353.19	353.7368	352.89	352.97	1721936.0
2022-04-06 17:00:00	QQQ	ETF	352.93	353.26	352.92	353.23	205701.0
2022-04-06 18:00:00	QQQ	ETF	353.07	353.55	352.96	353.37	315741.0
2022-04-06 19:00:00	QQQ	ETF	353.39	353.4	351.76	351.87	220837.0
2022-04-06 04:00:00	IWM	ETF	202.46	202.73	202.05	202.37	21970.0
2022-04-06 05:00:00	IWM	ETF	202.47	202.5	201.8	202.02	8376.0
2022-04-06 06:00:00	IWM	ETF	202.01	202.12	201.72	201.8	24386.0
2022-04-06 07:00:00	IWM	ETF	201.77	201.9	201.32	201.33	104737.0
2022-04-06 08:00:00	IWM	ETF	201.88	202.1	201.24	201.48	98703.0
2022-04-06 09:00:00	IWM	ETF	201.5	201.79	199.86	199.86	3389977.0
2022-04-06 10:00:00	IWM	ETF	199.86	200.87	198.89	200.06	4369835.0
2022-04-06 11:00:00	IWM	ETF	200.05	200.61	199.665	200.15	2353624.0
2022-04-06 12:00:00	IWM	ETF	200.15	200.39	199.55	200.24	1749313.0
2022-04-06 13:00:00	IWM	ETF	200.24	200.88	199.95	200.22	1756597.0
2022-04-06 14:00:00	IWM	ETF	200.25	201.57	198.68	201.31	4915849.0
2022-04-06 15:00:00	IWM	ETF	201.32	201.8	199.6	200.18	5523603.0
2022-04-06 16:00:00	IWM	ETF	200.11	200.2655	199.91	199.99	1691350.0
2022-04-06 17:00:00	IWM	ETF	200.09	200.09	199.95	200.09	9594.0
2022-04-06 18:00:00	IWM	ETF	200.02	200.37	200.02	200.21	49393.0
2022-04-06 19:00:00	IWM	ETF	200.2	200.22	199.47	199.47	48127.0
2022-04-06 04:00:00	DIA	ETF	345.48	345.48	344.98	344.98	580.0
2022-04-06 05:00:00	DIA	ETF	345.45	345.45	344.49	344.49	2770.0

> showing 50 of 16,917 rows — these rows as CSV

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