PREVIEW / etf_1hour / 2023-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-27.parquet
  size:    466 KB
  rows:    17,003

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-27 04:00:00	SPY	ETF	397.86	398.5	397.6	398.15	54557.0
2023-02-27 05:00:00	SPY	ETF	398.16	398.62	398.16	398.2	36558.0
2023-02-27 06:00:00	SPY	ETF	398.16	398.5	398.02	398.28	112396.0
2023-02-27 07:00:00	SPY	ETF	398.26	398.6	398.02	398.2	200785.0
2023-02-27 08:00:00	SPY	ETF	398.16	400.27	396.56	399.9	569865.0
2023-02-27 09:00:00	SPY	ETF	399.91	400.35	399.08	400.31	8383497.0
2023-02-27 10:00:00	SPY	ETF	400.33	401.29	398.57	399.21	14275327.0
2023-02-27 11:00:00	SPY	ETF	399.2199	399.57	397.63	398.2699	7527171.0
2023-02-27 12:00:00	SPY	ETF	398.27	398.83	397.57	398.71	5181149.0
2023-02-27 13:00:00	SPY	ETF	398.72	399.19	398.115	399.02	4154423.0
2023-02-27 14:00:00	SPY	ETF	399.02	399.51	397.76	397.93	6156497.0
2023-02-27 15:00:00	SPY	ETF	397.945	398.18	396.75	397.73	14907345.0
2023-02-27 16:00:00	SPY	ETF	397.72	398.08	397.6733	398.04	3616345.0
2023-02-27 17:00:00	SPY	ETF	397.95	398.04	397.87	397.99	167898.0
2023-02-27 18:00:00	SPY	ETF	398.0	398.3	397.94	398.07	63017.0
2023-02-27 19:00:00	SPY	ETF	398.06	398.47	398.06	398.25	52072.0
2023-02-27 04:00:00	QQQ	ETF	293.33	293.78	292.51	293.35	90294.0
2023-02-27 05:00:00	QQQ	ETF	293.39	293.75	293.19	293.19	52087.0
2023-02-27 06:00:00	QQQ	ETF	293.16	293.63	293.16	293.45	38286.0
2023-02-27 07:00:00	QQQ	ETF	293.45	293.77	293.22	293.38	167738.0
2023-02-27 08:00:00	QQQ	ETF	293.54	295.61	292.068	295.27	1051543.0
2023-02-27 09:00:00	QQQ	ETF	295.27	295.57	294.47	295.48	5998617.0
2023-02-27 10:00:00	QQQ	ETF	295.48	296.49	293.78	294.44	7721997.0
2023-02-27 11:00:00	QQQ	ETF	294.46	294.7946	293.51	294.35	4620100.0
2023-02-27 12:00:00	QQQ	ETF	294.38	294.88	293.66	294.7901	2864041.0
2023-02-27 13:00:00	QQQ	ETF	294.81	295.17	294.23	295.02	2723770.0
2023-02-27 14:00:00	QQQ	ETF	295.03	295.42	293.89	294.0899	3643956.0
2023-02-27 15:00:00	QQQ	ETF	294.08	294.32	293.34	293.94	6076357.0
2023-02-27 16:00:00	QQQ	ETF	293.94	294.34	293.92	294.19	1629959.0
2023-02-27 17:00:00	QQQ	ETF	294.06	294.25	294.0	294.1	29569.0
2023-02-27 18:00:00	QQQ	ETF	294.14	294.48	294.08	294.2	151460.0
2023-02-27 19:00:00	QQQ	ETF	294.2	294.57	294.19	294.41	36553.0
2023-02-27 04:00:00	IWM	ETF	188.0	188.53	188.0	188.51	15411.0
2023-02-27 05:00:00	IWM	ETF	188.47	188.53	188.43	188.44	3229.0
2023-02-27 06:00:00	IWM	ETF	188.42	188.53	188.34	188.34	4886.0
2023-02-27 07:00:00	IWM	ETF	188.46	188.62	188.24	188.31	57932.0
2023-02-27 08:00:00	IWM	ETF	188.4704	189.57	188.31	189.33	237604.0
2023-02-27 09:00:00	IWM	ETF	189.37	189.7	188.47	189.63	2436617.0
2023-02-27 10:00:00	IWM	ETF	189.64	190.2	188.57	189.0	2738148.0
2023-02-27 11:00:00	IWM	ETF	188.99	189.485	188.47	188.93	1711387.0
2023-02-27 12:00:00	IWM	ETF	188.93	188.99	188.35	188.66	1030904.0
2023-02-27 13:00:00	IWM	ETF	188.67	188.9	188.32	188.735	1108387.0
2023-02-27 14:00:00	IWM	ETF	188.735	188.965	187.89	188.15	1279084.0
2023-02-27 15:00:00	IWM	ETF	188.12	188.31	187.6	188.21	2880022.0
2023-02-27 16:00:00	IWM	ETF	188.17	188.39	188.17	188.35	1100977.0
2023-02-27 17:00:00	IWM	ETF	188.46	188.46	188.31	188.31	2145.0
2023-02-27 18:00:00	IWM	ETF	188.39	188.5	188.28	188.35	14210.0
2023-02-27 19:00:00	IWM	ETF	188.39	188.55	188.34	188.4399	8388.0
2023-02-27 04:00:00	DIA	ETF	329.24	329.58	329.23	329.55	2338.0
2023-02-27 05:00:00	DIA	ETF	329.55	329.68	329.55	329.68	2900.0

> showing 50 of 17,003 rows — these rows as CSV

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