PREVIEW / etf_1hour / 2024-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-06-07.parquet
  size:    533 KB
  rows:    19,750

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
2024-06-07 04:00:00	SPY	ETF	535.0	535.19	534.6	534.6	21980.0
2024-06-07 05:00:00	SPY	ETF	534.7	534.89	534.55	534.75	5334.0
2024-06-07 06:00:00	SPY	ETF	534.83	534.86	534.43	534.59	9424.0
2024-06-07 07:00:00	SPY	ETF	534.53	535.02	534.13	534.99	60665.0
2024-06-07 08:00:00	SPY	ETF	534.49	536.27	531.3	532.5	1715668.0
2024-06-07 09:00:00	SPY	ETF	532.36	534.31	532.19	534.0399	3335356.0
2024-06-07 10:00:00	SPY	ETF	534.05	536.3999	533.87	535.3	4617297.0
2024-06-07 11:00:00	SPY	ETF	535.31	535.43	533.95	535.1989	2742808.0
2024-06-07 12:00:00	SPY	ETF	535.19	536.42	534.8192	536.3468	1961338.0
2024-06-07 13:00:00	SPY	ETF	536.3486	536.89	535.755	535.8899	1981016.0
2024-06-07 14:00:00	SPY	ETF	535.88	535.9	533.49	535.08	3957580.0
2024-06-07 15:00:00	SPY	ETF	535.09	535.41	533.72	533.96	6716092.0
2024-06-07 16:00:00	SPY	ETF	533.94	534.01	533.51	533.75	2980325.0
2024-06-07 17:00:00	SPY	ETF	533.68	533.93	532.96	533.25	148778.0
2024-06-07 18:00:00	SPY	ETF	533.24	533.33	533.2	533.3	17605.0
2024-06-07 19:00:00	SPY	ETF	533.23	533.43	533.22	533.35	8101.0
2024-06-07 04:00:00	QQQ	ETF	463.96	464.37	463.81	463.86	38318.0
2024-06-07 05:00:00	QQQ	ETF	463.93	464.06	463.74	463.9	11133.0
2024-06-07 06:00:00	QQQ	ETF	463.93	463.93	463.62	463.76	14076.0
2024-06-07 07:00:00	QQQ	ETF	463.65	464.31	463.3	464.17	59933.0
2024-06-07 08:00:00	QQQ	ETF	463.5017	465.55	460.54	461.6	1396268.0
2024-06-07 09:00:00	QQQ	ETF	461.6	463.58	461.38	462.81	2425340.0
2024-06-07 10:00:00	QQQ	ETF	462.8	464.85	462.5	463.83	2059532.0
2024-06-07 11:00:00	QQQ	ETF	463.86	465.6927	462.4	464.021	1840573.0
2024-06-07 12:00:00	QQQ	ETF	464.04	465.51	463.74	465.43	1761041.0
2024-06-07 13:00:00	QQQ	ETF	465.4392	465.74	464.76	464.77	1211476.0
2024-06-07 14:00:00	QQQ	ETF	464.77	464.8	461.94	463.29	2402458.0
2024-06-07 15:00:00	QQQ	ETF	463.27	463.66	461.98	462.97	3704603.0
2024-06-07 16:00:00	QQQ	ETF	462.96	463.04	462.41	462.75	1878866.0
2024-06-07 17:00:00	QQQ	ETF	462.71	462.8	462.05	462.2	64682.0
2024-06-07 18:00:00	QQQ	ETF	462.2785	462.38	462.15	462.25	14634.0
2024-06-07 19:00:00	QQQ	ETF	462.25	462.5	462.2	462.2	9221.0
2024-06-07 04:00:00	IWM	ETF	203.73	203.81	203.53	203.64	17192.0
2024-06-07 05:00:00	IWM	ETF	203.63	203.66	203.47	203.57	4459.0
2024-06-07 06:00:00	IWM	ETF	203.56	203.56	203.07	203.15	25106.0
2024-06-07 07:00:00	IWM	ETF	203.21	203.44	203.09	203.4	19544.0
2024-06-07 08:00:00	IWM	ETF	203.24	204.59	200.42	201.24	1324563.0
2024-06-07 09:00:00	IWM	ETF	201.17	202.56	200.68	201.92	3634295.0
2024-06-07 10:00:00	IWM	ETF	201.92	203.17	201.67	202.325	2414327.0
2024-06-07 11:00:00	IWM	ETF	202.32	202.32	201.5	201.9601	1677970.0
2024-06-07 12:00:00	IWM	ETF	201.97	202.32	201.66	202.06	1148247.0
2024-06-07 13:00:00	IWM	ETF	202.05	202.1	201.535	201.54	1170570.0
2024-06-07 14:00:00	IWM	ETF	201.53	201.645	200.68	201.37	1961940.0
2024-06-07 15:00:00	IWM	ETF	201.34	201.512	200.95	201.24	3270993.0
2024-06-07 16:00:00	IWM	ETF	201.2	201.43	201.06	201.3	1066194.0
2024-06-07 17:00:00	IWM	ETF	201.38	201.39	200.7	200.89	100513.0
2024-06-07 18:00:00	IWM	ETF	200.8023	200.94	200.8023	200.83	12215.0
2024-06-07 19:00:00	IWM	ETF	200.94	200.99	200.87	200.9	10316.0
2024-06-07 06:00:00	DIA	ETF	389.34	389.34	389.26	389.26	633.0
2024-06-07 07:00:00	DIA	ETF	389.39	389.6	389.39	389.6	800.0

> showing 50 of 19,750 rows — these rows as CSV

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