PREVIEW / stock_1hour / 2012-05-16

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-16.parquet
  size:    943 KB
  rows:    44,530
  symbols: 3,531

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
2012-05-16 04:00:00	AAPL	Stock	19.7036	19.7496	19.69	19.7214	95536.0
2012-05-16 05:00:00	AAPL	Stock	19.7393	19.7393	19.7393	19.7393	5600.0
2012-05-16 06:00:00	AAPL	Stock	19.7357	19.7782	19.7357	19.7779	31080.0
2012-05-16 07:00:00	AAPL	Stock	19.785	19.9211	19.785	19.8929	1304380.0
2012-05-16 08:00:00	AAPL	Stock	19.8754	19.9029	19.7746	19.7857	2808344.0
2012-05-16 09:00:00	AAPL	Stock	19.7961	19.8889	19.7404	19.782	64162952.0
2012-05-16 10:00:00	AAPL	Stock	19.7846	19.8293	19.7007	19.799	79516136.0
2012-05-16 11:00:00	AAPL	Stock	19.7921	19.8146	19.6554	19.7268	60333196.0
2012-05-16 12:00:00	AAPL	Stock	19.7295	19.7411	19.6875	19.7036	26482596.0
2012-05-16 13:00:00	AAPL	Stock	19.7036	19.7143	19.4754	19.5677	75924688.0
2012-05-16 14:00:00	AAPL	Stock	19.5643	19.6071	19.4107	19.4921	84932372.0
2012-05-16 15:00:00	AAPL	Stock	19.4921	19.5436	19.3229	19.5025	147647248.0
2012-05-16 16:00:00	AAPL	Stock	19.5018	19.6981	19.3484	19.5125	11750872.0
2012-05-16 17:00:00	AAPL	Stock	19.5043	19.5043	19.3929	19.3929	736568.0
2012-05-16 18:00:00	AAPL	Stock	19.3929	19.4421	19.3836	19.4339	373296.0
2012-05-16 19:00:00	AAPL	Stock	19.4286	19.475	19.4268	19.4643	343532.0
2012-05-16 07:00:00	MSFT	Stock	30.37	30.37	30.37	30.37	405.0
2012-05-16 08:00:00	MSFT	Stock	30.23	30.47	30.2	30.45	16706.0
2012-05-16 09:00:00	MSFT	Stock	30.41	30.44	29.95	30.075	8035102.0
2012-05-16 10:00:00	MSFT	Stock	30.07	30.16	29.96	30.085	8699047.0
2012-05-16 11:00:00	MSFT	Stock	30.09	30.09	29.74	29.95	11243064.0
2012-05-16 12:00:00	MSFT	Stock	29.95	29.99	29.85	29.928	4663665.0
2012-05-16 13:00:00	MSFT	Stock	29.929	29.97	29.82	29.88	4785456.0
2012-05-16 14:00:00	MSFT	Stock	29.885	30.02	29.75	29.955	8391655.0
2012-05-16 15:00:00	MSFT	Stock	29.95	29.98	29.85	29.9	10051253.0
2012-05-16 16:00:00	MSFT	Stock	29.9	30.034	29.83	29.83	3263124.0
2012-05-16 17:00:00	MSFT	Stock	29.89	29.9	29.82	29.89	3400.0
2012-05-16 18:00:00	MSFT	Stock	29.85	29.85	29.82	29.83	900.0
2012-05-16 19:00:00	MSFT	Stock	29.83	29.9	29.83	29.9	16100.0
2012-05-16 09:00:00	NVDA	Stock	0.3265	0.3293	0.3245	0.3275	40248480.0
2012-05-16 10:00:00	NVDA	Stock	0.3274	0.3288	0.325	0.3269	86161720.0
2012-05-16 11:00:00	NVDA	Stock	0.3268	0.327	0.3228	0.3233	62271000.0
2012-05-16 12:00:00	NVDA	Stock	0.3235	0.3235	0.321	0.321	37036640.0
2012-05-16 13:00:00	NVDA	Stock	0.321	0.3223	0.3175	0.3191	31649760.0
2012-05-16 14:00:00	NVDA	Stock	0.3193	0.3213	0.3175	0.3205	65128280.0
2012-05-16 15:00:00	NVDA	Stock	0.3204	0.321	0.3175	0.3183	136100480.0
2012-05-16 16:00:00	NVDA	Stock	0.3183	0.3186	0.3178	0.3185	9220920.0
2012-05-16 17:00:00	NVDA	Stock	0.3185	0.3185	0.3185	0.3185	684000.0
2012-05-16 18:00:00	NVDA	Stock	0.3188	0.32	0.3188	0.32	46400.0
2012-05-16 19:00:00	NVDA	Stock	0.32	0.32	0.3175	0.32	155600.0
2012-05-16 07:00:00	AMZN	Stock	11.2395	11.2555	11.2395	11.2555	43200.0
2012-05-16 08:00:00	AMZN	Stock	11.225	11.2945	11.2	11.25	354380.0
2012-05-16 09:00:00	AMZN	Stock	11.255	11.4	11.2265	11.37	10865980.0
2012-05-16 10:00:00	AMZN	Stock	11.3656	11.385	11.2875	11.2946	11992020.0
2012-05-16 11:00:00	AMZN	Stock	11.2946	11.3055	11.225	11.2925	11517640.0
2012-05-16 12:00:00	AMZN	Stock	11.2916	11.2925	11.2255	11.2346	5357260.0
2012-05-16 13:00:00	AMZN	Stock	11.2355	11.283	11.125	11.2045	10080600.0
2012-05-16 14:00:00	AMZN	Stock	11.206	11.298	11.166	11.287	7714500.0
2012-05-16 15:00:00	AMZN	Stock	11.285	11.307	11.1255	11.199	42314920.0
2012-05-16 16:00:00	AMZN	Stock	11.203	11.2915	11.1418	11.2215	4763880.0

> showing 50 of 44,530 rows — these rows as CSV

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