PREVIEW / etf_1hour / 2022-09-01

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-01.parquet
  size:    455 KB
  rows:    16,898

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-09-01 04:00:00	SPY	ETF	392.79	393.0	391.84	392.11	32756.0
2022-09-01 05:00:00	SPY	ETF	392.25	392.96	391.82	392.61	33483.0
2022-09-01 06:00:00	SPY	ETF	392.61	392.82	392.28	392.7	27419.0
2022-09-01 07:00:00	SPY	ETF	392.58	394.5	392.58	393.85	446892.0
2022-09-01 08:00:00	SPY	ETF	393.9	394.48	391.81	392.59	687523.0
2022-09-01 09:00:00	SPY	ETF	392.61	393.46	391.95	392.805	6847368.0
2022-09-01 10:00:00	SPY	ETF	392.8	393.2794	390.12	390.3404	10798122.0
2022-09-01 11:00:00	SPY	ETF	390.33	392.62	390.04	391.178	8552156.0
2022-09-01 12:00:00	SPY	ETF	391.17	392.31	390.28	390.728	5182707.0
2022-09-01 13:00:00	SPY	ETF	390.75	393.15	390.51	392.13	5853121.0
2022-09-01 14:00:00	SPY	ETF	392.14	395.01	391.8201	394.27	9059239.0
2022-09-01 15:00:00	SPY	ETF	394.26	396.78	393.63	396.4	12384230.0
2022-09-01 16:00:00	SPY	ETF	396.39	396.62	395.69	396.45	2685641.0
2022-09-01 17:00:00	SPY	ETF	396.48	396.65	396.43	396.6	96137.0
2022-09-01 18:00:00	SPY	ETF	396.49	397.07	396.12	396.45	372207.0
2022-09-01 19:00:00	SPY	ETF	396.4	397.67	396.11	396.6	61606.0
2022-09-01 04:00:00	QQQ	ETF	296.37	296.66	295.57	295.92	84667.0
2022-09-01 05:00:00	QQQ	ETF	295.99	296.4	295.39	296.21	61494.0
2022-09-01 06:00:00	QQQ	ETF	296.16	296.74	296.11	296.74	42479.0
2022-09-01 07:00:00	QQQ	ETF	296.57	298.26	296.56	297.52	596379.0
2022-09-01 08:00:00	QQQ	ETF	297.54	298.24	295.4896	296.82	878630.0
2022-09-01 09:00:00	QQQ	ETF	296.82	297.9373	295.89	297.01	6079008.0
2022-09-01 10:00:00	QQQ	ETF	297.0337	297.4399	293.785	293.79	8805406.0
2022-09-01 11:00:00	QQQ	ETF	293.79	294.92	293.12	293.545	6365722.0
2022-09-01 12:00:00	QQQ	ETF	293.545	294.53	292.95	293.43	4170528.0
2022-09-01 13:00:00	QQQ	ETF	293.445	295.57	293.27	294.55	4410543.0
2022-09-01 14:00:00	QQQ	ETF	294.56	297.87	294.251	297.16	6219243.0
2022-09-01 15:00:00	QQQ	ETF	297.15	299.78	296.94	299.43	8191695.0
2022-09-01 16:00:00	QQQ	ETF	299.43	299.77	298.8	299.55	1576827.0
2022-09-01 17:00:00	QQQ	ETF	299.6	300.03	299.4	299.95	184531.0
2022-09-01 18:00:00	QQQ	ETF	299.85	300.2	299.38	299.61	219002.0
2022-09-01 19:00:00	QQQ	ETF	299.61	299.75	299.21	299.75	110730.0
2022-09-01 04:00:00	IWM	ETF	182.24	182.35	181.66	181.8	25752.0
2022-09-01 05:00:00	IWM	ETF	181.86	182.15	181.63	182.03	20309.0
2022-09-01 06:00:00	IWM	ETF	181.91	181.97	181.68	181.85	11475.0
2022-09-01 07:00:00	IWM	ETF	181.83	182.71	181.83	182.41	58137.0
2022-09-01 08:00:00	IWM	ETF	182.45	182.66	181.6996	181.85	171361.0
2022-09-01 09:00:00	IWM	ETF	181.87	182.08	180.1	180.33	3062471.0
2022-09-01 10:00:00	IWM	ETF	180.31	180.39	178.97	179.32	4085963.0
2022-09-01 11:00:00	IWM	ETF	179.31	180.38	179.13	179.5	2738273.0
2022-09-01 12:00:00	IWM	ETF	179.5	180.11	178.9	179.05	2302110.0
2022-09-01 13:00:00	IWM	ETF	179.06	180.27	178.9	179.49	1511517.0
2022-09-01 14:00:00	IWM	ETF	179.49	180.93	179.29	180.5	2210360.0
2022-09-01 15:00:00	IWM	ETF	180.5	181.62	180.13	181.5	4977567.0
2022-09-01 16:00:00	IWM	ETF	181.5	181.68	181.1	181.56	1158179.0
2022-09-01 17:00:00	IWM	ETF	181.68	181.74	181.5	181.7	244192.0
2022-09-01 18:00:00	IWM	ETF	181.66	181.93	181.4	181.63	62925.0
2022-09-01 19:00:00	IWM	ETF	181.55	181.73	181.42	181.72	61200.0
2022-09-01 04:00:00	DIA	ETF	314.42	314.42	313.9	313.9	990.0
2022-09-01 05:00:00	DIA	ETF	313.65	314.36	313.65	314.26	5364.0

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

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