PREVIEW / stock_1hour / 2013-10-03

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-03.parquet
  size:    1012 KB
  rows:    46,943
  symbols: 3,519

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-10-03 04:00:00	AAPL	Stock	17.3982	17.4107	17.3982	17.4107	14000.0
2013-10-03 05:00:00	AAPL	Stock	17.4286	17.4286	17.4107	17.4107	20720.0
2013-10-03 06:00:00	AAPL	Stock	17.4107	17.4354	17.4107	17.4354	16240.0
2013-10-03 07:00:00	AAPL	Stock	17.4561	17.5118	17.4339	17.5	253848.0
2013-10-03 08:00:00	AAPL	Stock	17.4964	17.5339	17.4354	17.525	1178828.0
2013-10-03 09:00:00	AAPL	Stock	17.5196	17.5839	17.4146	17.4289	45198384.0
2013-10-03 10:00:00	AAPL	Stock	17.43	17.43	17.2911	17.3446	58858604.0
2013-10-03 11:00:00	AAPL	Stock	17.3393	17.3571	17.1692	17.1735	53258352.0
2013-10-03 12:00:00	AAPL	Stock	17.1721	17.2946	17.1693	17.2679	39701144.0
2013-10-03 13:00:00	AAPL	Stock	17.2689	17.3204	17.2321	17.3143	31135664.0
2013-10-03 14:00:00	AAPL	Stock	17.3093	17.3139	17.2357	17.2507	23101484.0
2013-10-03 15:00:00	AAPL	Stock	17.2525	17.2796	17.2268	17.2639	32367720.0
2013-10-03 16:00:00	AAPL	Stock	17.2696	17.4857	17.2429	17.2429	27403124.0
2013-10-03 17:00:00	AAPL	Stock	17.2429	17.2639	17.2429	17.2604	313880.0
2013-10-03 18:00:00	AAPL	Stock	17.2546	17.2586	17.2446	17.2446	111104.0
2013-10-03 19:00:00	AAPL	Stock	17.2432	17.2554	17.2432	17.2536	125916.0
2013-10-03 07:00:00	MSFT	Stock	33.72	33.82	33.69	33.82	5740.0
2013-10-03 08:00:00	MSFT	Stock	33.77	33.82	33.77	33.82	12108.0
2013-10-03 09:00:00	MSFT	Stock	33.82	34.0	33.82	33.96	3712494.0
2013-10-03 10:00:00	MSFT	Stock	33.955	33.99	33.62	33.8	6077688.0
2013-10-03 11:00:00	MSFT	Stock	33.79	33.95	33.44	33.47	6050616.0
2013-10-03 12:00:00	MSFT	Stock	33.47	33.625	33.42	33.575	3823137.0
2013-10-03 13:00:00	MSFT	Stock	33.573	33.83	33.53	33.775	4240273.0
2013-10-03 14:00:00	MSFT	Stock	33.77	33.79	33.5	33.66	4115596.0
2013-10-03 15:00:00	MSFT	Stock	33.665	33.87	33.62	33.86	8067984.0
2013-10-03 16:00:00	MSFT	Stock	33.87	34.04	33.623	33.74	1633592.0
2013-10-03 17:00:00	MSFT	Stock	33.863	33.87	33.71	33.76	26578.0
2013-10-03 18:00:00	MSFT	Stock	33.76	33.76	33.76	33.76	423.0
2013-10-03 19:00:00	MSFT	Stock	33.78	33.8	33.78	33.79	2568.0
2013-10-03 09:00:00	NVDA	Stock	0.3885	0.3923	0.388	0.3885	20763280.0
2013-10-03 10:00:00	NVDA	Stock	0.3885	0.3885	0.3838	0.3848	49942200.0
2013-10-03 11:00:00	NVDA	Stock	0.3848	0.3858	0.383	0.383	32753560.0
2013-10-03 12:00:00	NVDA	Stock	0.383	0.3868	0.3826	0.3864	85957000.0
2013-10-03 13:00:00	NVDA	Stock	0.3864	0.3902	0.3861	0.3878	73139240.0
2013-10-03 14:00:00	NVDA	Stock	0.3878	0.3878	0.3855	0.3862	34632520.0
2013-10-03 15:00:00	NVDA	Stock	0.386	0.3865	0.3845	0.3848	87359960.0
2013-10-03 16:00:00	NVDA	Stock	0.3845	0.3856	0.384	0.3856	38711960.0
2013-10-03 17:00:00	NVDA	Stock	0.3844	0.3845	0.3844	0.3845	78280.0
2013-10-03 04:00:00	AMZN	Stock	15.95	15.95	15.95	15.95	6600.0
2013-10-03 05:00:00	AMZN	Stock	15.953	15.953	15.953	15.953	66000.0
2013-10-03 07:00:00	AMZN	Stock	15.96	15.975	15.96	15.975	4000.0
2013-10-03 08:00:00	AMZN	Stock	16.018	16.018	15.9815	16.0	32000.0
2013-10-03 09:00:00	AMZN	Stock	16.0005	16.146	15.9305	15.9746	8868960.0
2013-10-03 10:00:00	AMZN	Stock	15.978	15.9975	15.8272	15.8535	11867560.0
2013-10-03 11:00:00	AMZN	Stock	15.85	15.916	15.7	15.7385	8116620.0
2013-10-03 12:00:00	AMZN	Stock	15.7375	15.7875	15.651	15.7768	5536400.0
2013-10-03 13:00:00	AMZN	Stock	15.7684	15.887	15.7445	15.8705	4912440.0
2013-10-03 14:00:00	AMZN	Stock	15.8795	15.8795	15.7	15.7225	4701000.0
2013-10-03 15:00:00	AMZN	Stock	15.7235	15.7705	15.704	15.7365	6169740.0
2013-10-03 16:00:00	AMZN	Stock	15.738	15.8443	15.72	15.7565	2733260.0

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

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