PREVIEW / stock_1hour / 2008-02-14

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-14.parquet
  size:    790 KB
  rows:    39,448
  symbols: 3,229

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-14 04:00:00	AAPL	Stock	4.6621	4.6621	4.6621	4.6621	2800.0
2008-02-14 05:00:00	AAPL	Stock	4.6621	4.6621	4.6543	4.6543	30800.0
2008-02-14 06:00:00	AAPL	Stock	4.6432	4.6593	4.6429	4.6429	53200.0
2008-02-14 07:00:00	AAPL	Stock	4.6436	4.6607	4.6436	4.6482	181440.0
2008-02-14 08:00:00	AAPL	Stock	4.6464	4.6564	4.6325	4.6361	2805152.0
2008-02-14 09:00:00	AAPL	Stock	4.6389	4.6425	4.5586	4.6014	132846588.0
2008-02-14 10:00:00	AAPL	Stock	4.6011	4.6714	4.5804	4.5811	215739160.0
2008-02-14 11:00:00	AAPL	Stock	4.5811	4.5989	4.5607	4.5875	147582008.0
2008-02-14 12:00:00	AAPL	Stock	4.5882	4.6171	4.5714	4.5732	88433996.0
2008-02-14 13:00:00	AAPL	Stock	4.5729	4.5921	4.5546	4.5818	94913532.0
2008-02-14 14:00:00	AAPL	Stock	4.5818	4.5971	4.5443	4.5523	106311436.0
2008-02-14 15:00:00	AAPL	Stock	4.5543	4.575	4.5361	4.5536	151500468.0
2008-02-14 16:00:00	AAPL	Stock	4.5528	4.6529	4.5468	4.5536	13371344.0
2008-02-14 17:00:00	AAPL	Stock	4.5536	4.5571	4.5454	4.5454	326060.0
2008-02-14 18:00:00	AAPL	Stock	4.5543	4.5546	4.55	4.55	163408.0
2008-02-14 19:00:00	AAPL	Stock	4.55	4.5543	4.5379	4.5379	310044.0
2008-02-14 08:00:00	MSFT	Stock	29.0	29.05	28.86	28.93	25951.0
2008-02-14 09:00:00	MSFT	Stock	28.9	29.03	28.6	28.95	9451639.0
2008-02-14 10:00:00	MSFT	Stock	28.96	29.04	28.77	28.82	9432189.0
2008-02-14 11:00:00	MSFT	Stock	28.82	28.84	28.672	28.72	10835555.0
2008-02-14 12:00:00	MSFT	Stock	28.73	28.81	28.65	28.66	6594533.0
2008-02-14 13:00:00	MSFT	Stock	28.66	28.74	28.62	28.65	6300032.0
2008-02-14 14:00:00	MSFT	Stock	28.66	28.71	28.46	28.56	8357687.0
2008-02-14 15:00:00	MSFT	Stock	28.56	28.7	28.47	28.52	14442141.0
2008-02-14 16:00:00	MSFT	Stock	28.52	29.08	28.49	28.5	2832872.0
2008-02-14 17:00:00	MSFT	Stock	28.56	28.56	28.5	28.52	20950.0
2008-02-14 18:00:00	MSFT	Stock	28.58	28.58	28.5	28.52	904620.0
2008-02-14 19:00:00	MSFT	Stock	28.52	28.55	28.46	28.46	17256.0
2008-02-14 07:00:00	NVDA	Stock	0.6798	0.685	0.6798	0.6825	48000.0
2008-02-14 08:00:00	NVDA	Stock	0.6875	0.6875	0.66	0.6638	1998440.0
2008-02-14 09:00:00	NVDA	Stock	0.664	0.664	0.595	0.6055	411962480.0
2008-02-14 10:00:00	NVDA	Stock	0.6053	0.6098	0.5818	0.5895	496377400.0
2008-02-14 11:00:00	NVDA	Stock	0.5893	0.6562	0.5853	0.5893	218480640.0
2008-02-14 12:00:00	NVDA	Stock	0.5893	0.5938	0.5828	0.588	188590560.0
2008-02-14 13:00:00	NVDA	Stock	0.5883	0.589	0.58	0.585	198001400.0
2008-02-14 14:00:00	NVDA	Stock	0.585	0.5868	0.5695	0.5738	240510480.0
2008-02-14 15:00:00	NVDA	Stock	0.574	0.5765	0.5638	0.5655	359572960.0
2008-02-14 16:00:00	NVDA	Stock	0.5652	0.6032	0.5625	0.5668	51763760.0
2008-02-14 17:00:00	NVDA	Stock	0.5662	0.5672	0.5655	0.5672	471600.0
2008-02-14 18:00:00	NVDA	Stock	0.5688	0.5692	0.5662	0.567	402200.0
2008-02-14 19:00:00	NVDA	Stock	0.5675	0.575	0.565	0.5682	2773760.0
2008-02-14 08:00:00	AMZN	Stock	3.9145	3.9145	3.8865	3.8875	55000.0
2008-02-14 09:00:00	AMZN	Stock	3.8905	3.894	3.823	3.858	20389400.0
2008-02-14 10:00:00	AMZN	Stock	3.8595	3.8775	3.8105	3.8125	28599840.0
2008-02-14 11:00:00	AMZN	Stock	3.812	3.827	3.788	3.8225	19277400.0
2008-02-14 12:00:00	AMZN	Stock	3.8225	3.84	3.793	3.7965	12790280.0
2008-02-14 13:00:00	AMZN	Stock	3.7975	3.814	3.78	3.803	16790320.0
2008-02-14 14:00:00	AMZN	Stock	3.8045	3.812	3.759	3.795	19465080.0
2008-02-14 15:00:00	AMZN	Stock	3.7925	3.813	3.78	3.79	28178620.0
2008-02-14 16:00:00	AMZN	Stock	3.79	3.919	3.7895	3.7985	4363820.0

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

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