PREVIEW / etf_1hour / 2023-01-10

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-10.parquet
  size:    462 KB
  rows:    16,675

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-01-10 04:00:00	SPY	ETF	387.86	387.86	386.91	387.67	46488.0
2023-01-10 05:00:00	SPY	ETF	387.82	387.95	387.4	387.63	22839.0
2023-01-10 06:00:00	SPY	ETF	387.63	387.63	386.5	386.76	113590.0
2023-01-10 07:00:00	SPY	ETF	386.71	386.75	385.74	386.28	473009.0
2023-01-10 08:00:00	SPY	ETF	386.25	387.7396	385.75	386.6	534232.0
2023-01-10 09:00:00	SPY	ETF	386.6	389.23	386.3	388.45	5871156.0
2023-01-10 10:00:00	SPY	ETF	388.46	389.99	386.27	388.3701	8376111.0
2023-01-10 11:00:00	SPY	ETF	388.39	388.8	387.35	388.12	4172419.0
2023-01-10 12:00:00	SPY	ETF	388.12	389.1896	387.19	388.78	4234418.0
2023-01-10 13:00:00	SPY	ETF	388.78	389.6101	388.53	389.52	4610478.0
2023-01-10 14:00:00	SPY	ETF	389.57	390.22	389.24	389.49	4943966.0
2023-01-10 15:00:00	SPY	ETF	389.485	390.65	388.76	390.63	10691297.0
2023-01-10 16:00:00	SPY	ETF	390.62	390.82	390.37	390.62	6879882.0
2023-01-10 17:00:00	SPY	ETF	390.69	390.72	390.53	390.65	58061.0
2023-01-10 18:00:00	SPY	ETF	390.65	390.77	390.37	390.7	96905.0
2023-01-10 19:00:00	SPY	ETF	390.75	391.15	390.73	391.07	200778.0
2023-01-10 04:00:00	QQQ	ETF	270.12	270.57	269.84	270.54	67938.0
2023-01-10 05:00:00	QQQ	ETF	270.64	270.99	270.36	270.92	17207.0
2023-01-10 06:00:00	QQQ	ETF	270.86	270.86	269.4	269.6	138990.0
2023-01-10 07:00:00	QQQ	ETF	269.6	269.62	268.37	268.85	295735.0
2023-01-10 08:00:00	QQQ	ETF	269.15	271.01	268.4	269.08	361514.0
2023-01-10 09:00:00	QQQ	ETF	269.13	272.02	268.92	271.145	5889447.0
2023-01-10 10:00:00	QQQ	ETF	271.14	272.888	268.97	271.055	6164134.0
2023-01-10 11:00:00	QQQ	ETF	271.055	271.45	270.1	270.66	2832071.0
2023-01-10 12:00:00	QQQ	ETF	270.64	271.6899	269.84	271.345	2108008.0
2023-01-10 13:00:00	QQQ	ETF	271.35	272.04	271.07	271.95	2240504.0
2023-01-10 14:00:00	QQQ	ETF	271.96	272.6	271.73	272.06	2877750.0
2023-01-10 15:00:00	QQQ	ETF	272.05	272.93	271.31	272.93	4166322.0
2023-01-10 16:00:00	QQQ	ETF	272.92	272.99	272.75	272.84	1175496.0
2023-01-10 17:00:00	QQQ	ETF	272.8	272.89	272.78	272.85	32233.0
2023-01-10 18:00:00	QQQ	ETF	272.9	272.94	272.59	272.89	36437.0
2023-01-10 19:00:00	QQQ	ETF	272.92	273.28	272.92	273.21	97441.0
2023-01-10 04:00:00	IWM	ETF	177.46	177.73	177.28	177.73	13835.0
2023-01-10 05:00:00	IWM	ETF	177.81	177.86	177.58	177.71	5021.0
2023-01-10 06:00:00	IWM	ETF	177.7	177.7	177.3	177.35	5023.0
2023-01-10 07:00:00	IWM	ETF	177.39	177.43	176.93	177.15	40254.0
2023-01-10 08:00:00	IWM	ETF	177.13	177.49	177.03	177.49	50848.0
2023-01-10 09:00:00	IWM	ETF	177.5	178.75	177.28	178.16	1734575.0
2023-01-10 10:00:00	IWM	ETF	178.21	179.02	177.48	178.75	2890053.0
2023-01-10 11:00:00	IWM	ETF	178.77	179.18	178.59	178.95	1161513.0
2023-01-10 12:00:00	IWM	ETF	178.94	179.75	178.54	179.44	1030271.0
2023-01-10 13:00:00	IWM	ETF	179.43	180.02	179.37	179.97	827541.0
2023-01-10 14:00:00	IWM	ETF	179.995	180.4	179.95	180.04	1106476.0
2023-01-10 15:00:00	IWM	ETF	180.035	180.62	179.71	180.55	2643781.0
2023-01-10 16:00:00	IWM	ETF	180.54	180.63	180.34	180.52	775191.0
2023-01-10 17:00:00	IWM	ETF	180.5	180.56	180.45	180.46	5925.0
2023-01-10 18:00:00	IWM	ETF	180.46	180.56	180.38	180.56	29218.0
2023-01-10 19:00:00	IWM	ETF	180.56	180.73	180.56	180.7	50319.0
2023-01-10 04:00:00	DIA	ETF	334.45	334.45	334.27	334.45	1300.0
2023-01-10 05:00:00	DIA	ETF	334.84	334.84	334.6	334.78	500.0

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

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