PREVIEW / stock_1hour / 2011-05-11

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-11.parquet
  size:    966 KB
  rows:    45,938
  symbols: 3,553

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
2011-05-11 04:00:00	AAPL	Stock	12.4689	12.4689	12.4689	12.4689	8400.0
2011-05-11 05:00:00	AAPL	Stock	12.4696	12.4696	12.4696	12.4696	2800.0
2011-05-11 06:00:00	AAPL	Stock	12.475	12.475	12.4636	12.4636	31920.0
2011-05-11 07:00:00	AAPL	Stock	12.4607	12.4714	12.4464	12.4571	247240.0
2011-05-11 08:00:00	AAPL	Stock	12.4607	12.4732	12.4257	12.4593	1895600.0
2011-05-11 09:00:00	AAPL	Stock	12.4632	12.5	12.4214	12.4571	52279360.0
2011-05-11 10:00:00	AAPL	Stock	12.4571	12.475	12.415	12.4507	53264792.0
2011-05-11 11:00:00	AAPL	Stock	12.4508	12.48	12.4118	12.4219	30487296.0
2011-05-11 12:00:00	AAPL	Stock	12.4239	12.4307	12.3693	12.4021	50548624.0
2011-05-11 13:00:00	AAPL	Stock	12.4025	12.4071	12.33	12.3608	48439020.0
2011-05-11 14:00:00	AAPL	Stock	12.3599	12.3875	12.3329	12.375	29164100.0
2011-05-11 15:00:00	AAPL	Stock	12.3721	12.4246	12.3679	12.4014	51494688.0
2011-05-11 16:00:00	AAPL	Stock	12.4014	12.4602	12.3901	12.395	12735044.0
2011-05-11 17:00:00	AAPL	Stock	12.3964	12.4011	12.3786	12.3786	922348.0
2011-05-11 18:00:00	AAPL	Stock	12.3754	12.4011	12.35	12.35	611212.0
2011-05-11 19:00:00	AAPL	Stock	12.3514	12.3679	12.3282	12.3643	969836.0
2011-05-11 05:00:00	MSFT	Stock	25.8	25.8	25.8	25.8	500.0
2011-05-11 06:00:00	MSFT	Stock	25.75	25.75	25.75	25.75	200.0
2011-05-11 07:00:00	MSFT	Stock	25.78	25.8	25.73	25.77	8975.0
2011-05-11 08:00:00	MSFT	Stock	25.76	25.77	25.6	25.62	49420.0
2011-05-11 09:00:00	MSFT	Stock	25.64	25.68	25.51	25.55	7962492.0
2011-05-11 10:00:00	MSFT	Stock	25.55	25.56	25.49	25.532	10811680.0
2011-05-11 11:00:00	MSFT	Stock	25.54	25.61	25.5	25.538	8752735.0
2011-05-11 12:00:00	MSFT	Stock	25.534	25.55	25.34	25.371	13363795.0
2011-05-11 13:00:00	MSFT	Stock	25.38	25.39	25.21	25.258	11542844.0
2011-05-11 14:00:00	MSFT	Stock	25.25	25.38	25.23	25.31	9566657.0
2011-05-11 15:00:00	MSFT	Stock	25.31	25.39	25.25	25.35	12791760.0
2011-05-11 16:00:00	MSFT	Stock	25.35	25.577	25.267	25.36	2258884.0
2011-05-11 17:00:00	MSFT	Stock	25.33	25.36	25.22	25.25	124973.0
2011-05-11 18:00:00	MSFT	Stock	25.23	25.36	25.2	25.24	60446.0
2011-05-11 19:00:00	MSFT	Stock	25.23	25.27	25.22	25.27	14225.0
2011-05-11 08:00:00	NVDA	Stock	0.4948	0.4948	0.4948	0.4948	20000.0
2011-05-11 09:00:00	NVDA	Stock	0.4945	0.5008	0.4925	0.498	92069200.0
2011-05-11 10:00:00	NVDA	Stock	0.498	0.502	0.4963	0.4965	84609280.0
2011-05-11 11:00:00	NVDA	Stock	0.4964	0.4988	0.494	0.495	63885760.0
2011-05-11 12:00:00	NVDA	Stock	0.4948	0.498	0.4909	0.497	99002160.0
2011-05-11 13:00:00	NVDA	Stock	0.497	0.497	0.4923	0.494	83092560.0
2011-05-11 14:00:00	NVDA	Stock	0.4938	0.494	0.49	0.4925	57335320.0
2011-05-11 15:00:00	NVDA	Stock	0.4925	0.4972	0.492	0.4966	110758720.0
2011-05-11 16:00:00	NVDA	Stock	0.4968	0.497	0.4934	0.4963	15276280.0
2011-05-11 17:00:00	NVDA	Stock	0.4963	0.4968	0.494	0.495	468320.0
2011-05-11 18:00:00	NVDA	Stock	0.4942	0.4965	0.4942	0.4965	154000.0
2011-05-11 19:00:00	NVDA	Stock	0.495	0.4968	0.495	0.4968	307200.0
2011-05-11 07:00:00	AMZN	Stock	10.195	10.195	10.195	10.195	4000.0
2011-05-11 08:00:00	AMZN	Stock	10.185	10.2	10.143	10.1635	136500.0
2011-05-11 09:00:00	AMZN	Stock	10.165	10.232	10.1435	10.2145	11466660.0
2011-05-11 10:00:00	AMZN	Stock	10.212	10.275	10.181	10.2251	18681580.0
2011-05-11 11:00:00	AMZN	Stock	10.225	10.245	10.1775	10.1885	10741940.0
2011-05-11 12:00:00	AMZN	Stock	10.189	10.2042	10.13	10.158	12093120.0
2011-05-11 13:00:00	AMZN	Stock	10.1585	10.159	10.1125	10.1392	9558120.0

> showing 50 of 45,938 rows — these rows as CSV

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