PREVIEW / stock_1hour / 2008-10-21

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-21.parquet
  size:    799 KB
  rows:    40,297
  symbols: 3,339

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-21 04:00:00	AAPL	Stock	3.4675	3.4675	3.4675	3.4675	5600.0
2008-10-21 05:00:00	AAPL	Stock	3.4768	3.4768	3.4768	3.4768	2800.0
2008-10-21 06:00:00	AAPL	Stock	3.4846	3.5118	3.4846	3.5118	26600.0
2008-10-21 07:00:00	AAPL	Stock	3.5	3.5107	3.4571	3.4786	574336.0
2008-10-21 08:00:00	AAPL	Stock	3.4786	3.5204	3.4386	3.4557	5904808.0
2008-10-21 09:00:00	AAPL	Stock	3.4593	3.4786	3.4107	3.4607	179585056.0
2008-10-21 10:00:00	AAPL	Stock	3.4604	3.4964	3.3939	3.3971	253666280.0
2008-10-21 11:00:00	AAPL	Stock	3.3975	3.4211	3.3511	3.3546	206942120.0
2008-10-21 12:00:00	AAPL	Stock	3.3546	3.3621	3.2896	3.2936	239361584.0
2008-10-21 13:00:00	AAPL	Stock	3.2936	3.3646	3.2932	3.3375	165686696.0
2008-10-21 14:00:00	AAPL	Stock	3.3368	3.3746	3.3286	3.3375	236846092.0
2008-10-21 15:00:00	AAPL	Stock	3.3371	3.3632	3.2557	3.2632	453951848.0
2008-10-21 16:00:00	AAPL	Stock	3.2639	3.3746	3.25	3.3329	32383344.0
2008-10-21 17:00:00	AAPL	Stock	3.2143	3.6846	3.0357	3.6468	320296760.0
2008-10-21 18:00:00	AAPL	Stock	3.65	3.7132	3.6339	3.7107	53145344.0
2008-10-21 19:00:00	AAPL	Stock	3.7086	3.7493	3.6971	3.7004	14450436.0
2008-10-21 07:00:00	MSFT	Stock	24.25	24.25	24.25	24.25	1000.0
2008-10-21 08:00:00	MSFT	Stock	24.55	24.67	24.35	24.35	9977.0
2008-10-21 09:00:00	MSFT	Stock	24.3	24.58	24.22	24.54	7112231.0
2008-10-21 10:00:00	MSFT	Stock	24.53	25.01	24.51	24.52	15046921.0
2008-10-21 11:00:00	MSFT	Stock	24.52	24.82	24.2	24.23	12980973.0
2008-10-21 12:00:00	MSFT	Stock	24.23	24.55	23.83	23.84	12399292.0
2008-10-21 13:00:00	MSFT	Stock	23.84	24.22	23.83	24.06	9074826.0
2008-10-21 14:00:00	MSFT	Stock	24.065	24.4	24.03	24.18	12168370.0
2008-10-21 15:00:00	MSFT	Stock	24.18	24.44	23.27	23.34	26974148.0
2008-10-21 16:00:00	MSFT	Stock	23.34	24.739	23.2	23.25	3442089.0
2008-10-21 17:00:00	MSFT	Stock	23.25	23.99	23.21	23.85	238852.0
2008-10-21 18:00:00	MSFT	Stock	23.9	23.98	23.75	23.95	28451.0
2008-10-21 19:00:00	MSFT	Stock	23.95	23.98	23.86	23.94	12384.0
2008-10-21 08:00:00	NVDA	Stock	0.195	0.1998	0.1905	0.1905	47000.0
2008-10-21 09:00:00	NVDA	Stock	0.1905	0.192	0.1878	0.1895	55099240.0
2008-10-21 10:00:00	NVDA	Stock	0.1898	0.1933	0.189	0.1902	66428960.0
2008-10-21 11:00:00	NVDA	Stock	0.19	0.1913	0.1858	0.1865	52348040.0
2008-10-21 12:00:00	NVDA	Stock	0.1865	0.188	0.1835	0.1835	57486320.0
2008-10-21 13:00:00	NVDA	Stock	0.1835	0.1873	0.1833	0.1848	63524920.0
2008-10-21 14:00:00	NVDA	Stock	0.1848	0.1908	0.1843	0.1879	132833320.0
2008-10-21 15:00:00	NVDA	Stock	0.188	0.1898	0.179	0.1793	213436280.0
2008-10-21 16:00:00	NVDA	Stock	0.1793	0.1866	0.1788	0.1788	3455440.0
2008-10-21 17:00:00	NVDA	Stock	0.1795	0.1865	0.1788	0.1855	2359320.0
2008-10-21 18:00:00	NVDA	Stock	0.1855	0.1863	0.185	0.1853	800000.0
2008-10-21 19:00:00	NVDA	Stock	0.1853	0.1865	0.185	0.1865	330000.0
2008-10-21 07:00:00	AMZN	Stock	2.605	2.605	2.605	2.605	20000.0
2008-10-21 08:00:00	AMZN	Stock	2.6195	2.625	2.582	2.5825	62600.0
2008-10-21 09:00:00	AMZN	Stock	2.582	2.5995	2.525	2.582	29671440.0
2008-10-21 10:00:00	AMZN	Stock	2.58	2.6475	2.567	2.5952	31101700.0
2008-10-21 11:00:00	AMZN	Stock	2.594	2.6205	2.5555	2.5585	13797520.0
2008-10-21 12:00:00	AMZN	Stock	2.5595	2.5925	2.534	2.544	13373320.0
2008-10-21 13:00:00	AMZN	Stock	2.5445	2.561	2.506	2.5365	16169240.0
2008-10-21 14:00:00	AMZN	Stock	2.5385	2.612	2.5285	2.5735	18097680.0
2008-10-21 15:00:00	AMZN	Stock	2.5755	2.6	2.496	2.5115	41780500.0

> showing 50 of 40,297 rows — these rows as CSV

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