PREVIEW / stock_1hour / 2008-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-14.parquet
  size:    791 KB
  rows:    40,081
  symbols: 3,296

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-11-14 07:00:00	AAPL	Stock	3.4071	3.4071	3.3789	3.3789	5600.0
2008-11-14 08:00:00	AAPL	Stock	3.3954	3.4039	3.3393	3.3718	4334596.0
2008-11-14 09:00:00	AAPL	Stock	3.3707	3.3825	3.2618	3.2875	218036224.0
2008-11-14 10:00:00	AAPL	Stock	3.2871	3.3086	3.2411	3.2739	220233496.0
2008-11-14 11:00:00	AAPL	Stock	3.2743	3.2925	3.2357	3.2429	157260572.0
2008-11-14 12:00:00	AAPL	Stock	3.2421	3.2857	3.2289	3.2753	137540536.0
2008-11-14 13:00:00	AAPL	Stock	3.2745	3.2943	3.2475	3.2764	136357760.0
2008-11-14 14:00:00	AAPL	Stock	3.2764	3.3518	3.2687	3.3464	228962804.0
2008-11-14 15:00:00	AAPL	Stock	3.3464	3.3568	3.2143	3.2214	269458896.0
2008-11-14 16:00:00	AAPL	Stock	3.2211	3.2924	3.1943	3.21	21940576.0
2008-11-14 17:00:00	AAPL	Stock	3.2229	3.2232	3.2082	3.2232	1006684.0
2008-11-14 18:00:00	AAPL	Stock	3.2214	3.2229	3.2132	3.2143	574336.0
2008-11-14 19:00:00	AAPL	Stock	3.2143	3.2232	3.2125	3.2225	268436.0
2008-11-14 04:00:00	MSFT	Stock	21.0	21.0	21.0	21.0	100.0
2008-11-14 05:00:00	MSFT	Stock	21.01	21.01	21.01	21.01	100.0
2008-11-14 07:00:00	MSFT	Stock	21.0	21.01	20.96	21.0	3600.0
2008-11-14 08:00:00	MSFT	Stock	21.01	21.1	20.55	20.75	80302.0
2008-11-14 09:00:00	MSFT	Stock	20.73	20.82	20.4	20.7	8386574.0
2008-11-14 10:00:00	MSFT	Stock	20.69	20.77	20.26	20.27	10307732.0
2008-11-14 11:00:00	MSFT	Stock	20.27	20.29	20.078	20.11	9376684.0
2008-11-14 12:00:00	MSFT	Stock	20.11	20.24	19.84	20.19	8378714.0
2008-11-14 13:00:00	MSFT	Stock	20.19	20.49	19.91	20.36	9397295.0
2008-11-14 14:00:00	MSFT	Stock	20.36	21.1	20.33	21.06	13696270.0
2008-11-14 15:00:00	MSFT	Stock	21.06	21.34	19.65	19.976	31349056.0
2008-11-14 16:00:00	MSFT	Stock	19.93	20.6	19.81	19.96	4515673.0
2008-11-14 17:00:00	MSFT	Stock	20.06	20.06	19.95	20.05	95468.0
2008-11-14 18:00:00	MSFT	Stock	20.06	20.08	20.01	20.06	87391.0
2008-11-14 19:00:00	MSFT	Stock	20.06	20.08	20.02	20.06	9015.0
2008-11-14 08:00:00	NVDA	Stock	0.1868	0.1903	0.1868	0.19	52000.0
2008-11-14 09:00:00	NVDA	Stock	0.19	0.1915	0.185	0.1853	73419160.0
2008-11-14 10:00:00	NVDA	Stock	0.1855	0.1863	0.1808	0.1818	118644000.0
2008-11-14 11:00:00	NVDA	Stock	0.1818	0.186	0.1805	0.1813	62895560.0
2008-11-14 12:00:00	NVDA	Stock	0.1813	0.1855	0.1785	0.1845	52907160.0
2008-11-14 13:00:00	NVDA	Stock	0.1843	0.1858	0.181	0.184	47737040.0
2008-11-14 14:00:00	NVDA	Stock	0.184	0.1888	0.1835	0.188	101070040.0
2008-11-14 15:00:00	NVDA	Stock	0.1883	0.1888	0.179	0.1793	146397680.0
2008-11-14 16:00:00	NVDA	Stock	0.1793	0.1848	0.1773	0.1793	136707040.0
2008-11-14 17:00:00	NVDA	Stock	0.1793	0.1803	0.1791	0.1793	293640.0
2008-11-14 18:00:00	NVDA	Stock	0.18	0.18	0.18	0.18	41520.0
2008-11-14 19:00:00	NVDA	Stock	0.18	0.1813	0.18	0.1813	76840.0
2008-11-14 08:00:00	AMZN	Stock	2.19	2.2155	2.1605	2.2155	84000.0
2008-11-14 09:00:00	AMZN	Stock	2.215	2.215	2.1145	2.1545	28929380.0
2008-11-14 10:00:00	AMZN	Stock	2.1545	2.218	2.128	2.1385	43631880.0
2008-11-14 11:00:00	AMZN	Stock	2.1385	2.15	2.097	2.108	27990020.0
2008-11-14 12:00:00	AMZN	Stock	2.1095	2.1605	2.0775	2.1467	22795260.0
2008-11-14 13:00:00	AMZN	Stock	2.1465	2.1515	2.0875	2.1215	20254140.0
2008-11-14 14:00:00	AMZN	Stock	2.1215	2.225	2.116	2.2215	41258520.0
2008-11-14 15:00:00	AMZN	Stock	2.2195	2.225	2.075	2.0875	45678020.0
2008-11-14 16:00:00	AMZN	Stock	2.0875	2.1781	2.0755	2.093	5897360.0
2008-11-14 17:00:00	AMZN	Stock	2.0875	2.0985	2.0872	2.0872	68020.0

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

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