PREVIEW / etf_1hour / 2023-05-31

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-31.parquet
  size:    473 KB
  rows:    17,458

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-31 04:00:00	SPY	ETF	419.23	419.51	418.85	419.39	23338.0
2023-05-31 05:00:00	SPY	ETF	419.59	419.8	419.2	419.2	16563.0
2023-05-31 06:00:00	SPY	ETF	419.29	419.44	418.86	419.38	187082.0
2023-05-31 07:00:00	SPY	ETF	419.41	419.49	418.44	418.5	331604.0
2023-05-31 08:00:00	SPY	ETF	419.39	420.31	418.1	418.2	231630.0
2023-05-31 09:00:00	SPY	ETF	418.22	419.22	418.03	418.1391	5800748.0
2023-05-31 10:00:00	SPY	ETF	418.17	418.3	416.322	416.84	11338574.0
2023-05-31 11:00:00	SPY	ETF	416.86	417.08	416.22	416.75	6045338.0
2023-05-31 12:00:00	SPY	ETF	416.755	417.41	416.44	417.05	4312071.0
2023-05-31 13:00:00	SPY	ETF	417.05	418.49	416.9	418.31	5908779.0
2023-05-31 14:00:00	SPY	ETF	418.31	418.72	417.58	418.13	6528682.0
2023-05-31 15:00:00	SPY	ETF	418.13	419.13	417.57	417.83	24753265.0
2023-05-31 16:00:00	SPY	ETF	417.82	418.15	417.34	417.64	8560487.0
2023-05-31 17:00:00	SPY	ETF	417.6999	417.8	417.62	417.66	146331.0
2023-05-31 18:00:00	SPY	ETF	417.74	418.08	417.67	418.08	164833.0
2023-05-31 19:00:00	SPY	ETF	418.1	418.45	417.97	418.4	63197.0
2023-05-31 04:00:00	QQQ	ETF	349.11	349.25	348.75	349.25	95639.0
2023-05-31 05:00:00	QQQ	ETF	349.27	349.73	349.26	349.38	38160.0
2023-05-31 06:00:00	QQQ	ETF	349.47	349.56	348.93	349.5	55884.0
2023-05-31 07:00:00	QQQ	ETF	349.51	349.65	348.42	348.61	161201.0
2023-05-31 08:00:00	QQQ	ETF	349.55	350.242	348.08	348.16	430817.0
2023-05-31 09:00:00	QQQ	ETF	348.16	350.6	348.06	349.51	6432921.0
2023-05-31 10:00:00	QQQ	ETF	349.52	349.91	347.04	347.92	8207132.0
2023-05-31 11:00:00	QQQ	ETF	347.92	348.01	346.51	347.45	4422069.0
2023-05-31 12:00:00	QQQ	ETF	347.46	347.9	346.53	347.155	3734665.0
2023-05-31 13:00:00	QQQ	ETF	347.16	349.23	346.97	348.79	4262127.0
2023-05-31 14:00:00	QQQ	ETF	348.77	349.12	347.8499	348.341	3709999.0
2023-05-31 15:00:00	QQQ	ETF	348.35	349.01	347.47	347.66	12339235.0
2023-05-31 16:00:00	QQQ	ETF	347.67	347.99	347.22	347.36	2021807.0
2023-05-31 17:00:00	QQQ	ETF	347.34	347.5	347.32	347.44	40056.0
2023-05-31 18:00:00	QQQ	ETF	347.41	347.62	347.24	347.5	254353.0
2023-05-31 19:00:00	QQQ	ETF	347.58	347.95	347.48	347.88	52702.0
2023-05-31 04:00:00	IWM	ETF	175.05	175.33	174.96	175.24	9994.0
2023-05-31 05:00:00	IWM	ETF	175.29	175.42	175.26	175.3	5121.0
2023-05-31 06:00:00	IWM	ETF	174.9	175.07	174.75	175.01	8523.0
2023-05-31 07:00:00	IWM	ETF	175.0	175.0	174.44	174.52	52350.0
2023-05-31 08:00:00	IWM	ETF	174.5	175.3396	174.459	174.63	144185.0
2023-05-31 09:00:00	IWM	ETF	174.64	176.01	174.01	174.34	3348119.0
2023-05-31 10:00:00	IWM	ETF	174.35	174.39	172.64	172.82	6143726.0
2023-05-31 11:00:00	IWM	ETF	172.83	173.095	172.36	172.66	2840835.0
2023-05-31 12:00:00	IWM	ETF	172.66	173.22	172.495	172.83	2040102.0
2023-05-31 13:00:00	IWM	ETF	172.83	173.765	172.73	173.57	2528561.0
2023-05-31 14:00:00	IWM	ETF	173.58	173.955	173.32	173.51	2323971.0
2023-05-31 15:00:00	IWM	ETF	173.52	174.0899	173.27	173.66	4925658.0
2023-05-31 16:00:00	IWM	ETF	173.77	173.88	173.5	173.57	1922240.0
2023-05-31 17:00:00	IWM	ETF	173.56	173.74	173.53	173.67	4441.0
2023-05-31 18:00:00	IWM	ETF	173.57	173.79	173.54	173.74	29929.0
2023-05-31 19:00:00	IWM	ETF	173.8	174.02	173.7	174.0	64919.0
2023-05-31 06:00:00	DIA	ETF	329.85	330.1	329.85	330.1	2700.0
2023-05-31 07:00:00	DIA	ETF	330.08	330.08	329.87	330.07	2325.0

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

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