PREVIEW / etf_1hour / 2023-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-19.parquet
  size:    461 KB
  rows:    16,877

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-05-19 04:00:00	SPY	ETF	419.74	420.34	419.57	420.2	53579.0
2023-05-19 05:00:00	SPY	ETF	420.19	420.19	419.86	420.01	12454.0
2023-05-19 06:00:00	SPY	ETF	420.0	420.0	419.58	419.76	64187.0
2023-05-19 07:00:00	SPY	ETF	419.75	420.68	419.75	420.37	163719.0
2023-05-19 08:00:00	SPY	ETF	419.7882	420.87	419.75	420.81	291754.0
2023-05-19 09:00:00	SPY	ETF	420.75	420.79	419.8	420.55	5924944.0
2023-05-19 10:00:00	SPY	ETF	420.56	420.72	419.88	420.33	7031249.0
2023-05-19 11:00:00	SPY	ETF	420.335	420.555	417.35	418.515	17428095.0
2023-05-19 12:00:00	SPY	ETF	418.52	418.94	417.5	418.6788	7285489.0
2023-05-19 13:00:00	SPY	ETF	418.68	419.06	417.9642	418.005	4725243.0
2023-05-19 14:00:00	SPY	ETF	418.01	418.71	417.47	418.67	7008476.0
2023-05-19 15:00:00	SPY	ETF	418.67	418.99	417.99	418.61	11751628.0
2023-05-19 16:00:00	SPY	ETF	418.61	418.73	417.78	417.99	3217051.0
2023-05-19 17:00:00	SPY	ETF	418.06	418.62	417.95	418.12	296140.0
2023-05-19 18:00:00	SPY	ETF	418.12	418.5	418.08	418.5	115136.0
2023-05-19 19:00:00	SPY	ETF	418.49	418.6	418.39	418.6	34095.0
2023-05-19 04:00:00	QQQ	ETF	337.3	338.26	337.3	338.14	30356.0
2023-05-19 05:00:00	QQQ	ETF	338.18	338.18	337.76	337.89	27771.0
2023-05-19 06:00:00	QQQ	ETF	337.89	338.01	337.22	337.22	90282.0
2023-05-19 07:00:00	QQQ	ETF	337.25	337.93	337.25	337.53	265511.0
2023-05-19 08:00:00	QQQ	ETF	337.57	338.07	336.98	337.86	551426.0
2023-05-19 09:00:00	QQQ	ETF	337.87	338.205	336.9703	337.42	5371504.0
2023-05-19 10:00:00	QQQ	ETF	337.43	337.8068	336.56	337.0493	6767150.0
2023-05-19 11:00:00	QQQ	ETF	337.04	337.46	335.59	336.575	9193450.0
2023-05-19 12:00:00	QQQ	ETF	336.58	336.91	335.6	336.32	4852553.0
2023-05-19 13:00:00	QQQ	ETF	336.32	336.91	336.0	336.02	3695327.0
2023-05-19 14:00:00	QQQ	ETF	336.02	336.315	335.43	336.28	4002917.0
2023-05-19 15:00:00	QQQ	ETF	336.27	336.67	335.9	336.46	5876851.0
2023-05-19 16:00:00	QQQ	ETF	336.48	336.52	335.88	336.06	2175644.0
2023-05-19 17:00:00	QQQ	ETF	336.08	336.51	336.08	336.13	1104194.0
2023-05-19 18:00:00	QQQ	ETF	336.18	336.5	336.18	336.5	55234.0
2023-05-19 19:00:00	QQQ	ETF	336.45	336.57	336.4	336.46	28262.0
2023-05-19 04:00:00	IWM	ETF	177.36	177.83	177.35	177.83	4388.0
2023-05-19 05:00:00	IWM	ETF	177.75	177.83	177.6	177.7	2259.0
2023-05-19 06:00:00	IWM	ETF	177.63	177.67	177.41	177.59	21530.0
2023-05-19 07:00:00	IWM	ETF	177.6	178.26	177.6	177.93	105781.0
2023-05-19 08:00:00	IWM	ETF	178.0185	178.24	177.5204	178.17	177970.0
2023-05-19 09:00:00	IWM	ETF	178.11	178.69	177.65	177.92	2627347.0
2023-05-19 10:00:00	IWM	ETF	177.92	177.92	176.87	177.36	2900923.0
2023-05-19 11:00:00	IWM	ETF	177.36	177.57	175.25	175.85	5597125.0
2023-05-19 12:00:00	IWM	ETF	175.86	176.23	175.43	176.04	2465003.0
2023-05-19 13:00:00	IWM	ETF	176.04	176.32	175.64	175.65	1651282.0
2023-05-19 14:00:00	IWM	ETF	175.66	176.01	175.43	176.01	1901991.0
2023-05-19 15:00:00	IWM	ETF	176.0	176.16	175.76	176.06	3484674.0
2023-05-19 16:00:00	IWM	ETF	176.11	176.16	175.64	175.81	1373635.0
2023-05-19 17:00:00	IWM	ETF	175.85	176.11	175.7	175.74	392144.0
2023-05-19 18:00:00	IWM	ETF	175.7302	176.05	175.7302	176.05	8111.0
2023-05-19 19:00:00	IWM	ETF	175.9	176.19	175.9	176.0	6735.0
2023-05-19 04:00:00	DIA	ETF	335.58	335.58	335.58	335.58	900.0
2023-05-19 06:00:00	DIA	ETF	335.58	335.78	335.41	335.78	6940.0

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

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