PREVIEW / etf_1hour / 2022-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-25.parquet
  size:    467 KB
  rows:    16,964

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
2022-10-25 04:00:00	SPY	ETF	378.0	379.25	378.0	378.11	68747.0
2022-10-25 05:00:00	SPY	ETF	378.08	378.09	376.96	377.38	50078.0
2022-10-25 06:00:00	SPY	ETF	377.3	377.85	376.92	377.76	33179.0
2022-10-25 07:00:00	SPY	ETF	377.83	378.42	377.49	377.54	243912.0
2022-10-25 08:00:00	SPY	ETF	377.88	379.6	376.97	377.8	722116.0
2022-10-25 09:00:00	SPY	ETF	377.82	382.6	377.8	382.37	8821751.0
2022-10-25 10:00:00	SPY	ETF	382.4	382.99	381.29	382.22	10482102.0
2022-10-25 11:00:00	SPY	ETF	382.23	383.89	382.03	383.49	6366810.0
2022-10-25 12:00:00	SPY	ETF	383.5	384.21	382.95	383.08	5093682.0
2022-10-25 13:00:00	SPY	ETF	383.085	383.58	382.305	382.97	6114010.0
2022-10-25 14:00:00	SPY	ETF	382.97	384.46	382.8865	383.55	5808768.0
2022-10-25 15:00:00	SPY	ETF	383.55	385.25	383.52	384.87	14654975.0
2022-10-25 16:00:00	SPY	ETF	384.87	385.05	382.37	383.19	4715569.0
2022-10-25 17:00:00	SPY	ETF	383.27	384.92	381.75	381.81	441403.0
2022-10-25 18:00:00	SPY	ETF	381.9	382.0	381.15	381.16	326807.0
2022-10-25 19:00:00	SPY	ETF	381.17	381.32	380.63	381.15	165261.0
2022-10-25 04:00:00	QQQ	ETF	278.88	279.2	278.3	278.4	65109.0
2022-10-25 05:00:00	QQQ	ETF	278.34	278.34	277.61	278.0	40342.0
2022-10-25 06:00:00	QQQ	ETF	277.92	278.53	277.64	278.48	65361.0
2022-10-25 07:00:00	QQQ	ETF	278.52	278.89	278.13	278.24	231629.0
2022-10-25 08:00:00	QQQ	ETF	278.22	278.99	277.78	278.5	405842.0
2022-10-25 09:00:00	QQQ	ETF	278.5	283.06	278.5	282.71	7943075.0
2022-10-25 10:00:00	QQQ	ETF	282.73	283.03	281.624	282.17	7738121.0
2022-10-25 11:00:00	QQQ	ETF	282.1632	283.82	282.0	283.5	4505457.0
2022-10-25 12:00:00	QQQ	ETF	283.505	284.03	282.6	282.76	3504106.0
2022-10-25 13:00:00	QQQ	ETF	282.78	283.16	281.84	282.61	3910916.0
2022-10-25 14:00:00	QQQ	ETF	282.63	283.93	282.54	283.23	3692632.0
2022-10-25 15:00:00	QQQ	ETF	283.22	284.6	283.19	284.26	8800988.0
2022-10-25 16:00:00	QQQ	ETF	284.26	284.71	280.03	281.11	4537115.0
2022-10-25 17:00:00	QQQ	ETF	281.14	284.21	279.0	279.23	588257.0
2022-10-25 18:00:00	QQQ	ETF	279.13	279.63	278.3	278.39	1385399.0
2022-10-25 19:00:00	QQQ	ETF	278.41	278.5	277.88	278.28	293383.0
2022-10-25 04:00:00	IWM	ETF	173.64	173.86	173.2	173.24	11955.0
2022-10-25 05:00:00	IWM	ETF	173.17	173.18	172.67	172.77	12379.0
2022-10-25 06:00:00	IWM	ETF	172.83	173.01	172.61	173.0	33672.0
2022-10-25 07:00:00	IWM	ETF	172.98	173.33	172.8	172.97	56965.0
2022-10-25 08:00:00	IWM	ETF	172.97	174.34	172.65	173.13	63536.0
2022-10-25 09:00:00	IWM	ETF	173.09	176.82	173.09	176.56	3828381.0
2022-10-25 10:00:00	IWM	ETF	176.56	177.79	176.4125	177.36	5321725.0
2022-10-25 11:00:00	IWM	ETF	177.37	178.54	177.32	178.33	2706287.0
2022-10-25 12:00:00	IWM	ETF	178.33	178.895	177.655	177.71	1920061.0
2022-10-25 13:00:00	IWM	ETF	177.705	178.12	177.34	177.73	1804783.0
2022-10-25 14:00:00	IWM	ETF	177.73	178.2099	177.63	177.64	1579485.0
2022-10-25 15:00:00	IWM	ETF	177.63	178.61	177.63	178.14	3746618.0
2022-10-25 16:00:00	IWM	ETF	178.17	178.6	177.91	178.25	1856024.0
2022-10-25 17:00:00	IWM	ETF	178.21	178.21	177.4	177.7	254310.0
2022-10-25 18:00:00	IWM	ETF	177.74	178.17	177.7	177.71	122610.0
2022-10-25 19:00:00	IWM	ETF	177.72	177.96	177.48	177.83	155666.0
2022-10-25 04:00:00	DIA	ETF	314.92	314.98	314.41	314.44	1410.0
2022-10-25 05:00:00	DIA	ETF	314.37	314.37	313.55	313.81	2135.0

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

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