PREVIEW / stock_1hour / 2009-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-09.parquet
  size:    792 KB
  rows:    39,426
  symbols: 3,307

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
2009-01-09 08:00:00	AAPL	Stock	3.2982	3.3536	3.2982	3.3343	2124248.0
2009-01-09 09:00:00	AAPL	Stock	3.3343	3.3354	3.2464	3.2479	85249472.0
2009-01-09 10:00:00	AAPL	Stock	3.2482	3.2632	3.2193	3.2339	99599276.0
2009-01-09 11:00:00	AAPL	Stock	3.2336	3.2532	3.2232	3.2336	62530328.0
2009-01-09 12:00:00	AAPL	Stock	3.2335	3.25	3.2293	3.245	41693176.0
2009-01-09 13:00:00	AAPL	Stock	3.245	3.2636	3.2321	3.2493	61398204.0
2009-01-09 14:00:00	AAPL	Stock	3.2493	3.2768	3.2493	3.2657	67254432.0
2009-01-09 15:00:00	AAPL	Stock	3.2657	3.2725	3.2239	3.235	109128516.0
2009-01-09 16:00:00	AAPL	Stock	3.2343	3.2517	3.2268	3.2307	14203392.0
2009-01-09 17:00:00	AAPL	Stock	3.2304	3.235	3.2286	3.2346	593712.0
2009-01-09 18:00:00	AAPL	Stock	3.2357	3.2411	3.2321	3.24	2847376.0
2009-01-09 19:00:00	AAPL	Stock	3.2386	3.2407	3.2329	3.2364	119504.0
2009-01-09 06:00:00	MSFT	Stock	20.05	20.05	20.05	20.05	380.0
2009-01-09 07:00:00	MSFT	Stock	20.25	20.25	20.25	20.25	1980.0
2009-01-09 08:00:00	MSFT	Stock	20.05	20.12	19.97	20.1	16715.0
2009-01-09 09:00:00	MSFT	Stock	20.1	20.3	19.73	19.74	6020352.0
2009-01-09 10:00:00	MSFT	Stock	19.74	19.91	19.67	19.82	7002006.0
2009-01-09 11:00:00	MSFT	Stock	19.82	19.86	19.65	19.76	6474524.0
2009-01-09 12:00:00	MSFT	Stock	19.76	19.82	19.72	19.73	4987937.0
2009-01-09 13:00:00	MSFT	Stock	19.728	19.82	19.68	19.71	3398521.0
2009-01-09 14:00:00	MSFT	Stock	19.71	19.88	19.71	19.76	4477745.0
2009-01-09 15:00:00	MSFT	Stock	19.76	19.81	19.41	19.51	13079317.0
2009-01-09 16:00:00	MSFT	Stock	19.51	19.755	19.505	19.55	3902796.0
2009-01-09 17:00:00	MSFT	Stock	19.59	19.59	19.52	19.57	22951.0
2009-01-09 18:00:00	MSFT	Stock	19.56	19.64	19.53	19.64	8299.0
2009-01-09 19:00:00	MSFT	Stock	19.63	19.65	19.61	19.64	6220.0
2009-01-09 07:00:00	NVDA	Stock	0.21	0.21	0.21	0.21	40000.0
2009-01-09 08:00:00	NVDA	Stock	0.2078	0.21	0.207	0.21	934800.0
2009-01-09 09:00:00	NVDA	Stock	0.21	0.21	0.198	0.1992	119878000.0
2009-01-09 10:00:00	NVDA	Stock	0.1992	0.202	0.199	0.2002	104099720.0
2009-01-09 11:00:00	NVDA	Stock	0.2002	0.2025	0.1995	0.1998	92471600.0
2009-01-09 12:00:00	NVDA	Stock	0.1999	0.2007	0.1982	0.199	104827760.0
2009-01-09 13:00:00	NVDA	Stock	0.199	0.2005	0.1978	0.2	70529000.0
2009-01-09 14:00:00	NVDA	Stock	0.2	0.2025	0.1998	0.2023	88299280.0
2009-01-09 15:00:00	NVDA	Stock	0.202	0.2023	0.1978	0.1985	160932280.0
2009-01-09 16:00:00	NVDA	Stock	0.198	0.2005	0.196	0.1982	5649600.0
2009-01-09 17:00:00	NVDA	Stock	0.1992	0.1998	0.1978	0.1988	226480.0
2009-01-09 18:00:00	NVDA	Stock	0.1988	0.1998	0.1988	0.1998	16000.0
2009-01-09 19:00:00	NVDA	Stock	0.1998	0.1998	0.1998	0.1998	32000.0
2009-01-09 08:00:00	AMZN	Stock	2.806	2.858	2.806	2.854	105600.0
2009-01-09 09:00:00	AMZN	Stock	2.852	2.852	2.751	2.763	21110500.0
2009-01-09 10:00:00	AMZN	Stock	2.7645	2.8045	2.735	2.787	25362080.0
2009-01-09 11:00:00	AMZN	Stock	2.787	2.805	2.7775	2.789	16662200.0
2009-01-09 12:00:00	AMZN	Stock	2.789	2.8245	2.7875	2.8145	8961880.0
2009-01-09 13:00:00	AMZN	Stock	2.814	2.8425	2.812	2.817	12862940.0
2009-01-09 14:00:00	AMZN	Stock	2.8175	2.8385	2.808	2.8325	14243820.0
2009-01-09 15:00:00	AMZN	Stock	2.832	2.832	2.775	2.775	26772380.0
2009-01-09 16:00:00	AMZN	Stock	2.78	2.7978	2.7755	2.7755	1216900.0
2009-01-09 17:00:00	AMZN	Stock	2.7755	2.777	2.7755	2.7765	19060.0
2009-01-09 19:00:00	AMZN	Stock	2.7815	2.7845	2.7815	2.7845	24000.0

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

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