PREVIEW / etf_1hour / 2022-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-04.parquet
  size:    452 KB
  rows:    16,341

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-02-04 04:00:00	SPY	ETF	450.19	450.58	449.5	449.83	40852.0
2022-02-04 05:00:00	SPY	ETF	449.5	449.57	446.98	447.66	89329.0
2022-02-04 06:00:00	SPY	ETF	447.36	447.66	445.2	445.2	196944.0
2022-02-04 07:00:00	SPY	ETF	445.21	447.92	445.21	447.58	785848.0
2022-02-04 08:00:00	SPY	ETF	445.8299	452.04	443.98	444.38	1727437.0
2022-02-04 09:00:00	SPY	ETF	444.4	448.31	443.495	447.19	8507914.0
2022-02-04 10:00:00	SPY	ETF	447.17	448.72	444.22	444.7	11906263.0
2022-02-04 11:00:00	SPY	ETF	444.71	447.86	443.83	446.84	10453863.0
2022-02-04 12:00:00	SPY	ETF	446.86	448.63	446.45	448.56	7531214.0
2022-02-04 13:00:00	SPY	ETF	448.56	450.83	448.55	450.64	10311179.0
2022-02-04 14:00:00	SPY	ETF	450.65	451.14	449.32	451.0599	9592047.0
2022-02-04 15:00:00	SPY	ETF	451.06	452.78	448.58	448.73	19819218.0
2022-02-04 16:00:00	SPY	ETF	448.76	449.06	447.78	448.05	6294773.0
2022-02-04 17:00:00	SPY	ETF	447.91	448.3	447.8	448.0	146604.0
2022-02-04 18:00:00	SPY	ETF	448.05	448.7	448.05	448.4	56888.0
2022-02-04 19:00:00	SPY	ETF	448.45	448.66	448.3	448.66	23542.0
2022-02-04 04:00:00	QQQ	ETF	359.07	359.4	357.96	358.06	189566.0
2022-02-04 05:00:00	QQQ	ETF	358.0	358.4	355.64	356.63	245635.0
2022-02-04 06:00:00	QQQ	ETF	356.62	356.62	354.14	354.14	299815.0
2022-02-04 07:00:00	QQQ	ETF	354.19	356.95	354.15	356.79	665559.0
2022-02-04 08:00:00	QQQ	ETF	354.6599	361.28	351.53	351.63	2457563.0
2022-02-04 09:00:00	QQQ	ETF	351.66	356.19	350.31	355.43	10283334.0
2022-02-04 10:00:00	QQQ	ETF	355.43	357.64	353.3	353.67	13975119.0
2022-02-04 11:00:00	QQQ	ETF	353.68	356.62	352.2	355.6	8356000.0
2022-02-04 12:00:00	QQQ	ETF	355.6	357.4001	354.99	357.3	6200310.0
2022-02-04 13:00:00	QQQ	ETF	357.31	359.76	357.3	359.56	6345754.0
2022-02-04 14:00:00	QQQ	ETF	359.54	360.12	358.195	359.855	6356411.0
2022-02-04 15:00:00	QQQ	ETF	359.88	361.4	357.8247	357.99	10982049.0
2022-02-04 16:00:00	QQQ	ETF	357.97	358.33	356.77	357.06	2215218.0
2022-02-04 17:00:00	QQQ	ETF	357.05	358.01	357.03	357.53	218735.0
2022-02-04 18:00:00	QQQ	ETF	357.54	358.0	357.54	357.9	99584.0
2022-02-04 19:00:00	QQQ	ETF	357.81	358.0	357.75	358.0	34732.0
2022-02-04 04:00:00	IWM	ETF	198.34	198.53	197.89	198.01	13372.0
2022-02-04 05:00:00	IWM	ETF	198.01	198.01	196.17	196.48	48972.0
2022-02-04 06:00:00	IWM	ETF	196.34	196.44	195.5	195.66	81223.0
2022-02-04 07:00:00	IWM	ETF	195.65	197.25	195.6	196.94	111899.0
2022-02-04 08:00:00	IWM	ETF	197.06	199.17	194.49	195.75	507658.0
2022-02-04 09:00:00	IWM	ETF	195.61	197.74	195.3	196.23	4805838.0
2022-02-04 10:00:00	IWM	ETF	196.3	197.64	195.35	195.49	4293893.0
2022-02-04 11:00:00	IWM	ETF	195.5	197.01	194.92	196.41	2630090.0
2022-02-04 12:00:00	IWM	ETF	196.45	197.38	195.91	197.36	1818389.0
2022-02-04 13:00:00	IWM	ETF	197.365	198.99	197.36	198.86	2704847.0
2022-02-04 14:00:00	IWM	ETF	198.86	199.16	198.06	199.05	2459184.0
2022-02-04 15:00:00	IWM	ETF	199.08	200.1	198.32	198.44	4209774.0
2022-02-04 16:00:00	IWM	ETF	198.48	198.53	197.76	197.9	1698939.0
2022-02-04 17:00:00	IWM	ETF	197.9	198.38	197.88	198.17	176454.0
2022-02-04 18:00:00	IWM	ETF	198.16	198.38	198.03	198.3	12987.0
2022-02-04 19:00:00	IWM	ETF	198.25	198.38	198.17	198.24	19439.0
2022-02-04 04:00:00	DIA	ETF	351.91	351.94	351.91	351.93	1400.0
2022-02-04 05:00:00	DIA	ETF	351.58	351.58	350.07	350.23	4900.0

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

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