PREVIEW / etf_1hour / 2023-05-30

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-30.parquet
  size:    487 KB
  rows:    17,642

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-30 04:00:00	SPY	ETF	421.51	422.21	421.51	422.08	57912.0
2023-05-30 05:00:00	SPY	ETF	422.06	422.59	422.06	422.43	41680.0
2023-05-30 06:00:00	SPY	ETF	422.4	422.54	422.19	422.19	35898.0
2023-05-30 07:00:00	SPY	ETF	422.16	422.72	421.84	422.45	236083.0
2023-05-30 08:00:00	SPY	ETF	422.2001	422.99	421.04	422.45	457322.0
2023-05-30 09:00:00	SPY	ETF	422.4701	422.59	421.065	421.3301	7468738.0
2023-05-30 10:00:00	SPY	ETF	421.36	421.98	420.19	420.68	8846783.0
2023-05-30 11:00:00	SPY	ETF	420.68	421.1	419.68	420.7071	6104673.0
2023-05-30 12:00:00	SPY	ETF	420.7169	420.78	419.48	420.52	5361830.0
2023-05-30 13:00:00	SPY	ETF	420.53	420.54	418.935	419.015	6037078.0
2023-05-30 14:00:00	SPY	ETF	419.01	420.975	418.735	420.2154	7435127.0
2023-05-30 15:00:00	SPY	ETF	420.215	420.6	419.618	420.17	12277871.0
2023-05-30 16:00:00	SPY	ETF	420.16	420.46	420.08	420.18	2535515.0
2023-05-30 17:00:00	SPY	ETF	420.06	420.25	419.76	419.85	191939.0
2023-05-30 18:00:00	SPY	ETF	419.9	420.1	419.77	420.02	41156.0
2023-05-30 19:00:00	SPY	ETF	420.03	420.48	420.03	420.32	34817.0
2023-05-30 04:00:00	QQQ	ETF	350.7	352.12	350.11	351.86	187203.0
2023-05-30 05:00:00	QQQ	ETF	351.8	352.7	351.77	352.4	92637.0
2023-05-30 06:00:00	QQQ	ETF	352.38	352.63	352.09	352.09	83862.0
2023-05-30 07:00:00	QQQ	ETF	352.05	353.46	352.05	353.23	394157.0
2023-05-30 08:00:00	QQQ	ETF	352.0806	354.18	349.8	353.1	864889.0
2023-05-30 09:00:00	QQQ	ETF	353.15	353.93	350.65	351.12	12165902.0
2023-05-30 10:00:00	QQQ	ETF	351.11	351.84	350.06	351.35	9744585.0
2023-05-30 11:00:00	QQQ	ETF	351.345	352.12	350.51	351.4592	6364502.0
2023-05-30 12:00:00	QQQ	ETF	351.46	351.55	349.89	351.2	5329657.0
2023-05-30 13:00:00	QQQ	ETF	351.2	351.215	348.7	348.8699	4778145.0
2023-05-30 14:00:00	QQQ	ETF	348.88	351.11	348.53	350.6295	5331346.0
2023-05-30 15:00:00	QQQ	ETF	350.62	350.75	349.36	349.96	6741660.0
2023-05-30 16:00:00	QQQ	ETF	349.97	350.35	349.92	350.13	1624848.0
2023-05-30 17:00:00	QQQ	ETF	350.14	350.21	349.55	349.55	66837.0
2023-05-30 18:00:00	QQQ	ETF	349.74	350.18	349.66	350.18	79784.0
2023-05-30 19:00:00	QQQ	ETF	350.1899	350.74	350.1899	350.56	58612.0
2023-05-30 04:00:00	IWM	ETF	176.69	176.76	176.61	176.67	11162.0
2023-05-30 05:00:00	IWM	ETF	176.61	176.88	176.61	176.72	7397.0
2023-05-30 06:00:00	IWM	ETF	176.71	176.85	176.65	176.65	25212.0
2023-05-30 07:00:00	IWM	ETF	176.63	176.74	176.23	176.55	71282.0
2023-05-30 08:00:00	IWM	ETF	176.4005	176.79	176.2298	176.67	246014.0
2023-05-30 09:00:00	IWM	ETF	176.71	177.554	176.125	176.37	2883839.0
2023-05-30 10:00:00	IWM	ETF	176.41	176.83	175.2	175.38	3757423.0
2023-05-30 11:00:00	IWM	ETF	175.37	175.68	174.8	175.5894	2287988.0
2023-05-30 12:00:00	IWM	ETF	175.58	175.62	174.975	175.45	1953503.0
2023-05-30 13:00:00	IWM	ETF	175.47	175.48	174.765	174.91	1651496.0
2023-05-30 14:00:00	IWM	ETF	174.92	175.73	174.76	175.36	1909798.0
2023-05-30 15:00:00	IWM	ETF	175.36	175.92	175.23	175.48	4199402.0
2023-05-30 16:00:00	IWM	ETF	175.5	175.72	175.37	175.55	839185.0
2023-05-30 17:00:00	IWM	ETF	175.55	175.75	175.42	175.42	4028.0
2023-05-30 18:00:00	IWM	ETF	175.41	175.45	175.3	175.32	27567.0
2023-05-30 19:00:00	IWM	ETF	175.39	175.55	175.39	175.46	26912.0
2023-05-30 04:00:00	DIA	ETF	331.59	331.66	331.34	331.66	2744.0
2023-05-30 05:00:00	DIA	ETF	331.72	331.79	331.72	331.79	1145.0

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

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