PREVIEW / etf_1hour / 2023-02-22

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-22.parquet
  size:    471 KB
  rows:    17,195

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-22 04:00:00	SPY	ETF	399.31	399.74	398.72	399.49	27265.0
2023-02-22 05:00:00	SPY	ETF	399.28	399.48	398.79	399.25	17388.0
2023-02-22 06:00:00	SPY	ETF	399.33	399.4	398.22	399.02	62106.0
2023-02-22 07:00:00	SPY	ETF	399.08	400.66	399.0	400.25	453608.0
2023-02-22 08:00:00	SPY	ETF	398.9939	400.64	398.9939	399.93	707369.0
2023-02-22 09:00:00	SPY	ETF	399.94	400.47	399.29	399.73	6371171.0
2023-02-22 10:00:00	SPY	ETF	399.72	399.81	397.621	399.106	9618136.0
2023-02-22 11:00:00	SPY	ETF	399.11	399.6	398.59	399.4399	4817298.0
2023-02-22 12:00:00	SPY	ETF	399.44	400.55	399.0836	400.105	5253264.0
2023-02-22 13:00:00	SPY	ETF	400.11	400.8801	399.81	400.3599	4369859.0
2023-02-22 14:00:00	SPY	ETF	400.3563	401.13	397.51	397.5899	13936238.0
2023-02-22 15:00:00	SPY	ETF	397.57	398.71	397.02	398.58	16036791.0
2023-02-22 16:00:00	SPY	ETF	398.6	399.53	398.39	399.4	4005243.0
2023-02-22 17:00:00	SPY	ETF	399.48	399.6	399.02	399.6	210285.0
2023-02-22 18:00:00	SPY	ETF	399.6	399.62	399.2	399.59	65336.0
2023-02-22 19:00:00	SPY	ETF	399.63	399.86	399.55	399.66	83722.0
2023-02-22 04:00:00	QQQ	ETF	294.44	294.65	293.46	294.4	70979.0
2023-02-22 05:00:00	QQQ	ETF	294.25	294.44	293.73	294.12	31133.0
2023-02-22 06:00:00	QQQ	ETF	294.18	294.24	293.24	294.06	113536.0
2023-02-22 07:00:00	QQQ	ETF	294.07	295.64	293.91	295.22	428057.0
2023-02-22 08:00:00	QQQ	ETF	293.96	295.5801	293.5504	294.9	563325.0
2023-02-22 09:00:00	QQQ	ETF	294.9	295.98	294.5399	294.7	5925529.0
2023-02-22 10:00:00	QQQ	ETF	294.73	294.78	292.56	294.16	6665961.0
2023-02-22 11:00:00	QQQ	ETF	294.17	294.59	293.59	294.37	3253574.0
2023-02-22 12:00:00	QQQ	ETF	294.4	295.36	293.91	294.99	2553220.0
2023-02-22 13:00:00	QQQ	ETF	294.976	295.83	294.75	295.355	2905985.0
2023-02-22 14:00:00	QQQ	ETF	295.3901	296.3599	293.18	293.24	9076161.0
2023-02-22 15:00:00	QQQ	ETF	293.24	294.25	292.905	294.21	6095315.0
2023-02-22 16:00:00	QQQ	ETF	294.2	296.04	293.99	295.76	2560522.0
2023-02-22 17:00:00	QQQ	ETF	295.71	296.08	295.63	295.97	221679.0
2023-02-22 18:00:00	QQQ	ETF	295.97	296.04	295.44	295.8	175202.0
2023-02-22 19:00:00	QQQ	ETF	295.78	296.04	295.76	295.84	82147.0
2023-02-22 04:00:00	IWM	ETF	187.47	187.67	187.16	187.53	14989.0
2023-02-22 05:00:00	IWM	ETF	187.64	187.64	187.18	187.43	5491.0
2023-02-22 06:00:00	IWM	ETF	187.34	187.35	186.82	187.17	4909.0
2023-02-22 07:00:00	IWM	ETF	187.32	188.09	187.31	187.89	44546.0
2023-02-22 08:00:00	IWM	ETF	187.93	188.13	187.51	187.98	35199.0
2023-02-22 09:00:00	IWM	ETF	187.99	189.15	187.75	188.44	2690829.0
2023-02-22 10:00:00	IWM	ETF	188.44	188.53	186.7515	188.02	3832855.0
2023-02-22 11:00:00	IWM	ETF	188.02	188.36	187.89	188.2	1228110.0
2023-02-22 12:00:00	IWM	ETF	188.19	188.73	187.87	188.48	1216770.0
2023-02-22 13:00:00	IWM	ETF	188.48	189.03	188.32	188.61	1440864.0
2023-02-22 14:00:00	IWM	ETF	188.55	189.03	187.09	187.12	3381266.0
2023-02-22 15:00:00	IWM	ETF	187.11	188.06	186.975	188.0	3133378.0
2023-02-22 16:00:00	IWM	ETF	188.0	188.2	187.49	188.2	1226486.0
2023-02-22 17:00:00	IWM	ETF	188.19	188.38	188.05	188.35	15742.0
2023-02-22 18:00:00	IWM	ETF	188.33	188.34	188.05	188.3	18474.0
2023-02-22 19:00:00	IWM	ETF	188.27	188.46	188.26	188.43	18787.0
2023-02-22 04:00:00	DIA	ETF	331.25	331.27	331.25	331.27	200.0
2023-02-22 05:00:00	DIA	ETF	331.31	331.33	331.22	331.22	2300.0

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

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