PREVIEW / stock_1hour / 2013-03-18

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-18.parquet
  size:    988 KB
  rows:    46,395
  symbols: 3,489

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-03-18 04:00:00	AAPL	Stock	15.8929	15.8929	15.6786	15.6786	42784.0
2013-03-18 05:00:00	AAPL	Stock	15.71	15.7143	15.71	15.7143	89488.0
2013-03-18 06:00:00	AAPL	Stock	15.7146	15.7318	15.6964	15.6964	87108.0
2013-03-18 07:00:00	AAPL	Stock	15.6896	15.7571	15.6593	15.7439	873544.0
2013-03-18 08:00:00	AAPL	Stock	15.7439	15.815	15.6696	15.7739	3724952.0
2013-03-18 09:00:00	AAPL	Stock	15.7786	15.9814	15.7521	15.92	97264608.0
2013-03-18 10:00:00	AAPL	Stock	15.9204	16.0607	15.8875	16.0464	85474620.0
2013-03-18 11:00:00	AAPL	Stock	16.0449	16.0854	16.0036	16.0843	49457324.0
2013-03-18 12:00:00	AAPL	Stock	16.0846	16.1707	16.0775	16.1304	70486752.0
2013-03-18 13:00:00	AAPL	Stock	16.1307	16.2364	16.12	16.2161	61589696.0
2013-03-18 14:00:00	AAPL	Stock	16.2174	16.3332	16.2107	16.2832	69692868.0
2013-03-18 15:00:00	AAPL	Stock	16.2821	16.3379	16.215	16.2757	123362484.0
2013-03-18 16:00:00	AAPL	Stock	16.2773	16.3009	15.9339	16.2646	15849456.0
2013-03-18 17:00:00	AAPL	Stock	15.8518	16.3036	15.8518	16.3036	2568972.0
2013-03-18 18:00:00	AAPL	Stock	16.3029	16.3029	16.2861	16.2882	4045720.0
2013-03-18 19:00:00	AAPL	Stock	16.2921	16.3	16.2861	16.2893	386064.0
2013-03-18 07:00:00	MSFT	Stock	27.79	27.8	27.76	27.8	5370.0
2013-03-18 08:00:00	MSFT	Stock	27.84	27.87	27.75	27.85	21483.0
2013-03-18 09:00:00	MSFT	Stock	27.85	28.08	27.8	28.07	8521682.0
2013-03-18 10:00:00	MSFT	Stock	28.07	28.21	28.07	28.15	6654857.0
2013-03-18 11:00:00	MSFT	Stock	28.16	28.24	27.85	28.24	5336818.0
2013-03-18 12:00:00	MSFT	Stock	28.24	28.28	28.2	28.235	4274675.0
2013-03-18 13:00:00	MSFT	Stock	28.235	28.28	28.205	28.22	2764665.0
2013-03-18 14:00:00	MSFT	Stock	28.22	28.27	28.16	28.161	3808904.0
2013-03-18 15:00:00	MSFT	Stock	28.165	28.18	28.09	28.1	9823532.0
2013-03-18 16:00:00	MSFT	Stock	28.1	28.303	28.04	28.196	2956250.0
2013-03-18 17:00:00	MSFT	Stock	28.07	28.267	28.07	28.1	39640.0
2013-03-18 18:00:00	MSFT	Stock	28.1	28.1	28.1	28.1	700.0
2013-03-18 19:00:00	MSFT	Stock	28.08	28.12	28.08	28.1	1800.0
2013-03-18 06:00:00	NVDA	Stock	0.3125	0.3125	0.3125	0.3125	4000.0
2013-03-18 07:00:00	NVDA	Stock	0.3128	0.3128	0.3125	0.3125	12000.0
2013-03-18 08:00:00	NVDA	Stock	0.315	0.315	0.313	0.3133	394600.0
2013-03-18 09:00:00	NVDA	Stock	0.3133	0.3143	0.3115	0.3138	36892960.0
2013-03-18 10:00:00	NVDA	Stock	0.3138	0.3155	0.3135	0.3139	37291840.0
2013-03-18 11:00:00	NVDA	Stock	0.3138	0.3159	0.3138	0.3158	37832760.0
2013-03-18 12:00:00	NVDA	Stock	0.3159	0.3168	0.3143	0.3143	30365880.0
2013-03-18 13:00:00	NVDA	Stock	0.3143	0.3148	0.313	0.3133	34807240.0
2013-03-18 14:00:00	NVDA	Stock	0.3133	0.3151	0.313	0.3139	35000440.0
2013-03-18 15:00:00	NVDA	Stock	0.3138	0.3143	0.3128	0.3135	70663320.0
2013-03-18 16:00:00	NVDA	Stock	0.3138	0.3168	0.3137	0.3138	4802000.0
2013-03-18 17:00:00	NVDA	Stock	0.3163	0.3163	0.3163	0.3163	72280.0
2013-03-18 04:00:00	AMZN	Stock	12.87	12.87	12.87	12.87	4000.0
2013-03-18 07:00:00	AMZN	Stock	12.947	12.95	12.947	12.95	4000.0
2013-03-18 08:00:00	AMZN	Stock	12.95	13.2	12.95	12.9625	196980.0
2013-03-18 09:00:00	AMZN	Stock	12.962	13.0745	12.93	12.9955	5986760.0
2013-03-18 10:00:00	AMZN	Stock	12.9885	13.0278	12.89	12.8975	10614260.0
2013-03-18 11:00:00	AMZN	Stock	12.9	12.925	12.8685	12.8955	5674440.0
2013-03-18 12:00:00	AMZN	Stock	12.898	12.967	12.8845	12.905	4224140.0
2013-03-18 13:00:00	AMZN	Stock	12.9023	12.9225	12.856	12.882	5782140.0
2013-03-18 14:00:00	AMZN	Stock	12.8795	12.965	12.8654	12.9185	5342620.0

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

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