PREVIEW / etf_1hour / 2022-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-23.parquet
  size:    437 KB
  rows:    15,829

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-08-23 04:00:00	SPY	ETF	414.18	414.88	414.08	414.08	62172.0
2022-08-23 05:00:00	SPY	ETF	414.11	414.49	413.68	414.49	88202.0
2022-08-23 06:00:00	SPY	ETF	414.39	414.39	413.49	413.84	139476.0
2022-08-23 07:00:00	SPY	ETF	413.74	414.2	413.35	414.09	217705.0
2022-08-23 08:00:00	SPY	ETF	413.81	414.72	411.75	413.12	396727.0
2022-08-23 09:00:00	SPY	ETF	413.02	414.51	412.35	413.88	5433145.0
2022-08-23 10:00:00	SPY	ETF	413.88	415.42	412.77	412.8999	7139241.0
2022-08-23 11:00:00	SPY	ETF	412.91	413.55	412.03	412.95	5015571.0
2022-08-23 12:00:00	SPY	ETF	412.96	413.21	411.77	413.0909	4335146.0
2022-08-23 13:00:00	SPY	ETF	413.092	413.61	412.05	412.46	3548148.0
2022-08-23 14:00:00	SPY	ETF	412.48	413.29	412.18	412.82	3508080.0
2022-08-23 15:00:00	SPY	ETF	412.83	413.51	412.14	412.33	8523590.0
2022-08-23 16:00:00	SPY	ETF	412.32	412.55	411.98	412.02	2352229.0
2022-08-23 17:00:00	SPY	ETF	412.01	412.2	411.99	412.05	33284.0
2022-08-23 18:00:00	SPY	ETF	412.02	412.36	411.99	412.33	74614.0
2022-08-23 19:00:00	SPY	ETF	412.33	412.51	412.0	412.1	65287.0
2022-08-23 04:00:00	QQQ	ETF	314.92	315.71	314.92	315.13	84520.0
2022-08-23 05:00:00	QQQ	ETF	315.07	315.43	314.62	315.43	31418.0
2022-08-23 06:00:00	QQQ	ETF	315.31	315.35	314.35	314.76	32349.0
2022-08-23 07:00:00	QQQ	ETF	314.68	315.29	314.37	315.11	209195.0
2022-08-23 08:00:00	QQQ	ETF	314.4599	315.53	313.0	314.19	516779.0
2022-08-23 09:00:00	QQQ	ETF	314.151	316.17	313.33	315.26	5837760.0
2022-08-23 10:00:00	QQQ	ETF	315.27	317.0	314.0028	314.13	5641272.0
2022-08-23 11:00:00	QQQ	ETF	314.1101	315.2	313.5038	314.6	3877582.0
2022-08-23 12:00:00	QQQ	ETF	314.62	315.05	313.69	314.94	2842676.0
2022-08-23 13:00:00	QQQ	ETF	314.96	315.61	314.15	314.6068	2917878.0
2022-08-23 14:00:00	QQQ	ETF	314.61	315.44	314.35	314.91	2467418.0
2022-08-23 15:00:00	QQQ	ETF	314.9	315.35	313.69	314.1	4531248.0
2022-08-23 16:00:00	QQQ	ETF	314.11	314.27	313.83	313.83	2155868.0
2022-08-23 17:00:00	QQQ	ETF	313.86	314.1	313.69	313.83	132002.0
2022-08-23 18:00:00	QQQ	ETF	313.8	314.17	313.8	314.1	72572.0
2022-08-23 19:00:00	QQQ	ETF	314.18	314.3496	313.88	314.0	54752.0
2022-08-23 04:00:00	IWM	ETF	191.33	191.55	191.1	191.1	18280.0
2022-08-23 05:00:00	IWM	ETF	191.08	191.42	190.97	191.42	11097.0
2022-08-23 06:00:00	IWM	ETF	191.29	191.31	190.86	191.13	4262.0
2022-08-23 07:00:00	IWM	ETF	190.97	191.18	190.7	191.09	22707.0
2022-08-23 08:00:00	IWM	ETF	190.93	191.19	190.59	190.84	33799.0
2022-08-23 09:00:00	IWM	ETF	190.8	192.44	190.55	192.03	2628149.0
2022-08-23 10:00:00	IWM	ETF	192.04	192.93	191.46	191.495	2246307.0
2022-08-23 11:00:00	IWM	ETF	191.5	191.87	191.03	191.33	1596607.0
2022-08-23 12:00:00	IWM	ETF	191.35	191.36	190.39	191.13	1264495.0
2022-08-23 13:00:00	IWM	ETF	191.13	191.28	190.46	190.75	1889449.0
2022-08-23 14:00:00	IWM	ETF	190.75	191.42	190.61	191.21	764288.0
2022-08-23 15:00:00	IWM	ETF	191.21	191.78	190.84	190.95	2585062.0
2022-08-23 16:00:00	IWM	ETF	190.95	191.03	190.67	190.69	931764.0
2022-08-23 17:00:00	IWM	ETF	190.71	190.95	190.7	190.83	175444.0
2022-08-23 18:00:00	IWM	ETF	190.8	190.98	190.7	190.95	27105.0
2022-08-23 19:00:00	IWM	ETF	191.0	191.07	190.74	190.83	26686.0
2022-08-23 04:00:00	DIA	ETF	331.55	331.6	331.4	331.4	2100.0
2022-08-23 05:00:00	DIA	ETF	331.3	331.3	331.3	331.3	400.0

> showing 50 of 15,829 rows — these rows as CSV

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