PREVIEW / etf_1hour / 2022-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-14.parquet
  size:    443 KB
  rows:    16,237

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-09-14 04:00:00	SPY	ETF	394.71	395.99	394.59	395.63	96154.0
2022-09-14 05:00:00	SPY	ETF	395.66	395.72	394.78	394.9	77644.0
2022-09-14 06:00:00	SPY	ETF	395.0	395.46	394.48	394.81	189428.0
2022-09-14 07:00:00	SPY	ETF	394.77	394.85	392.41	392.48	326475.0
2022-09-14 08:00:00	SPY	ETF	394.79	395.92	392.38	394.21	1059377.0
2022-09-14 09:00:00	SPY	ETF	394.13	395.61	393.02	395.11	6293927.0
2022-09-14 10:00:00	SPY	ETF	395.11	395.69	391.76	395.49	8617896.0
2022-09-14 11:00:00	SPY	ETF	395.47	396.2	394.27	394.66	5574278.0
2022-09-14 12:00:00	SPY	ETF	394.67	395.7	394.0199	395.2599	4039047.0
2022-09-14 13:00:00	SPY	ETF	395.27	395.73	392.74	393.11	4899432.0
2022-09-14 14:00:00	SPY	ETF	393.13	393.84	392.28	392.61	5925699.0
2022-09-14 15:00:00	SPY	ETF	392.62	394.96	391.12	394.61	15222432.0
2022-09-14 16:00:00	SPY	ETF	394.61	395.63	394.4	395.5	2883151.0
2022-09-14 17:00:00	SPY	ETF	395.5	395.69	394.563	395.61	209599.0
2022-09-14 18:00:00	SPY	ETF	395.58	395.85	395.11	395.55	115816.0
2022-09-14 19:00:00	SPY	ETF	395.56	395.56	395.04	395.32	91695.0
2022-09-14 04:00:00	QQQ	ETF	294.67	296.0	294.57	295.55	157689.0
2022-09-14 05:00:00	QQQ	ETF	295.34	295.69	294.77	295.1	34064.0
2022-09-14 06:00:00	QQQ	ETF	295.25	295.46	294.6	294.93	56722.0
2022-09-14 07:00:00	QQQ	ETF	294.86	294.93	292.73	292.9	461540.0
2022-09-14 08:00:00	QQQ	ETF	294.83	295.9804	292.78	294.65	1628730.0
2022-09-14 09:00:00	QQQ	ETF	294.64	295.95	293.16	295.45	8069015.0
2022-09-14 10:00:00	QQQ	ETF	295.46	296.29	293.06	296.03	8205420.0
2022-09-14 11:00:00	QQQ	ETF	296.02	296.93	295.26	295.8799	4115017.0
2022-09-14 12:00:00	QQQ	ETF	295.89	296.74	295.145	296.2999	3200017.0
2022-09-14 13:00:00	QQQ	ETF	296.3083	296.77	294.08	294.38	3762363.0
2022-09-14 14:00:00	QQQ	ETF	294.375	295.14	293.65	294.1301	4005130.0
2022-09-14 15:00:00	QQQ	ETF	294.15	296.37	293.06	296.07	8133933.0
2022-09-14 16:00:00	QQQ	ETF	296.09	296.91	295.94	296.81	1739670.0
2022-09-14 17:00:00	QQQ	ETF	296.98	296.99	296.03	296.8	87098.0
2022-09-14 18:00:00	QQQ	ETF	296.76	297.27	296.49	297.11	122835.0
2022-09-14 19:00:00	QQQ	ETF	297.08	297.08	296.61	296.87	138468.0
2022-09-14 04:00:00	IWM	ETF	182.72	183.45	182.68	183.3	35718.0
2022-09-14 05:00:00	IWM	ETF	183.3	183.4	182.95	182.95	11981.0
2022-09-14 06:00:00	IWM	ETF	183.08	183.17	182.6	182.85	5622.0
2022-09-14 07:00:00	IWM	ETF	182.8	182.8	181.64	181.69	48996.0
2022-09-14 08:00:00	IWM	ETF	181.62	182.7904	181.59	182.5	112386.0
2022-09-14 09:00:00	IWM	ETF	182.52	182.76	181.22	182.1	1767025.0
2022-09-14 10:00:00	IWM	ETF	182.13	182.82	180.57	182.72	2390000.0
2022-09-14 11:00:00	IWM	ETF	182.71	183.28	182.25	182.84	1715730.0
2022-09-14 12:00:00	IWM	ETF	182.85	183.32	182.45	182.99	1353731.0
2022-09-14 13:00:00	IWM	ETF	183.03	183.28	182.01	182.14	1436240.0
2022-09-14 14:00:00	IWM	ETF	182.14	182.65	181.79	182.06	1921073.0
2022-09-14 15:00:00	IWM	ETF	182.04	183.12	181.14	183.07	4469520.0
2022-09-14 16:00:00	IWM	ETF	183.09	183.6	182.462	183.44	1269897.0
2022-09-14 17:00:00	IWM	ETF	183.49	183.54	182.96	183.34	145471.0
2022-09-14 18:00:00	IWM	ETF	183.32	183.67	183.19	183.54	40248.0
2022-09-14 19:00:00	IWM	ETF	183.45	183.52	183.2	183.39	24846.0
2022-09-14 04:00:00	DIA	ETF	312.88	313.39	312.86	313.11	2904.0
2022-09-14 05:00:00	DIA	ETF	313.1	313.1	312.77	312.77	1100.0

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

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