PREVIEW / etf_1hour / 2023-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-02.parquet
  size:    491 KB
  rows:    17,707

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-06-02 04:00:00	SPY	ETF	422.75	423.54	422.75	423.54	26111.0
2023-06-02 05:00:00	SPY	ETF	423.45	424.16	423.4	423.77	38187.0
2023-06-02 06:00:00	SPY	ETF	423.8	424.11	423.69	423.87	119844.0
2023-06-02 07:00:00	SPY	ETF	423.87	424.25	423.73	423.8	189551.0
2023-06-02 08:00:00	SPY	ETF	423.8891	424.63	422.47	423.87	1237742.0
2023-06-02 09:00:00	SPY	ETF	423.87	426.375	423.87	424.37	9406675.0
2023-06-02 10:00:00	SPY	ETF	424.365	426.9	423.95	426.83	11336881.0
2023-06-02 11:00:00	SPY	ETF	426.835	427.69	426.76	427.44	9892081.0
2023-06-02 12:00:00	SPY	ETF	427.45	428.14	426.9301	428.015	5010170.0
2023-06-02 13:00:00	SPY	ETF	428.02	428.385	427.67	428.14	5146807.0
2023-06-02 14:00:00	SPY	ETF	428.145	428.44	427.47	428.332	5777984.0
2023-06-02 15:00:00	SPY	ETF	428.34	428.74	427.71	427.91	17634779.0
2023-06-02 16:00:00	SPY	ETF	427.9	428.02	427.67	427.9	5167717.0
2023-06-02 17:00:00	SPY	ETF	427.85	428.08	427.69	427.93	115814.0
2023-06-02 18:00:00	SPY	ETF	427.93	428.0	427.75	427.88	27407.0
2023-06-02 19:00:00	SPY	ETF	427.95	428.03	427.89	428.03	17331.0
2023-06-02 04:00:00	QQQ	ETF	352.62	353.39	352.62	353.39	60037.0
2023-06-02 05:00:00	QQQ	ETF	353.35	354.22	353.35	353.73	62865.0
2023-06-02 06:00:00	QQQ	ETF	353.73	354.03	353.4	353.45	188430.0
2023-06-02 07:00:00	QQQ	ETF	353.42	354.26	353.42	354.0	226030.0
2023-06-02 08:00:00	QQQ	ETF	353.5983	354.2496	352.26	353.0	975571.0
2023-06-02 09:00:00	QQQ	ETF	353.01	355.83	352.16	352.3	8101788.0
2023-06-02 10:00:00	QQQ	ETF	352.3	354.98	352.01	354.8505	7431793.0
2023-06-02 11:00:00	QQQ	ETF	354.87	355.3	354.21	354.85	4788732.0
2023-06-02 12:00:00	QQQ	ETF	354.855	355.36	354.06	355.0	3640127.0
2023-06-02 13:00:00	QQQ	ETF	355.0099	355.3	354.61	354.83	2571427.0
2023-06-02 14:00:00	QQQ	ETF	354.85	355.11	353.88	354.85	2820096.0
2023-06-02 15:00:00	QQQ	ETF	354.86	355.2	354.3401	354.64	6754657.0
2023-06-02 16:00:00	QQQ	ETF	354.64	354.93	354.6291	354.8699	2561031.0
2023-06-02 17:00:00	QQQ	ETF	354.84	354.96	354.65	354.83	134833.0
2023-06-02 18:00:00	QQQ	ETF	354.81	354.82	354.53	354.82	37223.0
2023-06-02 19:00:00	QQQ	ETF	354.78	354.83	354.69	354.82	21918.0
2023-06-02 04:00:00	IWM	ETF	176.5	176.76	176.5	176.71	17005.0
2023-06-02 05:00:00	IWM	ETF	176.68	177.05	176.58	176.84	16238.0
2023-06-02 06:00:00	IWM	ETF	176.74	177.23	176.74	177.23	35062.0
2023-06-02 07:00:00	IWM	ETF	177.19	177.25	176.87	176.87	52394.0
2023-06-02 08:00:00	IWM	ETF	177.1482	177.97	176.26	177.73	530034.0
2023-06-02 09:00:00	IWM	ETF	177.73	179.1	177.54	177.71	4752957.0
2023-06-02 10:00:00	IWM	ETF	177.72	179.46	177.45	179.45	5184836.0
2023-06-02 11:00:00	IWM	ETF	179.46	180.07	179.425	179.88	4672596.0
2023-06-02 12:00:00	IWM	ETF	179.9	180.6	179.78	180.43	3498594.0
2023-06-02 13:00:00	IWM	ETF	180.44	181.44	180.29	181.2901	4212003.0
2023-06-02 14:00:00	IWM	ETF	181.3	181.37	180.82	181.305	4105640.0
2023-06-02 15:00:00	IWM	ETF	181.31	182.09	181.31	181.97	9389635.0
2023-06-02 16:00:00	IWM	ETF	182.02	182.07	181.83	182.0	1957090.0
2023-06-02 17:00:00	IWM	ETF	182.0	182.02	181.73	181.94	91434.0
2023-06-02 18:00:00	IWM	ETF	182.0	182.05	181.96	182.05	4330.0
2023-06-02 19:00:00	IWM	ETF	182.07	182.19	181.98	182.19	6010.0
2023-06-02 04:00:00	DIA	ETF	332.26	332.26	332.26	332.26	300.0
2023-06-02 05:00:00	DIA	ETF	332.46	332.5	332.46	332.5	600.0

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

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