PREVIEW / etf_1hour / 2022-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-28.parquet
  size:    450 KB
  rows:    16,238

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-28 04:00:00	SPY	ETF	389.63	390.91	389.63	390.91	34310.0
2022-06-28 05:00:00	SPY	ETF	390.86	391.36	390.22	390.22	33690.0
2022-06-28 06:00:00	SPY	ETF	390.44	390.93	390.22	390.75	45692.0
2022-06-28 07:00:00	SPY	ETF	390.81	391.15	390.55	390.84	160518.0
2022-06-28 08:00:00	SPY	ETF	390.7099	391.5	388.52	390.17	463530.0
2022-06-28 09:00:00	SPY	ETF	390.18	393.16	390.06	391.9199	6966181.0
2022-06-28 10:00:00	SPY	ETF	391.9	392.32	387.71	388.77	9192673.0
2022-06-28 11:00:00	SPY	ETF	388.76	389.0	383.87	384.09	9850296.0
2022-06-28 12:00:00	SPY	ETF	384.1	385.34	383.31	384.53	7109262.0
2022-06-28 13:00:00	SPY	ETF	384.5	384.5675	382.53	383.085	5142029.0
2022-06-28 14:00:00	SPY	ETF	383.02	383.78	380.71	381.51	6679169.0
2022-06-28 15:00:00	SPY	ETF	381.495	381.94	380.53	380.74	14685352.0
2022-06-28 16:00:00	SPY	ETF	380.74	381.15	380.41	381.06	4206438.0
2022-06-28 17:00:00	SPY	ETF	381.0	381.24	380.9	381.04	117880.0
2022-06-28 18:00:00	SPY	ETF	381.06	381.38	380.87	381.38	89182.0
2022-06-28 19:00:00	SPY	ETF	381.22	381.36	380.8	381.2	80867.0
2022-06-28 04:00:00	QQQ	ETF	293.3	294.16	293.26	294.16	49551.0
2022-06-28 05:00:00	QQQ	ETF	294.17	294.5	293.5	293.52	45211.0
2022-06-28 06:00:00	QQQ	ETF	293.57	294.04	293.34	293.88	45010.0
2022-06-28 07:00:00	QQQ	ETF	294.0	294.38	293.68	293.87	184597.0
2022-06-28 08:00:00	QQQ	ETF	293.84	295.0	292.53	293.16	581413.0
2022-06-28 09:00:00	QQQ	ETF	293.19	295.65	292.59	293.98	6856616.0
2022-06-28 10:00:00	QQQ	ETF	293.98	294.44	289.8301	290.68	7990617.0
2022-06-28 11:00:00	QQQ	ETF	290.64	290.98	286.16	286.34	8011903.0
2022-06-28 12:00:00	QQQ	ETF	286.3495	287.5	285.55	286.99	6683329.0
2022-06-28 13:00:00	QQQ	ETF	286.984	286.99	285.1	285.505	4157942.0
2022-06-28 14:00:00	QQQ	ETF	285.51	286.19	283.86	284.52	5405811.0
2022-06-28 15:00:00	QQQ	ETF	284.515	284.8689	283.35	283.47	8254447.0
2022-06-28 16:00:00	QQQ	ETF	283.47	283.75	283.2	283.72	1679898.0
2022-06-28 17:00:00	QQQ	ETF	283.65	283.75	283.35	283.46	495792.0
2022-06-28 18:00:00	QQQ	ETF	283.54	284.04	283.5	284.03	153128.0
2022-06-28 19:00:00	QQQ	ETF	283.85	284.0	283.51	283.79	145045.0
2022-06-28 04:00:00	IWM	ETF	176.78	177.13	176.73	177.12	15480.0
2022-06-28 05:00:00	IWM	ETF	177.09	177.37	176.82	176.86	10403.0
2022-06-28 06:00:00	IWM	ETF	177.0	177.35	176.82	177.16	29795.0
2022-06-28 07:00:00	IWM	ETF	177.04	177.1	176.84	177.05	27423.0
2022-06-28 08:00:00	IWM	ETF	177.0999	177.13	176.29	176.85	195169.0
2022-06-28 09:00:00	IWM	ETF	176.86	178.15	176.63	177.58	2638092.0
2022-06-28 10:00:00	IWM	ETF	177.54	177.88	175.9361	176.5263	2553645.0
2022-06-28 11:00:00	IWM	ETF	176.52	176.75	173.96	174.08	2379245.0
2022-06-28 12:00:00	IWM	ETF	174.07	175.09	173.77	174.54	1797498.0
2022-06-28 13:00:00	IWM	ETF	174.53	174.67	173.08	173.34	2270538.0
2022-06-28 14:00:00	IWM	ETF	173.35	173.79	172.35	172.88	1923252.0
2022-06-28 15:00:00	IWM	ETF	172.85	173.39	172.425	172.53	3413774.0
2022-06-28 16:00:00	IWM	ETF	172.44	172.74	172.36	172.54	1075162.0
2022-06-28 17:00:00	IWM	ETF	172.51	172.84	172.46	172.5	10106.0
2022-06-28 18:00:00	IWM	ETF	172.56	172.75	172.5	172.68	12528.0
2022-06-28 19:00:00	IWM	ETF	172.61	172.72	172.45	172.57	37241.0
2022-06-28 04:00:00	DIA	ETF	315.4	315.83	315.4	315.83	800.0
2022-06-28 05:00:00	DIA	ETF	316.45	316.45	316.2	316.2	885.0

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

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