PREVIEW / etf_1hour / 2023-01-05

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-05.parquet
  size:    455 KB
  rows:    16,746

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-01-05 04:00:00	SPY	ETF	383.0	383.6	382.52	383.6	25811.0
2023-01-05 05:00:00	SPY	ETF	383.64	384.32	383.59	384.08	28624.0
2023-01-05 06:00:00	SPY	ETF	384.12	384.71	384.08	384.29	69679.0
2023-01-05 07:00:00	SPY	ETF	384.28	384.92	383.8	383.88	187353.0
2023-01-05 08:00:00	SPY	ETF	384.24	384.9	381.4	381.71	949064.0
2023-01-05 09:00:00	SPY	ETF	381.66	381.76	378.89	380.12	8280876.0
2023-01-05 10:00:00	SPY	ETF	380.13	381.84	379.28	379.39	9896580.0
2023-01-05 11:00:00	SPY	ETF	379.4	380.34	378.76	379.3	5008760.0
2023-01-05 12:00:00	SPY	ETF	379.29	380.45	379.095	379.42	3979838.0
2023-01-05 13:00:00	SPY	ETF	379.435	381.47	379.04	380.57	7141971.0
2023-01-05 14:00:00	SPY	ETF	380.58	381.71	380.06	380.8009	4871057.0
2023-01-05 15:00:00	SPY	ETF	380.82	380.82	378.915	379.4	12220845.0
2023-01-05 16:00:00	SPY	ETF	379.4	379.84	379.27	379.76	4803247.0
2023-01-05 17:00:00	SPY	ETF	379.74	379.85	379.4	379.77	66671.0
2023-01-05 18:00:00	SPY	ETF	379.85	380.2	379.38	380.0	346704.0
2023-01-05 19:00:00	SPY	ETF	380.0	380.38	380.0	380.34	36936.0
2023-01-05 04:00:00	QQQ	ETF	265.34	265.54	264.67	265.53	69087.0
2023-01-05 05:00:00	QQQ	ETF	265.4	266.29	265.4	266.01	50254.0
2023-01-05 06:00:00	QQQ	ETF	266.05	266.87	266.05	266.56	61980.0
2023-01-05 07:00:00	QQQ	ETF	266.5	267.02	266.04	266.1	186449.0
2023-01-05 08:00:00	QQQ	ETF	266.41	266.97	263.83	264.2	658352.0
2023-01-05 09:00:00	QQQ	ETF	264.19	264.19	261.5001	262.82	5218001.0
2023-01-05 10:00:00	QQQ	ETF	262.81	264.21	261.99	262.16	4970582.0
2023-01-05 11:00:00	QQQ	ETF	262.16	263.18	261.89	262.42	3187813.0
2023-01-05 12:00:00	QQQ	ETF	262.44	263.2	261.96	262.0	2426484.0
2023-01-05 13:00:00	QQQ	ETF	262.005	263.85	261.64	262.88	4213142.0
2023-01-05 14:00:00	QQQ	ETF	262.91	263.83	262.53	263.01	2430030.0
2023-01-05 15:00:00	QQQ	ETF	263.025	263.025	261.26	261.6	7172952.0
2023-01-05 16:00:00	QQQ	ETF	261.62	262.08	261.53	262.01	2743473.0
2023-01-05 17:00:00	QQQ	ETF	262.02	262.04	261.6	262.0	94652.0
2023-01-05 18:00:00	QQQ	ETF	261.99	262.25	261.58	262.1	783950.0
2023-01-05 19:00:00	QQQ	ETF	262.1	262.37	262.1	262.36	68286.0
2023-01-05 04:00:00	IWM	ETF	175.44	175.68	175.11	175.66	31940.0
2023-01-05 05:00:00	IWM	ETF	175.68	176.03	175.68	175.8	6733.0
2023-01-05 06:00:00	IWM	ETF	175.83	176.04	175.75	175.81	23712.0
2023-01-05 07:00:00	IWM	ETF	175.69	176.11	175.56	175.58	23847.0
2023-01-05 08:00:00	IWM	ETF	175.6901	175.75	174.34	174.49	111358.0
2023-01-05 09:00:00	IWM	ETF	174.42	174.76	172.39	173.23	2855098.0
2023-01-05 10:00:00	IWM	ETF	173.22	174.39	172.98	173.6	2395372.0
2023-01-05 11:00:00	IWM	ETF	173.57	173.92	173.05	173.43	1348662.0
2023-01-05 12:00:00	IWM	ETF	173.42	173.95	173.21	173.46	906251.0
2023-01-05 13:00:00	IWM	ETF	173.45	174.56	173.3	174.0762	1271927.0
2023-01-05 14:00:00	IWM	ETF	174.09	174.71	173.79	174.16	840363.0
2023-01-05 15:00:00	IWM	ETF	174.15	174.15	173.43	173.67	2431133.0
2023-01-05 16:00:00	IWM	ETF	173.68	173.75	173.5	173.71	581669.0
2023-01-05 17:00:00	IWM	ETF	173.61	173.75	173.61	173.75	3935.0
2023-01-05 18:00:00	IWM	ETF	173.75	173.98	173.65	173.86	26262.0
2023-01-05 19:00:00	IWM	ETF	173.9	174.05	173.88	173.96	11085.0
2023-01-05 04:00:00	DIA	ETF	332.02	332.28	331.96	332.26	1441.0
2023-01-05 06:00:00	DIA	ETF	332.97	332.97	332.97	332.97	100.0

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

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