PREVIEW / stock_1hour / 2011-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-17.parquet
  size:    897 KB
  rows:    43,050
  symbols: 3,476

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-10-17 04:00:00	AAPL	Stock	15.17	15.2143	15.17	15.2143	28700.0
2011-10-17 05:00:00	AAPL	Stock	15.2321	15.2321	15.1304	15.1786	128240.0
2011-10-17 06:00:00	AAPL	Stock	15.1429	15.1607	15.0893	15.0921	182308.0
2011-10-17 07:00:00	AAPL	Stock	15.1061	15.1964	15.0914	15.1096	1516172.0
2011-10-17 08:00:00	AAPL	Stock	15.1229	15.1732	15.0714	15.0789	8601908.0
2011-10-17 09:00:00	AAPL	Stock	15.08	15.1321	14.9918	15.0784	99078756.0
2011-10-17 10:00:00	AAPL	Stock	15.08	15.2393	15.0464	15.1842	135231572.0
2011-10-17 11:00:00	AAPL	Stock	15.1811	15.2107	15.0289	15.0504	83250076.0
2011-10-17 12:00:00	AAPL	Stock	15.0471	15.0693	14.855	14.9404	120587208.0
2011-10-17 13:00:00	AAPL	Stock	14.9396	15.0211	14.8932	14.9832	62613152.0
2011-10-17 14:00:00	AAPL	Stock	14.9864	14.9964	14.8821	14.9607	49043092.0
2011-10-17 15:00:00	AAPL	Stock	14.9607	15.025	14.9468	14.9918	91510832.0
2011-10-17 16:00:00	AAPL	Stock	14.9918	15.0481	14.8943	14.9464	27184360.0
2011-10-17 17:00:00	AAPL	Stock	14.93	14.9425	14.8929	14.9411	917280.0
2011-10-17 18:00:00	AAPL	Stock	14.9414	14.9996	14.9329	14.9761	418348.0
2011-10-17 19:00:00	AAPL	Stock	14.9654	14.985	14.9471	14.9561	524412.0
2011-10-17 04:00:00	MSFT	Stock	27.4	27.4	27.4	27.4	100.0
2011-10-17 07:00:00	MSFT	Stock	27.35	27.41	27.18	27.18	4299.0
2011-10-17 08:00:00	MSFT	Stock	27.25	27.25	27.16	27.16	5510.0
2011-10-17 09:00:00	MSFT	Stock	27.13	27.42	27.08	27.205	4202448.0
2011-10-17 10:00:00	MSFT	Stock	27.2	27.25	27.01	27.02	5916658.0
2011-10-17 11:00:00	MSFT	Stock	27.018	27.19	27.01	27.08	4309638.0
2011-10-17 12:00:00	MSFT	Stock	27.08	27.14	27.02	27.07	3569711.0
2011-10-17 13:00:00	MSFT	Stock	27.06	27.08	26.98	27.03	3781105.0
2011-10-17 14:00:00	MSFT	Stock	27.035	27.04	26.85	26.98	3812520.0
2011-10-17 15:00:00	MSFT	Stock	26.98	27.04	26.87	26.98	9771102.0
2011-10-17 16:00:00	MSFT	Stock	26.98	27.27	26.67	26.68	2507022.0
2011-10-17 17:00:00	MSFT	Stock	26.68	26.68	26.63	26.65	24647.0
2011-10-17 18:00:00	MSFT	Stock	26.98	26.98	26.7	26.7	8900.0
2011-10-17 19:00:00	MSFT	Stock	26.71	26.73	26.7	26.7	9588.0
2011-10-17 08:00:00	NVDA	Stock	0.3925	0.3925	0.39	0.39	150720.0
2011-10-17 09:00:00	NVDA	Stock	0.3885	0.3888	0.383	0.3842	87335600.0
2011-10-17 10:00:00	NVDA	Stock	0.3842	0.3845	0.3798	0.3808	75369720.0
2011-10-17 11:00:00	NVDA	Stock	0.3808	0.382	0.3775	0.3788	80465520.0
2011-10-17 12:00:00	NVDA	Stock	0.3788	0.3788	0.3738	0.375	89303560.0
2011-10-17 13:00:00	NVDA	Stock	0.3753	0.3773	0.3738	0.3755	54197440.0
2011-10-17 14:00:00	NVDA	Stock	0.3755	0.3761	0.3715	0.3735	61572600.0
2011-10-17 15:00:00	NVDA	Stock	0.3738	0.3755	0.3715	0.3735	140648200.0
2011-10-17 16:00:00	NVDA	Stock	0.3735	0.393	0.37	0.3735	21005160.0
2011-10-17 17:00:00	NVDA	Stock	0.3735	0.3735	0.37	0.371	73400.0
2011-10-17 18:00:00	NVDA	Stock	0.3703	0.3735	0.37	0.371	387840.0
2011-10-17 19:00:00	NVDA	Stock	0.3708	0.3723	0.3705	0.3723	82000.0
2011-10-17 04:00:00	AMZN	Stock	12.4685	12.469	12.4685	12.469	4000.0
2011-10-17 06:00:00	AMZN	Stock	12.4	12.4	12.306	12.306	40000.0
2011-10-17 07:00:00	AMZN	Stock	12.3355	12.3355	12.2755	12.325	26000.0
2011-10-17 08:00:00	AMZN	Stock	12.3195	12.3595	12.2585	12.268	561000.0
2011-10-17 09:00:00	AMZN	Stock	12.274	12.274	12.125	12.155	19829480.0
2011-10-17 10:00:00	AMZN	Stock	12.1582	12.2465	12.1425	12.186	17752620.0
2011-10-17 11:00:00	AMZN	Stock	12.185	12.2065	12.134	12.146	10882160.0
2011-10-17 12:00:00	AMZN	Stock	12.142	12.1679	12.0385	12.0765	12435400.0

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

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