PREVIEW / etf_1hour / 2023-02-08

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-08.parquet
  size:    471 KB
  rows:    17,062

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-08 04:00:00	SPY	ETF	414.35	414.76	413.95	414.3	15873.0
2023-02-08 05:00:00	SPY	ETF	414.32	414.32	413.84	414.26	26733.0
2023-02-08 06:00:00	SPY	ETF	414.33	414.38	413.56	413.81	35311.0
2023-02-08 07:00:00	SPY	ETF	413.89	414.43	413.24	413.57	147523.0
2023-02-08 08:00:00	SPY	ETF	414.09	415.7	413.13	413.38	485903.0
2023-02-08 09:00:00	SPY	ETF	413.35	414.42	412.77	414.09	5939442.0
2023-02-08 10:00:00	SPY	ETF	414.07	414.53	412.01	412.45	7983467.0
2023-02-08 11:00:00	SPY	ETF	412.44	412.53	410.15	411.44	9063761.0
2023-02-08 12:00:00	SPY	ETF	411.44	411.995	410.555	411.89	5262836.0
2023-02-08 13:00:00	SPY	ETF	411.89	412.61	410.94	411.41	5530830.0
2023-02-08 14:00:00	SPY	ETF	411.41	412.15	410.49	411.3539	5394449.0
2023-02-08 15:00:00	SPY	ETF	411.36	411.435	409.93	410.66	14320928.0
2023-02-08 16:00:00	SPY	ETF	410.67	411.07	410.4	411.0	2888881.0
2023-02-08 17:00:00	SPY	ETF	410.97	411.05	410.85	410.9	77965.0
2023-02-08 18:00:00	SPY	ETF	410.9	411.27	410.57	411.16	173731.0
2023-02-08 19:00:00	SPY	ETF	411.2	411.43	411.18	411.4087	64803.0
2023-02-08 04:00:00	QQQ	ETF	309.53	309.89	309.09	309.46	31875.0
2023-02-08 05:00:00	QQQ	ETF	309.51	309.59	308.87	309.57	72121.0
2023-02-08 06:00:00	QQQ	ETF	309.57	309.68	309.15	309.4	63718.0
2023-02-08 07:00:00	QQQ	ETF	309.44	310.18	308.84	309.2	326847.0
2023-02-08 08:00:00	QQQ	ETF	309.28	310.79	308.48	308.71	369930.0
2023-02-08 09:00:00	QQQ	ETF	308.7	309.88	307.31	308.19	5407792.0
2023-02-08 10:00:00	QQQ	ETF	308.19	309.0	305.76	306.04	7036431.0
2023-02-08 11:00:00	QQQ	ETF	306.015	306.225	303.79	305.33	6149670.0
2023-02-08 12:00:00	QQQ	ETF	305.34	305.84	304.42	305.59	3483801.0
2023-02-08 13:00:00	QQQ	ETF	305.6	306.34	304.3	305.02	3728369.0
2023-02-08 14:00:00	QQQ	ETF	305.03	305.83	304.24	304.98	3574772.0
2023-02-08 15:00:00	QQQ	ETF	304.99	305.06	303.67	304.38	6352953.0
2023-02-08 16:00:00	QQQ	ETF	304.38	304.76	304.1	304.73	1960757.0
2023-02-08 17:00:00	QQQ	ETF	304.77	304.77	304.46	304.5	25384.0
2023-02-08 18:00:00	QQQ	ETF	304.54	304.98	304.38	304.85	55305.0
2023-02-08 19:00:00	QQQ	ETF	304.84	305.17	304.84	305.12	71719.0
2023-02-08 04:00:00	IWM	ETF	194.93	195.0	194.66	194.75	30817.0
2023-02-08 05:00:00	IWM	ETF	194.84	194.84	194.63	194.78	5664.0
2023-02-08 06:00:00	IWM	ETF	194.56	194.56	194.35	194.35	570.0
2023-02-08 07:00:00	IWM	ETF	194.47	194.651	194.2	194.26	68348.0
2023-02-08 08:00:00	IWM	ETF	194.51	195.05	194.0	194.24	60493.0
2023-02-08 09:00:00	IWM	ETF	194.23	195.58	193.79	195.09	1955774.0
2023-02-08 10:00:00	IWM	ETF	195.07	195.37	193.39	193.77	1569634.0
2023-02-08 11:00:00	IWM	ETF	193.76	193.82	192.55	193.28	1746832.0
2023-02-08 12:00:00	IWM	ETF	193.28	193.58	192.84	193.56	1268866.0
2023-02-08 13:00:00	IWM	ETF	193.56	193.96	192.91	193.02	825501.0
2023-02-08 14:00:00	IWM	ETF	193.02	193.37	192.5	192.97	1698223.0
2023-02-08 15:00:00	IWM	ETF	192.97	193.19	192.2	192.68	2683614.0
2023-02-08 16:00:00	IWM	ETF	192.72	192.88	192.48	192.83	815738.0
2023-02-08 17:00:00	IWM	ETF	192.95	192.95	192.72	192.82	12861.0
2023-02-08 18:00:00	IWM	ETF	192.79	192.91	192.65	192.9	29671.0
2023-02-08 19:00:00	IWM	ETF	192.87	193.06	192.87	193.04	14595.0
2023-02-08 04:00:00	DIA	ETF	341.0	341.03	340.98	341.03	2600.0
2023-02-08 05:00:00	DIA	ETF	341.02	341.03	340.98	340.98	1000.0

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

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