PREVIEW / etf_1hour / 2022-02-16

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-16.parquet
  size:    440 KB
  rows:    15,848

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-16 04:00:00	SPY	ETF	446.99	447.75	445.88	445.9	71561.0
2022-02-16 05:00:00	SPY	ETF	445.8	445.98	444.75	445.67	47005.0
2022-02-16 06:00:00	SPY	ETF	445.64	445.95	445.18	445.85	32426.0
2022-02-16 07:00:00	SPY	ETF	445.64	446.0	444.73	445.02	234486.0
2022-02-16 08:00:00	SPY	ETF	445.9001	447.0996	444.02	444.15	541547.0
2022-02-16 09:00:00	SPY	ETF	444.32	444.81	442.42	442.77	7538374.0
2022-02-16 10:00:00	SPY	ETF	442.77	443.59	442.25	443.0	7796430.0
2022-02-16 11:00:00	SPY	ETF	443.03	443.76	442.761	443.62	4810446.0
2022-02-16 12:00:00	SPY	ETF	443.61	443.97	441.94	442.88	5418316.0
2022-02-16 13:00:00	SPY	ETF	442.86	443.36	442.5	442.97	3777618.0
2022-02-16 14:00:00	SPY	ETF	442.9603	447.21	442.02	446.58	15392882.0
2022-02-16 15:00:00	SPY	ETF	446.6	448.055	446.26	446.61	15637371.0
2022-02-16 16:00:00	SPY	ETF	446.62	446.78	446.0	446.16	4034955.0
2022-02-16 17:00:00	SPY	ETF	446.1	446.52	446.09	446.13	113730.0
2022-02-16 18:00:00	SPY	ETF	446.16	447.04	445.68	445.75	300799.0
2022-02-16 19:00:00	SPY	ETF	445.8	446.02	445.49	445.8199	90771.0
2022-02-16 04:00:00	QQQ	ETF	356.86	357.61	356.09	356.17	68057.0
2022-02-16 05:00:00	QQQ	ETF	356.09	356.35	355.24	355.88	27318.0
2022-02-16 06:00:00	QQQ	ETF	356.04	356.33	355.61	356.28	69545.0
2022-02-16 07:00:00	QQQ	ETF	356.19	356.56	355.02	355.4	213236.0
2022-02-16 08:00:00	QQQ	ETF	356.5005	357.44	354.0	354.22	634796.0
2022-02-16 09:00:00	QQQ	ETF	354.25	354.34	350.71	351.365	7040936.0
2022-02-16 10:00:00	QQQ	ETF	351.33	352.78	350.83	352.26	7280914.0
2022-02-16 11:00:00	QQQ	ETF	352.28	353.0887	351.69	352.5816	3840634.0
2022-02-16 12:00:00	QQQ	ETF	352.5798	352.9569	350.81	351.5	4101335.0
2022-02-16 13:00:00	QQQ	ETF	351.49	352.18	351.1	351.83	2550757.0
2022-02-16 14:00:00	QQQ	ETF	351.795	356.18	350.97	355.68	10291809.0
2022-02-16 15:00:00	QQQ	ETF	355.6999	357.0896	355.59	356.01	7784584.0
2022-02-16 16:00:00	QQQ	ETF	356.01	356.95	355.1	355.89	2198085.0
2022-02-16 17:00:00	QQQ	ETF	355.79	356.04	355.72	355.72	130874.0
2022-02-16 18:00:00	QQQ	ETF	355.88	356.48	355.23	355.25	253363.0
2022-02-16 19:00:00	QQQ	ETF	355.39	355.5	355.1	355.35	116557.0
2022-02-16 04:00:00	IWM	ETF	206.57	207.02	205.98	205.98	17685.0
2022-02-16 05:00:00	IWM	ETF	205.77	206.33	205.43	206.33	9484.0
2022-02-16 06:00:00	IWM	ETF	206.37	206.38	205.75	206.13	5152.0
2022-02-16 07:00:00	IWM	ETF	206.16	206.33	205.53	205.75	52412.0
2022-02-16 08:00:00	IWM	ETF	206.08	207.0	205.14	205.21	188908.0
2022-02-16 09:00:00	IWM	ETF	205.28	205.48	204.08	204.89	2574858.0
2022-02-16 10:00:00	IWM	ETF	204.82	205.93	204.37	205.44	2671869.0
2022-02-16 11:00:00	IWM	ETF	205.45	205.765	205.05	205.15	1529351.0
2022-02-16 12:00:00	IWM	ETF	205.16	205.42	204.37	204.62	1280701.0
2022-02-16 13:00:00	IWM	ETF	204.61	204.83	204.28	204.54	1116288.0
2022-02-16 14:00:00	IWM	ETF	204.53	207.14	204.14	206.49	5226665.0
2022-02-16 15:00:00	IWM	ETF	206.5	207.27	206.0499	206.3899	4302248.0
2022-02-16 16:00:00	IWM	ETF	206.49	206.49	205.87	206.02	5715088.0
2022-02-16 17:00:00	IWM	ETF	206.33	206.49	206.0	206.27	55398.0
2022-02-16 18:00:00	IWM	ETF	206.15	206.62	205.51	205.59	158536.0
2022-02-16 19:00:00	IWM	ETF	205.57	205.94	205.52	205.72	30553.0
2022-02-16 04:00:00	DIA	ETF	351.25	351.43	350.2	350.2	1082.0
2022-02-16 05:00:00	DIA	ETF	349.87	350.0	349.25	349.25	1100.0

> showing 50 of 15,848 rows — these rows as CSV

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