PREVIEW / etf_1hour / 2022-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-29.parquet
  size:    445 KB
  rows:    16,235

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-07-29 04:00:00	SPY	ETF	408.71	409.2	408.35	408.55	53009.0
2022-07-29 05:00:00	SPY	ETF	408.5	409.14	408.34	409.14	70884.0
2022-07-29 06:00:00	SPY	ETF	409.17	409.37	408.85	409.16	89340.0
2022-07-29 07:00:00	SPY	ETF	409.16	409.26	408.39	408.57	97834.0
2022-07-29 08:00:00	SPY	ETF	409.14	409.5	407.3	407.97	611141.0
2022-07-29 09:00:00	SPY	ETF	408.0	409.47	406.77	409.18	5994670.0
2022-07-29 10:00:00	SPY	ETF	409.21	410.99	408.68	409.4299	7547176.0
2022-07-29 11:00:00	SPY	ETF	409.4	409.79	408.01	409.56	5511252.0
2022-07-29 12:00:00	SPY	ETF	409.57	410.73	408.83	410.48	3654169.0
2022-07-29 13:00:00	SPY	ETF	410.49	411.22	410.01	410.89	3549003.0
2022-07-29 14:00:00	SPY	ETF	410.9	412.02	410.63	411.87	6734799.0
2022-07-29 15:00:00	SPY	ETF	411.88	413.03	411.78	412.06	19906204.0
2022-07-29 16:00:00	SPY	ETF	412.04	412.25	411.75	411.94	5477048.0
2022-07-29 17:00:00	SPY	ETF	411.81	412.0	411.63	411.7	88335.0
2022-07-29 18:00:00	SPY	ETF	411.67	411.67	411.43	411.45	35840.0
2022-07-29 19:00:00	SPY	ETF	411.51	411.52	411.35	411.46	43606.0
2022-07-29 04:00:00	QQQ	ETF	313.81	314.08	312.62	313.06	88589.0
2022-07-29 05:00:00	QQQ	ETF	312.99	313.57	312.75	313.56	51465.0
2022-07-29 06:00:00	QQQ	ETF	313.44	313.65	313.09	313.2	75201.0
2022-07-29 07:00:00	QQQ	ETF	313.21	313.31	312.36	312.81	251810.0
2022-07-29 08:00:00	QQQ	ETF	313.23	314.61	310.042	312.15	861949.0
2022-07-29 09:00:00	QQQ	ETF	312.11	313.36	309.931	312.86	7448994.0
2022-07-29 10:00:00	QQQ	ETF	312.87	314.46	312.38	312.82	7177446.0
2022-07-29 11:00:00	QQQ	ETF	312.7901	312.95	310.96	312.74	5600488.0
2022-07-29 12:00:00	QQQ	ETF	312.75	313.77	312.121	313.64	2818337.0
2022-07-29 13:00:00	QQQ	ETF	313.64	314.65	313.29	314.34	3231144.0
2022-07-29 14:00:00	QQQ	ETF	314.35	315.47	314.1	315.16	4178006.0
2022-07-29 15:00:00	QQQ	ETF	315.16	316.39	315.05	315.45	7790499.0
2022-07-29 16:00:00	QQQ	ETF	315.45	315.62	315.24	315.58	1302259.0
2022-07-29 17:00:00	QQQ	ETF	315.6	315.6	315.25	315.28	86558.0
2022-07-29 18:00:00	QQQ	ETF	315.25	315.35	315.13	315.13	30322.0
2022-07-29 19:00:00	QQQ	ETF	315.15	315.25	315.1	315.16	27476.0
2022-07-29 04:00:00	IWM	ETF	186.58	186.79	186.48	186.56	24988.0
2022-07-29 05:00:00	IWM	ETF	186.6	186.89	186.5	186.75	14944.0
2022-07-29 06:00:00	IWM	ETF	186.71	187.05	186.6	186.94	52987.0
2022-07-29 07:00:00	IWM	ETF	186.94	186.95	186.53	186.63	26568.0
2022-07-29 08:00:00	IWM	ETF	186.6104	186.92	185.88	186.28	126270.0
2022-07-29 09:00:00	IWM	ETF	186.19	186.2	185.04	185.7	2006071.0
2022-07-29 10:00:00	IWM	ETF	185.69	187.205	185.53	186.37	2712818.0
2022-07-29 11:00:00	IWM	ETF	186.38	186.605	185.63	186.025	1786328.0
2022-07-29 12:00:00	IWM	ETF	186.03	186.29	185.68	186.11	968563.0
2022-07-29 13:00:00	IWM	ETF	186.11	186.67	185.95	186.54	1136228.0
2022-07-29 14:00:00	IWM	ETF	186.56	187.33	186.47	187.27	1570834.0
2022-07-29 15:00:00	IWM	ETF	187.285	187.73	187.11	187.21	3837204.0
2022-07-29 16:00:00	IWM	ETF	187.25	187.35	187.09	187.15	2308338.0
2022-07-29 17:00:00	IWM	ETF	187.24	187.24	186.94	187.07	41113.0
2022-07-29 18:00:00	IWM	ETF	186.96	187.07	186.85	186.99	12449.0
2022-07-29 19:00:00	IWM	ETF	186.98	187.13	186.85	186.93	11791.0
2022-07-29 04:00:00	DIA	ETF	326.02	326.02	325.89	326.0	2590.0
2022-07-29 06:00:00	DIA	ETF	326.18	326.46	326.18	326.46	6700.0

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

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