PREVIEW / stock_1hour / 2008-10-15

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-15.parquet
  size:    817 KB
  rows:    41,156
  symbols: 3,327

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-15 05:00:00	AAPL	Stock	3.7393	3.7904	3.7393	3.7857	25396.0
2008-10-15 06:00:00	AAPL	Stock	3.8018	3.8018	3.7929	3.7929	16800.0
2008-10-15 07:00:00	AAPL	Stock	3.7929	3.8014	3.7679	3.7768	586600.0
2008-10-15 08:00:00	AAPL	Stock	3.7732	3.7979	3.6521	3.6964	6684468.0
2008-10-15 09:00:00	AAPL	Stock	3.6964	3.8039	3.6557	3.7929	208825876.0
2008-10-15 10:00:00	AAPL	Stock	3.7914	3.8214	3.7032	3.7207	257159420.0
2008-10-15 11:00:00	AAPL	Stock	3.7207	3.7679	3.7089	3.7418	136377332.0
2008-10-15 12:00:00	AAPL	Stock	3.7418	3.7679	3.6786	3.7027	147250600.0
2008-10-15 13:00:00	AAPL	Stock	3.7025	3.7061	3.5757	3.59	189465192.0
2008-10-15 14:00:00	AAPL	Stock	3.5911	3.6884	3.5536	3.6321	269926216.0
2008-10-15 15:00:00	AAPL	Stock	3.6321	3.6704	3.4961	3.4982	292140464.0
2008-10-15 16:00:00	AAPL	Stock	3.4982	3.7171	3.4964	3.5	49729540.0
2008-10-15 17:00:00	AAPL	Stock	3.5036	3.5036	3.4561	3.4646	1125628.0
2008-10-15 18:00:00	AAPL	Stock	3.4629	3.4704	3.4286	3.4536	1170456.0
2008-10-15 19:00:00	AAPL	Stock	3.4486	3.4554	3.4379	3.4379	538356.0
2008-10-15 07:00:00	MSFT	Stock	24.1	24.14	24.1	24.12	950.0
2008-10-15 08:00:00	MSFT	Stock	24.01	24.02	23.67	23.67	58332.0
2008-10-15 09:00:00	MSFT	Stock	23.67	23.9	23.41	23.75	10242273.0
2008-10-15 10:00:00	MSFT	Stock	23.75	24.25	23.618	23.68	19100310.0
2008-10-15 11:00:00	MSFT	Stock	23.68	23.78	23.51	23.6	9528812.0
2008-10-15 12:00:00	MSFT	Stock	23.608	23.74	23.38	23.59	10388790.0
2008-10-15 13:00:00	MSFT	Stock	23.595	23.6	23.11	23.19	11390741.0
2008-10-15 14:00:00	MSFT	Stock	23.2	23.7	23.0	23.26	14470269.0
2008-10-15 15:00:00	MSFT	Stock	23.26	23.57	22.48	22.63	26443011.0
2008-10-15 16:00:00	MSFT	Stock	22.63	24.1	22.49	22.74	9552559.0
2008-10-15 17:00:00	MSFT	Stock	22.66	22.77	22.51	22.59	37304.0
2008-10-15 18:00:00	MSFT	Stock	22.6	26.32	22.5	22.55	11100.0
2008-10-15 19:00:00	MSFT	Stock	22.52	22.64	22.52	22.56	6400.0
2008-10-15 07:00:00	NVDA	Stock	0.1985	0.2053	0.197	0.2053	44000.0
2008-10-15 08:00:00	NVDA	Stock	0.2	0.2062	0.195	0.197	871400.0
2008-10-15 09:00:00	NVDA	Stock	0.1975	0.1995	0.19	0.195	89504560.0
2008-10-15 10:00:00	NVDA	Stock	0.1952	0.1965	0.189	0.1898	135376320.0
2008-10-15 11:00:00	NVDA	Stock	0.1898	0.192	0.1868	0.187	79952320.0
2008-10-15 12:00:00	NVDA	Stock	0.1868	0.1885	0.1828	0.1838	90567560.0
2008-10-15 13:00:00	NVDA	Stock	0.1838	0.184	0.179	0.181	121512920.0
2008-10-15 14:00:00	NVDA	Stock	0.1813	0.1865	0.18	0.1828	111337520.0
2008-10-15 15:00:00	NVDA	Stock	0.183	0.1853	0.1755	0.1755	185760480.0
2008-10-15 16:00:00	NVDA	Stock	0.1758	0.1968	0.175	0.1755	34335280.0
2008-10-15 17:00:00	NVDA	Stock	0.178	0.1788	0.1768	0.1768	297800.0
2008-10-15 18:00:00	NVDA	Stock	0.177	0.1775	0.1763	0.1763	77200.0
2008-10-15 19:00:00	NVDA	Stock	0.1755	0.18	0.175	0.18	232440.0
2008-10-15 08:00:00	AMZN	Stock	2.775	2.775	2.7175	2.725	125000.0
2008-10-15 09:00:00	AMZN	Stock	2.718	2.7345	2.625	2.6645	40924120.0
2008-10-15 10:00:00	AMZN	Stock	2.6605	2.671	2.5755	2.581	42222360.0
2008-10-15 11:00:00	AMZN	Stock	2.58	2.65	2.5355	2.5705	39926960.0
2008-10-15 12:00:00	AMZN	Stock	2.571	2.589	2.492	2.531	30558820.0
2008-10-15 13:00:00	AMZN	Stock	2.5315	2.5335	2.4175	2.478	44545920.0
2008-10-15 14:00:00	AMZN	Stock	2.4788	2.594	2.464	2.58	48566080.0
2008-10-15 15:00:00	AMZN	Stock	2.5785	2.593	2.43	2.436	54914460.0
2008-10-15 16:00:00	AMZN	Stock	2.4475	2.793	2.27	2.4355	7531620.0

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

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