PREVIEW / stock_1hour / 2008-11-10

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-10.parquet
  size:    792 KB
  rows:    40,439
  symbols: 3,308

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-10 07:00:00	AAPL	Stock	3.5839	3.6429	3.5839	3.6014	249424.0
2008-11-10 08:00:00	AAPL	Stock	3.6014	3.6214	3.5846	3.5871	2749516.0
2008-11-10 09:00:00	AAPL	Stock	3.5875	3.5889	3.495	3.5311	139599600.0
2008-11-10 10:00:00	AAPL	Stock	3.5325	3.5714	3.5125	3.5236	150647196.0
2008-11-10 11:00:00	AAPL	Stock	3.5239	3.5243	3.3975	3.4114	175620788.0
2008-11-10 12:00:00	AAPL	Stock	3.4118	3.4607	3.3929	3.4046	146322512.0
2008-11-10 13:00:00	AAPL	Stock	3.4057	3.4536	3.3939	3.4445	123966080.0
2008-11-10 14:00:00	AAPL	Stock	3.4446	3.445	3.3786	3.4014	140049616.0
2008-11-10 15:00:00	AAPL	Stock	3.4011	3.4321	3.375	3.4221	218098104.0
2008-11-10 16:00:00	AAPL	Stock	3.425	3.4541	3.4006	3.4243	21461468.0
2008-11-10 17:00:00	AAPL	Stock	3.4154	3.4245	3.4071	3.4089	555380.0
2008-11-10 18:00:00	AAPL	Stock	3.4071	3.4243	3.4018	3.4018	1917244.0
2008-11-10 19:00:00	AAPL	Stock	3.4007	3.4107	3.3964	3.4107	150892.0
2008-11-10 04:00:00	MSFT	Stock	21.88	21.88	21.88	21.88	200.0
2008-11-10 05:00:00	MSFT	Stock	21.96	21.96	21.96	21.96	200.0
2008-11-10 08:00:00	MSFT	Stock	21.93	21.96	21.5	21.9	117108.0
2008-11-10 09:00:00	MSFT	Stock	21.9	21.97	21.66	21.8	5649604.0
2008-11-10 10:00:00	MSFT	Stock	21.8	21.95	21.7	21.758	10125988.0
2008-11-10 11:00:00	MSFT	Stock	21.76	21.84	21.47	21.51	6520564.0
2008-11-10 12:00:00	MSFT	Stock	21.512	21.65	21.3	21.38	5294424.0
2008-11-10 13:00:00	MSFT	Stock	21.37	21.63	21.28	21.58	5200838.0
2008-11-10 14:00:00	MSFT	Stock	21.58	21.7	21.25	21.32	7283116.0
2008-11-10 15:00:00	MSFT	Stock	21.31	21.47	21.19	21.3	13732192.0
2008-11-10 16:00:00	MSFT	Stock	21.31	21.5	21.296	21.3	12425974.0
2008-11-10 17:00:00	MSFT	Stock	21.45	21.45	21.299	21.42	26038.0
2008-11-10 18:00:00	MSFT	Stock	21.37	21.38	21.3	21.3	488392.0
2008-11-10 19:00:00	MSFT	Stock	21.36	21.45	21.36	21.42	7489.0
2008-11-10 08:00:00	NVDA	Stock	0.2228	0.229	0.2223	0.2268	1562320.0
2008-11-10 09:00:00	NVDA	Stock	0.2275	0.2275	0.2185	0.2198	62166000.0
2008-11-10 10:00:00	NVDA	Stock	0.2198	0.2235	0.2178	0.2183	69964320.0
2008-11-10 11:00:00	NVDA	Stock	0.2183	0.2198	0.2135	0.2145	55430760.0
2008-11-10 12:00:00	NVDA	Stock	0.2148	0.2165	0.209	0.2095	44511000.0
2008-11-10 13:00:00	NVDA	Stock	0.2095	0.2102	0.2058	0.2085	75534320.0
2008-11-10 14:00:00	NVDA	Stock	0.2085	0.2094	0.2025	0.2035	78383960.0
2008-11-10 15:00:00	NVDA	Stock	0.2035	0.205	0.1992	0.2035	169615720.0
2008-11-10 16:00:00	NVDA	Stock	0.204	0.2103	0.2	0.204	18350640.0
2008-11-10 17:00:00	NVDA	Stock	0.204	0.2065	0.204	0.2065	105360.0
2008-11-10 18:00:00	NVDA	Stock	0.2055	0.2055	0.204	0.204	1367280.0
2008-11-10 19:00:00	NVDA	Stock	0.2062	0.2062	0.205	0.205	100000.0
2008-11-10 04:00:00	AMZN	Stock	2.495	2.495	2.495	2.495	2000.0
2008-11-10 07:00:00	AMZN	Stock	2.5	2.5	2.5	2.5	10000.0
2008-11-10 08:00:00	AMZN	Stock	2.495	2.525	2.485	2.485	107340.0
2008-11-10 09:00:00	AMZN	Stock	2.485	2.534	2.4	2.431	32612400.0
2008-11-10 10:00:00	AMZN	Stock	2.4335	2.4395	2.39	2.3918	26062620.0
2008-11-10 11:00:00	AMZN	Stock	2.3925	2.395	2.36	2.3715	22047740.0
2008-11-10 12:00:00	AMZN	Stock	2.372	2.3923	2.343	2.3625	17284240.0
2008-11-10 13:00:00	AMZN	Stock	2.3625	2.413	2.347	2.4015	16560000.0
2008-11-10 14:00:00	AMZN	Stock	2.4015	2.4045	2.3595	2.374	21026500.0
2008-11-10 15:00:00	AMZN	Stock	2.3725	2.425	2.357	2.4225	36718860.0
2008-11-10 16:00:00	AMZN	Stock	2.413	2.425	2.4005	2.423	2900300.0

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

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