PREVIEW / stock_1hour / 2001-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-27.parquet
  size:    359 KB
  rows:    17,480
  symbols: 1,306

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
2001-06-27 09:00:00	AAPL	Stock	0.4239	0.4286	0.4161	0.4191	30856000.0
2001-06-27 10:00:00	AAPL	Stock	0.4186	0.4207	0.417	0.4188	22702400.0
2001-06-27 11:00:00	AAPL	Stock	0.4191	0.4202	0.4161	0.4173	33376000.0
2001-06-27 12:00:00	AAPL	Stock	0.4171	0.4191	0.4152	0.4168	16161600.0
2001-06-27 13:00:00	AAPL	Stock	0.4168	0.4168	0.4088	0.4109	54017600.0
2001-06-27 14:00:00	AAPL	Stock	0.4109	0.417	0.4018	0.4154	64058400.0
2001-06-27 15:00:00	AAPL	Stock	0.4157	0.422	0.4132	0.4163	108746400.0
2001-06-27 16:00:00	AAPL	Stock	0.417	0.4232	0.4091	0.4168	21274400.0
2001-06-27 17:00:00	AAPL	Stock	0.4161	0.4161	0.4161	0.4161	5600.0
2001-06-27 18:00:00	AAPL	Stock	0.417	0.417	0.417	0.417	16800.0
2001-06-27 08:00:00	MSFT	Stock	35.055	35.12	34.95	35.0	11000.0
2001-06-27 09:00:00	MSFT	Stock	34.995	35.0	34.68	34.8	6867400.0
2001-06-27 10:00:00	MSFT	Stock	34.8	35.025	34.75	34.91	6647400.0
2001-06-27 11:00:00	MSFT	Stock	34.905	35.4	34.9	35.3	6400000.0
2001-06-27 12:00:00	MSFT	Stock	35.315	35.35	35.145	35.21	2796000.0
2001-06-27 13:00:00	MSFT	Stock	35.21	35.275	35.055	35.095	7085200.0
2001-06-27 14:00:00	MSFT	Stock	35.095	35.23	34.875	35.2	13953200.0
2001-06-27 15:00:00	MSFT	Stock	35.2	35.765	35.045	35.57	18808800.0
2001-06-27 16:00:00	MSFT	Stock	35.57	35.62	34.93	35.55	3901800.0
2001-06-27 17:00:00	MSFT	Stock	35.55	35.61	35.55	35.57	22400.0
2001-06-27 18:00:00	MSFT	Stock	35.6	35.6	35.55	35.6	1400.0
2001-06-27 08:00:00	NVDA	Stock	0.3906	0.3921	0.3898	0.3898	5424000.0
2001-06-27 09:00:00	NVDA	Stock	0.389	0.3896	0.3819	0.3838	132192000.0
2001-06-27 10:00:00	NVDA	Stock	0.384	0.3859	0.38	0.3829	136416000.0
2001-06-27 11:00:00	NVDA	Stock	0.3828	0.3857	0.3828	0.3838	65184000.0
2001-06-27 12:00:00	NVDA	Stock	0.3838	0.385	0.3813	0.3842	44784000.0
2001-06-27 13:00:00	NVDA	Stock	0.3842	0.385	0.3813	0.3817	37080000.0
2001-06-27 14:00:00	NVDA	Stock	0.3815	0.3844	0.3719	0.3815	198408000.0
2001-06-27 15:00:00	NVDA	Stock	0.3815	0.3835	0.3773	0.3779	177120000.0
2001-06-27 16:00:00	NVDA	Stock	0.3788	0.379	0.3776	0.3785	13680000.0
2001-06-27 17:00:00	NVDA	Stock	0.3785	0.3785	0.3779	0.3779	240000.0
2001-06-27 08:00:00	AMZN	Stock	0.664	0.69	0.664	0.6825	392000.0
2001-06-27 09:00:00	AMZN	Stock	0.6825	0.7125	0.6775	0.7125	42222000.0
2001-06-27 10:00:00	AMZN	Stock	0.712	0.7125	0.69	0.69	20824000.0
2001-06-27 11:00:00	AMZN	Stock	0.6925	0.709	0.6925	0.705	14524000.0
2001-06-27 12:00:00	AMZN	Stock	0.705	0.7095	0.6985	0.7015	11708000.0
2001-06-27 13:00:00	AMZN	Stock	0.702	0.704	0.6965	0.6975	6854000.0
2001-06-27 14:00:00	AMZN	Stock	0.6975	0.705	0.6875	0.704	20810000.0
2001-06-27 15:00:00	AMZN	Stock	0.705	0.71	0.695	0.7015	28100000.0
2001-06-27 16:00:00	AMZN	Stock	0.702	0.711	0.6935	0.7005	2202000.0
2001-06-27 17:00:00	AMZN	Stock	0.702	0.704	0.701	0.703	56000.0
2001-06-27 09:00:00	CL	Stock	30.25	30.275	30.13	30.2	193400.0
2001-06-27 10:00:00	CL	Stock	30.2	30.285	30.15	30.21	266800.0
2001-06-27 11:00:00	CL	Stock	30.215	30.215	29.955	30.005	353800.0
2001-06-27 12:00:00	CL	Stock	30.005	30.195	30.005	30.135	255800.0
2001-06-27 13:00:00	CL	Stock	30.135	30.18	29.975	29.98	295000.0
2001-06-27 14:00:00	CL	Stock	29.975	30.15	29.96	30.1	527000.0
2001-06-27 15:00:00	CL	Stock	30.095	30.375	30.09	30.275	593800.0
2001-06-27 16:00:00	CL	Stock	30.275	30.3	30.17	30.17	208800.0

> showing 49 of 17,480 rows — these rows as CSV

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