PREVIEW / etf_1hour / 2022-12-02

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-02.parquet
  size:    469 KB
  rows:    16,918

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-12-02 04:00:00	SPY	ETF	407.15	407.44	406.85	407.44	30389.0
2022-12-02 05:00:00	SPY	ETF	407.49	407.69	407.24	407.5	29181.0
2022-12-02 06:00:00	SPY	ETF	407.36	407.37	406.86	407.0	35472.0
2022-12-02 07:00:00	SPY	ETF	407.03	407.4	406.6	407.38	147475.0
2022-12-02 08:00:00	SPY	ETF	406.75	407.74	400.01	402.05	4605868.0
2022-12-02 09:00:00	SPY	ETF	402.02	404.1	400.57	403.08	9920515.0
2022-12-02 10:00:00	SPY	ETF	403.08	405.15	402.635	404.07	9872155.0
2022-12-02 11:00:00	SPY	ETF	404.03	406.19	403.58	405.42	8691495.0
2022-12-02 12:00:00	SPY	ETF	405.42	406.3	404.67	404.77	4283713.0
2022-12-02 13:00:00	SPY	ETF	404.74	405.45	404.33	405.22	3429724.0
2022-12-02 14:00:00	SPY	ETF	405.225	406.66	404.48	406.54	4609618.0
2022-12-02 15:00:00	SPY	ETF	406.54	407.86	405.8	406.87	12619199.0
2022-12-02 16:00:00	SPY	ETF	406.87	407.0	405.93	405.96	2606744.0
2022-12-02 17:00:00	SPY	ETF	406.14	406.2	405.96	406.15	96260.0
2022-12-02 18:00:00	SPY	ETF	406.15	406.15	405.86	406.0	31282.0
2022-12-02 19:00:00	SPY	ETF	406.03	406.03	405.0	405.93	31108.0
2022-12-02 04:00:00	QQQ	ETF	293.43	293.66	293.07	293.64	51383.0
2022-12-02 05:00:00	QQQ	ETF	293.6	293.78	293.48	293.59	26394.0
2022-12-02 06:00:00	QQQ	ETF	293.61	293.61	293.13	293.24	19474.0
2022-12-02 07:00:00	QQQ	ETF	293.3	293.62	292.88	293.62	173796.0
2022-12-02 08:00:00	QQQ	ETF	293.62	293.94	286.0	288.17	3622133.0
2022-12-02 09:00:00	QQQ	ETF	288.02	290.23	287.21	289.26	7406354.0
2022-12-02 10:00:00	QQQ	ETF	289.26	291.1582	288.73	289.965	7701070.0
2022-12-02 11:00:00	QQQ	ETF	289.97	291.78	289.37	290.93	4647809.0
2022-12-02 12:00:00	QQQ	ETF	290.92	291.8	290.2501	290.42	3425403.0
2022-12-02 13:00:00	QQQ	ETF	290.42	291.0	289.8	290.76	2225035.0
2022-12-02 14:00:00	QQQ	ETF	290.76	292.06	290.18	292.02	2998110.0
2022-12-02 15:00:00	QQQ	ETF	292.02	293.45	291.61	292.61	6494866.0
2022-12-02 16:00:00	QQQ	ETF	292.61	292.62	291.77	291.8	2657773.0
2022-12-02 17:00:00	QQQ	ETF	291.88	292.15	291.86	292.05	28566.0
2022-12-02 18:00:00	QQQ	ETF	292.01	292.01	291.65	291.91	12214.0
2022-12-02 19:00:00	QQQ	ETF	291.95	292.0	291.9	292.0	34764.0
2022-12-02 04:00:00	IWM	ETF	186.88	186.89	186.5	186.89	13436.0
2022-12-02 05:00:00	IWM	ETF	186.91	187.01	186.8	187.01	9229.0
2022-12-02 06:00:00	IWM	ETF	186.92	186.98	186.63	186.75	2774.0
2022-12-02 07:00:00	IWM	ETF	186.569	187.01	186.569	186.94	19293.0
2022-12-02 08:00:00	IWM	ETF	186.94	187.12	183.0	184.15	498465.0
2022-12-02 09:00:00	IWM	ETF	184.06	185.93	183.56	185.8787	2833196.0
2022-12-02 10:00:00	IWM	ETF	185.8781	187.08	185.57	186.45	3135087.0
2022-12-02 11:00:00	IWM	ETF	186.45	187.66	186.292	187.24	1555760.0
2022-12-02 12:00:00	IWM	ETF	187.24	187.77	186.82	186.88	1185693.0
2022-12-02 13:00:00	IWM	ETF	186.86	187.48	186.72	187.415	937175.0
2022-12-02 14:00:00	IWM	ETF	187.415	188.34	186.9901	188.33	1902129.0
2022-12-02 15:00:00	IWM	ETF	188.33	188.86	187.7401	188.06	3743427.0
2022-12-02 16:00:00	IWM	ETF	188.06	188.0755	187.63	187.67	1674325.0
2022-12-02 17:00:00	IWM	ETF	187.55	187.84	187.5	187.8	5694.0
2022-12-02 18:00:00	IWM	ETF	187.85	187.85	187.66	187.76	5214.0
2022-12-02 19:00:00	IWM	ETF	187.8	187.88	187.4	187.53	17424.0
2022-12-02 04:00:00	DIA	ETF	344.05	344.05	344.03	344.03	595.0
2022-12-02 05:00:00	DIA	ETF	344.36	344.36	344.16	344.16	500.0

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

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