PREVIEW / stock_1hour / 2013-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-06.parquet
  size:    996 KB
  rows:    46,086
  symbols: 3,507

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
2013-09-06 05:00:00	AAPL	Stock	17.7696	17.7696	17.7607	17.7657	23240.0
2013-09-06 06:00:00	AAPL	Stock	17.7661	17.7814	17.7661	17.7814	5600.0
2013-09-06 07:00:00	AAPL	Stock	17.7996	17.8479	17.7857	17.8393	733068.0
2013-09-06 08:00:00	AAPL	Stock	17.8393	17.8532	17.7686	17.8218	3898468.0
2013-09-06 09:00:00	AAPL	Stock	17.8218	17.8264	17.5739	17.5893	72397948.0
2013-09-06 10:00:00	AAPL	Stock	17.5861	17.7418	17.4982	17.73	79869356.0
2013-09-06 11:00:00	AAPL	Stock	17.725	17.7618	17.6864	17.7218	30316272.0
2013-09-06 12:00:00	AAPL	Stock	17.7243	17.7779	17.7214	17.7479	22158920.0
2013-09-06 13:00:00	AAPL	Stock	17.7436	17.7857	17.7307	17.7686	20272476.0
2013-09-06 14:00:00	AAPL	Stock	17.7686	17.8196	17.7472	17.7916	28665896.0
2013-09-06 15:00:00	AAPL	Stock	17.7921	17.835	17.7075	17.7943	77245308.0
2013-09-06 16:00:00	AAPL	Stock	17.7925	17.8739	17.5937	17.8586	18427136.0
2013-09-06 17:00:00	AAPL	Stock	17.8589	17.8632	17.7936	17.8571	1495004.0
2013-09-06 18:00:00	AAPL	Stock	17.8543	17.8886	17.8536	17.8611	757596.0
2013-09-06 19:00:00	AAPL	Stock	17.8639	17.8925	17.8639	17.8857	561036.0
2013-09-06 06:00:00	MSFT	Stock	31.3	31.3	31.3	31.3	800.0
2013-09-06 07:00:00	MSFT	Stock	31.34	31.47	31.34	31.36	17400.0
2013-09-06 08:00:00	MSFT	Stock	31.39	31.4	31.32	31.35	277771.0
2013-09-06 09:00:00	MSFT	Stock	31.34	31.39	31.21	31.265	14446930.0
2013-09-06 10:00:00	MSFT	Stock	31.27	31.32	31.13	31.3	14755521.0
2013-09-06 11:00:00	MSFT	Stock	31.3	31.37	31.21	31.25	6596245.0
2013-09-06 12:00:00	MSFT	Stock	31.25	31.29	31.21	31.26	6830680.0
2013-09-06 13:00:00	MSFT	Stock	31.26	31.31	31.21	31.277	6378367.0
2013-09-06 14:00:00	MSFT	Stock	31.277	31.29	31.22	31.25	5516706.0
2013-09-06 15:00:00	MSFT	Stock	31.26	31.26	31.15	31.16	15664323.0
2013-09-06 16:00:00	MSFT	Stock	31.15	31.282	31.1	31.17	1749959.0
2013-09-06 17:00:00	MSFT	Stock	31.19	31.27	31.17	31.22	5895.0
2013-09-06 19:00:00	MSFT	Stock	31.18	31.2	31.17	31.19	3124.0
2013-09-06 08:00:00	NVDA	Stock	0.3748	0.375	0.3743	0.375	567800.0
2013-09-06 09:00:00	NVDA	Stock	0.3745	0.3748	0.3691	0.3734	36323440.0
2013-09-06 10:00:00	NVDA	Stock	0.3735	0.3758	0.372	0.3745	73794200.0
2013-09-06 11:00:00	NVDA	Stock	0.3745	0.3753	0.373	0.373	20492840.0
2013-09-06 12:00:00	NVDA	Stock	0.373	0.3738	0.3728	0.3735	9903400.0
2013-09-06 13:00:00	NVDA	Stock	0.3736	0.3748	0.3733	0.3743	16690680.0
2013-09-06 14:00:00	NVDA	Stock	0.3744	0.3748	0.373	0.3734	16742360.0
2013-09-06 15:00:00	NVDA	Stock	0.3735	0.3738	0.3718	0.372	42701240.0
2013-09-06 16:00:00	NVDA	Stock	0.372	0.3741	0.3719	0.3719	8155800.0
2013-09-06 17:00:00	NVDA	Stock	0.3715	0.3715	0.3715	0.3715	5680.0
2013-09-06 08:00:00	AMZN	Stock	14.8035	14.8035	14.705	14.755	303460.0
2013-09-06 09:00:00	AMZN	Stock	14.755	14.8149	14.6135	14.621	7181840.0
2013-09-06 10:00:00	AMZN	Stock	14.6185	14.769	14.54	14.7545	7882000.0
2013-09-06 11:00:00	AMZN	Stock	14.76	14.944	14.7555	14.908	11227820.0
2013-09-06 12:00:00	AMZN	Stock	14.9085	14.919	14.8445	14.885	2811940.0
2013-09-06 13:00:00	AMZN	Stock	14.8825	14.919	14.853	14.8885	2523100.0
2013-09-06 14:00:00	AMZN	Stock	14.8915	14.917	14.8475	14.858	4910740.0
2013-09-06 15:00:00	AMZN	Stock	14.8585	14.8725	14.7855	14.796	5901380.0
2013-09-06 16:00:00	AMZN	Stock	14.793	14.8408	14.788	14.79	2214400.0
2013-09-06 17:00:00	AMZN	Stock	14.824	14.825	14.824	14.825	44240.0
2013-09-06 19:00:00	AMZN	Stock	14.811	14.811	14.795	14.795	27440.0
2013-09-06 06:00:00	META	Stock	42.78	43.1	42.78	43.0	7619.0

> showing 50 of 46,086 rows — these rows as CSV

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