PREVIEW / etf_1hour / 2022-05-31

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-31.parquet
  size:    461 KB
  rows:    16,767

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-05-31 04:00:00	SPY	ETF	413.9	417.05	413.71	415.42	147070.0
2022-05-31 05:00:00	SPY	ETF	415.26	415.26	411.98	412.72	121319.0
2022-05-31 06:00:00	SPY	ETF	412.62	414.12	412.01	413.43	182668.0
2022-05-31 07:00:00	SPY	ETF	413.38	414.59	413.0	413.49	478253.0
2022-05-31 08:00:00	SPY	ETF	413.7	416.69	411.99	412.11	884915.0
2022-05-31 09:00:00	SPY	ETF	412.15	414.09	410.22	411.2	8578398.0
2022-05-31 10:00:00	SPY	ETF	411.16	413.51	410.03	412.9359	8872522.0
2022-05-31 11:00:00	SPY	ETF	412.92	414.88	411.2505	414.59	6586354.0
2022-05-31 12:00:00	SPY	ETF	414.61	415.77	413.48	415.15	6541898.0
2022-05-31 13:00:00	SPY	ETF	415.15	416.325	413.61	416.22	5709396.0
2022-05-31 14:00:00	SPY	ETF	416.22	416.46	412.24	413.04	8015888.0
2022-05-31 15:00:00	SPY	ETF	413.05	415.26	412.07	412.94	19027270.0
2022-05-31 16:00:00	SPY	ETF	412.94	413.24	412.05	412.97	8051618.0
2022-05-31 17:00:00	SPY	ETF	412.93	413.26	412.85	413.24	207442.0
2022-05-31 18:00:00	SPY	ETF	413.25	414.0	413.06	413.98	156583.0
2022-05-31 19:00:00	SPY	ETF	414.06	414.6	413.72	414.57	45309.0
2022-05-31 04:00:00	QQQ	ETF	309.36	310.88	308.51	310.16	145960.0
2022-05-31 05:00:00	QQQ	ETF	310.05	310.05	307.72	308.23	230355.0
2022-05-31 06:00:00	QQQ	ETF	308.2	309.3	307.68	308.75	163600.0
2022-05-31 07:00:00	QQQ	ETF	308.71	309.78	308.71	309.1	322754.0
2022-05-31 08:00:00	QQQ	ETF	309.04	311.22	307.13	307.42	1024949.0
2022-05-31 09:00:00	QQQ	ETF	307.41	309.35	305.28	306.08	7632020.0
2022-05-31 10:00:00	QQQ	ETF	306.05	308.39	304.33	307.77	8098899.0
2022-05-31 11:00:00	QQQ	ETF	307.77	310.22	306.42	309.89	4750407.0
2022-05-31 12:00:00	QQQ	ETF	309.91	311.01	308.73	310.47	4489996.0
2022-05-31 13:00:00	QQQ	ETF	310.4382	311.2	308.66	311.1	3353007.0
2022-05-31 14:00:00	QQQ	ETF	311.06	311.33	307.28	308.0182	6516262.0
2022-05-31 15:00:00	QQQ	ETF	308.02	310.72	307.3815	308.31	9023251.0
2022-05-31 16:00:00	QQQ	ETF	308.31	308.86	308.02	308.54	1865237.0
2022-05-31 17:00:00	QQQ	ETF	308.6	308.6	308.28	308.54	828332.0
2022-05-31 18:00:00	QQQ	ETF	308.58	309.52	308.58	309.5199	212080.0
2022-05-31 19:00:00	QQQ	ETF	309.55	309.86	309.28	309.7	102730.0
2022-05-31 04:00:00	IWM	ETF	186.9	187.81	186.9	187.39	44125.0
2022-05-31 05:00:00	IWM	ETF	187.15	187.15	185.9	186.34	57649.0
2022-05-31 06:00:00	IWM	ETF	186.34	186.81	185.98	186.45	92674.0
2022-05-31 07:00:00	IWM	ETF	186.47	186.95	186.23	186.47	120083.0
2022-05-31 08:00:00	IWM	ETF	186.68	187.68	185.97	186.07	219965.0
2022-05-31 09:00:00	IWM	ETF	186.09	187.32	185.0	185.28	3573638.0
2022-05-31 10:00:00	IWM	ETF	185.27	186.32	184.43	185.89	3683655.0
2022-05-31 11:00:00	IWM	ETF	185.85	186.28	184.61	186.18	2033718.0
2022-05-31 12:00:00	IWM	ETF	186.18	186.84	185.64	186.47	1748095.0
2022-05-31 13:00:00	IWM	ETF	186.46	186.75	185.51	186.68	1526806.0
2022-05-31 14:00:00	IWM	ETF	186.66	186.75	184.22	184.65	2095628.0
2022-05-31 15:00:00	IWM	ETF	184.65	185.99	184.09	185.24	4797612.0
2022-05-31 16:00:00	IWM	ETF	185.31	185.52	185.08	185.41	2189058.0
2022-05-31 17:00:00	IWM	ETF	185.49	185.5	185.31	185.33	255109.0
2022-05-31 18:00:00	IWM	ETF	185.45	185.75	185.33	185.68	57382.0
2022-05-31 19:00:00	IWM	ETF	185.78	186.16	185.55	186.16	39804.0
2022-05-31 04:00:00	DIA	ETF	330.96	332.5	330.96	332.43	3017.0
2022-05-31 05:00:00	DIA	ETF	331.8	331.8	329.42	329.98	8200.0

> showing 50 of 16,767 rows — these rows as CSV

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