PREVIEW / etf_1hour / 2023-02-28

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-28.parquet
  size:    465 KB
  rows:    16,810

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
2023-02-28 04:00:00	SPY	ETF	397.1	397.42	396.8	397.32	37746.0
2023-02-28 05:00:00	SPY	ETF	397.31	398.19	397.28	398.11	30765.0
2023-02-28 06:00:00	SPY	ETF	398.24	398.94	398.03	398.65	111475.0
2023-02-28 07:00:00	SPY	ETF	398.7	399.3	398.56	399.07	130573.0
2023-02-28 08:00:00	SPY	ETF	398.76	399.29	396.5	398.51	616165.0
2023-02-28 09:00:00	SPY	ETF	398.48	398.54	396.45	397.34	6958860.0
2023-02-28 10:00:00	SPY	ETF	397.35	398.29	396.59	397.3293	9137787.0
2023-02-28 11:00:00	SPY	ETF	397.32	398.4	397.15	397.41	6759905.0
2023-02-28 12:00:00	SPY	ETF	397.41	399.044	397.41	398.83	5528498.0
2023-02-28 13:00:00	SPY	ETF	398.8299	399.28	398.65	398.94	4869364.0
2023-02-28 14:00:00	SPY	ETF	398.955	399.22	397.69	397.8076	7628594.0
2023-02-28 15:00:00	SPY	ETF	397.805	397.83	396.18	396.2	20860355.0
2023-02-28 16:00:00	SPY	ETF	396.19	397.6441	395.5	395.89	7161387.0
2023-02-28 17:00:00	SPY	ETF	395.87	395.98	395.78	395.8	108510.0
2023-02-28 18:00:00	SPY	ETF	395.8	396.009	395.19	395.3	93115.0
2023-02-28 19:00:00	SPY	ETF	395.36	395.36	394.77	394.82	180595.0
2023-02-28 04:00:00	QQQ	ETF	293.33	293.73	293.12	293.42	34699.0
2023-02-28 05:00:00	QQQ	ETF	293.4	294.24	293.4	294.2	50063.0
2023-02-28 06:00:00	QQQ	ETF	294.15	294.96	294.15	294.71	64099.0
2023-02-28 07:00:00	QQQ	ETF	294.74	295.451	294.65	295.26	233898.0
2023-02-28 08:00:00	QQQ	ETF	294.73	295.4	292.92	294.3	568789.0
2023-02-28 09:00:00	QQQ	ETF	294.3	294.68	292.96	294.208	5059660.0
2023-02-28 10:00:00	QQQ	ETF	294.21	294.96	293.07	293.77	6320195.0
2023-02-28 11:00:00	QQQ	ETF	293.81	294.755	293.61	294.07	4406581.0
2023-02-28 12:00:00	QQQ	ETF	294.09	295.62	294.09	295.42	3861418.0
2023-02-28 13:00:00	QQQ	ETF	295.42	296.11	295.35	295.87	3692983.0
2023-02-28 14:00:00	QQQ	ETF	295.88	296.124	294.87	294.9499	4086861.0
2023-02-28 15:00:00	QQQ	ETF	294.96	294.96	293.48	293.49	7896239.0
2023-02-28 16:00:00	QQQ	ETF	293.49	293.6	292.59	292.94	1505463.0
2023-02-28 17:00:00	QQQ	ETF	292.92	293.56	292.68	292.77	531419.0
2023-02-28 18:00:00	QQQ	ETF	292.84	292.93	292.27	292.49	140754.0
2023-02-28 19:00:00	QQQ	ETF	292.54	292.54	291.94	291.98	123477.0
2023-02-28 04:00:00	IWM	ETF	187.8	187.89	187.64	187.76	6836.0
2023-02-28 05:00:00	IWM	ETF	188.07	188.54	188.04	188.53	11157.0
2023-02-28 06:00:00	IWM	ETF	188.52	188.77	188.46	188.75	4727.0
2023-02-28 07:00:00	IWM	ETF	188.74	188.97	188.71	188.84	20315.0
2023-02-28 08:00:00	IWM	ETF	188.97	188.97	188.28	188.59	101206.0
2023-02-28 09:00:00	IWM	ETF	188.6	189.48	188.06	189.11	1795485.0
2023-02-28 10:00:00	IWM	ETF	189.12	189.79	188.8138	189.41	1857912.0
2023-02-28 11:00:00	IWM	ETF	189.43	190.02	189.12	189.3	1806684.0
2023-02-28 12:00:00	IWM	ETF	189.3	189.75	189.21	189.69	876941.0
2023-02-28 13:00:00	IWM	ETF	189.7	189.94	189.6	189.67	634235.0
2023-02-28 14:00:00	IWM	ETF	189.67	189.83	189.27	189.31	907747.0
2023-02-28 15:00:00	IWM	ETF	189.31	189.38	188.08	188.1	3454770.0
2023-02-28 16:00:00	IWM	ETF	188.18	188.42	187.86	188.37	1571906.0
2023-02-28 17:00:00	IWM	ETF	188.22	188.37	188.22	188.29	30853.0
2023-02-28 18:00:00	IWM	ETF	188.29	188.42	187.83	187.86	29741.0
2023-02-28 19:00:00	IWM	ETF	187.86	187.91	187.59	187.6	29799.0
2023-02-28 04:00:00	DIA	ETF	328.63	328.73	328.63	328.73	350.0
2023-02-28 06:00:00	DIA	ETF	329.33	329.76	329.33	329.76	4600.0

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

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