PREVIEW / etf_1hour / 2023-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-01.parquet
  size:    485 KB
  rows:    18,062

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-01 04:00:00	SPY	ETF	405.23	405.32	404.85	404.87	34786.0
2023-02-01 05:00:00	SPY	ETF	404.96	405.15	404.61	404.8	22256.0
2023-02-01 06:00:00	SPY	ETF	404.8	405.32	404.69	405.25	59257.0
2023-02-01 07:00:00	SPY	ETF	405.22	405.9	405.11	405.76	205261.0
2023-02-01 08:00:00	SPY	ETF	405.3799	405.93	404.83	405.07	407553.0
2023-02-01 09:00:00	SPY	ETF	405.06	406.43	404.81	406.2	5636349.0
2023-02-01 10:00:00	SPY	ETF	406.21	406.3575	403.9605	404.13	7799793.0
2023-02-01 11:00:00	SPY	ETF	404.1491	405.54	403.93	404.575	5190415.0
2023-02-01 12:00:00	SPY	ETF	404.565	404.66	403.76	404.13	3680587.0
2023-02-01 13:00:00	SPY	ETF	404.13	405.41	403.96	404.73	4072788.0
2023-02-01 14:00:00	SPY	ETF	404.72	410.28	402.35	409.12	22311859.0
2023-02-01 15:00:00	SPY	ETF	409.18	413.67	409.13	410.79	25730950.0
2023-02-01 16:00:00	SPY	ETF	410.79	412.02	410.15	411.63	4736167.0
2023-02-01 17:00:00	SPY	ETF	411.63	412.1494	411.55	412.05	172106.0
2023-02-01 18:00:00	SPY	ETF	412.04	412.72	411.92	412.4	220783.0
2023-02-01 19:00:00	SPY	ETF	412.43	412.44	411.61	412.12	324209.0
2023-02-01 04:00:00	QQQ	ETF	294.0	294.25	293.74	293.94	64006.0
2023-02-01 05:00:00	QQQ	ETF	293.8	293.99	293.49	293.63	20229.0
2023-02-01 06:00:00	QQQ	ETF	293.68	294.16	293.59	294.16	54114.0
2023-02-01 07:00:00	QQQ	ETF	294.13	295.03	294.05	294.71	173965.0
2023-02-01 08:00:00	QQQ	ETF	294.12	295.01	293.5704	294.18	506968.0
2023-02-01 09:00:00	QQQ	ETF	294.25	294.79	293.41	294.58	3578982.0
2023-02-01 10:00:00	QQQ	ETF	294.61	294.75	292.95	293.08	4813678.0
2023-02-01 11:00:00	QQQ	ETF	293.03	294.44	292.84	293.89	2590909.0
2023-02-01 12:00:00	QQQ	ETF	293.91	294.17	293.33	293.93	1504424.0
2023-02-01 13:00:00	QQQ	ETF	293.95	294.85	293.7804	294.23	2514764.0
2023-02-01 14:00:00	QQQ	ETF	294.21	300.26	292.3	299.17	17033565.0
2023-02-01 15:00:00	QQQ	ETF	299.19	303.43	299.18	301.08	14891525.0
2023-02-01 16:00:00	QQQ	ETF	301.08	303.6	300.5	303.24	2833253.0
2023-02-01 17:00:00	QQQ	ETF	303.16	303.7	303.03	303.64	226134.0
2023-02-01 18:00:00	QQQ	ETF	303.64	304.49	300.92	304.13	446289.0
2023-02-01 19:00:00	QQQ	ETF	304.14	304.15	303.38	303.99	242275.0
2023-02-01 04:00:00	IWM	ETF	190.97	191.1	190.81	190.87	23027.0
2023-02-01 05:00:00	IWM	ETF	190.95	191.0	190.83	190.96	10207.0
2023-02-01 06:00:00	IWM	ETF	190.98	191.22	190.91	191.12	51988.0
2023-02-01 07:00:00	IWM	ETF	191.161	191.42	191.101	191.31	17997.0
2023-02-01 08:00:00	IWM	ETF	191.1999	191.38	190.8604	191.11	99022.0
2023-02-01 09:00:00	IWM	ETF	191.13	191.9899	190.74	191.9899	1643173.0
2023-02-01 10:00:00	IWM	ETF	192.0	192.1	190.57	190.65	1679595.0
2023-02-01 11:00:00	IWM	ETF	190.61	191.34	190.5799	190.77	1021603.0
2023-02-01 12:00:00	IWM	ETF	190.78	191.0	190.4236	190.82	718134.0
2023-02-01 13:00:00	IWM	ETF	190.82	191.5	190.71	191.07	1472768.0
2023-02-01 14:00:00	IWM	ETF	191.07	194.07	190.13	193.41	4390419.0
2023-02-01 15:00:00	IWM	ETF	193.41	196.19	193.41	194.5	7523672.0
2023-02-01 16:00:00	IWM	ETF	194.49	194.5	193.93	194.29	1104965.0
2023-02-01 17:00:00	IWM	ETF	194.1	194.49	194.1	194.49	26188.0
2023-02-01 18:00:00	IWM	ETF	194.38	194.81	194.3	194.58	97209.0
2023-02-01 19:00:00	IWM	ETF	194.59	194.61	194.2	194.46	40213.0
2023-02-01 04:00:00	DIA	ETF	339.55	339.55	339.55	339.55	264.0
2023-02-01 05:00:00	DIA	ETF	339.25	339.25	339.25	339.25	100.0

> showing 50 of 18,062 rows — these rows as CSV

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