PREVIEW / etf_1hour / 2023-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-07.parquet
  size:    481 KB
  rows:    17,545

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-07 04:00:00	SPY	ETF	410.0	411.04	409.96	410.84	104286.0
2023-02-07 05:00:00	SPY	ETF	410.77	411.02	410.2	410.23	81025.0
2023-02-07 06:00:00	SPY	ETF	410.2	410.55	409.96	410.25	127977.0
2023-02-07 07:00:00	SPY	ETF	410.26	410.74	410.18	410.51	170323.0
2023-02-07 08:00:00	SPY	ETF	410.29	411.07	409.26	409.47	708262.0
2023-02-07 09:00:00	SPY	ETF	409.49	409.58	408.5319	409.01	4228985.0
2023-02-07 10:00:00	SPY	ETF	408.99	409.41	408.36	408.75	4960855.0
2023-02-07 11:00:00	SPY	ETF	408.7799	410.7	408.7516	410.235	5392398.0
2023-02-07 12:00:00	SPY	ETF	410.23	415.16	408.56	414.33	9198846.0
2023-02-07 13:00:00	SPY	ETF	414.33	414.95	407.57	408.905	15597981.0
2023-02-07 14:00:00	SPY	ETF	408.9199	413.73	408.8724	413.56	11289093.0
2023-02-07 15:00:00	SPY	ETF	413.58	416.49	412.68	415.18	15267384.0
2023-02-07 16:00:00	SPY	ETF	415.18	415.1908	414.13	414.33	4038644.0
2023-02-07 17:00:00	SPY	ETF	414.37	414.6	414.29	414.44	108711.0
2023-02-07 18:00:00	SPY	ETF	414.45	414.93	414.39	414.5	179561.0
2023-02-07 19:00:00	SPY	ETF	414.54	414.77	414.31	414.76	38815.0
2023-02-07 04:00:00	QQQ	ETF	303.73	305.09	303.72	304.76	74207.0
2023-02-07 05:00:00	QQQ	ETF	304.79	305.01	304.06	304.06	65651.0
2023-02-07 06:00:00	QQQ	ETF	304.03	304.41	303.92	304.32	59241.0
2023-02-07 07:00:00	QQQ	ETF	304.37	304.89	304.37	304.79	142150.0
2023-02-07 08:00:00	QQQ	ETF	304.38	304.9004	303.45	303.81	399648.0
2023-02-07 09:00:00	QQQ	ETF	303.8	304.67	303.09	303.28	5098452.0
2023-02-07 10:00:00	QQQ	ETF	303.27	304.23	302.77	303.69	4889309.0
2023-02-07 11:00:00	QQQ	ETF	303.69	305.61	303.69	305.055	3428385.0
2023-02-07 12:00:00	QQQ	ETF	305.06	310.05	304.22	309.15	8036774.0
2023-02-07 13:00:00	QQQ	ETF	309.17	309.68	302.32	303.65	11987319.0
2023-02-07 14:00:00	QQQ	ETF	303.66	308.42	303.592	308.1467	7341434.0
2023-02-07 15:00:00	QQQ	ETF	308.1	311.03	307.18	309.94	9014473.0
2023-02-07 16:00:00	QQQ	ETF	309.93	309.94	308.69	309.17	1321131.0
2023-02-07 17:00:00	QQQ	ETF	309.14	309.88	309.04	309.44	66454.0
2023-02-07 18:00:00	QQQ	ETF	309.44	310.0	309.33	309.39	102285.0
2023-02-07 19:00:00	QQQ	ETF	309.4	309.7	309.15	309.7	101826.0
2023-02-07 04:00:00	IWM	ETF	194.23	194.55	194.2	194.43	33668.0
2023-02-07 05:00:00	IWM	ETF	194.46	194.54	194.23	194.24	7279.0
2023-02-07 06:00:00	IWM	ETF	194.27	194.28	193.94	194.08	49942.0
2023-02-07 07:00:00	IWM	ETF	194.08	194.3	194.001	194.15	15475.0
2023-02-07 08:00:00	IWM	ETF	194.05	194.3096	193.6	193.73	75434.0
2023-02-07 09:00:00	IWM	ETF	193.7	193.7	192.53	193.16	2284842.0
2023-02-07 10:00:00	IWM	ETF	193.15	193.255	191.99	192.46	1978625.0
2023-02-07 11:00:00	IWM	ETF	192.46	193.26	192.44	192.98	1415271.0
2023-02-07 12:00:00	IWM	ETF	192.97	195.49	192.8	195.21	2587893.0
2023-02-07 13:00:00	IWM	ETF	195.21	195.54	191.65	192.44	4325266.0
2023-02-07 14:00:00	IWM	ETF	192.42	194.81	192.385	194.605	2500413.0
2023-02-07 15:00:00	IWM	ETF	194.61	196.1	194.085	195.57	2964523.0
2023-02-07 16:00:00	IWM	ETF	195.58	195.58	195.01	195.1	1502980.0
2023-02-07 17:00:00	IWM	ETF	194.97	195.25	194.97	195.1	2148.0
2023-02-07 18:00:00	IWM	ETF	195.1	195.35	195.09	195.13	20163.0
2023-02-07 19:00:00	IWM	ETF	195.21	195.33	195.07	195.2	34085.0
2023-02-07 04:00:00	DIA	ETF	338.66	338.99	338.66	338.99	544.0
2023-02-07 05:00:00	DIA	ETF	339.11	339.11	338.8	338.8	650.0

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

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