PREVIEW / stock_1hour / 2008-11-26

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-26.parquet
  size:    792 KB
  rows:    40,092
  symbols: 3,351

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-26 07:00:00	AAPL	Stock	3.225	3.225	3.2071	3.2071	78400.0
2008-11-26 08:00:00	AAPL	Stock	3.1964	3.2304	3.1821	3.2046	2208752.0
2008-11-26 09:00:00	AAPL	Stock	3.2071	3.3204	3.2036	3.3046	111393016.0
2008-11-26 10:00:00	AAPL	Stock	3.3046	3.375	3.3	3.3561	169441468.0
2008-11-26 11:00:00	AAPL	Stock	3.3571	3.3929	3.3386	3.3686	115319624.0
2008-11-26 12:00:00	AAPL	Stock	3.3696	3.3861	3.3396	3.3818	80627092.0
2008-11-26 13:00:00	AAPL	Stock	3.3825	3.3889	3.3239	3.3296	90622980.0
2008-11-26 14:00:00	AAPL	Stock	3.3296	3.3929	3.3161	3.3854	121909648.0
2008-11-26 15:00:00	AAPL	Stock	3.3854	3.4018	3.3421	3.3964	173377736.0
2008-11-26 16:00:00	AAPL	Stock	3.3982	3.3982	3.2968	3.3893	23022216.0
2008-11-26 17:00:00	AAPL	Stock	3.3911	3.4043	3.3896	3.3911	1166144.0
2008-11-26 18:00:00	AAPL	Stock	3.3925	3.3929	3.39	3.3911	309596.0
2008-11-26 19:00:00	AAPL	Stock	3.3929	3.3946	3.3896	3.3896	364392.0
2008-11-26 07:00:00	MSFT	Stock	19.73	19.73	19.7	19.7	1538.0
2008-11-26 08:00:00	MSFT	Stock	19.86	19.86	19.67	19.75	30132.0
2008-11-26 09:00:00	MSFT	Stock	19.76	20.39	19.73	20.35	5837895.0
2008-11-26 10:00:00	MSFT	Stock	20.36	20.49	20.1	20.42	10260142.0
2008-11-26 11:00:00	MSFT	Stock	20.43	20.63	20.32	20.36	8869981.0
2008-11-26 12:00:00	MSFT	Stock	20.36	20.42	20.2	20.32	5917865.0
2008-11-26 13:00:00	MSFT	Stock	20.33	20.45	20.25	20.27	5255944.0
2008-11-26 14:00:00	MSFT	Stock	20.27	20.4	20.17	20.34	8061656.0
2008-11-26 15:00:00	MSFT	Stock	20.34	20.49	20.13	20.49	15438103.0
2008-11-26 16:00:00	MSFT	Stock	20.49	20.494	19.99	20.49	18933963.0
2008-11-26 17:00:00	MSFT	Stock	20.37	20.4	20.37	20.37	2827.0
2008-11-26 18:00:00	MSFT	Stock	20.37	20.4	20.37	20.39	2350.0
2008-11-26 19:00:00	MSFT	Stock	20.39	20.39	20.36	20.39	1645.0
2008-11-26 08:00:00	NVDA	Stock	0.1725	0.1725	0.1705	0.1705	48000.0
2008-11-26 09:00:00	NVDA	Stock	0.1723	0.1785	0.1708	0.1775	52980880.0
2008-11-26 10:00:00	NVDA	Stock	0.1775	0.1825	0.1768	0.182	111415160.0
2008-11-26 11:00:00	NVDA	Stock	0.182	0.1868	0.1808	0.1855	80671600.0
2008-11-26 12:00:00	NVDA	Stock	0.1858	0.186	0.1816	0.1848	75174680.0
2008-11-26 13:00:00	NVDA	Stock	0.1848	0.1863	0.1823	0.185	51168040.0
2008-11-26 14:00:00	NVDA	Stock	0.185	0.1895	0.184	0.1888	65988840.0
2008-11-26 15:00:00	NVDA	Stock	0.1888	0.1908	0.1865	0.1903	122963760.0
2008-11-26 16:00:00	NVDA	Stock	0.19	0.1915	0.1771	0.1903	21732720.0
2008-11-26 17:00:00	NVDA	Stock	0.1915	0.1925	0.1913	0.1913	178600.0
2008-11-26 07:00:00	AMZN	Stock	2.1	2.1	2.093	2.093	6000.0
2008-11-26 08:00:00	AMZN	Stock	2.062	2.066	2.0255	2.03	139440.0
2008-11-26 09:00:00	AMZN	Stock	2.039	2.0885	2.0145	2.036	30810940.0
2008-11-26 10:00:00	AMZN	Stock	2.035	2.0875	2.027	2.0625	34895460.0
2008-11-26 11:00:00	AMZN	Stock	2.0625	2.081	2.052	2.072	30182020.0
2008-11-26 12:00:00	AMZN	Stock	2.0725	2.0985	2.0525	2.092	23807300.0
2008-11-26 13:00:00	AMZN	Stock	2.0935	2.1345	2.0885	2.106	35102020.0
2008-11-26 14:00:00	AMZN	Stock	2.1045	2.181	2.0825	2.166	35873300.0
2008-11-26 15:00:00	AMZN	Stock	2.167	2.2	2.1495	2.198	64742860.0
2008-11-26 16:00:00	AMZN	Stock	2.203	2.2105	2.1064	2.2	3897320.0
2008-11-26 17:00:00	AMZN	Stock	2.215	2.225	2.21	2.225	93600.0
2008-11-26 18:00:00	AMZN	Stock	2.225	2.237	2.2055	2.2275	106000.0
2008-11-26 08:00:00	TLT	Stock	104.25	104.25	104.0	104.0	10400.0
2008-11-26 09:00:00	TLT	Stock	104.25	105.17	104.25	105.0	156469.0

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

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