PREVIEW / etf_1hour / 2022-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-28.parquet
  size:    484 KB
  rows:    17,525

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-12-28 04:00:00	SPY	ETF	382.0	382.0	381.15	381.67	39059.0
2022-12-28 05:00:00	SPY	ETF	381.7	382.34	381.52	382.18	24268.0
2022-12-28 06:00:00	SPY	ETF	382.21	382.52	381.94	382.45	27627.0
2022-12-28 07:00:00	SPY	ETF	382.46	382.68	382.25	382.55	230952.0
2022-12-28 08:00:00	SPY	ETF	382.38	382.7	381.3304	381.71	209885.0
2022-12-28 09:00:00	SPY	ETF	381.71	383.39	380.62	382.12	4086827.0
2022-12-28 10:00:00	SPY	ETF	382.09	382.95	379.34	379.45	6426718.0
2022-12-28 11:00:00	SPY	ETF	379.39	379.67	378.1	378.22	6057458.0
2022-12-28 12:00:00	SPY	ETF	378.225	379.53	377.3	379.33	6386462.0
2022-12-28 13:00:00	SPY	ETF	379.31	380.2397	378.485	378.67	4604043.0
2022-12-28 14:00:00	SPY	ETF	378.7	379.39	378.13	378.44	6225197.0
2022-12-28 15:00:00	SPY	ETF	378.44	378.47	376.42	376.68	11844551.0
2022-12-28 16:00:00	SPY	ETF	376.67	381.3534	376.5	377.04	3034845.0
2022-12-28 17:00:00	SPY	ETF	377.0	377.1496	376.66	377.0	658286.0
2022-12-28 18:00:00	SPY	ETF	377.1	377.4	376.95	377.28	41820.0
2022-12-28 19:00:00	SPY	ETF	377.28	377.3499	376.67	377.07	55553.0
2022-12-28 04:00:00	QQQ	ETF	263.82	263.94	262.98	263.4	73614.0
2022-12-28 05:00:00	QQQ	ETF	263.38	264.18	263.23	263.92	74329.0
2022-12-28 06:00:00	QQQ	ETF	263.88	264.27	263.7	264.19	85771.0
2022-12-28 07:00:00	QQQ	ETF	264.07	264.41	263.86	264.22	171786.0
2022-12-28 08:00:00	QQQ	ETF	264.0198	264.41	263.2796	263.54	373174.0
2022-12-28 09:00:00	QQQ	ETF	263.5409	265.47	262.22	264.33	5135951.0
2022-12-28 10:00:00	QQQ	ETF	264.35	265.16	261.36	261.42	6089563.0
2022-12-28 11:00:00	QQQ	ETF	261.39	261.65	260.51	260.58	4592247.0
2022-12-28 12:00:00	QQQ	ETF	260.54	262.25	260.09	262.08	3492642.0
2022-12-28 13:00:00	QQQ	ETF	262.1	262.96	261.04	261.3	4364907.0
2022-12-28 14:00:00	QQQ	ETF	261.35	261.66	260.54	260.79	3078564.0
2022-12-28 15:00:00	QQQ	ETF	260.79	260.84	259.73	260.02	6385287.0
2022-12-28 16:00:00	QQQ	ETF	260.0	260.56	259.88	260.35	1870112.0
2022-12-28 17:00:00	QQQ	ETF	260.36	260.41	260.1	260.39	397541.0
2022-12-28 18:00:00	QQQ	ETF	260.42	260.68	260.38	260.56	89047.0
2022-12-28 19:00:00	QQQ	ETF	260.69	260.71	260.25	260.56	37813.0
2022-12-28 04:00:00	IWM	ETF	173.39	173.45	173.1	173.38	26928.0
2022-12-28 05:00:00	IWM	ETF	173.43	173.69	173.39	173.68	5519.0
2022-12-28 06:00:00	IWM	ETF	173.64	173.93	173.64	173.88	45817.0
2022-12-28 07:00:00	IWM	ETF	173.871	174.05	173.81	173.94	29490.0
2022-12-28 08:00:00	IWM	ETF	173.93	174.06	173.33	173.33	36934.0
2022-12-28 09:00:00	IWM	ETF	173.38	174.1	172.73	173.1373	1315359.0
2022-12-28 10:00:00	IWM	ETF	173.14	173.5	171.48	171.53	1545937.0
2022-12-28 11:00:00	IWM	ETF	171.5	171.76	171.12	171.2	1540194.0
2022-12-28 12:00:00	IWM	ETF	171.2	172.13	170.74	172.02	1169347.0
2022-12-28 13:00:00	IWM	ETF	172.03	172.42	171.21	171.3	739756.0
2022-12-28 14:00:00	IWM	ETF	171.31	171.54	170.97	171.15	1100099.0
2022-12-28 15:00:00	IWM	ETF	171.155	171.155	170.34	170.53	3574665.0
2022-12-28 16:00:00	IWM	ETF	170.53	174.9	170.41	170.72	4539928.0
2022-12-28 17:00:00	IWM	ETF	170.72	170.72	170.53	170.61	162369.0
2022-12-28 18:00:00	IWM	ETF	170.68	170.9	170.58	170.67	21356.0
2022-12-28 19:00:00	IWM	ETF	170.75	170.81	170.42	170.73	41806.0
2022-12-28 04:00:00	DIA	ETF	332.25	332.25	332.25	332.25	100.0
2022-12-28 05:00:00	DIA	ETF	333.14	333.25	333.14	333.25	3400.0

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

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