PREVIEW / etf_1hour / 2023-02-21

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-21.parquet
  size:    486 KB
  rows:    17,784

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-21 04:00:00	SPY	ETF	403.67	405.49	403.36	405.0	98023.0
2023-02-21 05:00:00	SPY	ETF	405.07	405.07	404.0	404.0	28173.0
2023-02-21 06:00:00	SPY	ETF	403.98	404.66	403.73	404.62	47929.0
2023-02-21 07:00:00	SPY	ETF	404.64	404.7	403.78	404.18	347511.0
2023-02-21 08:00:00	SPY	ETF	404.17	405.65	403.34	403.4	597719.0
2023-02-21 09:00:00	SPY	ETF	403.41	404.16	402.29	402.51	7747028.0
2023-02-21 10:00:00	SPY	ETF	402.51	402.9	401.26	401.34	10733989.0
2023-02-21 11:00:00	SPY	ETF	401.34	401.72	400.27	400.4952	7263357.0
2023-02-21 12:00:00	SPY	ETF	400.48	400.97	400.11	400.89	4652034.0
2023-02-21 13:00:00	SPY	ETF	400.88	400.97	399.49	399.655	4640015.0
2023-02-21 14:00:00	SPY	ETF	399.655	400.07	398.82	399.7	7675646.0
2023-02-21 15:00:00	SPY	ETF	399.71	400.16	398.9	399.13	13615542.0
2023-02-21 16:00:00	SPY	ETF	399.14	399.61	399.0605	399.37	5414151.0
2023-02-21 17:00:00	SPY	ETF	399.35	399.49	399.24	399.27	53536.0
2023-02-21 18:00:00	SPY	ETF	399.32	399.63	399.13	399.63	79731.0
2023-02-21 19:00:00	SPY	ETF	399.68	399.8	399.45	399.74	79234.0
2023-02-21 04:00:00	QQQ	ETF	297.37	299.34	297.29	298.94	140252.0
2023-02-21 05:00:00	QQQ	ETF	298.85	298.93	298.15	298.15	67008.0
2023-02-21 06:00:00	QQQ	ETF	298.17	298.77	298.0	298.42	81528.0
2023-02-21 07:00:00	QQQ	ETF	298.59	298.62	297.8	298.15	256452.0
2023-02-21 08:00:00	QQQ	ETF	298.54	300.38	297.3804	297.51	604242.0
2023-02-21 09:00:00	QQQ	ETF	297.51	298.73	296.98	297.25	6335604.0
2023-02-21 10:00:00	QQQ	ETF	297.23	297.57	296.08	296.25	6497489.0
2023-02-21 11:00:00	QQQ	ETF	296.26	296.64	295.21	295.36	3823786.0
2023-02-21 12:00:00	QQQ	ETF	295.33	295.93	295.12	295.86	2613980.0
2023-02-21 13:00:00	QQQ	ETF	295.86	295.94	294.89	295.035	2931891.0
2023-02-21 14:00:00	QQQ	ETF	295.05	295.22	294.2707	294.71	3884659.0
2023-02-21 15:00:00	QQQ	ETF	294.72	295.132	293.89	294.02	6995172.0
2023-02-21 16:00:00	QQQ	ETF	294.03	294.55	294.0	294.4	2098691.0
2023-02-21 17:00:00	QQQ	ETF	294.38	294.41	294.3	294.32	24958.0
2023-02-21 18:00:00	QQQ	ETF	294.35	294.48	294.06	294.43	82510.0
2023-02-21 19:00:00	QQQ	ETF	294.45	294.63	294.32	294.58	80366.0
2023-02-21 04:00:00	IWM	ETF	191.63	192.0	190.79	191.83	22198.0
2023-02-21 05:00:00	IWM	ETF	191.8	191.8	191.3	191.33	9615.0
2023-02-21 06:00:00	IWM	ETF	191.32	191.74	191.2	191.59	14286.0
2023-02-21 07:00:00	IWM	ETF	191.74	191.74	191.35	191.53	49547.0
2023-02-21 08:00:00	IWM	ETF	191.55	192.0	190.91	191.06	485875.0
2023-02-21 09:00:00	IWM	ETF	191.05	191.3383	189.555	189.61	3544225.0
2023-02-21 10:00:00	IWM	ETF	189.6	189.9217	188.87	188.91	2996176.0
2023-02-21 11:00:00	IWM	ETF	188.9	189.2	188.0611	188.1319	1761455.0
2023-02-21 12:00:00	IWM	ETF	188.115	188.43	187.84	188.415	1612891.0
2023-02-21 13:00:00	IWM	ETF	188.4	188.465	187.53	187.66	1118850.0
2023-02-21 14:00:00	IWM	ETF	187.665	188.0893	187.24	187.82	1604668.0
2023-02-21 15:00:00	IWM	ETF	187.83	188.1	187.27	187.42	2850331.0
2023-02-21 16:00:00	IWM	ETF	187.43	187.6	187.42	187.57	3429778.0
2023-02-21 17:00:00	IWM	ETF	187.46	187.6	187.43	187.44	8549.0
2023-02-21 18:00:00	IWM	ETF	187.53	187.72	187.46	187.72	11198.0
2023-02-21 19:00:00	IWM	ETF	187.71	187.82	187.56	187.78	41755.0
2023-02-21 04:00:00	DIA	ETF	336.04	337.19	335.85	337.19	3300.0
2023-02-21 06:00:00	DIA	ETF	335.53	335.68	335.53	335.68	1970.0

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

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