PREVIEW / stock_1hour / 2009-09-22

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-09-22.parquet
  size:    894 KB
  rows:    42,622
  symbols: 3,395

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-09-22 04:00:00	AAPL	Stock	6.5961	6.5961	6.5961	6.5961	2800.0
2009-09-22 05:00:00	AAPL	Stock	6.6079	6.6079	6.6079	6.6079	2800.0
2009-09-22 06:00:00	AAPL	Stock	6.6161	6.625	6.6154	6.625	36400.0
2009-09-22 07:00:00	AAPL	Stock	6.6161	6.6329	6.6089	6.6329	122080.0
2009-09-22 08:00:00	AAPL	Stock	6.6189	6.6429	6.6143	6.6336	1544060.0
2009-09-22 09:00:00	AAPL	Stock	6.6336	6.6336	6.5596	6.5636	75897528.0
2009-09-22 10:00:00	AAPL	Stock	6.5636	6.5907	6.5304	6.5487	67202968.0
2009-09-22 11:00:00	AAPL	Stock	6.5493	6.5946	6.5486	6.5946	37575944.0
2009-09-22 12:00:00	AAPL	Stock	6.5932	6.6098	6.5739	6.5857	33979484.0
2009-09-22 13:00:00	AAPL	Stock	6.585	6.5979	6.5718	6.5807	28188972.0
2009-09-22 14:00:00	AAPL	Stock	6.5807	6.5979	6.5739	6.5935	28318108.0
2009-09-22 15:00:00	AAPL	Stock	6.5939	6.5989	6.5764	6.5886	49087836.0
2009-09-22 16:00:00	AAPL	Stock	6.5907	6.5957	6.543	6.5882	9730112.0
2009-09-22 17:00:00	AAPL	Stock	6.5864	6.5914	6.5854	6.5854	11418932.0
2009-09-22 18:00:00	AAPL	Stock	6.5886	6.5982	6.5886	6.5893	214312.0
2009-09-22 19:00:00	AAPL	Stock	6.5911	6.5929	6.5832	6.5854	112756.0
2009-09-22 06:00:00	MSFT	Stock	25.49	25.49	25.49	25.49	386.0
2009-09-22 07:00:00	MSFT	Stock	25.42	25.42	25.42	25.42	500.0
2009-09-22 08:00:00	MSFT	Stock	25.42	25.45	25.4	25.4	12491.0
2009-09-22 09:00:00	MSFT	Stock	25.4	25.49	25.29	25.38	3700965.0
2009-09-22 10:00:00	MSFT	Stock	25.38	25.52	25.34	25.47	7473960.0
2009-09-22 11:00:00	MSFT	Stock	25.47	25.569	25.462	25.55	5442031.0
2009-09-22 12:00:00	MSFT	Stock	25.54	25.7	25.52	25.67	6979184.0
2009-09-22 13:00:00	MSFT	Stock	25.662	25.72	25.59	25.72	7007560.0
2009-09-22 14:00:00	MSFT	Stock	25.71	25.73	25.65	25.705	4418699.0
2009-09-22 15:00:00	MSFT	Stock	25.7	25.82	25.29	25.77	15751826.0
2009-09-22 16:00:00	MSFT	Stock	25.77	25.87	25.435	25.84	6477913.0
2009-09-22 17:00:00	MSFT	Stock	25.82	25.82	25.77	25.78	1484.0
2009-09-22 18:00:00	MSFT	Stock	25.79	25.79	25.77	25.77	65508.0
2009-09-22 19:00:00	MSFT	Stock	25.81	25.86	25.81	25.82	1697.0
2009-09-22 09:00:00	NVDA	Stock	0.3825	0.3825	0.3778	0.38	53107800.0
2009-09-22 10:00:00	NVDA	Stock	0.3798	0.382	0.3788	0.3798	42392680.0
2009-09-22 11:00:00	NVDA	Stock	0.3798	0.3822	0.3788	0.3803	38244560.0
2009-09-22 12:00:00	NVDA	Stock	0.3805	0.3838	0.3803	0.3818	55774680.0
2009-09-22 13:00:00	NVDA	Stock	0.3815	0.383	0.379	0.379	39382520.0
2009-09-22 14:00:00	NVDA	Stock	0.3793	0.3798	0.3765	0.3795	52735120.0
2009-09-22 15:00:00	NVDA	Stock	0.3795	0.3805	0.3785	0.3795	67269120.0
2009-09-22 16:00:00	NVDA	Stock	0.3795	0.3803	0.3795	0.3795	7666360.0
2009-09-22 19:00:00	NVDA	Stock	0.38	0.38	0.38	0.38	36000.0
2009-09-22 07:00:00	AMZN	Stock	4.54	4.55	4.54	4.55	12000.0
2009-09-22 08:00:00	AMZN	Stock	4.5495	4.5495	4.53	4.53	670000.0
2009-09-22 09:00:00	AMZN	Stock	4.5365	4.6925	4.5345	4.6675	36797320.0
2009-09-22 10:00:00	AMZN	Stock	4.6685	4.7095	4.645	4.6625	32823900.0
2009-09-22 11:00:00	AMZN	Stock	4.664	4.7095	4.661	4.6685	19389220.0
2009-09-22 12:00:00	AMZN	Stock	4.6685	4.6925	4.6575	4.658	14249820.0
2009-09-22 13:00:00	AMZN	Stock	4.659	4.6675	4.638	4.665	12028260.0
2009-09-22 14:00:00	AMZN	Stock	4.664	4.704	4.6635	4.7001	18274180.0
2009-09-22 15:00:00	AMZN	Stock	4.699	4.709	4.684	4.6895	25058400.0
2009-09-22 16:00:00	AMZN	Stock	4.6875	4.69	4.6706	4.69	3959400.0
2009-09-22 17:00:00	AMZN	Stock	4.69	4.69	4.69	4.69	9900.0

> showing 50 of 42,622 rows — these rows as CSV

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