PREVIEW / stock_1hour / 2008-12-04

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-04.parquet
  size:    777 KB
  rows:    39,462
  symbols: 3,337

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-12-04 05:00:00	AAPL	Stock	3.4257	3.4643	3.4257	3.4643	8400.0
2008-12-04 06:00:00	AAPL	Stock	3.45	3.4529	3.45	3.4529	16800.0
2008-12-04 07:00:00	AAPL	Stock	3.425	3.425	3.4036	3.4143	152180.0
2008-12-04 08:00:00	AAPL	Stock	3.4111	3.4111	3.375	3.3861	3552192.0
2008-12-04 09:00:00	AAPL	Stock	3.3854	3.4004	3.3125	3.3714	167620516.0
2008-12-04 10:00:00	AAPL	Stock	3.3711	3.3911	3.3036	3.3793	209425804.0
2008-12-04 11:00:00	AAPL	Stock	3.3793	3.3871	3.3129	3.3257	126802704.0
2008-12-04 12:00:00	AAPL	Stock	3.3257	3.3525	3.2954	3.3379	90931792.0
2008-12-04 13:00:00	AAPL	Stock	3.3386	3.3386	3.2889	3.3146	84989632.0
2008-12-04 14:00:00	AAPL	Stock	3.3146	3.3336	3.2768	3.2807	111325564.0
2008-12-04 15:00:00	AAPL	Stock	3.2807	3.2882	3.1807	3.2675	267476860.0
2008-12-04 16:00:00	AAPL	Stock	3.2579	3.3331	3.2262	3.2582	24069024.0
2008-12-04 17:00:00	AAPL	Stock	3.2582	3.2607	3.2518	3.2536	117180.0
2008-12-04 18:00:00	AAPL	Stock	3.2536	3.2596	3.2514	3.2521	152376.0
2008-12-04 19:00:00	AAPL	Stock	3.2554	3.2589	3.2446	3.2536	190400.0
2008-12-04 08:00:00	MSFT	Stock	19.65	19.65	19.45	19.5	12302.0
2008-12-04 09:00:00	MSFT	Stock	19.53	19.92	19.32	19.6	6855188.0
2008-12-04 10:00:00	MSFT	Stock	19.61	19.88	19.52	19.86	11154721.0
2008-12-04 11:00:00	MSFT	Stock	19.85	19.87	19.55	19.58	7353879.0
2008-12-04 12:00:00	MSFT	Stock	19.58	19.6	19.4	19.53	5560329.0
2008-12-04 13:00:00	MSFT	Stock	19.53	19.59	19.37	19.5	5557800.0
2008-12-04 14:00:00	MSFT	Stock	19.5	19.64	19.36	19.36	6977259.0
2008-12-04 15:00:00	MSFT	Stock	19.36	19.4	18.79	19.11	25698652.0
2008-12-04 16:00:00	MSFT	Stock	19.11	19.79	19.027	19.16	8122858.0
2008-12-04 17:00:00	MSFT	Stock	19.16	19.382	19.0	19.02	39456.0
2008-12-04 18:00:00	MSFT	Stock	19.07	19.07	19.0	19.06	8600.0
2008-12-04 19:00:00	MSFT	Stock	19.06	19.11	19.06	19.1	3975.0
2008-12-04 08:00:00	NVDA	Stock	0.185	0.185	0.185	0.185	8000.0
2008-12-04 09:00:00	NVDA	Stock	0.1825	0.195	0.1825	0.193	70386520.0
2008-12-04 10:00:00	NVDA	Stock	0.1928	0.1948	0.187	0.1903	58178320.0
2008-12-04 11:00:00	NVDA	Stock	0.1903	0.1903	0.1858	0.1868	36736720.0
2008-12-04 12:00:00	NVDA	Stock	0.187	0.187	0.1833	0.1838	29835520.0
2008-12-04 13:00:00	NVDA	Stock	0.1838	0.1838	0.1808	0.1828	33855040.0
2008-12-04 14:00:00	NVDA	Stock	0.1825	0.1833	0.1783	0.1793	61271880.0
2008-12-04 15:00:00	NVDA	Stock	0.1793	0.1793	0.1728	0.177	151638160.0
2008-12-04 16:00:00	NVDA	Stock	0.1773	0.185	0.1768	0.177	6507920.0
2008-12-04 17:00:00	NVDA	Stock	0.1775	0.1775	0.1775	0.1775	20000.0
2008-12-04 18:00:00	NVDA	Stock	0.1775	0.1775	0.177	0.177	18000.0
2008-12-04 19:00:00	NVDA	Stock	0.1775	0.1775	0.177	0.177	12000.0
2008-12-04 07:00:00	AMZN	Stock	2.287	2.3345	2.287	2.3025	40000.0
2008-12-04 08:00:00	AMZN	Stock	2.3	2.3125	2.264	2.29	1389480.0
2008-12-04 09:00:00	AMZN	Stock	2.29	2.461	2.284	2.4348	79305920.0
2008-12-04 10:00:00	AMZN	Stock	2.437	2.495	2.42	2.4918	62637100.0
2008-12-04 11:00:00	AMZN	Stock	2.4915	2.525	2.4605	2.494	52916420.0
2008-12-04 12:00:00	AMZN	Stock	2.494	2.4965	2.44	2.4645	36482980.0
2008-12-04 13:00:00	AMZN	Stock	2.463	2.466	2.4255	2.434	24813700.0
2008-12-04 14:00:00	AMZN	Stock	2.4345	2.46	2.425	2.425	31479680.0
2008-12-04 15:00:00	AMZN	Stock	2.4255	2.427	2.3105	2.3665	82335660.0
2008-12-04 16:00:00	AMZN	Stock	2.374	2.3755	2.3595	2.366	1351120.0
2008-12-04 17:00:00	AMZN	Stock	2.365	2.365	2.3505	2.3505	90000.0

> showing 50 of 39,462 rows — these rows as CSV

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