PREVIEW / etf_1hour / 2023-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-31.parquet
  size:    486 KB
  rows:    17,273

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-08-31 04:00:00	SPY	ETF	451.93	451.97	451.42	451.86	19140.0
2023-08-31 05:00:00	SPY	ETF	451.93	451.93	451.22	451.32	21237.0
2023-08-31 06:00:00	SPY	ETF	451.47	451.79	451.46	451.67	14051.0
2023-08-31 07:00:00	SPY	ETF	451.55	452.59	451.33	452.4	69280.0
2023-08-31 08:00:00	SPY	ETF	452.559	452.96	451.33	452.22	515659.0
2023-08-31 09:00:00	SPY	ETF	452.22	452.55	451.37	452.43	4525666.0
2023-08-31 10:00:00	SPY	ETF	452.43	452.83	451.81	452.34	6168815.0
2023-08-31 11:00:00	SPY	ETF	452.35	452.37	451.45	451.9	4485900.0
2023-08-31 12:00:00	SPY	ETF	451.91	452.25	450.36	450.965	5536099.0
2023-08-31 13:00:00	SPY	ETF	450.97	451.87	450.77	451.46	4303233.0
2023-08-31 14:00:00	SPY	ETF	451.47	452.19	450.7801	450.88	5809894.0
2023-08-31 15:00:00	SPY	ETF	450.865	451.68	450.16	450.28	15530106.0
2023-08-31 16:00:00	SPY	ETF	450.26	451.9451	450.24	450.56	4170242.0
2023-08-31 17:00:00	SPY	ETF	450.52	450.65	450.46	450.5	58755.0
2023-08-31 18:00:00	SPY	ETF	450.5	450.59	450.33	450.44	52156.0
2023-08-31 19:00:00	SPY	ETF	450.52	450.7	450.49	450.67	24120.0
2023-08-31 04:00:00	QQQ	ETF	377.43	377.55	377.17	377.23	29138.0
2023-08-31 05:00:00	QQQ	ETF	377.25	377.25	376.26	376.35	58102.0
2023-08-31 06:00:00	QQQ	ETF	376.35	376.9	376.35	376.68	24916.0
2023-08-31 07:00:00	QQQ	ETF	376.69	377.819	376.48	377.64	177113.0
2023-08-31 08:00:00	QQQ	ETF	376.6791	378.1892	376.3296	377.34	573750.0
2023-08-31 09:00:00	QQQ	ETF	377.28	378.775	376.67	378.75	4505852.0
2023-08-31 10:00:00	QQQ	ETF	378.77	379.719	378.05	379.13	4501278.0
2023-08-31 11:00:00	QQQ	ETF	379.131	379.33	378.09	378.7	3166093.0
2023-08-31 12:00:00	QQQ	ETF	378.7	379.12	376.96	377.77	3158243.0
2023-08-31 13:00:00	QQQ	ETF	377.78	378.93	377.57	378.48	2451831.0
2023-08-31 14:00:00	QQQ	ETF	378.49	379.43	378.3	378.42	2544110.0
2023-08-31 15:00:00	QQQ	ETF	378.415	379.365	377.84	377.89	5150969.0
2023-08-31 16:00:00	QQQ	ETF	377.89	378.3	377.88	378.01	1181474.0
2023-08-31 17:00:00	QQQ	ETF	378.04	378.04	377.8	377.84	15112.0
2023-08-31 18:00:00	QQQ	ETF	377.85	377.95	377.7	377.7804	45533.0
2023-08-31 19:00:00	QQQ	ETF	377.8	378.02	377.8	378.02	34900.0
2023-08-31 04:00:00	IWM	ETF	189.44	189.52	189.25	189.4	11497.0
2023-08-31 05:00:00	IWM	ETF	189.39	189.39	189.04	189.13	3837.0
2023-08-31 06:00:00	IWM	ETF	189.13	189.32	189.13	189.32	3252.0
2023-08-31 07:00:00	IWM	ETF	189.2	189.76	189.11	189.66	138463.0
2023-08-31 08:00:00	IWM	ETF	189.3398	189.94	189.25	189.48	97079.0
2023-08-31 09:00:00	IWM	ETF	189.46	190.05	189.055	190.04	1530003.0
2023-08-31 10:00:00	IWM	ETF	190.035	190.255	189.605	189.95	1882437.0
2023-08-31 11:00:00	IWM	ETF	189.96	190.09	189.48	189.605	1314941.0
2023-08-31 12:00:00	IWM	ETF	189.605	189.715	188.675	188.97	1294138.0
2023-08-31 13:00:00	IWM	ETF	188.95	189.5	188.8	189.11	912695.0
2023-08-31 14:00:00	IWM	ETF	189.11	189.236	188.585	188.66	1266710.0
2023-08-31 15:00:00	IWM	ETF	188.66	189.16	188.53	188.56	3423302.0
2023-08-31 16:00:00	IWM	ETF	188.61	188.9	188.53	188.82	1845515.0
2023-08-31 17:00:00	IWM	ETF	188.78	188.78	188.66	188.77	8296.0
2023-08-31 18:00:00	IWM	ETF	188.71	188.81	188.65	188.67	37519.0
2023-08-31 19:00:00	IWM	ETF	188.78	188.88	188.73	188.86	16937.0
2023-08-31 04:00:00	DIA	ETF	350.72	350.79	350.72	350.79	340.0
2023-08-31 06:00:00	DIA	ETF	350.81	350.85	350.7	350.8	2000.0

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

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