PREVIEW / stock_1hour / 2008-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-28.parquet
  size:    815 KB
  rows:    41,209
  symbols: 3,368

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-10-28 04:00:00	AAPL	Stock	3.3264	3.4221	3.3264	3.4107	16800.0
2008-10-28 05:00:00	AAPL	Stock	3.3857	3.3929	3.375	3.3929	64316.0
2008-10-28 06:00:00	AAPL	Stock	3.4096	3.4096	3.3661	3.3661	47600.0
2008-10-28 07:00:00	AAPL	Stock	3.4014	3.4357	3.3964	3.41	664468.0
2008-10-28 08:00:00	AAPL	Stock	3.4018	3.4107	3.3786	3.3975	5905396.0
2008-10-28 09:00:00	AAPL	Stock	3.3971	3.4286	3.3671	3.4025	174845160.0
2008-10-28 10:00:00	AAPL	Stock	3.4029	3.4143	3.2989	3.3121	280567420.0
2008-10-28 11:00:00	AAPL	Stock	3.3118	3.3821	3.3089	3.3411	179575200.0
2008-10-28 12:00:00	AAPL	Stock	3.3411	3.375	3.3271	3.3629	121857428.0
2008-10-28 13:00:00	AAPL	Stock	3.3625	3.3875	3.3182	3.3254	141676948.0
2008-10-28 14:00:00	AAPL	Stock	3.3254	3.4414	3.3221	3.4346	227049088.0
2008-10-28 15:00:00	AAPL	Stock	3.4343	3.5875	3.4143	3.5771	415676912.0
2008-10-28 16:00:00	AAPL	Stock	3.5757	3.5957	3.4039	3.575	64164856.0
2008-10-28 17:00:00	AAPL	Stock	3.5721	3.5804	3.5714	3.5804	944944.0
2008-10-28 18:00:00	AAPL	Stock	3.5804	3.6196	3.5804	3.6	3303524.0
2008-10-28 19:00:00	AAPL	Stock	3.6	3.6064	3.5875	3.5893	1080688.0
2008-10-28 07:00:00	MSFT	Stock	21.75	21.78	21.7	21.73	23095.0
2008-10-28 08:00:00	MSFT	Stock	21.67	21.75	21.55	21.65	212519.0
2008-10-28 09:00:00	MSFT	Stock	21.65	22.2	21.55	22.02	11776851.0
2008-10-28 10:00:00	MSFT	Stock	22.02	22.08	21.34	21.43	19604933.0
2008-10-28 11:00:00	MSFT	Stock	21.43	21.7	21.38	21.56	11610971.0
2008-10-28 12:00:00	MSFT	Stock	21.54	21.89	21.44	21.78	9961446.0
2008-10-28 13:00:00	MSFT	Stock	21.77	22.0	21.62	21.69	8621598.0
2008-10-28 14:00:00	MSFT	Stock	21.69	22.43	21.66	22.36	14592449.0
2008-10-28 15:00:00	MSFT	Stock	22.36	23.21	22.26	23.14	37962015.0
2008-10-28 16:00:00	MSFT	Stock	23.14	23.21	21.85	23.05	18074453.0
2008-10-28 17:00:00	MSFT	Stock	23.06	23.13	22.99	23.01	37957.0
2008-10-28 18:00:00	MSFT	Stock	23.02	23.05	22.99	22.99	27035.0
2008-10-28 19:00:00	MSFT	Stock	22.99	23.03	22.99	22.99	10470.0
2008-10-28 08:00:00	NVDA	Stock	0.1785	0.1863	0.1785	0.1848	433000.0
2008-10-28 09:00:00	NVDA	Stock	0.1863	0.187	0.1823	0.1843	117714240.0
2008-10-28 10:00:00	NVDA	Stock	0.1843	0.1843	0.1803	0.182	130441960.0
2008-10-28 11:00:00	NVDA	Stock	0.182	0.1888	0.182	0.1848	109251280.0
2008-10-28 12:00:00	NVDA	Stock	0.1848	0.1849	0.1815	0.1823	59180760.0
2008-10-28 13:00:00	NVDA	Stock	0.1823	0.186	0.1813	0.1823	50945160.0
2008-10-28 14:00:00	NVDA	Stock	0.1823	0.19	0.1815	0.1893	90596880.0
2008-10-28 15:00:00	NVDA	Stock	0.1893	0.2007	0.1885	0.2	238586040.0
2008-10-28 16:00:00	NVDA	Stock	0.1998	0.2013	0.1875	0.2005	13477600.0
2008-10-28 17:00:00	NVDA	Stock	0.1879	0.2007	0.1879	0.2	832960.0
2008-10-28 18:00:00	NVDA	Stock	0.2	0.2	0.1988	0.1988	118280.0
2008-10-28 19:00:00	NVDA	Stock	0.1988	0.1988	0.197	0.197	46400.0
2008-10-28 08:00:00	AMZN	Stock	2.6115	2.6115	2.575	2.5765	390620.0
2008-10-28 09:00:00	AMZN	Stock	2.574	2.645	2.5395	2.6075	31466940.0
2008-10-28 10:00:00	AMZN	Stock	2.6075	2.609	2.4535	2.4695	51639500.0
2008-10-28 11:00:00	AMZN	Stock	2.472	2.5925	2.4715	2.551	28198780.0
2008-10-28 12:00:00	AMZN	Stock	2.5505	2.5885	2.5458	2.567	17959700.0
2008-10-28 13:00:00	AMZN	Stock	2.567	2.612	2.556	2.5765	23293800.0
2008-10-28 14:00:00	AMZN	Stock	2.5755	2.7365	2.5705	2.7235	50189960.0
2008-10-28 15:00:00	AMZN	Stock	2.7235	2.815	2.6905	2.813	79334820.0
2008-10-28 16:00:00	AMZN	Stock	2.8095	2.8125	2.6678	2.779	11734260.0

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

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