PREVIEW / etf_1hour / 2022-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-19.parquet
  size:    442 KB
  rows:    16,290

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-19 04:00:00	SPY	ETF	382.87	384.79	382.44	382.55	86800.0
2022-09-19 05:00:00	SPY	ETF	382.59	382.97	381.98	382.29	45673.0
2022-09-19 06:00:00	SPY	ETF	382.24	382.64	381.5	382.48	139839.0
2022-09-19 07:00:00	SPY	ETF	382.61	383.09	381.98	381.99	313407.0
2022-09-19 08:00:00	SPY	ETF	382.45	385.26	381.97	383.11	555774.0
2022-09-19 09:00:00	SPY	ETF	383.14	385.49	382.1784	384.8401	7788041.0
2022-09-19 10:00:00	SPY	ETF	384.8873	387.16	384.03	386.2099	8018522.0
2022-09-19 11:00:00	SPY	ETF	386.22	387.06	384.2	384.525	5617426.0
2022-09-19 12:00:00	SPY	ETF	384.52	386.31	383.895	386.13	4252732.0
2022-09-19 13:00:00	SPY	ETF	386.13	386.27	384.9802	385.42	3483629.0
2022-09-19 14:00:00	SPY	ETF	385.44	385.92	384.67	385.85	5069549.0
2022-09-19 15:00:00	SPY	ETF	385.87	388.55	385.85	388.54	14119708.0
2022-09-19 16:00:00	SPY	ETF	388.53	389.37	386.4895	388.98	3933711.0
2022-09-19 17:00:00	SPY	ETF	388.98	389.13	388.55	389.06	166657.0
2022-09-19 18:00:00	SPY	ETF	389.02	389.52	388.88	389.18	136734.0
2022-09-19 19:00:00	SPY	ETF	389.18	389.81	389.08	389.77	80701.0
2022-09-19 04:00:00	QQQ	ETF	287.46	287.96	285.94	286.07	52341.0
2022-09-19 05:00:00	QQQ	ETF	286.04	286.43	285.75	286.16	64238.0
2022-09-19 06:00:00	QQQ	ETF	286.09	286.38	285.5	286.38	79525.0
2022-09-19 07:00:00	QQQ	ETF	286.39	286.65	285.83	285.83	253326.0
2022-09-19 08:00:00	QQQ	ETF	285.83	288.2	285.6496	286.83	493774.0
2022-09-19 09:00:00	QQQ	ETF	286.84	288.8495	286.04	288.45	7221029.0
2022-09-19 10:00:00	QQQ	ETF	288.47	289.92	287.37	289.2001	6491039.0
2022-09-19 11:00:00	QQQ	ETF	289.21	289.99	287.33	287.5001	5200441.0
2022-09-19 12:00:00	QQQ	ETF	287.47	289.32	286.845	289.1	3511339.0
2022-09-19 13:00:00	QQQ	ETF	289.1199	289.2374	288.11	288.49	2749834.0
2022-09-19 14:00:00	QQQ	ETF	288.5	289.21	288.0	289.13	3434002.0
2022-09-19 15:00:00	QQQ	ETF	289.17	291.21	289.155	291.1	8664545.0
2022-09-19 16:00:00	QQQ	ETF	291.09	292.03	290.55	291.59	1966676.0
2022-09-19 17:00:00	QQQ	ETF	291.4	291.72	291.05	291.65	63064.0
2022-09-19 18:00:00	QQQ	ETF	291.62	292.0	291.47	291.69	43570.0
2022-09-19 19:00:00	QQQ	ETF	291.74	292.3	291.66	292.3	115646.0
2022-09-19 04:00:00	IWM	ETF	178.45	178.45	177.06	177.06	18967.0
2022-09-19 05:00:00	IWM	ETF	177.12	177.41	176.79	176.99	15567.0
2022-09-19 06:00:00	IWM	ETF	176.97	177.2	176.6	177.2	25749.0
2022-09-19 07:00:00	IWM	ETF	177.2	177.48	176.87	176.87	40583.0
2022-09-19 08:00:00	IWM	ETF	177.22	177.88	176.93	177.65	76597.0
2022-09-19 09:00:00	IWM	ETF	177.63	179.46	176.96	179.14	3973703.0
2022-09-19 10:00:00	IWM	ETF	179.15	179.89	178.29	178.99	2867871.0
2022-09-19 11:00:00	IWM	ETF	179.0	180.0	178.34	178.58	1739996.0
2022-09-19 12:00:00	IWM	ETF	178.575	179.49	178.39	179.43	1738472.0
2022-09-19 13:00:00	IWM	ETF	179.42	179.72	179.16	179.52	1238515.0
2022-09-19 14:00:00	IWM	ETF	179.53	179.89	179.25	179.7	1180439.0
2022-09-19 15:00:00	IWM	ETF	179.71	180.75	179.69	180.52	3972314.0
2022-09-19 16:00:00	IWM	ETF	180.52	180.93	180.43	180.7	1491089.0
2022-09-19 17:00:00	IWM	ETF	180.68	180.77	180.52	180.77	88870.0
2022-09-19 18:00:00	IWM	ETF	180.63	180.92	180.63	180.72	39658.0
2022-09-19 19:00:00	IWM	ETF	180.75	181.17	180.72	181.16	37145.0
2022-09-19 04:00:00	DIA	ETF	308.05	308.05	305.71	305.71	3039.0
2022-09-19 05:00:00	DIA	ETF	305.35	305.35	305.35	305.35	100.0

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

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