PREVIEW / etf_1hour / 2023-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-27.parquet
  size:    479 KB
  rows:    17,093

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-06-27 04:00:00	SPY	ETF	432.45	432.72	432.09	432.22	37324.0
2023-06-27 05:00:00	SPY	ETF	432.15	432.33	432.1	432.18	8729.0
2023-06-27 06:00:00	SPY	ETF	432.32	432.5	432.11	432.47	16603.0
2023-06-27 07:00:00	SPY	ETF	432.49	432.5	431.68	431.74	114508.0
2023-06-27 08:00:00	SPY	ETF	432.3301	432.94	431.59	432.15	238679.0
2023-06-27 09:00:00	SPY	ETF	432.1	433.3	432.02	432.73	5121797.0
2023-06-27 10:00:00	SPY	ETF	432.72	433.43	431.88	433.35	8127821.0
2023-06-27 11:00:00	SPY	ETF	433.35	434.32	432.54	434.2099	6840178.0
2023-06-27 12:00:00	SPY	ETF	434.21	435.35	434.1	435.0799	4993136.0
2023-06-27 13:00:00	SPY	ETF	435.07	436.28	434.78	436.225	5292587.0
2023-06-27 14:00:00	SPY	ETF	436.23	436.63	436.09	436.135	6435043.0
2023-06-27 15:00:00	SPY	ETF	436.15	436.81	436.08	436.14	13208733.0
2023-06-27 16:00:00	SPY	ETF	436.13	436.1974	435.68	435.81	3809604.0
2023-06-27 17:00:00	SPY	ETF	435.85	436.17	435.72	435.81	567998.0
2023-06-27 18:00:00	SPY	ETF	435.75	435.83	435.43	435.49	131051.0
2023-06-27 19:00:00	SPY	ETF	435.4899	435.54	435.3	435.45	54994.0
2023-06-27 04:00:00	QQQ	ETF	358.9	359.38	358.74	358.97	40163.0
2023-06-27 05:00:00	QQQ	ETF	358.98	359.28	358.88	359.21	11648.0
2023-06-27 06:00:00	QQQ	ETF	359.27	359.66	359.17	359.55	58675.0
2023-06-27 07:00:00	QQQ	ETF	359.52	359.55	358.8	358.89	112752.0
2023-06-27 08:00:00	QQQ	ETF	359.5406	359.68	357.948	359.13	336151.0
2023-06-27 09:00:00	QQQ	ETF	359.13	360.51	358.77	360.25	4646597.0
2023-06-27 10:00:00	QQQ	ETF	360.18	361.67	358.51	359.64	5370973.0
2023-06-27 11:00:00	QQQ	ETF	359.67	361.51	358.551	361.41	4458772.0
2023-06-27 12:00:00	QQQ	ETF	361.42	362.82	361.25	362.47	4128374.0
2023-06-27 13:00:00	QQQ	ETF	362.46	363.96	362.04	363.94	4036174.0
2023-06-27 14:00:00	QQQ	ETF	363.955	364.41	363.61	363.72	3745640.0
2023-06-27 15:00:00	QQQ	ETF	363.73	364.57	363.65	363.86	6796542.0
2023-06-27 16:00:00	QQQ	ETF	363.85	363.9046	363.28	363.35	2594988.0
2023-06-27 17:00:00	QQQ	ETF	363.33	363.48	363.3133	363.48	63915.0
2023-06-27 18:00:00	QQQ	ETF	363.39	363.44	362.45	362.59	188456.0
2023-06-27 19:00:00	QQQ	ETF	362.56	362.79	362.24	362.65	177840.0
2023-06-27 04:00:00	IWM	ETF	181.33	181.34	180.89	180.9	19800.0
2023-06-27 05:00:00	IWM	ETF	180.96	180.98	180.81	180.81	9381.0
2023-06-27 06:00:00	IWM	ETF	180.9	181.08	180.75	181.08	4452.0
2023-06-27 07:00:00	IWM	ETF	181.04	181.07	180.45	180.47	41512.0
2023-06-27 08:00:00	IWM	ETF	181.05	181.34	180.38	180.92	108107.0
2023-06-27 09:00:00	IWM	ETF	180.9	181.46	180.4	181.14	3345490.0
2023-06-27 10:00:00	IWM	ETF	181.12	182.79	180.88	182.735	4102193.0
2023-06-27 11:00:00	IWM	ETF	182.745	182.94	182.23	182.72	2328369.0
2023-06-27 12:00:00	IWM	ETF	182.73	183.76	182.71	183.38	2252170.0
2023-06-27 13:00:00	IWM	ETF	183.38	183.985	183.14	183.71	2297031.0
2023-06-27 14:00:00	IWM	ETF	183.715	183.85	183.46	183.4699	1817024.0
2023-06-27 15:00:00	IWM	ETF	183.47	183.95	183.25	183.36	5471250.0
2023-06-27 16:00:00	IWM	ETF	183.36	183.37	183.04	183.09	1428499.0
2023-06-27 17:00:00	IWM	ETF	183.16	183.27	183.14	183.25	13204.0
2023-06-27 18:00:00	IWM	ETF	183.19	183.3	183.1	183.15	13923.0
2023-06-27 19:00:00	IWM	ETF	183.15	183.23	183.06	183.12	13680.0
2023-06-27 04:00:00	DIA	ETF	337.6	337.6	337.39	337.39	1100.0
2023-06-27 06:00:00	DIA	ETF	337.03	337.03	337.01	337.01	250.0

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

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