PREVIEW / etf_1hour / 2023-04-11

all etf 1-hour files

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

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-11 04:00:00	SPY	ETF	409.9	410.36	409.9	410.34	24940.0
2023-04-11 05:00:00	SPY	ETF	410.36	410.84	410.34	410.8	15068.0
2023-04-11 06:00:00	SPY	ETF	410.85	410.85	410.25	410.43	24647.0
2023-04-11 07:00:00	SPY	ETF	410.4	410.48	409.36	409.54	182271.0
2023-04-11 08:00:00	SPY	ETF	410.45	410.8296	409.36	409.73	338466.0
2023-04-11 09:00:00	SPY	ETF	409.73	410.2809	409.41	409.52	4213409.0
2023-04-11 10:00:00	SPY	ETF	409.54	410.03	408.92	409.38	6291398.0
2023-04-11 11:00:00	SPY	ETF	409.4	410.1192	409.35	410.0291	4099111.0
2023-04-11 12:00:00	SPY	ETF	410.03	410.54	409.83	410.41	3937587.0
2023-04-11 13:00:00	SPY	ETF	410.42	410.88	410.14	410.81	3661217.0
2023-04-11 14:00:00	SPY	ETF	410.83	411.12	410.54	410.95	4312329.0
2023-04-11 15:00:00	SPY	ETF	410.95	411.18	409.23	409.71	12553966.0
2023-04-11 16:00:00	SPY	ETF	409.7	410.03	409.6116	409.8	2942134.0
2023-04-11 17:00:00	SPY	ETF	409.86	409.9	409.65	409.75	49332.0
2023-04-11 18:00:00	SPY	ETF	409.74	409.941	409.74	409.85	68284.0
2023-04-11 19:00:00	SPY	ETF	409.85	410.05	409.81	409.94	36735.0
2023-04-11 04:00:00	QQQ	ETF	317.99	318.6	317.99	318.6	40289.0
2023-04-11 05:00:00	QQQ	ETF	318.58	319.02	318.58	319.02	36609.0
2023-04-11 06:00:00	QQQ	ETF	319.0	319.02	318.23	318.33	28497.0
2023-04-11 07:00:00	QQQ	ETF	318.32	318.45	317.07	317.28	218589.0
2023-04-11 08:00:00	QQQ	ETF	318.36	319.0004	317.1	317.29	328770.0
2023-04-11 09:00:00	QQQ	ETF	317.28	317.93	316.26	316.5999	4364528.0
2023-04-11 10:00:00	QQQ	ETF	316.6	316.919	315.42	315.58	5209725.0
2023-04-11 11:00:00	QQQ	ETF	315.575	316.3299	315.31	315.86	3754350.0
2023-04-11 12:00:00	QQQ	ETF	315.85	316.55	315.56	316.3613	3036270.0
2023-04-11 13:00:00	QQQ	ETF	316.37	317.0	315.9	316.94	2995635.0
2023-04-11 14:00:00	QQQ	ETF	316.95	317.21	316.5	317.05	2641109.0
2023-04-11 15:00:00	QQQ	ETF	317.055	317.21	315.47	315.83	7440986.0
2023-04-11 16:00:00	QQQ	ETF	315.82	316.08	315.79	315.95	1456957.0
2023-04-11 17:00:00	QQQ	ETF	315.97	316.09	315.7	315.8	70268.0
2023-04-11 18:00:00	QQQ	ETF	315.8	316.07	315.8	316.03	53311.0
2023-04-11 19:00:00	QQQ	ETF	316.03	316.29	316.02	316.13	50338.0
2023-04-11 04:00:00	IWM	ETF	176.0	176.08	175.83	176.04	13034.0
2023-04-11 05:00:00	IWM	ETF	176.26	176.43	176.1	176.33	5437.0
2023-04-11 06:00:00	IWM	ETF	176.36	176.47	176.25	176.29	11490.0
2023-04-11 07:00:00	IWM	ETF	176.37	176.45	175.9	176.03	46765.0
2023-04-11 08:00:00	IWM	ETF	176.26	176.58	175.9496	176.27	143672.0
2023-04-11 09:00:00	IWM	ETF	176.27	177.35	176.16	176.93	2900329.0
2023-04-11 10:00:00	IWM	ETF	176.94	177.39	176.12	176.67	2394073.0
2023-04-11 11:00:00	IWM	ETF	176.69	177.155	176.51	177.09	1973494.0
2023-04-11 12:00:00	IWM	ETF	177.1	177.645	177.06	177.495	2066294.0
2023-04-11 13:00:00	IWM	ETF	177.5	177.71	177.17	177.65	1417581.0
2023-04-11 14:00:00	IWM	ETF	177.66	177.97	177.55	177.815	1497120.0
2023-04-11 15:00:00	IWM	ETF	177.81	177.94	176.98	177.14	5180276.0
2023-04-11 16:00:00	IWM	ETF	177.139	177.29	177.1	177.16	721181.0
2023-04-11 17:00:00	IWM	ETF	177.15	177.25	177.01	177.13	12659.0
2023-04-11 18:00:00	IWM	ETF	177.14	177.37	177.13	177.26	13536.0
2023-04-11 19:00:00	IWM	ETF	177.23	177.29	177.18	177.18	20127.0
2023-04-11 04:00:00	DIA	ETF	335.93	336.04	335.93	335.99	720.0
2023-04-11 05:00:00	DIA	ETF	336.3	336.53	336.26	336.53	4295.0

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

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