PREVIEW / etf_1hour / 2023-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-26.parquet
  size:    469 KB
  rows:    17,131

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-04-26 04:00:00	SPY	ETF	407.35	407.96	406.8	407.85	69124.0
2023-04-26 05:00:00	SPY	ETF	407.9	408.02	407.09	407.39	64572.0
2023-04-26 06:00:00	SPY	ETF	407.42	407.7	406.53	406.7	81654.0
2023-04-26 07:00:00	SPY	ETF	406.75	407.3	405.81	406.48	477717.0
2023-04-26 08:00:00	SPY	ETF	406.4294	408.38	405.88	407.36	844894.0
2023-04-26 09:00:00	SPY	ETF	407.35	407.54	406.32	406.8987	5684982.0
2023-04-26 10:00:00	SPY	ETF	406.89	406.97	405.02	406.24	9793836.0
2023-04-26 11:00:00	SPY	ETF	406.25	407.55	406.2372	407.335	7341745.0
2023-04-26 12:00:00	SPY	ETF	407.33	407.84	406.49	406.68	5420126.0
2023-04-26 13:00:00	SPY	ETF	406.68	406.98	404.99	405.28	6802428.0
2023-04-26 14:00:00	SPY	ETF	405.28	405.3485	404.09	404.36	7639520.0
2023-04-26 15:00:00	SPY	ETF	404.37	404.96	403.78	404.37	14614997.0
2023-04-26 16:00:00	SPY	ETF	404.36	405.7462	404.29	405.36	3798143.0
2023-04-26 17:00:00	SPY	ETF	405.35	405.64	404.36	405.6	158905.0
2023-04-26 18:00:00	SPY	ETF	405.6	405.6	404.36	405.34	565824.0
2023-04-26 19:00:00	SPY	ETF	405.34	405.42	405.19	405.42	21829.0
2023-04-26 04:00:00	QQQ	ETF	313.8	314.1	313.23	314.0	155483.0
2023-04-26 05:00:00	QQQ	ETF	313.97	314.08	313.61	313.96	172150.0
2023-04-26 06:00:00	QQQ	ETF	313.95	314.01	312.79	312.89	173663.0
2023-04-26 07:00:00	QQQ	ETF	312.96	313.11	311.9	312.06	799236.0
2023-04-26 08:00:00	QQQ	ETF	312.1592	314.38	310.222	313.4	933733.0
2023-04-26 09:00:00	QQQ	ETF	313.42	313.78	312.22	313.69	6656913.0
2023-04-26 10:00:00	QQQ	ETF	313.69	313.85	312.14	313.25	7086848.0
2023-04-26 11:00:00	QQQ	ETF	313.25	314.55	313.18	314.3299	5185522.0
2023-04-26 12:00:00	QQQ	ETF	314.355	314.935	313.36	313.555	3455574.0
2023-04-26 13:00:00	QQQ	ETF	313.56	313.86	312.37	312.7476	3153780.0
2023-04-26 14:00:00	QQQ	ETF	312.75	312.829	311.7	311.9152	4210903.0
2023-04-26 15:00:00	QQQ	ETF	311.92	312.38	311.34	311.79	7405984.0
2023-04-26 16:00:00	QQQ	ETF	311.87	313.93	311.75	313.69	2726957.0
2023-04-26 17:00:00	QQQ	ETF	313.68	313.95	311.87	313.8	120275.0
2023-04-26 18:00:00	QQQ	ETF	313.76	313.88	313.43	313.59	119312.0
2023-04-26 19:00:00	QQQ	ETF	313.46	313.61	313.35	313.61	104108.0
2023-04-26 04:00:00	IWM	ETF	172.28	172.65	171.7	172.6	36184.0
2023-04-26 05:00:00	IWM	ETF	172.53	172.73	172.12	172.29	25460.0
2023-04-26 06:00:00	IWM	ETF	172.3	172.49	171.95	171.95	17472.0
2023-04-26 07:00:00	IWM	ETF	172.0	172.77	171.5	172.34	192854.0
2023-04-26 08:00:00	IWM	ETF	171.95	172.76	171.62	172.76	119621.0
2023-04-26 09:00:00	IWM	ETF	172.78	173.4	172.0	172.47	3644204.0
2023-04-26 10:00:00	IWM	ETF	172.485	173.065	171.67	172.61	4572274.0
2023-04-26 11:00:00	IWM	ETF	172.62	173.1967	172.58	172.95	1769711.0
2023-04-26 12:00:00	IWM	ETF	172.955	173.28	172.54	172.745	1912129.0
2023-04-26 13:00:00	IWM	ETF	172.745	172.995	171.97	171.995	2204388.0
2023-04-26 14:00:00	IWM	ETF	172.005	172.17	171.125	171.47	2621251.0
2023-04-26 15:00:00	IWM	ETF	171.47	171.73	171.0	171.44	5500079.0
2023-04-26 16:00:00	IWM	ETF	171.44	171.66	171.19	171.42	1066335.0
2023-04-26 17:00:00	IWM	ETF	171.47	171.64	171.39	171.57	95663.0
2023-04-26 18:00:00	IWM	ETF	171.54	171.54	171.03	171.3	35554.0
2023-04-26 19:00:00	IWM	ETF	171.29	171.36	171.2	171.3001	24492.0
2023-04-26 04:00:00	DIA	ETF	335.14	335.75	335.0	335.74	7103.0
2023-04-26 05:00:00	DIA	ETF	335.53	335.68	335.0	335.01	3068.0

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

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