PREVIEW / etf_1hour / 2022-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-02.parquet
  size:    461 KB
  rows:    17,022

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-11-02 04:00:00	SPY	ETF	385.05	386.14	385.05	385.7	25041.0
2022-11-02 05:00:00	SPY	ETF	385.72	385.9	384.62	384.78	7300.0
2022-11-02 06:00:00	SPY	ETF	385.05	385.05	384.25	384.57	48824.0
2022-11-02 07:00:00	SPY	ETF	384.54	385.16	384.36	385.08	86676.0
2022-11-02 08:00:00	SPY	ETF	385.08	385.9696	383.54	384.17	648741.0
2022-11-02 09:00:00	SPY	ETF	384.17	384.37	382.41	382.44	4300487.0
2022-11-02 10:00:00	SPY	ETF	382.44	383.12	382.11	382.75	5198149.0
2022-11-02 11:00:00	SPY	ETF	382.76	383.1021	382.27	382.71	3588200.0
2022-11-02 12:00:00	SPY	ETF	382.7	382.885	381.39	382.48	4374305.0
2022-11-02 13:00:00	SPY	ETF	382.48	383.94	382.0	383.325	4931049.0
2022-11-02 14:00:00	SPY	ETF	383.3281	388.63	378.96	380.49	35958703.0
2022-11-02 15:00:00	SPY	ETF	380.515	383.19	374.84	374.87	29625861.0
2022-11-02 16:00:00	SPY	ETF	374.87	382.1875	374.16	374.95	7128128.0
2022-11-02 17:00:00	SPY	ETF	374.93	375.02	374.8004	374.8004	197862.0
2022-11-02 18:00:00	SPY	ETF	374.84	375.16	373.88	374.28	221735.0
2022-11-02 19:00:00	SPY	ETF	374.22	374.35	373.8	374.08	126204.0
2022-11-02 04:00:00	QQQ	ETF	275.55	276.49	275.55	276.12	83660.0
2022-11-02 05:00:00	QQQ	ETF	276.16	276.24	275.3	275.65	29939.0
2022-11-02 06:00:00	QQQ	ETF	275.64	275.78	275.1	275.42	55331.0
2022-11-02 07:00:00	QQQ	ETF	275.47	275.73	275.2	275.6	94048.0
2022-11-02 08:00:00	QQQ	ETF	275.63	276.4296	274.25	275.18	760443.0
2022-11-02 09:00:00	QQQ	ETF	275.1	275.32	273.64	273.8523	3320791.0
2022-11-02 10:00:00	QQQ	ETF	273.87	274.56	273.24	273.605	3260032.0
2022-11-02 11:00:00	QQQ	ETF	273.62	273.78	272.53	272.77	2164046.0
2022-11-02 12:00:00	QQQ	ETF	272.78	273.01	271.71	272.7699	2688333.0
2022-11-02 13:00:00	QQQ	ETF	272.79	273.72	272.18	273.17	2547589.0
2022-11-02 14:00:00	QQQ	ETF	273.18	278.21	269.9975	270.9453	28433470.0
2022-11-02 15:00:00	QQQ	ETF	270.92	273.03	265.61	265.66	20364730.0
2022-11-02 16:00:00	QQQ	ETF	265.66	266.05	264.9	265.75	3670782.0
2022-11-02 17:00:00	QQQ	ETF	265.73	265.98	265.68	265.7	318965.0
2022-11-02 18:00:00	QQQ	ETF	265.66	265.79	264.8	265.27	217317.0
2022-11-02 19:00:00	QQQ	ETF	265.2	265.28	264.87	265.19	137132.0
2022-11-02 04:00:00	IWM	ETF	183.72	184.32	183.72	183.97	9997.0
2022-11-02 05:00:00	IWM	ETF	184.09	184.09	183.51	183.59	4907.0
2022-11-02 06:00:00	IWM	ETF	183.56	183.61	183.23	183.24	5368.0
2022-11-02 07:00:00	IWM	ETF	183.33	183.65	183.22	183.62	17830.0
2022-11-02 08:00:00	IWM	ETF	183.32	184.3	182.94	183.26	60073.0
2022-11-02 09:00:00	IWM	ETF	183.18	183.2	181.21	181.31	3015714.0
2022-11-02 10:00:00	IWM	ETF	181.3	182.0	181.0	181.79	2025215.0
2022-11-02 11:00:00	IWM	ETF	181.815	182.02	181.14	181.17	947052.0
2022-11-02 12:00:00	IWM	ETF	181.16	181.285	180.33	181.04	1786123.0
2022-11-02 13:00:00	IWM	ETF	181.03	181.56	180.79	181.53	1323447.0
2022-11-02 14:00:00	IWM	ETF	181.45	185.0	179.54	180.27	9196561.0
2022-11-02 15:00:00	IWM	ETF	180.27	181.54	177.43	177.49	8605683.0
2022-11-02 16:00:00	IWM	ETF	177.49	177.81	177.15	177.59	812929.0
2022-11-02 17:00:00	IWM	ETF	177.55	177.75	177.36	177.38	2003051.0
2022-11-02 18:00:00	IWM	ETF	177.44	177.69	177.0	177.13	21358.0
2022-11-02 19:00:00	IWM	ETF	177.11	177.12	176.79	176.99	60176.0
2022-11-02 04:00:00	DIA	ETF	326.65	326.65	326.64	326.64	1500.0
2022-11-02 05:00:00	DIA	ETF	327.3	327.3	326.5	326.59	1000.0

> showing 50 of 17,022 rows — these rows as CSV

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