PREVIEW / etf_1hour / 2023-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-05.parquet
  size:    467 KB
  rows:    16,938

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
2023-04-05 04:00:00	SPY	ETF	408.43	408.67	407.76	407.95	56411.0
2023-04-05 05:00:00	SPY	ETF	407.94	408.34	407.78	407.86	55772.0
2023-04-05 06:00:00	SPY	ETF	407.86	408.36	407.74	408.35	13037.0
2023-04-05 07:00:00	SPY	ETF	408.32	408.66	408.2	408.28	126542.0
2023-04-05 08:00:00	SPY	ETF	408.43	409.04	407.64	407.94	461311.0
2023-04-05 09:00:00	SPY	ETF	407.89	408.62	407.77	408.35	5416852.0
2023-04-05 10:00:00	SPY	ETF	408.37	408.7	406.23	406.35	10085314.0
2023-04-05 11:00:00	SPY	ETF	406.35	407.405	406.15	407.06	6643969.0
2023-04-05 12:00:00	SPY	ETF	407.05	407.125	405.88	406.1552	5321590.0
2023-04-05 13:00:00	SPY	ETF	406.165	407.23	405.98	407.16	5691299.0
2023-04-05 14:00:00	SPY	ETF	407.17	407.77	407.05	407.5	5285331.0
2023-04-05 15:00:00	SPY	ETF	407.51	407.86	406.84	407.65	10010877.0
2023-04-05 16:00:00	SPY	ETF	407.65	407.74	407.42	407.43	2239128.0
2023-04-05 17:00:00	SPY	ETF	407.55	407.55	407.17	407.25	43260.0
2023-04-05 18:00:00	SPY	ETF	407.25	407.41	407.06	407.37	112540.0
2023-04-05 19:00:00	SPY	ETF	407.32	407.4	407.21	407.28	38015.0
2023-04-05 04:00:00	QQQ	ETF	318.78	318.79	318.22	318.43	33012.0
2023-04-05 05:00:00	QQQ	ETF	318.39	318.74	318.39	318.43	9590.0
2023-04-05 06:00:00	QQQ	ETF	318.53	318.84	318.43	318.82	16087.0
2023-04-05 07:00:00	QQQ	ETF	318.84	319.25	318.74	319.01	223220.0
2023-04-05 08:00:00	QQQ	ETF	319.0704	319.61	318.3204	318.74	404000.0
2023-04-05 09:00:00	QQQ	ETF	318.75	318.95	316.795	317.2401	6321043.0
2023-04-05 10:00:00	QQQ	ETF	317.27	317.89	314.6	314.62	11413731.0
2023-04-05 11:00:00	QQQ	ETF	314.6294	315.48	314.42	315.12	6322203.0
2023-04-05 12:00:00	QQQ	ETF	315.12	315.18	314.07	314.44	4804092.0
2023-04-05 13:00:00	QQQ	ETF	314.45	315.39	314.25	315.325	4097579.0
2023-04-05 14:00:00	QQQ	ETF	315.33	316.12	315.17	315.77	5384466.0
2023-04-05 15:00:00	QQQ	ETF	315.775	316.175	314.94	315.85	9424797.0
2023-04-05 16:00:00	QQQ	ETF	315.84	315.92	315.52	315.66	1295254.0
2023-04-05 17:00:00	QQQ	ETF	315.69	315.7	315.51	315.55	19757.0
2023-04-05 18:00:00	QQQ	ETF	315.54	315.55	315.31	315.51	55707.0
2023-04-05 19:00:00	QQQ	ETF	315.44	315.5	315.21	315.3	91821.0
2023-04-05 04:00:00	IWM	ETF	175.1	175.1	174.58	174.79	14392.0
2023-04-05 05:00:00	IWM	ETF	174.72	174.91	174.5	174.67	4382.0
2023-04-05 06:00:00	IWM	ETF	174.6	175.04	174.6	175.04	17289.0
2023-04-05 07:00:00	IWM	ETF	175.14	175.33	174.76	174.86	42975.0
2023-04-05 08:00:00	IWM	ETF	175.16	175.2	174.24	174.41	166614.0
2023-04-05 09:00:00	IWM	ETF	174.37	174.83	173.661	174.43	3493796.0
2023-04-05 10:00:00	IWM	ETF	174.44	174.58	172.63	172.76	4615887.0
2023-04-05 11:00:00	IWM	ETF	172.76	173.38	172.53	173.21	3044880.0
2023-04-05 12:00:00	IWM	ETF	173.21	173.275	172.63	172.9	1367054.0
2023-04-05 13:00:00	IWM	ETF	172.9	173.57	172.76	173.06	1803926.0
2023-04-05 14:00:00	IWM	ETF	173.06	173.55	173.04	173.215	1648313.0
2023-04-05 15:00:00	IWM	ETF	173.21	173.79	172.89	173.63	3147647.0
2023-04-05 16:00:00	IWM	ETF	173.63	173.79	173.38	173.4	2095233.0
2023-04-05 17:00:00	IWM	ETF	173.32	173.49	173.25	173.3	1817.0
2023-04-05 18:00:00	IWM	ETF	173.34	173.47	173.27	173.47	7017.0
2023-04-05 19:00:00	IWM	ETF	173.4	173.47	173.31	173.35	7374.0
2023-04-05 05:00:00	DIA	ETF	333.75	333.75	333.49	333.49	1796.0
2023-04-05 06:00:00	DIA	ETF	333.62	333.62	333.62	333.62	500.0

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

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