PREVIEW / stock_1hour / 2009-01-21

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-21.parquet
  size:    818 KB
  rows:    40,127
  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
2009-01-21 06:00:00	AAPL	Stock	2.8375	2.8375	2.8375	2.8375	18200.0
2009-01-21 07:00:00	AAPL	Stock	2.8375	2.8489	2.8239	2.8239	197624.0
2009-01-21 08:00:00	AAPL	Stock	2.8282	2.8464	2.8239	2.8432	2120888.0
2009-01-21 09:00:00	AAPL	Stock	2.8436	2.9143	2.8325	2.8893	113169196.0
2009-01-21 10:00:00	AAPL	Stock	2.8914	2.8989	2.8482	2.8511	128095324.0
2009-01-21 11:00:00	AAPL	Stock	2.8511	2.8696	2.8429	2.8607	91116592.0
2009-01-21 12:00:00	AAPL	Stock	2.8607	2.8839	2.8557	2.8689	60265240.0
2009-01-21 13:00:00	AAPL	Stock	2.8682	2.89	2.8632	2.8761	71116780.0
2009-01-21 14:00:00	AAPL	Stock	2.8761	2.9082	2.8621	2.9079	96186804.0
2009-01-21 15:00:00	AAPL	Stock	2.9082	2.96	2.8975	2.9586	220118416.0
2009-01-21 16:00:00	AAPL	Stock	2.9571	3.3107	2.8888	3.21	214144644.0
2009-01-21 17:00:00	AAPL	Stock	3.2093	3.2296	2.8575	3.2111	69850872.0
2009-01-21 18:00:00	AAPL	Stock	3.2107	3.2411	2.9582	3.2286	17540264.0
2009-01-21 19:00:00	AAPL	Stock	3.2293	3.2407	3.2232	3.2393	4068988.0
2009-01-21 07:00:00	MSFT	Stock	18.7	18.7	18.7	18.7	100.0
2009-01-21 08:00:00	MSFT	Stock	18.7	18.7	18.61	18.7	33760.0
2009-01-21 09:00:00	MSFT	Stock	18.7	19.1	18.65	19.0	7572250.0
2009-01-21 10:00:00	MSFT	Stock	19.0	19.06	18.46	18.53	11161577.0
2009-01-21 11:00:00	MSFT	Stock	18.53	18.79	18.51	18.757	7215965.0
2009-01-21 12:00:00	MSFT	Stock	18.76	18.9	18.72	18.89	5950153.0
2009-01-21 13:00:00	MSFT	Stock	18.89	19.01	18.8	19.01	6217372.0
2009-01-21 14:00:00	MSFT	Stock	19.01	19.13	18.92	19.13	7325719.0
2009-01-21 15:00:00	MSFT	Stock	19.13	19.44	19.09	19.42	15907171.0
2009-01-21 16:00:00	MSFT	Stock	19.44	19.57	18.754	19.45	5894917.0
2009-01-21 17:00:00	MSFT	Stock	19.49	19.57	18.72	19.5	50632.0
2009-01-21 18:00:00	MSFT	Stock	19.38	19.54	19.38	19.5	49555.0
2009-01-21 19:00:00	MSFT	Stock	19.5	19.52	19.43	19.45	5724.0
2009-01-21 08:00:00	NVDA	Stock	0.1825	0.1825	0.1823	0.1825	36000.0
2009-01-21 09:00:00	NVDA	Stock	0.1828	0.1875	0.1813	0.185	100141680.0
2009-01-21 10:00:00	NVDA	Stock	0.1853	0.186	0.1775	0.178	100017880.0
2009-01-21 11:00:00	NVDA	Stock	0.1783	0.1798	0.1773	0.1776	72823840.0
2009-01-21 12:00:00	NVDA	Stock	0.178	0.1813	0.1773	0.1788	68214280.0
2009-01-21 13:00:00	NVDA	Stock	0.1786	0.1815	0.177	0.1814	46478080.0
2009-01-21 14:00:00	NVDA	Stock	0.1813	0.1855	0.1798	0.185	74741320.0
2009-01-21 15:00:00	NVDA	Stock	0.1853	0.1903	0.185	0.1888	160401000.0
2009-01-21 16:00:00	NVDA	Stock	0.189	0.193	0.1831	0.193	23524440.0
2009-01-21 17:00:00	NVDA	Stock	0.19	0.1923	0.19	0.1923	40000.0
2009-01-21 18:00:00	NVDA	Stock	0.1913	0.1923	0.1913	0.1923	292800.0
2009-01-21 08:00:00	AMZN	Stock	2.45	2.4625	2.4425	2.4625	84280.0
2009-01-21 09:00:00	AMZN	Stock	2.4625	2.4965	2.4305	2.4815	15152320.0
2009-01-21 10:00:00	AMZN	Stock	2.482	2.499	2.418	2.4215	17750000.0
2009-01-21 11:00:00	AMZN	Stock	2.4224	2.454	2.42	2.4335	12843260.0
2009-01-21 12:00:00	AMZN	Stock	2.4345	2.465	2.4125	2.428	10711680.0
2009-01-21 13:00:00	AMZN	Stock	2.426	2.452	2.419	2.452	9765000.0
2009-01-21 14:00:00	AMZN	Stock	2.453	2.4865	2.4375	2.4865	11446680.0
2009-01-21 15:00:00	AMZN	Stock	2.4865	2.5345	2.48	2.5275	27650240.0
2009-01-21 16:00:00	AMZN	Stock	2.527	2.5595	2.422	2.5415	6160960.0
2009-01-21 17:00:00	AMZN	Stock	2.539	2.5475	2.535	2.5375	305020.0
2009-01-21 18:00:00	AMZN	Stock	2.5325	2.537	2.522	2.53	50200.0
2009-01-21 19:00:00	AMZN	Stock	2.528	2.53	2.528	2.53	11000.0

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

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