PREVIEW / stock_1hour / 2009-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-03-06.parquet
  size:    813 KB
  rows:    40,611
  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
2009-03-06 07:00:00	AAPL	Stock	3.1625	3.1625	3.1532	3.1571	67340.0
2009-03-06 08:00:00	AAPL	Stock	3.1536	3.1943	3.1532	3.1789	2664060.0
2009-03-06 09:00:00	AAPL	Stock	3.1818	3.1821	3.0757	3.0996	121264976.0
2009-03-06 10:00:00	AAPL	Stock	3.0996	3.1089	2.9732	2.9982	223089552.0
2009-03-06 11:00:00	AAPL	Stock	2.9982	3.0125	2.9404	3.0071	163195228.0
2009-03-06 12:00:00	AAPL	Stock	3.0068	3.0264	2.9743	3.0132	104005216.0
2009-03-06 13:00:00	AAPL	Stock	3.0136	3.0214	2.9757	3.0096	81135152.0
2009-03-06 14:00:00	AAPL	Stock	3.0104	3.0321	2.9786	2.9839	105790972.0
2009-03-06 15:00:00	AAPL	Stock	2.9839	3.0525	2.9721	3.0507	177040248.0
2009-03-06 16:00:00	AAPL	Stock	3.0507	3.0714	2.9961	3.0625	23143372.0
2009-03-06 17:00:00	AAPL	Stock	3.0629	3.0629	3.0571	3.0589	280784.0
2009-03-06 18:00:00	AAPL	Stock	3.0575	3.0632	3.0464	3.0632	1026424.0
2009-03-06 19:00:00	AAPL	Stock	3.0611	3.0625	3.0546	3.0593	68880.0
2009-03-06 07:00:00	MSFT	Stock	15.31	15.31	15.3	15.3	500.0
2009-03-06 08:00:00	MSFT	Stock	15.36	15.5	15.28	15.45	137814.0
2009-03-06 09:00:00	MSFT	Stock	15.45	15.62	15.27	15.48	8348406.0
2009-03-06 10:00:00	MSFT	Stock	15.48	15.5	15.0	15.045	17160815.0
2009-03-06 11:00:00	MSFT	Stock	15.04	15.21	15.0	15.132	8317872.0
2009-03-06 12:00:00	MSFT	Stock	15.132	15.29	15.09	15.17	7245929.0
2009-03-06 13:00:00	MSFT	Stock	15.17	15.18	14.93	15.01	10025724.0
2009-03-06 14:00:00	MSFT	Stock	15.01	15.12	14.95	14.968	10998353.0
2009-03-06 15:00:00	MSFT	Stock	14.97	15.33	14.87	15.29	23086547.0
2009-03-06 16:00:00	MSFT	Stock	15.3	15.4	15.016	15.35	4304949.0
2009-03-06 17:00:00	MSFT	Stock	15.35	15.38	15.12	15.36	21865.0
2009-03-06 18:00:00	MSFT	Stock	15.37	15.38	15.28	15.36	26620.0
2009-03-06 19:00:00	MSFT	Stock	15.36	15.39	15.35	15.35	6717.0
2009-03-06 09:00:00	NVDA	Stock	0.21	0.2172	0.2062	0.212	139474480.0
2009-03-06 10:00:00	NVDA	Stock	0.212	0.2138	0.205	0.206	153528440.0
2009-03-06 11:00:00	NVDA	Stock	0.206	0.2102	0.2058	0.2085	105488320.0
2009-03-06 12:00:00	NVDA	Stock	0.2085	0.2108	0.2078	0.2098	88664040.0
2009-03-06 13:00:00	NVDA	Stock	0.2098	0.2098	0.207	0.2095	104814320.0
2009-03-06 14:00:00	NVDA	Stock	0.2092	0.2108	0.2058	0.2062	113847160.0
2009-03-06 15:00:00	NVDA	Stock	0.2062	0.211	0.2038	0.21	230167120.0
2009-03-06 16:00:00	NVDA	Stock	0.21	0.2128	0.2075	0.21	23303200.0
2009-03-06 19:00:00	NVDA	Stock	0.212	0.212	0.21	0.21	46000.0
2009-03-06 08:00:00	AMZN	Stock	3.26	3.27	3.2415	3.2515	302900.0
2009-03-06 09:00:00	AMZN	Stock	3.2545	3.275	3.1725	3.185	34685880.0
2009-03-06 10:00:00	AMZN	Stock	3.185	3.188	3.0615	3.079	57335100.0
2009-03-06 11:00:00	AMZN	Stock	3.0775	3.1015	3.0515	3.0595	34459480.0
2009-03-06 12:00:00	AMZN	Stock	3.0605	3.0985	3.014	3.038	32371260.0
2009-03-06 13:00:00	AMZN	Stock	3.0365	3.05	3.0115	3.0295	18974120.0
2009-03-06 14:00:00	AMZN	Stock	3.0285	3.051	2.995	3.0015	34499120.0
2009-03-06 15:00:00	AMZN	Stock	3.003	3.0835	2.991	3.0835	76877800.0
2009-03-06 16:00:00	AMZN	Stock	3.0835	3.087	2.997	3.0845	8089760.0
2009-03-06 17:00:00	AMZN	Stock	3.085	3.0925	3.085	3.0925	60100.0
2009-03-06 18:00:00	AMZN	Stock	3.0865	3.095	3.0865	3.095	5100.0
2009-03-06 19:00:00	AMZN	Stock	3.0865	3.0865	3.08	3.08	14380.0
2009-03-06 08:00:00	TLT	Stock	104.65	104.65	104.65	104.65	200.0
2009-03-06 09:00:00	TLT	Stock	104.64	104.64	104.09	104.42	347226.0
2009-03-06 10:00:00	TLT	Stock	104.41	105.97	104.28	105.7	592438.0

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

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