PREVIEW / etf_1hour / 2022-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-07.parquet
  size:    464 KB
  rows:    16,984

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
2022-11-07 04:00:00	SPY	ETF	375.0	377.89	375.0	377.05	57067.0
2022-11-07 05:00:00	SPY	ETF	377.1	378.35	377.06	378.27	57028.0
2022-11-07 06:00:00	SPY	ETF	378.35	378.85	378.18	378.28	64712.0
2022-11-07 07:00:00	SPY	ETF	378.22	378.85	377.61	377.9	297153.0
2022-11-07 08:00:00	SPY	ETF	378.78	378.82	374.5	377.3225	731980.0
2022-11-07 09:00:00	SPY	ETF	377.42	378.34	375.53	376.11	5472480.0
2022-11-07 10:00:00	SPY	ETF	376.11	378.39	376.01	377.605	7267421.0
2022-11-07 11:00:00	SPY	ETF	377.62	378.15	376.21	376.22	5220769.0
2022-11-07 12:00:00	SPY	ETF	376.21	377.37	375.81	377.0097	4037882.0
2022-11-07 13:00:00	SPY	ETF	377.0	377.9801	376.96	377.92	3954666.0
2022-11-07 14:00:00	SPY	ETF	377.92	380.0	377.92	379.33	7549343.0
2022-11-07 15:00:00	SPY	ETF	379.335	380.57	379.32	379.94	12645784.0
2022-11-07 16:00:00	SPY	ETF	379.94	380.04	379.4333	379.68	6715348.0
2022-11-07 17:00:00	SPY	ETF	379.61	379.82	379.45	379.71	62615.0
2022-11-07 18:00:00	SPY	ETF	379.71	380.04	379.38	379.95	72875.0
2022-11-07 19:00:00	SPY	ETF	380.03	381.11	380.01	380.83	104933.0
2022-11-07 04:00:00	QQQ	ETF	264.0	265.93	264.0	265.0	60215.0
2022-11-07 05:00:00	QQQ	ETF	264.91	266.09	264.91	266.05	32012.0
2022-11-07 06:00:00	QQQ	ETF	266.05	266.53	265.9	265.9	64626.0
2022-11-07 07:00:00	QQQ	ETF	265.91	266.3	265.31	265.58	248455.0
2022-11-07 08:00:00	QQQ	ETF	265.5608	266.61	262.9	265.45	867859.0
2022-11-07 09:00:00	QQQ	ETF	265.46	266.485	263.57	264.42	5002531.0
2022-11-07 10:00:00	QQQ	ETF	264.44	266.31	263.97	265.456	5886421.0
2022-11-07 11:00:00	QQQ	ETF	265.47	266.02	264.0109	264.02	4173262.0
2022-11-07 12:00:00	QQQ	ETF	264.02	265.04	263.61	264.79	3165513.0
2022-11-07 13:00:00	QQQ	ETF	264.75	265.77	264.74	265.6	2678253.0
2022-11-07 14:00:00	QQQ	ETF	265.61	267.83	265.61	267.1491	5589651.0
2022-11-07 15:00:00	QQQ	ETF	267.16	268.14	267.125	267.58	7194399.0
2022-11-07 16:00:00	QQQ	ETF	267.58	267.93	267.33	267.54	1291169.0
2022-11-07 17:00:00	QQQ	ETF	267.66	267.66	267.43	267.6	21445.0
2022-11-07 18:00:00	QQQ	ETF	267.55	267.84	267.36	267.79	83372.0
2022-11-07 19:00:00	QQQ	ETF	267.8	268.73	267.8	268.53	124019.0
2022-11-07 04:00:00	IWM	ETF	179.46	179.65	179.24	179.265	21988.0
2022-11-07 05:00:00	IWM	ETF	179.26	179.84	179.26	179.75	9078.0
2022-11-07 06:00:00	IWM	ETF	179.86	180.11	179.86	179.9	62938.0
2022-11-07 07:00:00	IWM	ETF	179.91	180.25	179.61	179.79	71454.0
2022-11-07 08:00:00	IWM	ETF	179.9501	180.24	178.15	179.53	116435.0
2022-11-07 09:00:00	IWM	ETF	179.5	180.59	177.68	177.9	2143373.0
2022-11-07 10:00:00	IWM	ETF	177.93	179.11	177.73	178.485	2142284.0
2022-11-07 11:00:00	IWM	ETF	178.5	179.35	178.08	178.09	1810934.0
2022-11-07 12:00:00	IWM	ETF	178.09	178.8	177.91	178.33	901176.0
2022-11-07 13:00:00	IWM	ETF	178.31	178.92	178.225	178.76	1285593.0
2022-11-07 14:00:00	IWM	ETF	178.76	180.27	178.76	179.62	2106356.0
2022-11-07 15:00:00	IWM	ETF	179.625	180.02	179.3925	179.62	3300206.0
2022-11-07 16:00:00	IWM	ETF	179.49	179.66	179.31	179.45	1476354.0
2022-11-07 17:00:00	IWM	ETF	179.36	179.49	179.33	179.48	3830.0
2022-11-07 18:00:00	IWM	ETF	179.34	179.75	179.26	179.74	13454.0
2022-11-07 19:00:00	IWM	ETF	179.75	180.35	179.68	180.25	66145.0
2022-11-07 04:00:00	DIA	ETF	325.05	325.27	325.05	325.18	1207.0
2022-11-07 05:00:00	DIA	ETF	325.14	325.77	325.12	325.44	1400.0

> showing 50 of 16,984 rows — these rows as CSV

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