PREVIEW / stock_1hour / 2009-01-15

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-15.parquet
  size:    815 KB
  rows:    40,206
  symbols: 3,314

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-15 04:00:00	AAPL	Stock	2.84	2.8507	2.84	2.84	33600.0
2009-01-15 05:00:00	AAPL	Stock	2.8218	2.825	2.8075	2.825	36400.0
2009-01-15 06:00:00	AAPL	Stock	2.8125	2.8214	2.7989	2.8043	240520.0
2009-01-15 07:00:00	AAPL	Stock	2.7982	2.8536	2.7868	2.8321	4511332.0
2009-01-15 08:00:00	AAPL	Stock	2.8321	2.9239	2.8079	2.9175	50576120.0
2009-01-15 09:00:00	AAPL	Stock	2.9179	2.9496	2.8393	2.9057	441884128.0
2009-01-15 10:00:00	AAPL	Stock	2.905	2.9152	2.8625	2.89	338456160.0
2009-01-15 11:00:00	AAPL	Stock	2.8904	2.9129	2.8825	2.9018	169954932.0
2009-01-15 12:00:00	AAPL	Stock	2.9014	2.9243	2.8925	2.9221	128161908.0
2009-01-15 13:00:00	AAPL	Stock	2.9225	2.9914	2.9161	2.9829	186081756.0
2009-01-15 14:00:00	AAPL	Stock	2.9829	3.0043	2.9482	2.9611	247604588.0
2009-01-15 15:00:00	AAPL	Stock	2.9607	2.9854	2.9396	2.9793	227076976.0
2009-01-15 16:00:00	AAPL	Stock	2.9775	2.993	2.9256	2.9793	22785672.0
2009-01-15 17:00:00	AAPL	Stock	2.9811	2.9821	2.9216	2.9818	524412.0
2009-01-15 18:00:00	AAPL	Stock	2.9818	2.9893	2.9771	2.9804	11404204.0
2009-01-15 19:00:00	AAPL	Stock	2.9807	2.9911	2.9779	2.9911	155652.0
2009-01-15 07:00:00	MSFT	Stock	19.18	19.18	19.0	19.0	3268.0
2009-01-15 08:00:00	MSFT	Stock	19.0	19.14	19.0	19.11	23152.0
2009-01-15 09:00:00	MSFT	Stock	19.11	19.31	18.64	18.71	10615702.0
2009-01-15 10:00:00	MSFT	Stock	18.71	18.88	18.53	18.61	18240883.0
2009-01-15 11:00:00	MSFT	Stock	18.62	18.9	18.52	18.77	10175306.0
2009-01-15 12:00:00	MSFT	Stock	18.77	18.78	18.6	18.73	6809962.0
2009-01-15 13:00:00	MSFT	Stock	18.74	18.97	18.73	18.95	10036748.0
2009-01-15 14:00:00	MSFT	Stock	18.95	19.28	18.89	19.14	13040589.0
2009-01-15 15:00:00	MSFT	Stock	19.13	19.29	18.9	19.27	17018048.0
2009-01-15 16:00:00	MSFT	Stock	19.25	19.27	18.873	19.14	9073930.0
2009-01-15 17:00:00	MSFT	Stock	19.25	19.32	18.809	19.27	85380.0
2009-01-15 18:00:00	MSFT	Stock	19.27	19.32	19.25	19.31	25670.0
2009-01-15 19:00:00	MSFT	Stock	19.31	19.32	19.3	19.32	7635.0
2009-01-15 08:00:00	NVDA	Stock	0.1813	0.1813	0.179	0.1813	28000.0
2009-01-15 09:00:00	NVDA	Stock	0.1823	0.1876	0.1813	0.1818	59680800.0
2009-01-15 10:00:00	NVDA	Stock	0.1818	0.184	0.18	0.1813	118779840.0
2009-01-15 11:00:00	NVDA	Stock	0.1815	0.1875	0.1813	0.1835	92527880.0
2009-01-15 12:00:00	NVDA	Stock	0.1833	0.1835	0.1805	0.1821	63909800.0
2009-01-15 13:00:00	NVDA	Stock	0.1821	0.188	0.182	0.1865	200702680.0
2009-01-15 14:00:00	NVDA	Stock	0.1865	0.1923	0.186	0.189	248037480.0
2009-01-15 15:00:00	NVDA	Stock	0.1888	0.1923	0.1858	0.189	138666520.0
2009-01-15 16:00:00	NVDA	Stock	0.1888	0.195	0.1855	0.195	5407440.0
2009-01-15 17:00:00	NVDA	Stock	0.1908	0.1938	0.1908	0.192	2012400.0
2009-01-15 19:00:00	NVDA	Stock	0.1938	0.1958	0.1938	0.1958	56480.0
2009-01-15 08:00:00	AMZN	Stock	2.4195	2.435	2.4195	2.435	75000.0
2009-01-15 09:00:00	AMZN	Stock	2.4235	2.4515	2.3815	2.4224	19214660.0
2009-01-15 10:00:00	AMZN	Stock	2.422	2.478	2.3945	2.464	37533260.0
2009-01-15 11:00:00	AMZN	Stock	2.4635	2.525	2.458	2.498	28720200.0
2009-01-15 12:00:00	AMZN	Stock	2.4985	2.5035	2.435	2.4535	23478780.0
2009-01-15 13:00:00	AMZN	Stock	2.4545	2.579	2.4545	2.5685	28063020.0
2009-01-15 14:00:00	AMZN	Stock	2.5675	2.6115	2.539	2.569	42182980.0
2009-01-15 15:00:00	AMZN	Stock	2.5695	2.603	2.4945	2.57	45655820.0
2009-01-15 16:00:00	AMZN	Stock	2.57	2.5775	2.5058	2.572	5662560.0
2009-01-15 17:00:00	AMZN	Stock	2.5008	2.5865	2.5008	2.5865	28000.0

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

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