PREVIEW / stock_1hour / 2008-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-04.parquet
  size:    808 KB
  rows:    39,970
  symbols: 3,240

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-02-04 04:00:00	AAPL	Stock	4.7857	4.7857	4.7857	4.7857	7000.0
2008-02-04 06:00:00	AAPL	Stock	4.7825	4.8032	4.7804	4.8032	30436.0
2008-02-04 07:00:00	AAPL	Stock	4.7921	4.8182	4.7829	4.8	180880.0
2008-02-04 08:00:00	AAPL	Stock	4.7961	4.8054	4.7768	4.7893	1319976.0
2008-02-04 09:00:00	AAPL	Stock	4.7857	4.8532	4.7768	4.8407	131447988.0
2008-02-04 10:00:00	AAPL	Stock	4.84	4.8536	4.8082	4.8343	140193396.0
2008-02-04 11:00:00	AAPL	Stock	4.8343	4.8482	4.7643	4.7682	129534244.0
2008-02-04 12:00:00	AAPL	Stock	4.7693	4.7736	4.7286	4.7436	113513568.0
2008-02-04 13:00:00	AAPL	Stock	4.7434	4.7511	4.7036	4.7493	116852820.0
2008-02-04 14:00:00	AAPL	Stock	4.7491	4.7491	4.6936	4.7193	117969236.0
2008-02-04 15:00:00	AAPL	Stock	4.7196	4.7307	4.7014	4.7039	121991660.0
2008-02-04 16:00:00	AAPL	Stock	4.7036	4.7768	4.6964	4.7014	26894644.0
2008-02-04 17:00:00	AAPL	Stock	4.7014	4.7057	4.7011	4.7036	323848.0
2008-02-04 18:00:00	AAPL	Stock	4.7036	4.7143	4.6982	4.7	543732.0
2008-02-04 19:00:00	AAPL	Stock	4.6982	4.7036	4.6968	4.6968	220304.0
2008-02-04 06:00:00	MSFT	Stock	30.72	30.72	30.72	30.72	1000.0
2008-02-04 07:00:00	MSFT	Stock	30.72	30.72	30.53	30.56	31676.0
2008-02-04 08:00:00	MSFT	Stock	30.58	30.75	30.5	30.64	621391.0
2008-02-04 09:00:00	MSFT	Stock	30.64	30.65	30.25	30.5	17832038.0
2008-02-04 10:00:00	MSFT	Stock	30.5	30.53	30.27	30.52	24129576.0
2008-02-04 11:00:00	MSFT	Stock	30.52	30.61	30.48	30.53	13733023.0
2008-02-04 12:00:00	MSFT	Stock	30.527	30.66	30.45	30.538	11955746.0
2008-02-04 13:00:00	MSFT	Stock	30.538	30.72	30.46	30.7	10055547.0
2008-02-04 14:00:00	MSFT	Stock	30.7	30.71	30.45	30.52	11409597.0
2008-02-04 15:00:00	MSFT	Stock	30.52	30.57	30.11	30.19	20985316.0
2008-02-04 16:00:00	MSFT	Stock	30.18	30.53	30.13	30.16	9228645.0
2008-02-04 17:00:00	MSFT	Stock	30.16	30.577	30.13	30.15	29586.0
2008-02-04 18:00:00	MSFT	Stock	30.16	30.2	30.12	30.2	15958.0
2008-02-04 19:00:00	MSFT	Stock	30.2	30.2	30.12	30.18	5767.0
2008-02-04 08:00:00	NVDA	Stock	0.68	0.68	0.675	0.68	102000.0
2008-02-04 09:00:00	NVDA	Stock	0.676	0.6898	0.6713	0.6765	65191400.0
2008-02-04 10:00:00	NVDA	Stock	0.6765	0.6778	0.657	0.6595	90753840.0
2008-02-04 11:00:00	NVDA	Stock	0.6595	0.6633	0.654	0.6578	58150520.0
2008-02-04 12:00:00	NVDA	Stock	0.6578	0.659	0.6525	0.656	48654840.0
2008-02-04 13:00:00	NVDA	Stock	0.6562	0.6578	0.6508	0.6572	48731400.0
2008-02-04 14:00:00	NVDA	Stock	0.6575	0.6575	0.647	0.6518	79748760.0
2008-02-04 15:00:00	NVDA	Stock	0.652	0.655	0.6492	0.6505	97672160.0
2008-02-04 16:00:00	NVDA	Stock	0.6515	0.6595	0.649	0.6505	69058480.0
2008-02-04 17:00:00	NVDA	Stock	0.6505	0.6591	0.647	0.6528	6552000.0
2008-02-04 18:00:00	NVDA	Stock	0.65	0.6525	0.65	0.6525	24000.0
2008-02-04 19:00:00	NVDA	Stock	0.6525	0.653	0.65	0.653	200800.0
2008-02-04 06:00:00	AMZN	Stock	3.7395	3.7395	3.7315	3.7315	4200.0
2008-02-04 08:00:00	AMZN	Stock	3.73	3.75	3.725	3.729	49100.0
2008-02-04 09:00:00	AMZN	Stock	3.7425	3.7825	3.7155	3.7775	19527260.0
2008-02-04 10:00:00	AMZN	Stock	3.7775	3.8095	3.746	3.802	34058620.0
2008-02-04 11:00:00	AMZN	Stock	3.803	3.833	3.7875	3.796	22389380.0
2008-02-04 12:00:00	AMZN	Stock	3.795	3.7962	3.7165	3.727	23675880.0
2008-02-04 13:00:00	AMZN	Stock	3.727	3.7385	3.709	3.719	22203200.0
2008-02-04 14:00:00	AMZN	Stock	3.718	3.725	3.705	3.7205	19456340.0
2008-02-04 15:00:00	AMZN	Stock	3.72	3.758	3.695	3.6975	35395700.0

> showing 50 of 39,970 rows — these rows as CSV

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