PREVIEW / etf_1hour / 2023-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-04.parquet
  size:    467 KB
  rows:    17,229

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-05-04 04:00:00	SPY	ETF	408.73	408.77	407.85	407.92	56479.0
2023-05-04 05:00:00	SPY	ETF	408.2	408.33	407.52	407.69	27638.0
2023-05-04 06:00:00	SPY	ETF	407.65	407.9	406.74	407.03	163288.0
2023-05-04 07:00:00	SPY	ETF	407.11	407.18	406.53	406.84	306868.0
2023-05-04 08:00:00	SPY	ETF	406.84	409.06	406.15	406.96	939737.0
2023-05-04 09:00:00	SPY	ETF	406.95	407.42	404.89	405.6	8703261.0
2023-05-04 10:00:00	SPY	ETF	405.61	405.97	403.86	404.87	14606570.0
2023-05-04 11:00:00	SPY	ETF	404.86	406.5201	404.21	404.3601	9460067.0
2023-05-04 12:00:00	SPY	ETF	404.34	405.85	403.74	405.82	6831923.0
2023-05-04 13:00:00	SPY	ETF	405.84	407.16	405.58	406.132	8384436.0
2023-05-04 14:00:00	SPY	ETF	406.15	406.2586	404.625	405.2491	6422932.0
2023-05-04 15:00:00	SPY	ETF	405.2401	406.31	404.58	405.17	13651156.0
2023-05-04 16:00:00	SPY	ETF	405.17	405.87	404.64	404.9	3825239.0
2023-05-04 17:00:00	SPY	ETF	404.94	405.45	404.77	405.25	293203.0
2023-05-04 18:00:00	SPY	ETF	405.25	406.28	405.23	406.28	134212.0
2023-05-04 19:00:00	SPY	ETF	406.28	406.5	406.07	406.25	53951.0
2023-05-04 04:00:00	QQQ	ETF	318.55	318.7	317.99	318.32	102929.0
2023-05-04 05:00:00	QQQ	ETF	318.47	318.5	317.72	317.89	35428.0
2023-05-04 06:00:00	QQQ	ETF	317.8	318.19	317.54	317.76	122008.0
2023-05-04 07:00:00	QQQ	ETF	317.72	317.75	317.24	317.43	203094.0
2023-05-04 08:00:00	QQQ	ETF	317.7001	319.0	316.55	316.97	524190.0
2023-05-04 09:00:00	QQQ	ETF	316.96	317.56	315.72	316.07	5386070.0
2023-05-04 10:00:00	QQQ	ETF	316.075	316.68	315.115	316.14	7395820.0
2023-05-04 11:00:00	QQQ	ETF	316.14	317.67	315.926	316.2899	5847814.0
2023-05-04 12:00:00	QQQ	ETF	316.28	317.27	315.815	317.24	2971976.0
2023-05-04 13:00:00	QQQ	ETF	317.25	318.23	317.01	317.695	4479291.0
2023-05-04 14:00:00	QQQ	ETF	317.71	317.75	316.11	316.53	3790179.0
2023-05-04 15:00:00	QQQ	ETF	316.5	317.285	316.0	316.23	6643999.0
2023-05-04 16:00:00	QQQ	ETF	316.23	317.29	315.72	316.19	1737107.0
2023-05-04 17:00:00	QQQ	ETF	316.18	316.95	315.8	316.5	451352.0
2023-05-04 18:00:00	QQQ	ETF	316.52	317.11	316.45	317.05	136059.0
2023-05-04 19:00:00	QQQ	ETF	317.03	317.42	317.0	317.36	132270.0
2023-05-04 04:00:00	IWM	ETF	172.01	172.01	171.39	171.43	8383.0
2023-05-04 05:00:00	IWM	ETF	171.47	171.76	171.26	171.44	9340.0
2023-05-04 06:00:00	IWM	ETF	171.44	171.44	170.61	170.71	43091.0
2023-05-04 07:00:00	IWM	ETF	170.77	171.15	170.61	170.88	112310.0
2023-05-04 08:00:00	IWM	ETF	170.71	171.8704	170.51	171.08	274076.0
2023-05-04 09:00:00	IWM	ETF	171.09	171.56	169.355	170.26	6498535.0
2023-05-04 10:00:00	IWM	ETF	170.26	170.54	168.89	169.525	8213491.0
2023-05-04 11:00:00	IWM	ETF	169.52	170.66	169.11	169.24	3781559.0
2023-05-04 12:00:00	IWM	ETF	169.23	170.19	168.78	170.17	3069570.0
2023-05-04 13:00:00	IWM	ETF	170.17	170.97	169.92	170.58	3193375.0
2023-05-04 14:00:00	IWM	ETF	170.58	170.735	169.91	170.29	1979609.0
2023-05-04 15:00:00	IWM	ETF	170.29	170.8	170.0	170.44	5120457.0
2023-05-04 16:00:00	IWM	ETF	170.4	170.62	170.16	170.3	1015294.0
2023-05-04 17:00:00	IWM	ETF	170.3	170.4	170.14	170.2	174211.0
2023-05-04 18:00:00	IWM	ETF	170.27	170.87	170.26	170.87	33103.0
2023-05-04 19:00:00	IWM	ETF	170.89	171.0	170.75	170.83	36128.0
2023-05-04 04:00:00	DIA	ETF	334.47	334.47	333.89	333.89	1680.0
2023-05-04 05:00:00	DIA	ETF	334.25	334.27	334.25	334.27	200.0

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

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