PREVIEW / etf_1hour / 2023-02-15

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-15.parquet
  size:    472 KB
  rows:    17,173

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-02-15 04:00:00	SPY	ETF	410.64	411.58	410.0	411.35	17048.0
2023-02-15 05:00:00	SPY	ETF	411.3	411.47	410.97	411.41	10021.0
2023-02-15 06:00:00	SPY	ETF	411.44	411.5	410.99	411.22	113839.0
2023-02-15 07:00:00	SPY	ETF	411.28	412.25	411.26	411.5	211394.0
2023-02-15 08:00:00	SPY	ETF	411.31	412.26	409.8	411.04	679734.0
2023-02-15 09:00:00	SPY	ETF	411.01	411.63	409.74	410.3	6070794.0
2023-02-15 10:00:00	SPY	ETF	410.32	411.67	409.47	410.67	6891352.0
2023-02-15 11:00:00	SPY	ETF	410.66	412.76	410.58	412.17	5889952.0
2023-02-15 12:00:00	SPY	ETF	412.16	412.3099	410.8136	411.52	4522310.0
2023-02-15 13:00:00	SPY	ETF	411.52	412.99	411.18	412.98	4112373.0
2023-02-15 14:00:00	SPY	ETF	412.98	413.53	412.3	412.43	6165325.0
2023-02-15 15:00:00	SPY	ETF	412.43	414.0	412.43	413.99	8592536.0
2023-02-15 16:00:00	SPY	ETF	413.99	414.27	412.1489	414.1	3345637.0
2023-02-15 17:00:00	SPY	ETF	414.1	414.13	413.85	413.95	122397.0
2023-02-15 18:00:00	SPY	ETF	413.9	414.1	413.73	414.07	70207.0
2023-02-15 19:00:00	SPY	ETF	414.09	414.5	413.98	414.37	71746.0
2023-02-15 04:00:00	QQQ	ETF	305.35	305.81	305.32	305.42	69315.0
2023-02-15 05:00:00	QQQ	ETF	305.39	305.57	305.07	305.5	46275.0
2023-02-15 06:00:00	QQQ	ETF	305.48	305.57	305.1	305.3	41483.0
2023-02-15 07:00:00	QQQ	ETF	305.41	306.46	305.41	305.88	229289.0
2023-02-15 08:00:00	QQQ	ETF	305.5232	306.98	304.49	305.62	1027960.0
2023-02-15 09:00:00	QQQ	ETF	305.62	306.79	304.61	305.14	5501108.0
2023-02-15 10:00:00	QQQ	ETF	305.14	306.31	304.2	305.13	4794498.0
2023-02-15 11:00:00	QQQ	ETF	305.12	307.7577	305.03	307.17	4354156.0
2023-02-15 12:00:00	QQQ	ETF	307.17	307.32	306.2	306.74	3612512.0
2023-02-15 13:00:00	QQQ	ETF	306.77	308.0	306.36	307.975	2313612.0
2023-02-15 14:00:00	QQQ	ETF	307.98	308.92	307.69	307.85	4678207.0
2023-02-15 15:00:00	QQQ	ETF	307.85	309.27	307.59	309.25	4938504.0
2023-02-15 16:00:00	QQQ	ETF	309.24	309.81	309.01	309.6	1544411.0
2023-02-15 17:00:00	QQQ	ETF	309.49	309.65	309.1	309.39	109256.0
2023-02-15 18:00:00	QQQ	ETF	309.39	309.65	309.21	309.59	86842.0
2023-02-15 19:00:00	QQQ	ETF	309.64	310.1	309.56	309.99	257065.0
2023-02-15 04:00:00	IWM	ETF	191.62	191.81	191.6	191.79	3363.0
2023-02-15 05:00:00	IWM	ETF	191.5	191.69	191.5	191.63	6154.0
2023-02-15 06:00:00	IWM	ETF	191.63	191.68	191.4	191.45	102890.0
2023-02-15 07:00:00	IWM	ETF	191.5	191.9	191.34	191.39	39834.0
2023-02-15 08:00:00	IWM	ETF	191.51	191.89	190.62	191.26	151970.0
2023-02-15 09:00:00	IWM	ETF	191.24	191.66	190.53	190.95	2030760.0
2023-02-15 10:00:00	IWM	ETF	190.95	192.65	190.89	192.422	1857333.0
2023-02-15 11:00:00	IWM	ETF	192.4	193.3399	192.36	193.02	1824056.0
2023-02-15 12:00:00	IWM	ETF	193.04	193.1	192.25	192.8701	1066504.0
2023-02-15 13:00:00	IWM	ETF	192.9	193.97	192.74	193.9593	1215927.0
2023-02-15 14:00:00	IWM	ETF	193.96	194.47	193.84	194.07	1439217.0
2023-02-15 15:00:00	IWM	ETF	194.08	194.5537	194.07	194.51	2700650.0
2023-02-15 16:00:00	IWM	ETF	194.46	194.67	194.46	194.54	2509624.0
2023-02-15 17:00:00	IWM	ETF	194.67	194.67	194.35	194.45	32031.0
2023-02-15 18:00:00	IWM	ETF	194.44	194.62	194.32	194.56	44325.0
2023-02-15 19:00:00	IWM	ETF	194.53	195.0	194.46	194.65	46923.0
2023-02-15 04:00:00	DIA	ETF	340.24	340.27	340.24	340.27	600.0
2023-02-15 05:00:00	DIA	ETF	340.16	340.16	340.16	340.16	100.0

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

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