PREVIEW / etf_1hour / 2023-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-13.parquet
  size:    463 KB
  rows:    16,850

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-09-13 04:00:00	SPY	ETF	446.06	446.2	445.52	445.55	18050.0
2023-09-13 05:00:00	SPY	ETF	445.55	446.0	445.48	445.84	14806.0
2023-09-13 06:00:00	SPY	ETF	445.65	445.65	445.19	445.61	40523.0
2023-09-13 07:00:00	SPY	ETF	445.75	446.18	445.26	446.18	179162.0
2023-09-13 08:00:00	SPY	ETF	445.5	446.58	444.2	446.17	1409820.0
2023-09-13 09:00:00	SPY	ETF	446.11	447.26	445.56	446.94	5195571.0
2023-09-13 10:00:00	SPY	ETF	446.945	447.23	445.0793	447.0577	8098649.0
2023-09-13 11:00:00	SPY	ETF	447.07	447.6	446.525	447.2417	5953256.0
2023-09-13 12:00:00	SPY	ETF	447.25	447.55	446.72	447.27	3844618.0
2023-09-13 13:00:00	SPY	ETF	447.27	447.71	447.1235	447.375	3349478.0
2023-09-13 14:00:00	SPY	ETF	447.38	447.51	445.51	446.2	6227546.0
2023-09-13 15:00:00	SPY	ETF	446.21	446.78	445.32	446.51	12399286.0
2023-09-13 16:00:00	SPY	ETF	446.5	446.89	446.35	446.86	2944289.0
2023-09-13 17:00:00	SPY	ETF	446.82	446.89	446.77	446.81	51602.0
2023-09-13 18:00:00	SPY	ETF	446.78	446.85	446.6	446.66	50355.0
2023-09-13 19:00:00	SPY	ETF	446.7599	447.0	446.71	447.0	20916.0
2023-09-13 04:00:00	QQQ	ETF	372.92	373.17	372.47	372.5	50192.0
2023-09-13 05:00:00	QQQ	ETF	372.46	372.84	372.39	372.6	14479.0
2023-09-13 06:00:00	QQQ	ETF	372.54	372.54	371.92	372.4	33739.0
2023-09-13 07:00:00	QQQ	ETF	372.45	373.17	372.04	373.16	78869.0
2023-09-13 08:00:00	QQQ	ETF	373.09	373.53	370.68	372.81	2348106.0
2023-09-13 09:00:00	QQQ	ETF	372.84	374.44	372.4	374.0906	4992724.0
2023-09-13 10:00:00	QQQ	ETF	374.12	374.68	371.88	374.3225	6017940.0
2023-09-13 11:00:00	QQQ	ETF	374.33	375.4462	373.87	374.91	4180697.0
2023-09-13 12:00:00	QQQ	ETF	374.905	375.52	374.26	375.16	2990675.0
2023-09-13 13:00:00	QQQ	ETF	375.16	375.84	374.96	375.4601	2404000.0
2023-09-13 14:00:00	QQQ	ETF	375.465	375.63	373.54	374.245	3738373.0
2023-09-13 15:00:00	QQQ	ETF	374.25	374.42	373.16	374.24	6488475.0
2023-09-13 16:00:00	QQQ	ETF	374.23	374.75	374.11	374.68	1064938.0
2023-09-13 17:00:00	QQQ	ETF	374.67	374.68	374.46	374.5	34798.0
2023-09-13 18:00:00	QQQ	ETF	374.55	374.65	374.48	374.57	33790.0
2023-09-13 19:00:00	QQQ	ETF	374.56	374.9	374.52	374.85	32590.0
2023-09-13 04:00:00	IWM	ETF	184.31	184.47	184.27	184.39	6628.0
2023-09-13 05:00:00	IWM	ETF	184.22	184.28	184.12	184.12	3594.0
2023-09-13 06:00:00	IWM	ETF	184.25	184.27	184.0	184.22	9064.0
2023-09-13 07:00:00	IWM	ETF	184.3	184.69	184.1	184.68	17108.0
2023-09-13 08:00:00	IWM	ETF	184.31	185.04	183.82	184.73	215583.0
2023-09-13 09:00:00	IWM	ETF	184.75	184.88	183.27	183.61	3227206.0
2023-09-13 10:00:00	IWM	ETF	183.6	184.13	182.87	183.95	3780789.0
2023-09-13 11:00:00	IWM	ETF	183.96	184.03	183.275	183.52	1800233.0
2023-09-13 12:00:00	IWM	ETF	183.525	183.775	183.36	183.705	1296605.0
2023-09-13 13:00:00	IWM	ETF	183.7	183.745	183.43	183.44	984168.0
2023-09-13 14:00:00	IWM	ETF	183.43	183.47	182.59	182.81	2178352.0
2023-09-13 15:00:00	IWM	ETF	182.81	183.1	182.39	182.98	5117254.0
2023-09-13 16:00:00	IWM	ETF	182.97	183.07	182.94	183.05	1092485.0
2023-09-13 17:00:00	IWM	ETF	183.06	183.06	182.97	183.0	2031.0
2023-09-13 18:00:00	IWM	ETF	183.0	183.08	182.96	183.03	2645.0
2023-09-13 19:00:00	IWM	ETF	183.05	183.17	183.01	183.17	9251.0
2023-09-13 04:00:00	DIA	ETF	347.1	347.1	347.1	347.1	250.0
2023-09-13 07:00:00	DIA	ETF	346.72	347.02	346.69	347.02	1500.0

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

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