PREVIEW / etf_1hour / 2023-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-20.parquet
  size:    483 KB
  rows:    17,734

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-20 04:00:00	SPY	ETF	454.55	454.97	454.55	454.74	29533.0
2023-07-20 05:00:00	SPY	ETF	454.72	454.76	454.46	454.73	8616.0
2023-07-20 06:00:00	SPY	ETF	454.72	455.1	454.69	454.9	21470.0
2023-07-20 07:00:00	SPY	ETF	454.89	454.92	454.58	454.83	140544.0
2023-07-20 08:00:00	SPY	ETF	454.84	454.9496	454.08	454.13	252905.0
2023-07-20 09:00:00	SPY	ETF	454.11	455.1	453.64	454.81	5693763.0
2023-07-20 10:00:00	SPY	ETF	454.82	454.95	452.81	453.67	10220190.0
2023-07-20 11:00:00	SPY	ETF	453.665	454.365	453.44	454.06	5908657.0
2023-07-20 12:00:00	SPY	ETF	454.06	454.78	453.33	453.495	5958056.0
2023-07-20 13:00:00	SPY	ETF	453.5	453.805	453.19	453.3989	3621090.0
2023-07-20 14:00:00	SPY	ETF	453.39	453.49	452.085	452.485	6524456.0
2023-07-20 15:00:00	SPY	ETF	452.49	452.745	451.44	452.18	13596242.0
2023-07-20 16:00:00	SPY	ETF	452.18	452.52	452.16	452.34	2533508.0
2023-07-20 17:00:00	SPY	ETF	452.38	452.48	452.31	452.3102	36003.0
2023-07-20 18:00:00	SPY	ETF	452.5	452.53	452.13	452.2	40430.0
2023-07-20 19:00:00	SPY	ETF	452.2	452.41	452.19	452.25	19361.0
2023-07-20 04:00:00	QQQ	ETF	383.03	383.22	382.41	382.58	46423.0
2023-07-20 05:00:00	QQQ	ETF	382.53	382.65	382.26	382.65	15728.0
2023-07-20 06:00:00	QQQ	ETF	382.63	383.37	382.6	383.13	54054.0
2023-07-20 07:00:00	QQQ	ETF	383.22	383.48	382.72	383.43	179798.0
2023-07-20 08:00:00	QQQ	ETF	383.19	384.04	382.25	382.58	509707.0
2023-07-20 09:00:00	QQQ	ETF	382.58	384.095	381.9	383.27	6345355.0
2023-07-20 10:00:00	QQQ	ETF	383.28	383.37	379.36	380.0301	10899470.0
2023-07-20 11:00:00	QQQ	ETF	380.03	381.45	379.93	380.46	5734436.0
2023-07-20 12:00:00	QQQ	ETF	380.47	381.39	379.03	379.24	5650491.0
2023-07-20 13:00:00	QQQ	ETF	379.22	379.755	378.92	379.17	4142975.0
2023-07-20 14:00:00	QQQ	ETF	379.15	379.16	377.13	377.142	6248725.0
2023-07-20 15:00:00	QQQ	ETF	377.15	377.48	375.72	376.68	12943121.0
2023-07-20 16:00:00	QQQ	ETF	376.69	377.09	376.67	376.92	2318325.0
2023-07-20 17:00:00	QQQ	ETF	376.92	377.04	376.67	376.86	87326.0
2023-07-20 18:00:00	QQQ	ETF	376.84	377.0	376.4	376.5	151298.0
2023-07-20 19:00:00	QQQ	ETF	376.54	376.78	376.39	376.47	71828.0
2023-07-20 04:00:00	IWM	ETF	197.43	197.82	197.43	197.54	18130.0
2023-07-20 05:00:00	IWM	ETF	197.56	197.56	197.32	197.55	6126.0
2023-07-20 06:00:00	IWM	ETF	197.56	197.67	197.53	197.58	5786.0
2023-07-20 07:00:00	IWM	ETF	197.6	197.64	197.43	197.5	65758.0
2023-07-20 08:00:00	IWM	ETF	197.58	197.63	196.84	196.85	141602.0
2023-07-20 09:00:00	IWM	ETF	196.91	197.02	195.48	196.0	3471820.0
2023-07-20 10:00:00	IWM	ETF	196.0	196.12	194.265	195.14	4630455.0
2023-07-20 11:00:00	IWM	ETF	195.115	195.39	194.82	195.25	2136427.0
2023-07-20 12:00:00	IWM	ETF	195.27	195.66	194.64	194.94	1605268.0
2023-07-20 13:00:00	IWM	ETF	194.95	195.06	194.593	194.9	1145684.0
2023-07-20 14:00:00	IWM	ETF	194.9	195.25	194.545	195.035	2118629.0
2023-07-20 15:00:00	IWM	ETF	195.035	195.26	194.72	195.11	4250124.0
2023-07-20 16:00:00	IWM	ETF	195.115	195.38	195.08	195.34	1478271.0
2023-07-20 17:00:00	IWM	ETF	195.32	195.32	195.14	195.2	7295.0
2023-07-20 18:00:00	IWM	ETF	195.28	195.5	195.21	195.25	29396.0
2023-07-20 19:00:00	IWM	ETF	195.29	195.31	195.2	195.24	19539.0
2023-07-20 04:00:00	DIA	ETF	351.33	351.33	351.3	351.3	397.0
2023-07-20 05:00:00	DIA	ETF	351.2	351.2	351.2	351.2	200.0

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

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