PREVIEW / etf_1hour / 2022-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-25.parquet
  size:    436 KB
  rows:    15,668

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-07-25 04:00:00	SPY	ETF	394.42	396.02	394.42	395.93	41949.0
2022-07-25 05:00:00	SPY	ETF	395.84	397.04	395.84	396.98	48695.0
2022-07-25 06:00:00	SPY	ETF	397.02	397.21	396.73	397.21	67925.0
2022-07-25 07:00:00	SPY	ETF	397.22	397.5	396.6	396.82	311025.0
2022-07-25 08:00:00	SPY	ETF	395.25	397.5	394.36	396.41	515667.0
2022-07-25 09:00:00	SPY	ETF	396.41	396.58	394.03	395.5	4501795.0
2022-07-25 10:00:00	SPY	ETF	395.53	395.88	393.74	395.22	5854921.0
2022-07-25 11:00:00	SPY	ETF	395.2128	396.29	394.27	395.9	4645388.0
2022-07-25 12:00:00	SPY	ETF	395.91	396.47	394.71	395.82	4652230.0
2022-07-25 13:00:00	SPY	ETF	395.82	396.31	394.47	394.485	3690417.0
2022-07-25 14:00:00	SPY	ETF	394.495	394.725	393.65	393.79	4362911.0
2022-07-25 15:00:00	SPY	ETF	393.8	395.75	393.21	395.55	9376080.0
2022-07-25 16:00:00	SPY	ETF	395.55	396.17	393.0	394.76	3515844.0
2022-07-25 17:00:00	SPY	ETF	394.61	394.82	394.11	394.33	317918.0
2022-07-25 18:00:00	SPY	ETF	394.33	394.48	394.1	394.37	147683.0
2022-07-25 19:00:00	SPY	ETF	394.35	394.38	393.91	394.209	125400.0
2022-07-25 04:00:00	QQQ	ETF	301.9	303.05	301.77	302.79	115304.0
2022-07-25 05:00:00	QQQ	ETF	302.8	303.69	302.8	303.58	70663.0
2022-07-25 06:00:00	QQQ	ETF	303.68	303.76	303.3	303.59	49276.0
2022-07-25 07:00:00	QQQ	ETF	303.59	303.83	303.01	303.27	156245.0
2022-07-25 08:00:00	QQQ	ETF	303.33	303.82	302.1	302.64	467710.0
2022-07-25 09:00:00	QQQ	ETF	302.69	302.83	300.364	301.1	5891260.0
2022-07-25 10:00:00	QQQ	ETF	301.14	301.49	298.75	300.32	6441851.0
2022-07-25 11:00:00	QQQ	ETF	300.3292	301.14	299.08	300.7388	3739737.0
2022-07-25 12:00:00	QQQ	ETF	300.73	301.59	299.76	300.93	2834593.0
2022-07-25 13:00:00	QQQ	ETF	300.93	301.32	299.53	299.535	2547502.0
2022-07-25 14:00:00	QQQ	ETF	299.555	299.75	298.65	298.81	2982084.0
2022-07-25 15:00:00	QQQ	ETF	298.81	300.44	298.22	300.36	6033908.0
2022-07-25 16:00:00	QQQ	ETF	300.37	300.84	299.42	299.6	1842211.0
2022-07-25 17:00:00	QQQ	ETF	299.89	299.89	299.12	299.14	93868.0
2022-07-25 18:00:00	QQQ	ETF	299.2	299.34	298.98	299.19	158043.0
2022-07-25 19:00:00	QQQ	ETF	299.19	299.19	298.68	298.9	166013.0
2022-07-25 04:00:00	IWM	ETF	179.42	180.21	179.42	180.12	36628.0
2022-07-25 05:00:00	IWM	ETF	180.08	180.69	180.08	180.61	14897.0
2022-07-25 06:00:00	IWM	ETF	180.69	180.76	180.52	180.76	14198.0
2022-07-25 07:00:00	IWM	ETF	180.71	180.77	180.32	180.37	49528.0
2022-07-25 08:00:00	IWM	ETF	180.4	180.81	180.03	180.17	60105.0
2022-07-25 09:00:00	IWM	ETF	180.15	180.27	178.43	179.72	3865589.0
2022-07-25 10:00:00	IWM	ETF	179.71	180.44	179.3	179.96	2031501.0
2022-07-25 11:00:00	IWM	ETF	179.95	180.92	179.63	180.745	1808844.0
2022-07-25 12:00:00	IWM	ETF	180.74	180.83	179.99	180.56	1143213.0
2022-07-25 13:00:00	IWM	ETF	180.57	180.9	180.011	180.04	1019775.0
2022-07-25 14:00:00	IWM	ETF	180.03	180.28	179.73	179.82	925673.0
2022-07-25 15:00:00	IWM	ETF	179.79	180.53	179.415	180.45	3145141.0
2022-07-25 16:00:00	IWM	ETF	180.44	180.83	180.07	180.14	758753.0
2022-07-25 17:00:00	IWM	ETF	180.02	180.17	179.79	179.81	17248.0
2022-07-25 18:00:00	IWM	ETF	179.91	180.03	179.74	179.99	45195.0
2022-07-25 19:00:00	IWM	ETF	179.9	180.01	179.73	179.85	33377.0
2022-07-25 04:00:00	DIA	ETF	318.93	319.55	318.93	319.55	3100.0
2022-07-25 05:00:00	DIA	ETF	319.94	320.44	319.94	320.44	2300.0

> showing 50 of 15,668 rows — these rows as CSV

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