PREVIEW / stock_1hour / 2008-12-29

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-29.parquet
  size:    819 KB
  rows:    40,681
  symbols: 3,370

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-29 06:00:00	AAPL	Stock	3.1089	3.1304	3.1089	3.1304	18200.0
2008-12-29 07:00:00	AAPL	Stock	3.1286	3.1286	3.1089	3.1139	82600.0
2008-12-29 08:00:00	AAPL	Stock	3.1071	3.1079	3.0911	3.1036	1228192.0
2008-12-29 09:00:00	AAPL	Stock	3.1043	3.1293	3.0879	3.1067	61211136.0
2008-12-29 10:00:00	AAPL	Stock	3.1064	3.1114	3.0707	3.0839	92713796.0
2008-12-29 11:00:00	AAPL	Stock	3.0836	3.0893	3.0725	3.08	57727432.0
2008-12-29 12:00:00	AAPL	Stock	3.08	3.0846	3.0518	3.0518	52424400.0
2008-12-29 13:00:00	AAPL	Stock	3.0521	3.0671	3.0382	3.0618	64490356.0
2008-12-29 14:00:00	AAPL	Stock	3.0625	3.0707	3.0518	3.0692	55939632.0
2008-12-29 15:00:00	AAPL	Stock	3.0693	3.1046	3.0668	3.0929	157119452.0
2008-12-29 16:00:00	AAPL	Stock	3.0929	3.1018	3.0741	3.0989	135816100.0
2008-12-29 17:00:00	AAPL	Stock	3.0989	3.0989	3.0964	3.0964	112280.0
2008-12-29 18:00:00	AAPL	Stock	3.0968	3.0982	3.0932	3.0982	1794044.0
2008-12-29 19:00:00	AAPL	Stock	3.1014	3.1036	3.0939	3.1032	78904.0
2008-12-29 04:00:00	MSFT	Stock	19.19	19.27	19.19	19.27	700.0
2008-12-29 07:00:00	MSFT	Stock	19.27	19.41	19.27	19.41	1600.0
2008-12-29 08:00:00	MSFT	Stock	19.25	19.28	19.23	19.27	17196.0
2008-12-29 09:00:00	MSFT	Stock	19.26	19.3	19.04	19.07	2160509.0
2008-12-29 10:00:00	MSFT	Stock	19.07	19.07	18.83	18.84	6256305.0
2008-12-29 11:00:00	MSFT	Stock	18.84	18.86	18.75	18.77	6676650.0
2008-12-29 12:00:00	MSFT	Stock	18.77	18.82	18.7	18.7	4822565.0
2008-12-29 13:00:00	MSFT	Stock	18.7	18.83	18.64	18.8	4143331.0
2008-12-29 14:00:00	MSFT	Stock	18.792	18.83	18.7	18.8	4591656.0
2008-12-29 15:00:00	MSFT	Stock	18.8	18.98	18.77	18.97	13584718.0
2008-12-29 16:00:00	MSFT	Stock	18.98	19.134	18.65	18.98	15411275.0
2008-12-29 17:00:00	MSFT	Stock	18.97	18.98	18.94	18.94	10278.0
2008-12-29 18:00:00	MSFT	Stock	18.98	18.98	18.95	18.98	373496.0
2008-12-29 19:00:00	MSFT	Stock	18.99	18.99	18.99	18.99	120.0
2008-12-29 08:00:00	NVDA	Stock	0.1913	0.1913	0.1888	0.191	280000.0
2008-12-29 09:00:00	NVDA	Stock	0.191	0.191	0.1853	0.1853	21466920.0
2008-12-29 10:00:00	NVDA	Stock	0.1853	0.1855	0.178	0.1814	69531960.0
2008-12-29 11:00:00	NVDA	Stock	0.1813	0.183	0.1805	0.1818	25277400.0
2008-12-29 12:00:00	NVDA	Stock	0.1818	0.1853	0.1818	0.185	34496320.0
2008-12-29 13:00:00	NVDA	Stock	0.185	0.19	0.185	0.1895	107627640.0
2008-12-29 14:00:00	NVDA	Stock	0.1898	0.1915	0.1888	0.1913	63923520.0
2008-12-29 15:00:00	NVDA	Stock	0.1915	0.1938	0.191	0.1938	126934120.0
2008-12-29 16:00:00	NVDA	Stock	0.1938	0.1942	0.1935	0.1942	388240.0
2008-12-29 17:00:00	NVDA	Stock	0.1918	0.1938	0.1915	0.1938	35440.0
2008-12-29 18:00:00	NVDA	Stock	0.1942	0.1942	0.1938	0.1938	12280.0
2008-12-29 19:00:00	NVDA	Stock	0.1938	0.1938	0.1938	0.1938	44000.0
2008-12-29 04:00:00	AMZN	Stock	2.589	2.589	2.589	2.589	6000.0
2008-12-29 07:00:00	AMZN	Stock	2.589	2.589	2.589	2.589	2000.0
2008-12-29 08:00:00	AMZN	Stock	2.5925	2.602	2.575	2.575	165200.0
2008-12-29 09:00:00	AMZN	Stock	2.575	2.5885	2.506	2.517	15328260.0
2008-12-29 10:00:00	AMZN	Stock	2.5175	2.5185	2.4675	2.4735	27038160.0
2008-12-29 11:00:00	AMZN	Stock	2.4715	2.4893	2.4655	2.4872	13236860.0
2008-12-29 12:00:00	AMZN	Stock	2.4875	2.4955	2.437	2.437	16916340.0
2008-12-29 13:00:00	AMZN	Stock	2.437	2.4565	2.428	2.455	12682840.0
2008-12-29 14:00:00	AMZN	Stock	2.454	2.4675	2.445	2.4642	10464240.0
2008-12-29 15:00:00	AMZN	Stock	2.464	2.4715	2.44	2.4695	30943600.0

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

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