PREVIEW / etf_1hour / 2023-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-24.parquet
  size:    470 KB
  rows:    17,147

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-03-24 04:00:00	SPY	ETF	394.84	394.84	391.77	392.82	146206.0
2023-03-24 05:00:00	SPY	ETF	392.63	393.3	390.49	390.49	165969.0
2023-03-24 06:00:00	SPY	ETF	390.47	391.09	389.78	390.51	332441.0
2023-03-24 07:00:00	SPY	ETF	390.59	390.97	389.56	389.89	732345.0
2023-03-24 08:00:00	SPY	ETF	390.44	395.3	389.33	391.2	1217482.0
2023-03-24 09:00:00	SPY	ETF	391.2	391.99	389.4	391.645	10963408.0
2023-03-24 10:00:00	SPY	ETF	391.66	392.94	390.22	391.54	13729496.0
2023-03-24 11:00:00	SPY	ETF	391.52	393.3	389.92	393.13	11805924.0
2023-03-24 12:00:00	SPY	ETF	393.13	394.0	391.7	393.31	8807401.0
2023-03-24 13:00:00	SPY	ETF	393.31	394.38	392.69	393.555	6884504.0
2023-03-24 14:00:00	SPY	ETF	393.56	395.14	393.42	394.65	7454540.0
2023-03-24 15:00:00	SPY	ETF	394.67	395.84	394.05	395.72	16148928.0
2023-03-24 16:00:00	SPY	ETF	395.71	396.55	395.5	396.5	4871617.0
2023-03-24 17:00:00	SPY	ETF	396.49	396.53	395.75	396.44	557132.0
2023-03-24 18:00:00	SPY	ETF	396.4	396.46	396.1	396.3499	44155.0
2023-03-24 19:00:00	SPY	ETF	396.35	396.5	396.29	396.46	21543.0
2023-03-24 04:00:00	QQQ	ETF	311.21	311.23	309.26	310.12	78374.0
2023-03-24 05:00:00	QQQ	ETF	309.92	310.49	308.43	308.52	61345.0
2023-03-24 06:00:00	QQQ	ETF	308.52	309.04	308.1	308.82	122614.0
2023-03-24 07:00:00	QQQ	ETF	308.9	309.029	307.93	308.18	302369.0
2023-03-24 08:00:00	QQQ	ETF	308.8	311.74	307.55	308.87	1098602.0
2023-03-24 09:00:00	QQQ	ETF	308.88	309.73	307.18	309.21	6972353.0
2023-03-24 10:00:00	QQQ	ETF	309.25	309.705	307.65	308.74	8775998.0
2023-03-24 11:00:00	QQQ	ETF	308.75	309.53	306.95	309.35	7376031.0
2023-03-24 12:00:00	QQQ	ETF	309.3555	310.0	307.555	308.71	5202961.0
2023-03-24 13:00:00	QQQ	ETF	308.73	309.765	308.2407	308.9701	4010998.0
2023-03-24 14:00:00	QQQ	ETF	308.98	310.32	308.81	309.8997	3596993.0
2023-03-24 15:00:00	QQQ	ETF	309.92	310.99	309.44	310.95	6970461.0
2023-03-24 16:00:00	QQQ	ETF	310.94	311.63	310.79	311.58	1083337.0
2023-03-24 17:00:00	QQQ	ETF	311.46	311.59	310.89	311.3903	99107.0
2023-03-24 18:00:00	QQQ	ETF	311.35	311.46	311.35	311.41	15869.0
2023-03-24 19:00:00	QQQ	ETF	311.41	311.6	311.33	311.57	21966.0
2023-03-24 04:00:00	IWM	ETF	170.88	170.88	169.43	170.19	32463.0
2023-03-24 05:00:00	IWM	ETF	169.82	170.29	168.6	168.78	45733.0
2023-03-24 06:00:00	IWM	ETF	168.63	168.89	167.99	168.41	89600.0
2023-03-24 07:00:00	IWM	ETF	168.39	168.72	167.9	167.96	244468.0
2023-03-24 08:00:00	IWM	ETF	167.95	171.42	167.69	168.89	447650.0
2023-03-24 09:00:00	IWM	ETF	168.88	168.98	167.455	168.9025	5462137.0
2023-03-24 10:00:00	IWM	ETF	168.9	170.23	168.33	169.03	6147920.0
2023-03-24 11:00:00	IWM	ETF	169.04	170.55	168.3	170.5	4201049.0
2023-03-24 12:00:00	IWM	ETF	170.53	170.98	169.775	170.6	4219234.0
2023-03-24 13:00:00	IWM	ETF	170.605	171.005	170.09	170.6	3071528.0
2023-03-24 14:00:00	IWM	ETF	170.61	171.43	170.5499	171.13	2862757.0
2023-03-24 15:00:00	IWM	ETF	171.11	172.105	170.9	171.8	5381731.0
2023-03-24 16:00:00	IWM	ETF	171.79	172.12	171.67	172.05	3054275.0
2023-03-24 17:00:00	IWM	ETF	172.04	172.11	171.79	171.87	479718.0
2023-03-24 18:00:00	IWM	ETF	171.87	172.0	171.81	171.81	5738.0
2023-03-24 19:00:00	IWM	ETF	171.85	172.08	171.82	171.92	5404.0
2023-03-24 04:00:00	DIA	ETF	320.93	321.09	319.73	319.73	3050.0
2023-03-24 05:00:00	DIA	ETF	320.23	320.42	318.45	318.45	5918.0

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

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