PREVIEW / stock_1hour / 2008-03-13

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-13.parquet
  size:    821 KB
  rows:    41,572
  symbols: 3,270

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
2008-03-13 04:00:00	AAPL	Stock	4.4732	4.4732	4.4554	4.4554	30800.0
2008-03-13 05:00:00	AAPL	Stock	4.4375	4.4375	4.4375	4.4375	8400.0
2008-03-13 06:00:00	AAPL	Stock	4.4318	4.4318	4.4318	4.4318	16800.0
2008-03-13 07:00:00	AAPL	Stock	4.4314	4.4375	4.4239	4.4286	224980.0
2008-03-13 08:00:00	AAPL	Stock	4.4389	4.4539	4.4186	4.4211	4484088.0
2008-03-13 09:00:00	AAPL	Stock	4.4214	4.4575	4.4014	4.4221	141651412.0
2008-03-13 10:00:00	AAPL	Stock	4.4221	4.4661	4.3929	4.415	187536608.0
2008-03-13 11:00:00	AAPL	Stock	4.4157	4.4861	4.4057	4.4832	180049072.0
2008-03-13 12:00:00	AAPL	Stock	4.4832	4.5075	4.4414	4.4639	122194604.0
2008-03-13 13:00:00	AAPL	Stock	4.4639	4.5754	4.4564	4.5557	172500496.0
2008-03-13 14:00:00	AAPL	Stock	4.5529	4.5836	4.5364	4.5836	161710920.0
2008-03-13 15:00:00	AAPL	Stock	4.5839	4.625	4.5425	4.5693	252774704.0
2008-03-13 16:00:00	AAPL	Stock	4.5693	4.5864	4.4929	4.575	38397324.0
2008-03-13 17:00:00	AAPL	Stock	4.5693	4.5821	4.5693	4.5718	1188768.0
2008-03-13 18:00:00	AAPL	Stock	4.5732	4.5964	4.5718	4.5918	1679076.0
2008-03-13 19:00:00	AAPL	Stock	4.5946	4.5961	4.5879	4.5961	498288.0
2008-03-13 07:00:00	MSFT	Stock	28.34	28.35	28.32	28.34	3548.0
2008-03-13 08:00:00	MSFT	Stock	28.35	28.41	28.29	28.4	22017.0
2008-03-13 09:00:00	MSFT	Stock	28.39	28.73	28.34	28.57	7030807.0
2008-03-13 10:00:00	MSFT	Stock	28.57	28.68	28.16	28.37	13387305.0
2008-03-13 11:00:00	MSFT	Stock	28.37	28.78	28.36	28.575	12414408.0
2008-03-13 12:00:00	MSFT	Stock	28.58	28.71	28.43	28.49	7510569.0
2008-03-13 13:00:00	MSFT	Stock	28.49	28.9	28.46	28.84	9114072.0
2008-03-13 14:00:00	MSFT	Stock	28.84	28.99	28.75	28.82	12307107.0
2008-03-13 15:00:00	MSFT	Stock	28.82	28.9	28.54	28.62	18533859.0
2008-03-13 16:00:00	MSFT	Stock	28.62	28.781	28.55	28.6	4140390.0
2008-03-13 17:00:00	MSFT	Stock	28.62	28.643	28.6	28.6	86328.0
2008-03-13 18:00:00	MSFT	Stock	28.61	28.62	28.6	28.62	4629.0
2008-03-13 19:00:00	MSFT	Stock	28.63	28.63	28.63	28.63	2100.0
2008-03-13 08:00:00	NVDA	Stock	0.4508	0.4575	0.4508	0.4555	120400.0
2008-03-13 09:00:00	NVDA	Stock	0.4558	0.4643	0.453	0.46	69994680.0
2008-03-13 10:00:00	NVDA	Stock	0.46	0.466	0.4572	0.465	169993520.0
2008-03-13 11:00:00	NVDA	Stock	0.465	0.481	0.4615	0.4785	236758200.0
2008-03-13 12:00:00	NVDA	Stock	0.4785	0.483	0.4742	0.4793	124383800.0
2008-03-13 13:00:00	NVDA	Stock	0.4793	0.4948	0.4785	0.4928	151100400.0
2008-03-13 14:00:00	NVDA	Stock	0.4928	0.4982	0.4905	0.493	178919960.0
2008-03-13 15:00:00	NVDA	Stock	0.493	0.4995	0.4918	0.4923	215616000.0
2008-03-13 16:00:00	NVDA	Stock	0.4923	0.4935	0.4658	0.4925	72923000.0
2008-03-13 17:00:00	NVDA	Stock	0.4925	0.4925	0.463	0.4925	524160.0
2008-03-13 18:00:00	NVDA	Stock	0.4925	0.4925	0.4925	0.4925	88000.0
2008-03-13 19:00:00	NVDA	Stock	0.4925	0.4948	0.4925	0.4948	47400.0
2008-03-13 04:00:00	AMZN	Stock	3.2865	3.2865	3.2865	3.2865	4000.0
2008-03-13 07:00:00	AMZN	Stock	3.265	3.265	3.265	3.265	10000.0
2008-03-13 08:00:00	AMZN	Stock	3.252	3.281	3.245	3.25	338200.0
2008-03-13 09:00:00	AMZN	Stock	3.266	3.2865	3.2183	3.24	15546240.0
2008-03-13 10:00:00	AMZN	Stock	3.24	3.2685	3.2305	3.2445	19950020.0
2008-03-13 11:00:00	AMZN	Stock	3.244	3.3995	3.235	3.345	46872480.0
2008-03-13 12:00:00	AMZN	Stock	3.346	3.3735	3.325	3.348	22572740.0
2008-03-13 13:00:00	AMZN	Stock	3.348	3.4615	3.3325	3.448	32016640.0
2008-03-13 14:00:00	AMZN	Stock	3.448	3.4775	3.421	3.4405	30944120.0

> showing 50 of 41,572 rows — these rows as CSV

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