PREVIEW / stock_1hour / 2010-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-23.parquet
  size:    915 KB
  rows:    43,363
  symbols: 3,474

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
2010-03-23 07:00:00	AAPL	Stock	8.0454	8.0464	8.0321	8.0411	214200.0
2010-03-23 08:00:00	AAPL	Stock	8.0414	8.0621	8.0368	8.0504	1522948.0
2010-03-23 09:00:00	AAPL	Stock	8.0504	8.075	8.03	8.0557	66161732.0
2010-03-23 10:00:00	AAPL	Stock	8.0557	8.0743	8.0232	8.0289	88337592.0
2010-03-23 11:00:00	AAPL	Stock	8.0289	8.0468	8.0036	8.0432	51057468.0
2010-03-23 12:00:00	AAPL	Stock	8.0432	8.0643	8.0407	8.0632	30426256.0
2010-03-23 13:00:00	AAPL	Stock	8.0629	8.0993	8.0589	8.0764	62282192.0
2010-03-23 14:00:00	AAPL	Stock	8.0768	8.1493	8.0757	8.145	109726232.0
2010-03-23 15:00:00	AAPL	Stock	8.1457	8.1707	8.1393	8.1568	122930108.0
2010-03-23 16:00:00	AAPL	Stock	8.1571	8.1607	8.092	8.1514	8335068.0
2010-03-23 17:00:00	AAPL	Stock	8.1514	8.1601	8.1486	8.1486	306040.0
2010-03-23 18:00:00	AAPL	Stock	8.1486	8.1593	8.1486	8.1557	453404.0
2010-03-23 19:00:00	AAPL	Stock	8.1571	8.1582	8.1486	8.1489	322504.0
2010-03-23 07:00:00	MSFT	Stock	29.61	29.61	29.61	29.61	114.0
2010-03-23 08:00:00	MSFT	Stock	29.6	29.63	29.57	29.63	1248.0
2010-03-23 09:00:00	MSFT	Stock	29.63	29.67	29.41	29.56	4086287.0
2010-03-23 10:00:00	MSFT	Stock	29.56	29.74	29.46	29.608	6785351.0
2010-03-23 11:00:00	MSFT	Stock	29.6	29.76	29.53	29.72	5561775.0
2010-03-23 12:00:00	MSFT	Stock	29.72	29.78	29.7	29.77	2838321.0
2010-03-23 13:00:00	MSFT	Stock	29.77	29.81	29.71	29.715	3081746.0
2010-03-23 14:00:00	MSFT	Stock	29.71	29.78	29.68	29.73	4175726.0
2010-03-23 15:00:00	MSFT	Stock	29.727	29.9	29.7	29.85	9408117.0
2010-03-23 16:00:00	MSFT	Stock	29.87	29.92	29.59	29.9	3700510.0
2010-03-23 17:00:00	MSFT	Stock	29.9	29.95	29.89	29.9	16427.0
2010-03-23 18:00:00	MSFT	Stock	29.88	29.97	29.88	29.96	71226.0
2010-03-23 19:00:00	MSFT	Stock	29.96	29.97	29.94	29.97	4400.0
2010-03-23 20:00:00	MSFT	Stock	29.5	29.71	29.5	29.71	2645.0
2010-03-23 08:00:00	NVDA	Stock	0.4412	0.4425	0.4412	0.4425	200000.0
2010-03-23 09:00:00	NVDA	Stock	0.4425	0.4468	0.438	0.4458	80303440.0
2010-03-23 10:00:00	NVDA	Stock	0.4458	0.4495	0.4415	0.4452	104129400.0
2010-03-23 11:00:00	NVDA	Stock	0.445	0.4458	0.4425	0.445	73396600.0
2010-03-23 12:00:00	NVDA	Stock	0.445	0.4461	0.443	0.4442	38890680.0
2010-03-23 13:00:00	NVDA	Stock	0.444	0.4462	0.4413	0.4418	44327360.0
2010-03-23 14:00:00	NVDA	Stock	0.442	0.4445	0.4412	0.4438	48427640.0
2010-03-23 15:00:00	NVDA	Stock	0.444	0.4482	0.4435	0.447	88886080.0
2010-03-23 16:00:00	NVDA	Stock	0.4472	0.4475	0.445	0.4462	13567280.0
2010-03-23 17:00:00	NVDA	Stock	0.4472	0.4472	0.4458	0.4458	172200.0
2010-03-23 18:00:00	NVDA	Stock	0.4455	0.4455	0.4455	0.4455	4240.0
2010-03-23 07:00:00	AMZN	Stock	6.53	6.53	6.53	6.53	2000.0
2010-03-23 08:00:00	AMZN	Stock	6.5465	6.5465	6.5465	6.5465	2000.0
2010-03-23 09:00:00	AMZN	Stock	6.5465	6.547	6.479	6.491	7720020.0
2010-03-23 10:00:00	AMZN	Stock	6.492	6.4975	6.431	6.4337	18225900.0
2010-03-23 11:00:00	AMZN	Stock	6.4332	6.46	6.4035	6.4495	16255920.0
2010-03-23 12:00:00	AMZN	Stock	6.45	6.4565	6.4303	6.4315	5954820.0
2010-03-23 13:00:00	AMZN	Stock	6.433	6.447	6.419	6.4204	7211660.0
2010-03-23 14:00:00	AMZN	Stock	6.4205	6.4615	6.42	6.4485	8121500.0
2010-03-23 15:00:00	AMZN	Stock	6.4485	6.472	6.4425	6.4625	17964460.0
2010-03-23 16:00:00	AMZN	Stock	6.463	6.4725	6.453	6.463	2500980.0
2010-03-23 17:00:00	AMZN	Stock	6.4565	6.466	6.4565	6.462	19000.0
2010-03-23 18:00:00	AMZN	Stock	6.463	6.4665	6.4575	6.4665	46900.0

> showing 50 of 43,363 rows — these rows as CSV

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