PREVIEW / etf_1hour / 2023-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-06.parquet
  size:    470 KB
  rows:    17,221

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-04-06 04:00:00	SPY	ETF	407.62	407.79	407.46	407.67	19034.0
2023-04-06 05:00:00	SPY	ETF	407.71	407.73	407.22	407.25	13315.0
2023-04-06 06:00:00	SPY	ETF	407.19	407.65	406.85	407.56	156549.0
2023-04-06 07:00:00	SPY	ETF	407.65	408.25	407.62	408.25	119998.0
2023-04-06 08:00:00	SPY	ETF	408.101	408.33	406.55	407.08	522501.0
2023-04-06 09:00:00	SPY	ETF	407.05	407.15	405.678	406.145	5248033.0
2023-04-06 10:00:00	SPY	ETF	406.15	407.29	406.07	406.44	8600953.0
2023-04-06 11:00:00	SPY	ETF	406.43	408.14	406.23	408.115	5881342.0
2023-04-06 12:00:00	SPY	ETF	408.12	409.15	408.12	408.59	6152089.0
2023-04-06 13:00:00	SPY	ETF	408.61	409.22	408.42	408.86	3901741.0
2023-04-06 14:00:00	SPY	ETF	408.865	409.48	408.76	408.93	4172630.0
2023-04-06 15:00:00	SPY	ETF	408.935	409.26	408.47	409.2	11526187.0
2023-04-06 16:00:00	SPY	ETF	409.2	409.22	409.01	409.01	2094637.0
2023-04-06 17:00:00	SPY	ETF	409.02	409.02	408.85	408.85	103281.0
2023-04-06 18:00:00	SPY	ETF	408.85	409.02	408.72	408.9	213875.0
2023-04-06 19:00:00	SPY	ETF	408.8699	408.88	408.68	408.76	36464.0
2023-04-06 04:00:00	QQQ	ETF	315.53	315.65	315.13	315.21	39511.0
2023-04-06 05:00:00	QQQ	ETF	315.28	315.32	314.09	314.2	38275.0
2023-04-06 06:00:00	QQQ	ETF	314.19	315.09	313.65	315.09	72196.0
2023-04-06 07:00:00	QQQ	ETF	315.09	315.61	315.0	315.59	150022.0
2023-04-06 08:00:00	QQQ	ETF	315.15	315.85	313.965	314.43	750527.0
2023-04-06 09:00:00	QQQ	ETF	314.37	314.56	312.82	313.64	5114417.0
2023-04-06 10:00:00	QQQ	ETF	313.65	315.275	313.555	314.54	6861843.0
2023-04-06 11:00:00	QQQ	ETF	314.51	317.06	314.38	316.95	4912277.0
2023-04-06 12:00:00	QQQ	ETF	316.95	317.849	316.95	317.065	4258467.0
2023-04-06 13:00:00	QQQ	ETF	317.09	318.13	316.87	318.064	2979641.0
2023-04-06 14:00:00	QQQ	ETF	318.07	318.55	317.91	318.01	3576222.0
2023-04-06 15:00:00	QQQ	ETF	318.0	318.44	317.65	318.1	6281153.0
2023-04-06 16:00:00	QQQ	ETF	318.1	318.1	317.8	317.9	1260377.0
2023-04-06 17:00:00	QQQ	ETF	317.91	317.96	317.74	317.85	47290.0
2023-04-06 18:00:00	QQQ	ETF	317.8	317.8	317.55	317.7	145605.0
2023-04-06 19:00:00	QQQ	ETF	317.69	317.84	317.62	317.82	33505.0
2023-04-06 04:00:00	IWM	ETF	173.69	173.94	173.66	173.91	7209.0
2023-04-06 05:00:00	IWM	ETF	173.94	174.05	173.75	173.97	6232.0
2023-04-06 06:00:00	IWM	ETF	173.88	174.14	173.83	174.06	78026.0
2023-04-06 07:00:00	IWM	ETF	174.1	174.44	174.1	174.44	155972.0
2023-04-06 08:00:00	IWM	ETF	174.43	174.5	173.7204	173.8	252038.0
2023-04-06 09:00:00	IWM	ETF	173.83	174.04	172.86	173.259	2454141.0
2023-04-06 10:00:00	IWM	ETF	173.26	174.1	172.68	173.06	4143396.0
2023-04-06 11:00:00	IWM	ETF	173.06	173.78	172.97	173.74	2039782.0
2023-04-06 12:00:00	IWM	ETF	173.74	174.46	173.74	173.97	2046127.0
2023-04-06 13:00:00	IWM	ETF	173.98	174.34	173.835	173.86	1839163.0
2023-04-06 14:00:00	IWM	ETF	173.87	174.24	173.81	173.87	1296524.0
2023-04-06 15:00:00	IWM	ETF	173.875	174.035	173.5398	173.94	4152949.0
2023-04-06 16:00:00	IWM	ETF	173.89	173.94	173.68	173.89	1123514.0
2023-04-06 17:00:00	IWM	ETF	173.84	173.84	173.7	173.72	5097.0
2023-04-06 18:00:00	IWM	ETF	173.75	173.85	173.7	173.73	41340.0
2023-04-06 19:00:00	IWM	ETF	173.73	173.75	173.59	173.7	18427.0
2023-04-06 05:00:00	DIA	ETF	335.13	335.13	335.13	335.13	600.0
2023-04-06 06:00:00	DIA	ETF	335.08	335.08	334.88	334.88	350.0

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

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