PREVIEW / etf_1hour / 2024-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-06-17.parquet
  size:    550 KB
  rows:    20,660

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
2024-06-17 04:00:00	SPY	ETF	542.55	543.4	542.33	542.42	14695.0
2024-06-17 05:00:00	SPY	ETF	542.43	542.63	542.38	542.57	16074.0
2024-06-17 06:00:00	SPY	ETF	542.41	542.41	541.94	542.18	24548.0
2024-06-17 07:00:00	SPY	ETF	542.41	542.82	542.34	542.71	49288.0
2024-06-17 08:00:00	SPY	ETF	542.47	543.38	542.03	542.34	153835.0
2024-06-17 09:00:00	SPY	ETF	542.3	542.4799	541.6072	542.1	2688002.0
2024-06-17 10:00:00	SPY	ETF	542.1	542.99	541.89	542.93	3379390.0
2024-06-17 11:00:00	SPY	ETF	542.9405	544.03	542.9405	543.7	2649600.0
2024-06-17 12:00:00	SPY	ETF	543.69	545.91	543.66	545.4099	3490561.0
2024-06-17 13:00:00	SPY	ETF	545.4	547.53	545.4	547.41	4150304.0
2024-06-17 14:00:00	SPY	ETF	547.4	548.53	547.31	547.7657	4812689.0
2024-06-17 15:00:00	SPY	ETF	547.76	548.39	546.74	547.05	9381320.0
2024-06-17 16:00:00	SPY	ETF	547.03	547.1	546.59	547.03	4223343.0
2024-06-17 17:00:00	SPY	ETF	546.94	547.07	546.94	547.07	78786.0
2024-06-17 18:00:00	SPY	ETF	547.03	547.64	546.99	547.36	94075.0
2024-06-17 19:00:00	SPY	ETF	547.48	547.6	547.21	547.54	17248.0
2024-06-17 04:00:00	QQQ	ETF	479.6	480.74	479.52	479.84	79875.0
2024-06-17 05:00:00	QQQ	ETF	479.82	480.04	479.59	479.94	10917.0
2024-06-17 06:00:00	QQQ	ETF	480.05	480.07	479.41	479.63	42124.0
2024-06-17 07:00:00	QQQ	ETF	479.68	480.16	479.66	479.98	106498.0
2024-06-17 08:00:00	QQQ	ETF	479.69	480.22	479.05	479.42	282827.0
2024-06-17 09:00:00	QQQ	ETF	479.43	479.82	478.14	479.38	2742213.0
2024-06-17 10:00:00	QQQ	ETF	479.38	480.09	478.79	479.93	2721909.0
2024-06-17 11:00:00	QQQ	ETF	479.95	481.05	479.95	480.82	2130008.0
2024-06-17 12:00:00	QQQ	ETF	480.82	483.22	480.6621	482.695	3171940.0
2024-06-17 13:00:00	QQQ	ETF	482.7008	486.04	482.7008	485.9451	3392887.0
2024-06-17 14:00:00	QQQ	ETF	485.95	486.86	485.565	486.035	3974816.0
2024-06-17 15:00:00	QQQ	ETF	486.035	486.65	484.82	485.05	6034752.0
2024-06-17 16:00:00	QQQ	ETF	485.06	485.08	484.29	484.79	1805990.0
2024-06-17 17:00:00	QQQ	ETF	484.81	485.0	484.761	484.95	75773.0
2024-06-17 18:00:00	QQQ	ETF	484.94	485.5	484.83	485.25	72111.0
2024-06-17 19:00:00	QQQ	ETF	485.24	485.34	485.0	485.24	37285.0
2024-06-17 04:00:00	IWM	ETF	198.93	199.12	198.34	198.35	16920.0
2024-06-17 05:00:00	IWM	ETF	198.35	198.53	198.28	198.49	6766.0
2024-06-17 06:00:00	IWM	ETF	198.39	198.39	197.7	198.08	20773.0
2024-06-17 07:00:00	IWM	ETF	198.15	198.51	198.1	198.23	45877.0
2024-06-17 08:00:00	IWM	ETF	198.5	199.27	197.7	197.86	104952.0
2024-06-17 09:00:00	IWM	ETF	197.87	198.695	197.78	198.36	2000047.0
2024-06-17 10:00:00	IWM	ETF	198.38	198.39	197.4088	197.635	2212933.0
2024-06-17 11:00:00	IWM	ETF	197.64	198.135	197.64	197.91	1607430.0
2024-06-17 12:00:00	IWM	ETF	197.89	199.25	197.89	199.14	1911852.0
2024-06-17 13:00:00	IWM	ETF	199.14	200.18	199.14	200.08	1993237.0
2024-06-17 14:00:00	IWM	ETF	200.09	200.95	200.09	200.3	2624686.0
2024-06-17 15:00:00	IWM	ETF	200.3	200.61	200.05	200.45	4662081.0
2024-06-17 16:00:00	IWM	ETF	200.4	200.45	197.5	200.33	1504279.0
2024-06-17 17:00:00	IWM	ETF	200.37	200.48	200.29	200.43	4717.0
2024-06-17 18:00:00	IWM	ETF	200.45	200.78	200.4	200.61	27240.0
2024-06-17 19:00:00	IWM	ETF	200.61	200.72	200.41	200.63	16822.0
2024-06-17 04:00:00	DIA	ETF	385.96	385.96	385.79	385.82	500.0
2024-06-17 05:00:00	DIA	ETF	385.98	385.99	385.91	385.91	900.0

> showing 50 of 20,660 rows — these rows as CSV

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