PREVIEW / stock_1hour / 2008-01-11

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-11.parquet
  size:    815 KB
  rows:    40,780
  symbols: 3,259

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-01-11 06:00:00	AAPL	Stock	6.3036	6.3036	6.3036	6.3036	11200.0
2008-01-11 07:00:00	AAPL	Stock	6.3036	6.3171	6.2854	6.3168	271488.0
2008-01-11 08:00:00	AAPL	Stock	6.3107	6.3107	6.2643	6.2857	4261180.0
2008-01-11 09:00:00	AAPL	Stock	6.2893	6.3518	6.2679	6.3011	131652388.0
2008-01-11 10:00:00	AAPL	Stock	6.2979	6.34	6.2704	6.2786	145689264.0
2008-01-11 11:00:00	AAPL	Stock	6.2786	6.3004	6.225	6.2386	142508800.0
2008-01-11 12:00:00	AAPL	Stock	6.2393	6.2429	6.1564	6.1839	146397216.0
2008-01-11 13:00:00	AAPL	Stock	6.1825	6.1854	6.1193	6.12	139870948.0
2008-01-11 14:00:00	AAPL	Stock	6.12	6.1821	6.0846	6.1075	168689892.0
2008-01-11 15:00:00	AAPL	Stock	6.1107	6.2296	6.0714	6.1571	311853752.0
2008-01-11 16:00:00	AAPL	Stock	6.1586	6.2653	6.1438	6.1696	38552276.0
2008-01-11 17:00:00	AAPL	Stock	6.1689	6.1696	6.1356	6.1643	827764.0
2008-01-11 18:00:00	AAPL	Stock	6.1643	6.1993	6.1643	6.1875	1630748.0
2008-01-11 19:00:00	AAPL	Stock	6.1875	6.2018	6.1814	6.1964	420364.0
2008-01-11 07:00:00	MSFT	Stock	33.81	33.81	33.81	33.81	400.0
2008-01-11 08:00:00	MSFT	Stock	34.04	34.2	34.04	34.18	6150.0
2008-01-11 09:00:00	MSFT	Stock	34.1	34.24	33.99	34.0	4383465.0
2008-01-11 10:00:00	MSFT	Stock	34.0	34.1	33.92	34.04	9281990.0
2008-01-11 11:00:00	MSFT	Stock	34.04	34.1	33.95	34.01	6092465.0
2008-01-11 12:00:00	MSFT	Stock	34.02	34.08	33.87	34.08	4590896.0
2008-01-11 13:00:00	MSFT	Stock	34.07	34.08	33.75	33.79	7149911.0
2008-01-11 14:00:00	MSFT	Stock	33.79	33.97	33.77	33.9	5983407.0
2008-01-11 15:00:00	MSFT	Stock	33.893	34.08	33.72	33.92	13745039.0
2008-01-11 16:00:00	MSFT	Stock	33.92	33.974	33.88	33.91	3877116.0
2008-01-11 17:00:00	MSFT	Stock	33.88	33.92	33.843	33.92	25078.0
2008-01-11 18:00:00	MSFT	Stock	33.87	33.88	33.86	33.88	6098.0
2008-01-11 19:00:00	MSFT	Stock	33.88	33.88	33.85	33.88	2700.0
2008-01-11 07:00:00	NVDA	Stock	0.6962	0.6962	0.6962	0.6962	12000.0
2008-01-11 08:00:00	NVDA	Stock	0.6962	0.6962	0.69	0.6938	142000.0
2008-01-11 09:00:00	NVDA	Stock	0.6938	0.705	0.6888	0.6952	32756680.0
2008-01-11 10:00:00	NVDA	Stock	0.6955	0.6968	0.6785	0.6838	88753600.0
2008-01-11 11:00:00	NVDA	Stock	0.684	0.6862	0.6758	0.6772	79213760.0
2008-01-11 12:00:00	NVDA	Stock	0.6772	0.6848	0.6758	0.6842	53172080.0
2008-01-11 13:00:00	NVDA	Stock	0.6842	0.6842	0.673	0.674	67220240.0
2008-01-11 14:00:00	NVDA	Stock	0.674	0.6832	0.674	0.6782	50456280.0
2008-01-11 15:00:00	NVDA	Stock	0.6782	0.6845	0.6713	0.6755	144260200.0
2008-01-11 16:00:00	NVDA	Stock	0.6753	0.6809	0.672	0.675	19997120.0
2008-01-11 17:00:00	NVDA	Stock	0.6772	0.6772	0.6728	0.6728	152000.0
2008-01-11 18:00:00	NVDA	Stock	0.6738	0.675	0.6728	0.675	40000.0
2008-01-11 08:00:00	AMZN	Stock	4.187	4.2395	4.175	4.176	63700.0
2008-01-11 09:00:00	AMZN	Stock	4.175	4.2015	4.1215	4.153	22823920.0
2008-01-11 10:00:00	AMZN	Stock	4.1525	4.178	4.1155	4.165	25109600.0
2008-01-11 11:00:00	AMZN	Stock	4.165	4.2	4.1105	4.161	20681960.0
2008-01-11 12:00:00	AMZN	Stock	4.161	4.177	4.1205	4.1355	21518500.0
2008-01-11 13:00:00	AMZN	Stock	4.137	4.143	4.075	4.081	25247360.0
2008-01-11 14:00:00	AMZN	Stock	4.0825	4.084	4.037	4.0585	32489820.0
2008-01-11 15:00:00	AMZN	Stock	4.058	4.084	4.0145	4.057	58864160.0
2008-01-11 16:00:00	AMZN	Stock	4.0575	4.1007	4.0488	4.0785	5637600.0
2008-01-11 17:00:00	AMZN	Stock	4.0545	4.078	4.054	4.054	21000.0
2008-01-11 18:00:00	AMZN	Stock	4.0775	4.0775	4.075	4.075	4000.0

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

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