PREVIEW / stock_1hour / 2013-12-06

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-06.parquet
  size:    1.0 MB
  rows:    47,801
  symbols: 3,528

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-12-06 04:00:00	AAPL	Stock	20.3214	20.3629	20.3214	20.3629	19320.0
2013-12-06 05:00:00	AAPL	Stock	20.3721	20.3721	20.3429	20.3429	50512.0
2013-12-06 06:00:00	AAPL	Stock	20.3482	20.3568	20.2143	20.2411	155428.0
2013-12-06 07:00:00	AAPL	Stock	20.25	20.275	20.1679	20.2318	607404.0
2013-12-06 08:00:00	AAPL	Stock	20.2432	20.3571	20.1814	20.2143	4217080.0
2013-12-06 09:00:00	AAPL	Stock	20.2164	20.2411	20.1286	20.1784	70704592.0
2013-12-06 10:00:00	AAPL	Stock	20.1786	20.2032	20.0461	20.1089	67089820.0
2013-12-06 11:00:00	AAPL	Stock	20.1104	20.1468	20.0836	20.1282	27447952.0
2013-12-06 12:00:00	AAPL	Stock	20.1293	20.175	20.0946	20.1118	33228748.0
2013-12-06 13:00:00	AAPL	Stock	20.1118	20.1314	20.0571	20.0754	25043424.0
2013-12-06 14:00:00	AAPL	Stock	20.0761	20.1443	20.0386	20.0589	23210040.0
2013-12-06 15:00:00	AAPL	Stock	20.0596	20.0902	19.9846	19.9975	59404716.0
2013-12-06 16:00:00	AAPL	Stock	20.0007	20.132	19.9889	20.0011	15554308.0
2013-12-06 17:00:00	AAPL	Stock	20.0004	20.0018	19.9982	20.0004	1131956.0
2013-12-06 18:00:00	AAPL	Stock	20.0	20.0068	19.9982	20.0036	395332.0
2013-12-06 19:00:00	AAPL	Stock	20.0043	20.0089	19.9982	20.0	187516.0
2013-12-06 07:00:00	MSFT	Stock	38.17	38.17	38.16	38.17	2680.0
2013-12-06 08:00:00	MSFT	Stock	38.17	38.3	37.99	38.23	98380.0
2013-12-06 09:00:00	MSFT	Stock	38.21	38.46	38.1	38.186	6682193.0
2013-12-06 10:00:00	MSFT	Stock	38.19	38.23	37.99	38.12	5118246.0
2013-12-06 11:00:00	MSFT	Stock	38.115	38.37	38.093	38.37	2605348.0
2013-12-06 12:00:00	MSFT	Stock	38.363	38.545	38.29	38.54	3080208.0
2013-12-06 13:00:00	MSFT	Stock	38.54	38.55	38.26	38.26	3481799.0
2013-12-06 14:00:00	MSFT	Stock	38.265	38.33	38.22	38.27	3204594.0
2013-12-06 15:00:00	MSFT	Stock	38.263	38.38	38.21	38.35	6095574.0
2013-12-06 16:00:00	MSFT	Stock	38.36	38.56	38.171	38.47	5782066.0
2013-12-06 17:00:00	MSFT	Stock	38.47	38.48	38.339	38.47	63535.0
2013-12-06 18:00:00	MSFT	Stock	38.36	38.48	38.36	38.45	10916.0
2013-12-06 19:00:00	MSFT	Stock	38.46	38.48	38.46	38.46	6350.0
2013-12-06 08:00:00	NVDA	Stock	0.3955	0.3955	0.3955	0.3955	4000.0
2013-12-06 09:00:00	NVDA	Stock	0.398	0.398	0.39	0.3905	33387320.0
2013-12-06 10:00:00	NVDA	Stock	0.3905	0.3918	0.3895	0.39	42304920.0
2013-12-06 11:00:00	NVDA	Stock	0.39	0.39	0.3878	0.3895	31238960.0
2013-12-06 12:00:00	NVDA	Stock	0.3894	0.3911	0.3888	0.3901	16403360.0
2013-12-06 13:00:00	NVDA	Stock	0.3902	0.3904	0.3893	0.3893	10539000.0
2013-12-06 14:00:00	NVDA	Stock	0.3895	0.3898	0.3888	0.3889	28012680.0
2013-12-06 15:00:00	NVDA	Stock	0.3889	0.3893	0.3858	0.3865	93472240.0
2013-12-06 16:00:00	NVDA	Stock	0.3868	0.3868	0.3868	0.3868	2709320.0
2013-12-06 17:00:00	NVDA	Stock	0.3868	0.3868	0.3868	0.3868	164800.0
2013-12-06 05:00:00	AMZN	Stock	19.372	19.372	19.372	19.372	2000.0
2013-12-06 06:00:00	AMZN	Stock	19.34	19.34	19.34	19.34	4000.0
2013-12-06 08:00:00	AMZN	Stock	19.325	19.3815	19.241	19.3815	304360.0
2013-12-06 09:00:00	AMZN	Stock	19.375	19.45	19.2505	19.3383	7911100.0
2013-12-06 10:00:00	AMZN	Stock	19.351	19.3711	19.1915	19.2795	8836880.0
2013-12-06 11:00:00	AMZN	Stock	19.273	19.3555	19.2385	19.332	2913120.0
2013-12-06 12:00:00	AMZN	Stock	19.3425	19.361	19.3052	19.3145	2347560.0
2013-12-06 13:00:00	AMZN	Stock	19.3155	19.325	19.2665	19.299	2021780.0
2013-12-06 14:00:00	AMZN	Stock	19.296	19.335	19.2955	19.3183	2021020.0
2013-12-06 15:00:00	AMZN	Stock	19.3185	19.354	19.295	19.334	7633520.0
2013-12-06 16:00:00	AMZN	Stock	19.3475	19.3615	19.3055	19.3195	4564620.0

> showing 50 of 47,801 rows — these rows as CSV

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