PREVIEW / etf_1hour / 2023-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-23.parquet
  size:    469 KB
  rows:    17,283

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-03-23 04:00:00	SPY	ETF	395.02	395.49	394.03	395.17	92399.0
2023-03-23 05:00:00	SPY	ETF	395.15	395.17	394.09	394.3	45960.0
2023-03-23 06:00:00	SPY	ETF	394.36	394.43	393.12	393.95	185650.0
2023-03-23 07:00:00	SPY	ETF	393.98	394.88	393.98	394.59	221880.0
2023-03-23 08:00:00	SPY	ETF	394.65	395.25	393.5196	394.32	520347.0
2023-03-23 09:00:00	SPY	ETF	394.31	396.17	393.7	395.95	7463667.0
2023-03-23 10:00:00	SPY	ETF	395.95	398.55	395.84	398.42	10960685.0
2023-03-23 11:00:00	SPY	ETF	398.42	399.29	397.77	398.02	8015707.0
2023-03-23 12:00:00	SPY	ETF	398.04	398.3201	396.54	396.77	7437008.0
2023-03-23 13:00:00	SPY	ETF	396.77	397.13	394.66	394.82	9347385.0
2023-03-23 14:00:00	SPY	ETF	394.82	395.36	390.54	392.3	15225016.0
2023-03-23 15:00:00	SPY	ETF	392.31	394.99	390.35	393.11	29184073.0
2023-03-23 16:00:00	SPY	ETF	393.13	394.84	392.93	394.33	4477676.0
2023-03-23 17:00:00	SPY	ETF	394.35	394.64	393.17	394.47	576169.0
2023-03-23 18:00:00	SPY	ETF	394.4	394.53	393.34	393.61	119253.0
2023-03-23 19:00:00	SPY	ETF	393.55	394.09	393.55	393.91	75983.0
2023-03-23 04:00:00	QQQ	ETF	308.83	309.9	308.08	309.53	145960.0
2023-03-23 05:00:00	QQQ	ETF	309.6	309.6	308.95	309.41	56304.0
2023-03-23 06:00:00	QQQ	ETF	309.39	309.52	308.4	309.18	126496.0
2023-03-23 07:00:00	QQQ	ETF	309.15	309.43	308.89	309.17	198595.0
2023-03-23 08:00:00	QQQ	ETF	309.1982	309.64	306.349	309.15	765232.0
2023-03-23 09:00:00	QQQ	ETF	309.14	310.93	308.7	310.8004	5511290.0
2023-03-23 10:00:00	QQQ	ETF	310.81	313.56	310.7	313.3199	7868030.0
2023-03-23 11:00:00	QQQ	ETF	313.35	314.15	312.62	313.0899	5248303.0
2023-03-23 12:00:00	QQQ	ETF	313.08	313.44	312.12	312.39	4255644.0
2023-03-23 13:00:00	QQQ	ETF	312.41	312.83	310.67	310.81	5052055.0
2023-03-23 14:00:00	QQQ	ETF	310.81	311.3	307.05	308.72	9056197.0
2023-03-23 15:00:00	QQQ	ETF	308.72	311.32	307.01	309.78	13258569.0
2023-03-23 16:00:00	QQQ	ETF	309.78	310.86	309.31	310.38	2002029.0
2023-03-23 17:00:00	QQQ	ETF	310.36	310.5797	309.75	310.52	226754.0
2023-03-23 18:00:00	QQQ	ETF	310.46	310.55	309.52	309.71	129608.0
2023-03-23 19:00:00	QQQ	ETF	309.78	310.27	309.75	310.2	90629.0
2023-03-23 04:00:00	IWM	ETF	172.84	173.26	172.84	173.21	28609.0
2023-03-23 05:00:00	IWM	ETF	172.9	172.98	172.0	172.01	30858.0
2023-03-23 06:00:00	IWM	ETF	172.0	172.03	171.03	171.84	75528.0
2023-03-23 07:00:00	IWM	ETF	171.9	172.65	171.87	172.4	127300.0
2023-03-23 08:00:00	IWM	ETF	171.92	172.98	171.76	172.02	184817.0
2023-03-23 09:00:00	IWM	ETF	172.01	173.1	171.7	172.88	2772779.0
2023-03-23 10:00:00	IWM	ETF	172.89	174.39	172.85	174.025	3574543.0
2023-03-23 11:00:00	IWM	ETF	174.03	174.39	172.98	173.01	2318906.0
2023-03-23 12:00:00	IWM	ETF	173.02	173.14	171.44	171.62	3987390.0
2023-03-23 13:00:00	IWM	ETF	171.63	171.97	170.65	170.72	4270946.0
2023-03-23 14:00:00	IWM	ETF	170.73	171.1	168.71	169.63	6461907.0
2023-03-23 15:00:00	IWM	ETF	169.64	171.29	168.85	170.2	8626487.0
2023-03-23 16:00:00	IWM	ETF	170.25	171.61	170.14	171.14	946600.0
2023-03-23 17:00:00	IWM	ETF	171.29	171.29	170.25	170.99	1196120.0
2023-03-23 18:00:00	IWM	ETF	171.02	171.18	170.65	170.84	30736.0
2023-03-23 19:00:00	IWM	ETF	170.8	171.15	170.72	170.81	26718.0
2023-03-23 04:00:00	DIA	ETF	322.15	322.23	321.95	321.95	3219.0
2023-03-23 05:00:00	DIA	ETF	321.87	321.87	321.0	321.0	3800.0

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

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