PREVIEW / etf_1hour / 2023-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-25.parquet
  size:    482 KB
  rows:    17,633

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-07-25 04:00:00	SPY	ETF	454.41	455.2	454.34	455.07	56361.0
2023-07-25 05:00:00	SPY	ETF	454.99	455.01	454.79	454.89	8921.0
2023-07-25 06:00:00	SPY	ETF	454.88	454.88	454.44	454.65	16725.0
2023-07-25 07:00:00	SPY	ETF	454.65	454.92	454.64	454.77	44788.0
2023-07-25 08:00:00	SPY	ETF	454.8191	455.1796	454.18	454.34	112772.0
2023-07-25 09:00:00	SPY	ETF	454.3	455.13	453.84	454.785	4315239.0
2023-07-25 10:00:00	SPY	ETF	454.8199	455.05	454.41	454.6	4775899.0
2023-07-25 11:00:00	SPY	ETF	454.61	455.6005	454.525	455.39	4658311.0
2023-07-25 12:00:00	SPY	ETF	455.385	455.89	455.215	455.8899	3335050.0
2023-07-25 13:00:00	SPY	ETF	455.9	456.13	455.53	455.82	3846808.0
2023-07-25 14:00:00	SPY	ETF	455.825	456.735	455.7	455.8299	5246816.0
2023-07-25 15:00:00	SPY	ETF	455.825	456.275	455.32	455.41	10682060.0
2023-07-25 16:00:00	SPY	ETF	455.4	456.41	454.95	456.33	3633449.0
2023-07-25 17:00:00	SPY	ETF	456.35	456.38	455.9	456.25	93296.0
2023-07-25 18:00:00	SPY	ETF	456.25	456.43	455.0	455.24	144430.0
2023-07-25 19:00:00	SPY	ETF	455.22	455.39	455.11	455.3101	55187.0
2023-07-25 04:00:00	QQQ	ETF	376.94	377.82	376.87	377.73	50866.0
2023-07-25 05:00:00	QQQ	ETF	377.71	377.86	377.54	377.74	11662.0
2023-07-25 06:00:00	QQQ	ETF	377.68	377.68	377.02	377.26	55109.0
2023-07-25 07:00:00	QQQ	ETF	377.28	377.63	377.26	377.58	54667.0
2023-07-25 08:00:00	QQQ	ETF	377.43	377.8496	376.3	377.35	150196.0
2023-07-25 09:00:00	QQQ	ETF	377.28	378.85	376.77	378.71	3662750.0
2023-07-25 10:00:00	QQQ	ETF	378.76	378.91	377.29	377.53	4024016.0
2023-07-25 11:00:00	QQQ	ETF	377.53	379.25	377.47	378.85	2703381.0
2023-07-25 12:00:00	QQQ	ETF	378.85	379.54	378.51	379.4982	2405326.0
2023-07-25 13:00:00	QQQ	ETF	379.51	379.825	379.19	379.37	2634957.0
2023-07-25 14:00:00	QQQ	ETF	379.365	380.47	379.23	379.3299	3134363.0
2023-07-25 15:00:00	QQQ	ETF	379.33	380.089	378.8	378.8	5243911.0
2023-07-25 16:00:00	QQQ	ETF	378.83	380.34	377.39	380.2	2671225.0
2023-07-25 17:00:00	QQQ	ETF	380.17	380.41	379.61	379.95	156261.0
2023-07-25 18:00:00	QQQ	ETF	380.0	380.56	377.68	378.27	471576.0
2023-07-25 19:00:00	QQQ	ETF	378.24	378.28	377.9	378.01	54646.0
2023-07-25 04:00:00	IWM	ETF	195.02	195.41	194.94	195.28	14433.0
2023-07-25 05:00:00	IWM	ETF	195.23	195.28	195.1	195.13	3755.0
2023-07-25 06:00:00	IWM	ETF	195.13	195.13	194.85	194.97	16742.0
2023-07-25 07:00:00	IWM	ETF	194.98	195.05	194.91	195.0	34209.0
2023-07-25 08:00:00	IWM	ETF	194.9989	195.3196	194.55	194.55	80328.0
2023-07-25 09:00:00	IWM	ETF	194.57	195.66	194.32	194.85	2277764.0
2023-07-25 10:00:00	IWM	ETF	194.86	196.08	194.8	195.76	2665571.0
2023-07-25 11:00:00	IWM	ETF	195.7396	195.7703	195.21	195.38	1280591.0
2023-07-25 12:00:00	IWM	ETF	195.39	195.67	195.31	195.67	1255467.0
2023-07-25 13:00:00	IWM	ETF	195.68	195.89	195.44	195.88	903900.0
2023-07-25 14:00:00	IWM	ETF	195.89	196.21	195.3	195.44	1924314.0
2023-07-25 15:00:00	IWM	ETF	195.45	195.59	194.855	194.97	3708225.0
2023-07-25 16:00:00	IWM	ETF	194.96	195.35	194.88	195.21	979001.0
2023-07-25 17:00:00	IWM	ETF	195.17	195.38	195.13	195.35	22800.0
2023-07-25 18:00:00	IWM	ETF	195.31	195.49	195.17	195.38	67980.0
2023-07-25 19:00:00	IWM	ETF	195.29	195.45	195.25	195.37	8568.0
2023-07-25 04:00:00	DIA	ETF	353.93	354.1	353.93	354.1	1200.0
2023-07-25 05:00:00	DIA	ETF	354.0	354.0	353.91	353.91	600.0

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

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