PREVIEW / etf_1hour / 2023-01-11

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-11.parquet
  size:    468 KB
  rows:    17,133

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-01-11 04:00:00	SPY	ETF	390.45	391.6	390.36	391.3	23434.0
2023-01-11 05:00:00	SPY	ETF	391.42	391.94	391.1	391.3	31535.0
2023-01-11 06:00:00	SPY	ETF	391.28	391.75	391.1	391.38	40154.0
2023-01-11 07:00:00	SPY	ETF	391.43	391.56	390.77	391.4	212837.0
2023-01-11 08:00:00	SPY	ETF	391.32	392.25	390.2	392.16	480022.0
2023-01-11 09:00:00	SPY	ETF	392.19	393.1594	391.75	392.31	5520529.0
2023-01-11 10:00:00	SPY	ETF	392.31	393.08	391.38	391.5801	7109078.0
2023-01-11 11:00:00	SPY	ETF	391.595	393.045	391.514	392.74	4696604.0
2023-01-11 12:00:00	SPY	ETF	392.77	393.63	392.765	393.189	4715933.0
2023-01-11 13:00:00	SPY	ETF	393.202	394.28	392.945	393.64	4776564.0
2023-01-11 14:00:00	SPY	ETF	393.65	394.56	393.18	394.3082	4342826.0
2023-01-11 15:00:00	SPY	ETF	394.3	395.6	394.03	395.5	13776555.0
2023-01-11 16:00:00	SPY	ETF	395.5	395.68	395.34	395.68	3584431.0
2023-01-11 17:00:00	SPY	ETF	395.57	395.8499	395.57	395.75	115690.0
2023-01-11 18:00:00	SPY	ETF	395.73	395.73	395.3	395.35	143240.0
2023-01-11 19:00:00	SPY	ETF	395.35	395.42	395.09	395.33	107316.0
2023-01-11 04:00:00	QQQ	ETF	272.77	273.7	272.39	273.32	78167.0
2023-01-11 05:00:00	QQQ	ETF	273.46	273.8	273.07	273.18	21610.0
2023-01-11 06:00:00	QQQ	ETF	273.2	273.76	272.98	273.27	37414.0
2023-01-11 07:00:00	QQQ	ETF	273.33	273.5	272.82	273.27	176929.0
2023-01-11 08:00:00	QQQ	ETF	273.28	274.0	272.01	273.89	400283.0
2023-01-11 09:00:00	QQQ	ETF	273.9	274.85	273.12	274.23	5151542.0
2023-01-11 10:00:00	QQQ	ETF	274.26	275.48	273.65	273.85	5431192.0
2023-01-11 11:00:00	QQQ	ETF	273.86	275.3696	273.79	275.16	3374869.0
2023-01-11 12:00:00	QQQ	ETF	275.19	276.1685	275.16	275.755	2977799.0
2023-01-11 13:00:00	QQQ	ETF	275.76	276.71	275.38	275.92	3434922.0
2023-01-11 14:00:00	QQQ	ETF	275.93	276.49	275.58	276.19	2656525.0
2023-01-11 15:00:00	QQQ	ETF	276.2	277.66	276.15	277.58	7611813.0
2023-01-11 16:00:00	QQQ	ETF	277.585	277.61	277.28	277.55	1699920.0
2023-01-11 17:00:00	QQQ	ETF	277.58	277.7	277.48	277.68	55448.0
2023-01-11 18:00:00	QQQ	ETF	277.63	277.63	277.3	277.55	106042.0
2023-01-11 19:00:00	QQQ	ETF	277.55	277.57	277.29	277.46	111463.0
2023-01-11 04:00:00	IWM	ETF	180.42	181.1	180.42	181.01	11755.0
2023-01-11 05:00:00	IWM	ETF	181.06	181.22	180.83	180.9	6645.0
2023-01-11 06:00:00	IWM	ETF	180.91	181.18	180.86	181.07	6967.0
2023-01-11 07:00:00	IWM	ETF	181.06	181.13	180.74	180.99	15801.0
2023-01-11 08:00:00	IWM	ETF	181.02	181.35	180.7	181.23	53787.0
2023-01-11 09:00:00	IWM	ETF	181.14	182.24	180.68	181.9305	1940095.0
2023-01-11 10:00:00	IWM	ETF	181.94	182.17	181.045	181.1	1810465.0
2023-01-11 11:00:00	IWM	ETF	181.09	182.03	181.08	181.875	1258492.0
2023-01-11 12:00:00	IWM	ETF	181.89	182.19	181.69	181.77	677491.0
2023-01-11 13:00:00	IWM	ETF	181.76	182.23	181.6	181.9499	957362.0
2023-01-11 14:00:00	IWM	ETF	181.95	182.19	181.78	182.105	1079023.0
2023-01-11 15:00:00	IWM	ETF	182.11	182.79	182.02	182.755	3231940.0
2023-01-11 16:00:00	IWM	ETF	182.75	182.95	182.66	182.95	898267.0
2023-01-11 17:00:00	IWM	ETF	182.84	182.94	182.76	182.85	36765.0
2023-01-11 18:00:00	IWM	ETF	182.9	182.9	182.61	182.66	16090.0
2023-01-11 19:00:00	IWM	ETF	182.7	182.71	182.55	182.71	18565.0
2023-01-11 04:00:00	DIA	ETF	337.68	337.85	337.67	337.85	13943.0
2023-01-11 05:00:00	DIA	ETF	337.87	337.95	337.87	337.9	4891.0

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

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