PREVIEW / etf_1hour / 2022-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-02.parquet
  size:    451 KB
  rows:    16,227

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-06-02 04:00:00	SPY	ETF	410.64	411.83	410.03	411.44	26136.0
2022-06-02 05:00:00	SPY	ETF	411.05	411.91	411.05	411.34	20856.0
2022-06-02 06:00:00	SPY	ETF	411.38	412.18	410.88	412.05	117487.0
2022-06-02 07:00:00	SPY	ETF	412.04	412.1	411.5	411.8	157669.0
2022-06-02 08:00:00	SPY	ETF	411.6701	412.17	409.57	410.84	620219.0
2022-06-02 09:00:00	SPY	ETF	410.95	411.18	407.32	408.2	6508198.0
2022-06-02 10:00:00	SPY	ETF	408.19	410.57	407.04	409.74	8951600.0
2022-06-02 11:00:00	SPY	ETF	409.76	413.3645	409.58	412.3099	8662918.0
2022-06-02 12:00:00	SPY	ETF	412.33	414.67	412.08	414.3	5937308.0
2022-06-02 13:00:00	SPY	ETF	414.31	415.23	413.62	415.0344	6440503.0
2022-06-02 14:00:00	SPY	ETF	415.05	415.8	414.62	414.71	6275791.0
2022-06-02 15:00:00	SPY	ETF	414.7	417.44	414.57	417.37	14181451.0
2022-06-02 16:00:00	SPY	ETF	417.36	418.0	416.72	417.58	4332493.0
2022-06-02 17:00:00	SPY	ETF	417.59	417.7	417.45	417.47	55400.0
2022-06-02 18:00:00	SPY	ETF	417.47	418.6	417.47	417.81	90558.0
2022-06-02 19:00:00	SPY	ETF	417.92	418.29	417.88	418.0	41023.0
2022-06-02 04:00:00	QQQ	ETF	306.52	308.34	306.52	307.65	64308.0
2022-06-02 05:00:00	QQQ	ETF	307.67	308.26	307.41	307.78	31519.0
2022-06-02 06:00:00	QQQ	ETF	307.76	308.58	307.39	308.37	98475.0
2022-06-02 07:00:00	QQQ	ETF	308.37	308.37	307.73	308.06	171324.0
2022-06-02 08:00:00	QQQ	ETF	307.87	308.5696	306.0	306.96	488072.0
2022-06-02 09:00:00	QQQ	ETF	306.99	307.86	303.4001	305.64	8051755.0
2022-06-02 10:00:00	QQQ	ETF	305.63	308.05	304.79	307.29	7270120.0
2022-06-02 11:00:00	QQQ	ETF	307.26	310.4389	307.04	309.5	5795627.0
2022-06-02 12:00:00	QQQ	ETF	309.51	312.14	309.3	311.77	4697113.0
2022-06-02 13:00:00	QQQ	ETF	311.81	312.93	311.24	312.87	3837232.0
2022-06-02 14:00:00	QQQ	ETF	312.84	313.74	312.5	312.585	4469436.0
2022-06-02 15:00:00	QQQ	ETF	312.585	314.56	312.33	314.42	8891584.0
2022-06-02 16:00:00	QQQ	ETF	314.42	314.6	313.86	314.46	1532234.0
2022-06-02 17:00:00	QQQ	ETF	314.44	314.69	314.38	314.52	42084.0
2022-06-02 18:00:00	QQQ	ETF	314.53	315.61	314.48	315.01	189336.0
2022-06-02 19:00:00	QQQ	ETF	315.02	315.33	315.0	315.12	105404.0
2022-06-02 04:00:00	IWM	ETF	184.68	185.28	184.61	184.94	17039.0
2022-06-02 05:00:00	IWM	ETF	185.11	185.34	184.86	185.08	4086.0
2022-06-02 06:00:00	IWM	ETF	185.1	185.4	184.81	185.4	80143.0
2022-06-02 07:00:00	IWM	ETF	185.25	185.46	185.12	185.36	31137.0
2022-06-02 08:00:00	IWM	ETF	185.3001	185.47	184.86	184.87	171914.0
2022-06-02 09:00:00	IWM	ETF	184.86	185.69	184.17	184.81	2683066.0
2022-06-02 10:00:00	IWM	ETF	184.81	186.28	184.61	186.25	3360565.0
2022-06-02 11:00:00	IWM	ETF	186.26	187.6	186.15	186.87	2187818.0
2022-06-02 12:00:00	IWM	ETF	186.89	188.15	186.795	187.83	1491210.0
2022-06-02 13:00:00	IWM	ETF	187.84	188.47	187.54	188.36	1101243.0
2022-06-02 14:00:00	IWM	ETF	188.355	188.62	187.8	187.85	1546980.0
2022-06-02 15:00:00	IWM	ETF	187.83	188.76	187.7887	188.69	2768549.0
2022-06-02 16:00:00	IWM	ETF	188.76	188.81	188.47	188.76	2294746.0
2022-06-02 17:00:00	IWM	ETF	188.72	188.9399	188.53	188.84	8757.0
2022-06-02 18:00:00	IWM	ETF	188.76	189.27	188.76	188.82	24255.0
2022-06-02 19:00:00	IWM	ETF	188.86	189.06	188.81	188.979	29516.0
2022-06-02 04:00:00	DIA	ETF	329.2	329.65	329.2	329.65	1200.0
2022-06-02 05:00:00	DIA	ETF	329.29	329.6	329.29	329.4	520.0

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

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