PREVIEW / etf_1hour / 2022-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-23.parquet
  size:    458 KB
  rows:    16,303

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-03-23 04:00:00	SPY	ETF	449.66	449.71	448.6	449.1	25893.0
2022-03-23 05:00:00	SPY	ETF	449.03	449.14	447.9	447.99	16931.0
2022-03-23 06:00:00	SPY	ETF	448.07	448.28	447.62	447.99	17635.0
2022-03-23 07:00:00	SPY	ETF	448.02	448.19	447.15	447.6	171698.0
2022-03-23 08:00:00	SPY	ETF	447.3999	450.3	446.8	447.13	393698.0
2022-03-23 09:00:00	SPY	ETF	447.08	447.54	445.64	446.08	6588586.0
2022-03-23 10:00:00	SPY	ETF	446.07	447.98	445.69	447.2235	7955397.0
2022-03-23 11:00:00	SPY	ETF	447.24	448.18	447.14	447.76	4508755.0
2022-03-23 12:00:00	SPY	ETF	447.76	448.49	446.13	446.82	5933561.0
2022-03-23 13:00:00	SPY	ETF	446.79	446.91	444.76	445.78	5849278.0
2022-03-23 14:00:00	SPY	ETF	445.79	446.3	444.71	445.3005	5787544.0
2022-03-23 15:00:00	SPY	ETF	445.31	445.978	443.79	443.84	15535044.0
2022-03-23 16:00:00	SPY	ETF	443.84	444.7	443.66	444.0	4520981.0
2022-03-23 17:00:00	SPY	ETF	443.98	443.98	443.4	443.85	139814.0
2022-03-23 18:00:00	SPY	ETF	444.0	444.25	443.78	444.1	93982.0
2022-03-23 19:00:00	SPY	ETF	444.12	444.5	444.1	444.34	41498.0
2022-03-23 04:00:00	QQQ	ETF	357.04	357.06	356.07	356.5	33691.0
2022-03-23 05:00:00	QQQ	ETF	356.5	356.59	355.32	355.5	88145.0
2022-03-23 06:00:00	QQQ	ETF	355.46	355.62	354.69	354.97	99426.0
2022-03-23 07:00:00	QQQ	ETF	355.0	355.22	354.0	354.32	356377.0
2022-03-23 08:00:00	QQQ	ETF	354.92	357.0	353.75	353.94	511630.0
2022-03-23 09:00:00	QQQ	ETF	353.94	354.67	352.26	353.02	9349661.0
2022-03-23 10:00:00	QQQ	ETF	352.99	355.88	352.34	355.38	9482206.0
2022-03-23 11:00:00	QQQ	ETF	355.38	356.96	355.14	356.93	4865775.0
2022-03-23 12:00:00	QQQ	ETF	356.94	357.66	354.76	355.62	5583512.0
2022-03-23 13:00:00	QQQ	ETF	355.6397	355.83	353.02	353.96	5551618.0
2022-03-23 14:00:00	QQQ	ETF	354.0	354.49	352.42	353.21	4397077.0
2022-03-23 15:00:00	QQQ	ETF	353.23	353.97	351.77	351.84	8304329.0
2022-03-23 16:00:00	QQQ	ETF	351.805	352.28	351.79	352.27	1220515.0
2022-03-23 17:00:00	QQQ	ETF	352.07	352.2	351.83	352.14	1919515.0
2022-03-23 18:00:00	QQQ	ETF	352.18	352.49	352.09	352.35	61481.0
2022-03-23 19:00:00	QQQ	ETF	352.37	352.72	352.37	352.52	113295.0
2022-03-23 04:00:00	IWM	ETF	207.19	207.4	206.82	207.11	9934.0
2022-03-23 05:00:00	IWM	ETF	207.15	207.21	206.41	206.5	9915.0
2022-03-23 06:00:00	IWM	ETF	206.56	206.66	206.4	206.54	14915.0
2022-03-23 07:00:00	IWM	ETF	206.68	206.68	206.4	206.5	25612.0
2022-03-23 08:00:00	IWM	ETF	206.57	207.5	206.26	206.36	65741.0
2022-03-23 09:00:00	IWM	ETF	206.46	206.65	204.54	204.71	2312735.0
2022-03-23 10:00:00	IWM	ETF	204.7	206.12	204.39	205.78	2056486.0
2022-03-23 11:00:00	IWM	ETF	205.795	206.93	205.77	206.9	1025724.0
2022-03-23 12:00:00	IWM	ETF	206.9	207.2	205.7	205.99	1372843.0
2022-03-23 13:00:00	IWM	ETF	206.0	206.1	204.37	205.04	1877665.0
2022-03-23 14:00:00	IWM	ETF	205.05	205.06	204.16	204.33	1548736.0
2022-03-23 15:00:00	IWM	ETF	204.34	204.7	203.75	203.88	3574219.0
2022-03-23 16:00:00	IWM	ETF	203.9	203.96	203.61	203.92	819113.0
2022-03-23 17:00:00	IWM	ETF	203.81	204.07	203.71	203.95	127824.0
2022-03-23 18:00:00	IWM	ETF	203.99	203.99	203.64	203.86	26324.0
2022-03-23 19:00:00	IWM	ETF	203.94	204.16	203.93	204.05	20477.0
2022-03-23 04:00:00	DIA	ETF	347.84	347.84	347.67	347.7	542.0
2022-03-23 05:00:00	DIA	ETF	347.0	347.0	347.0	347.0	100.0

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

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