PREVIEW / etf_1hour / 2022-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-23.parquet
  size:    459 KB
  rows:    16,434

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-12-23 04:00:00	SPY	ETF	381.07	381.11	380.36	380.9	29713.0
2022-12-23 05:00:00	SPY	ETF	380.97	382.25	380.8	382.03	30846.0
2022-12-23 06:00:00	SPY	ETF	382.04	382.42	381.19	381.34	41091.0
2022-12-23 07:00:00	SPY	ETF	381.37	381.77	381.08	381.63	122029.0
2022-12-23 08:00:00	SPY	ETF	381.56	382.96	378.94	380.79	1408225.0
2022-12-23 09:00:00	SPY	ETF	380.7	381.27	378.03	378.4921	5134008.0
2022-12-23 10:00:00	SPY	ETF	378.485	382.685	378.24	380.79	8609226.0
2022-12-23 11:00:00	SPY	ETF	380.79	382.12	380.0	381.58	4575667.0
2022-12-23 12:00:00	SPY	ETF	381.59	382.85	381.39	381.86	3934277.0
2022-12-23 13:00:00	SPY	ETF	381.86	382.4295	381.03	381.47	2750939.0
2022-12-23 14:00:00	SPY	ETF	381.44	382.6	381.065	382.54	3190687.0
2022-12-23 15:00:00	SPY	ETF	382.53	383.06	381.56	382.9	9021036.0
2022-12-23 16:00:00	SPY	ETF	382.89	382.97	382.2	382.63	3231342.0
2022-12-23 17:00:00	SPY	ETF	382.76	382.94	382.57	382.94	57098.0
2022-12-23 18:00:00	SPY	ETF	382.93	383.05	382.77	382.97	53821.0
2022-12-23 19:00:00	SPY	ETF	382.95	383.04	382.65	383.0	44424.0
2022-12-23 04:00:00	QQQ	ETF	266.07	266.88	266.07	266.6	36665.0
2022-12-23 05:00:00	QQQ	ETF	266.65	268.02	266.5	267.84	58380.0
2022-12-23 06:00:00	QQQ	ETF	267.86	268.23	267.04	267.13	117381.0
2022-12-23 07:00:00	QQQ	ETF	267.24	267.89	267.06	267.75	147649.0
2022-12-23 08:00:00	QQQ	ETF	267.4	269.0	265.07	266.75	1854444.0
2022-12-23 09:00:00	QQQ	ETF	266.74	266.95	263.63	264.07	4824053.0
2022-12-23 10:00:00	QQQ	ETF	264.07	268.04	263.53	265.8799	7329940.0
2022-12-23 11:00:00	QQQ	ETF	265.87	267.05	264.94	266.3199	3434954.0
2022-12-23 12:00:00	QQQ	ETF	266.32	267.515	266.13	266.56	2508844.0
2022-12-23 13:00:00	QQQ	ETF	266.56	267.08	265.97	266.43	1866892.0
2022-12-23 14:00:00	QQQ	ETF	266.41	267.31	266.035	267.2439	2156693.0
2022-12-23 15:00:00	QQQ	ETF	267.26	267.66	266.41	267.45	4553031.0
2022-12-23 16:00:00	QQQ	ETF	267.455	267.49	267.17	267.17	1206114.0
2022-12-23 17:00:00	QQQ	ETF	267.24	267.34	267.14	267.3389	35804.0
2022-12-23 18:00:00	QQQ	ETF	267.36	267.36	267.13	267.23	20863.0
2022-12-23 19:00:00	QQQ	ETF	267.3	267.32	266.99	267.25	11455.0
2022-12-23 04:00:00	IWM	ETF	173.95	174.04	173.76	174.03	12390.0
2022-12-23 05:00:00	IWM	ETF	174.03	174.52	174.02	174.39	2568.0
2022-12-23 06:00:00	IWM	ETF	174.43	174.61	174.07	174.1	5764.0
2022-12-23 07:00:00	IWM	ETF	174.01	174.14	173.81	174.12	21259.0
2022-12-23 08:00:00	IWM	ETF	173.97	175.0	173.0	174.07	252977.0
2022-12-23 09:00:00	IWM	ETF	174.08	174.28	172.34	172.54	1513625.0
2022-12-23 10:00:00	IWM	ETF	172.55	174.35	172.43	173.42	1624744.0
2022-12-23 11:00:00	IWM	ETF	173.41	173.89	173.085	173.7775	980529.0
2022-12-23 12:00:00	IWM	ETF	173.7787	174.17	173.415	173.55	859227.0
2022-12-23 13:00:00	IWM	ETF	173.54	173.87	173.26	173.67	558309.0
2022-12-23 14:00:00	IWM	ETF	173.65	174.2	173.515	174.18	716613.0
2022-12-23 15:00:00	IWM	ETF	174.19	174.45	173.86	174.38	1828987.0
2022-12-23 16:00:00	IWM	ETF	174.39	174.4	174.1	174.15	796587.0
2022-12-23 17:00:00	IWM	ETF	174.2	174.45	174.12	174.25	2621.0
2022-12-23 18:00:00	IWM	ETF	174.25	174.4	174.21	174.34	32340.0
2022-12-23 19:00:00	IWM	ETF	174.42	174.43	174.18	174.37	5611.0
2022-12-23 04:00:00	DIA	ETF	329.31	330.93	329.31	330.88	1300.0
2022-12-23 05:00:00	DIA	ETF	330.93	331.56	330.93	331.56	1300.0

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

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