PREVIEW / stock_1hour / 2006-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-19.parquet
  size:    612 KB
  rows:    29,323
  symbols: 2,316

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
2006-07-19 08:00:00	AAPL	Stock	1.8979	1.9107	1.8929	1.9	4500496.0
2006-07-19 09:00:00	AAPL	Stock	1.8989	1.9086	1.87	1.8982	103233844.0
2006-07-19 10:00:00	AAPL	Stock	1.8979	1.9125	1.8796	1.8918	188398952.0
2006-07-19 11:00:00	AAPL	Stock	1.8914	1.905	1.8807	1.8971	100363872.0
2006-07-19 12:00:00	AAPL	Stock	1.8971	1.9239	1.8911	1.9236	124194896.0
2006-07-19 13:00:00	AAPL	Stock	1.9236	1.9671	1.9182	1.9546	258405224.0
2006-07-19 14:00:00	AAPL	Stock	1.9546	1.9571	1.9375	1.945	144958520.0
2006-07-19 15:00:00	AAPL	Stock	1.9446	1.9536	1.9304	1.9325	189689976.0
2006-07-19 16:00:00	AAPL	Stock	1.9329	2.0886	1.8404	2.0793	203760760.0
2006-07-19 17:00:00	AAPL	Stock	2.0804	2.1011	2.0139	2.1011	71914724.0
2006-07-19 18:00:00	AAPL	Stock	2.0964	2.0996	2.0893	2.095	5949944.0
2006-07-19 07:00:00	MSFT	Stock	22.71	22.71	22.71	22.71	100.0
2006-07-19 08:00:00	MSFT	Stock	22.69	22.75	22.65	22.74	57489.0
2006-07-19 09:00:00	MSFT	Stock	22.68	23.2	22.62	23.09	10365767.0
2006-07-19 10:00:00	MSFT	Stock	23.09	23.18	22.98	23.08	14862518.0
2006-07-19 11:00:00	MSFT	Stock	23.07	23.2	23.04	23.103	5727310.0
2006-07-19 12:00:00	MSFT	Stock	23.1	23.23	23.05	23.22	4447501.0
2006-07-19 13:00:00	MSFT	Stock	23.22	23.32	23.16	23.16	7113509.0
2006-07-19 14:00:00	MSFT	Stock	23.16	23.37	23.16	23.36	10745265.0
2006-07-19 15:00:00	MSFT	Stock	23.37	23.46	23.3	23.44	17990555.0
2006-07-19 16:00:00	MSFT	Stock	23.42	23.46	23.33	23.39	1042295.0
2006-07-19 17:00:00	MSFT	Stock	23.39	23.39	23.35	23.39	9399.0
2006-07-19 18:00:00	MSFT	Stock	23.4	23.45	23.39	23.42	4268.0
2006-07-19 08:00:00	NVDA	Stock	0.3133	0.3133	0.3125	0.3125	96000.0
2006-07-19 09:00:00	NVDA	Stock	0.3102	0.3158	0.3085	0.3142	79478940.0
2006-07-19 10:00:00	NVDA	Stock	0.3142	0.326	0.3123	0.324	251196720.0
2006-07-19 11:00:00	NVDA	Stock	0.3242	0.3275	0.3142	0.3273	126704940.0
2006-07-19 12:00:00	NVDA	Stock	0.3273	0.3277	0.3142	0.3273	101315280.0
2006-07-19 13:00:00	NVDA	Stock	0.3272	0.3307	0.3143	0.3255	75307620.0
2006-07-19 14:00:00	NVDA	Stock	0.3255	0.3275	0.3142	0.327	120131940.0
2006-07-19 15:00:00	NVDA	Stock	0.3272	0.3288	0.325	0.3267	216003180.0
2006-07-19 16:00:00	NVDA	Stock	0.3267	0.3312	0.3185	0.322	12086400.0
2006-07-19 17:00:00	NVDA	Stock	0.325	0.3267	0.3237	0.3267	449100.0
2006-07-19 08:00:00	AMZN	Stock	1.6665	1.67	1.6665	1.6685	238100.0
2006-07-19 09:00:00	AMZN	Stock	1.6685	1.71	1.665	1.7085	20640700.0
2006-07-19 10:00:00	AMZN	Stock	1.7095	1.7325	1.679	1.6955	31256660.0
2006-07-19 11:00:00	AMZN	Stock	1.6955	1.712	1.6935	1.6936	16184980.0
2006-07-19 12:00:00	AMZN	Stock	1.6935	1.705	1.6875	1.699	16226700.0
2006-07-19 13:00:00	AMZN	Stock	1.6995	1.71	1.6945	1.707	13756500.0
2006-07-19 14:00:00	AMZN	Stock	1.7075	1.7385	1.704	1.7315	32910800.0
2006-07-19 15:00:00	AMZN	Stock	1.732	1.7365	1.713	1.723	43194060.0
2006-07-19 16:00:00	AMZN	Stock	1.7215	1.727	1.701	1.719	318940.0
2006-07-19 17:00:00	AMZN	Stock	1.7275	1.731	1.725	1.731	41600.0
2006-07-19 09:00:00	CL	Stock	30.55	30.855	30.48	30.795	347800.0
2006-07-19 10:00:00	CL	Stock	30.795	31.075	30.795	30.925	595400.0
2006-07-19 11:00:00	CL	Stock	30.935	31.135	30.9	31.025	479400.0
2006-07-19 12:00:00	CL	Stock	31.015	31.12	30.975	31.045	288400.0
2006-07-19 13:00:00	CL	Stock	31.055	31.17	31.03	31.155	302600.0
2006-07-19 14:00:00	CL	Stock	31.16	31.24	31.135	31.19	501600.0
2006-07-19 15:00:00	CL	Stock	31.195	31.255	31.1	31.12	781800.0

> showing 50 of 29,323 rows — these rows as CSV

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