PREVIEW / stock_1hour / 2012-02-14

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-14.parquet
  size:    937 KB
  rows:    44,420
  symbols: 3,527

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-02-14 04:00:00	AAPL	Stock	17.9643	18.0714	17.9643	18.0714	238280.0
2012-02-14 05:00:00	AAPL	Stock	18.0779	18.1071	18.0586	18.1071	165760.0
2012-02-14 06:00:00	AAPL	Stock	18.1	18.1179	18.0686	18.0714	219268.0
2012-02-14 07:00:00	AAPL	Stock	18.075	18.0804	18.0232	18.0232	1227436.0
2012-02-14 08:00:00	AAPL	Stock	18.0336	18.075	17.9429	17.9461	4888268.0
2012-02-14 09:00:00	AAPL	Stock	17.9514	18.0439	17.9286	17.9811	86555728.0
2012-02-14 10:00:00	AAPL	Stock	17.9821	18.0075	17.9286	17.9764	59990084.0
2012-02-14 11:00:00	AAPL	Stock	17.9779	18.0311	17.9629	18.0007	41228264.0
2012-02-14 12:00:00	AAPL	Stock	18.0018	18.0143	17.9729	17.9986	31772804.0
2012-02-14 13:00:00	AAPL	Stock	17.9989	18.0179	17.9625	17.9981	30812152.0
2012-02-14 14:00:00	AAPL	Stock	18.0	18.0414	17.9821	18.0036	44023392.0
2012-02-14 15:00:00	AAPL	Stock	18.0054	18.1986	18.0011	18.1934	120950564.0
2012-02-14 16:00:00	AAPL	Stock	18.1936	18.2818	17.9417	18.25	28578592.0
2012-02-14 17:00:00	AAPL	Stock	18.2536	18.2714	18.195	18.2514	1499988.0
2012-02-14 18:00:00	AAPL	Stock	18.2511	18.2768	18.25	18.275	487228.0
2012-02-14 19:00:00	AAPL	Stock	18.275	18.2907	18.2568	18.2679	1281420.0
2012-02-14 07:00:00	MSFT	Stock	30.48	30.49	30.38	30.38	8600.0
2012-02-14 08:00:00	MSFT	Stock	30.38	30.4	30.28	30.28	31110.0
2012-02-14 09:00:00	MSFT	Stock	30.31	30.46	30.22	30.26	6071861.0
2012-02-14 10:00:00	MSFT	Stock	30.27	30.29	30.07	30.08	6809073.0
2012-02-14 11:00:00	MSFT	Stock	30.077	30.15	30.05	30.078	4493747.0
2012-02-14 12:00:00	MSFT	Stock	30.08	30.1	29.9	29.901	4762704.0
2012-02-14 13:00:00	MSFT	Stock	29.902	30.05	29.85	29.999	12968411.0
2012-02-14 14:00:00	MSFT	Stock	29.995	30.09	29.97	30.08	5562245.0
2012-02-14 15:00:00	MSFT	Stock	30.09	30.27	30.02	30.25	9825286.0
2012-02-14 16:00:00	MSFT	Stock	30.25	30.38	29.98	30.25	4390164.0
2012-02-14 17:00:00	MSFT	Stock	30.23	30.25	30.2	30.2	167540.0
2012-02-14 18:00:00	MSFT	Stock	30.2	30.2	30.17	30.2	1962.0
2012-02-14 19:00:00	MSFT	Stock	30.19	30.2	30.16	30.16	17250.0
2012-02-14 08:00:00	NVDA	Stock	0.4038	0.405	0.4035	0.4038	190000.0
2012-02-14 09:00:00	NVDA	Stock	0.4038	0.4095	0.4018	0.4045	69997120.0
2012-02-14 10:00:00	NVDA	Stock	0.4043	0.4062	0.4013	0.404	71747480.0
2012-02-14 11:00:00	NVDA	Stock	0.404	0.4053	0.402	0.4045	59954240.0
2012-02-14 12:00:00	NVDA	Stock	0.4045	0.4048	0.4005	0.4005	48105160.0
2012-02-14 13:00:00	NVDA	Stock	0.4005	0.4043	0.4003	0.4038	39966640.0
2012-02-14 14:00:00	NVDA	Stock	0.4038	0.404	0.4013	0.402	36115960.0
2012-02-14 15:00:00	NVDA	Stock	0.402	0.4062	0.4015	0.406	82121520.0
2012-02-14 16:00:00	NVDA	Stock	0.406	0.409	0.4025	0.4068	41016200.0
2012-02-14 17:00:00	NVDA	Stock	0.406	0.409	0.406	0.409	909200.0
2012-02-14 18:00:00	NVDA	Stock	0.41	0.41	0.4085	0.4085	209400.0
2012-02-14 19:00:00	NVDA	Stock	0.408	0.41	0.408	0.4098	193240.0
2012-02-14 05:00:00	AMZN	Stock	9.55	9.575	9.55	9.575	46000.0
2012-02-14 07:00:00	AMZN	Stock	9.57	9.57	9.57	9.57	2000.0
2012-02-14 08:00:00	AMZN	Stock	9.561	9.563	9.5125	9.52	382340.0
2012-02-14 09:00:00	AMZN	Stock	9.524	9.6785	9.513	9.645	20828140.0
2012-02-14 10:00:00	AMZN	Stock	9.6465	9.674	9.4865	9.524	23954700.0
2012-02-14 11:00:00	AMZN	Stock	9.525	9.5585	9.503	9.536	14987120.0
2012-02-14 12:00:00	AMZN	Stock	9.536	9.572	9.5285	9.5425	11090200.0
2012-02-14 13:00:00	AMZN	Stock	9.5425	9.578	9.5175	9.5675	9719420.0
2012-02-14 14:00:00	AMZN	Stock	9.5645	9.5965	9.305	9.445	61367480.0

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

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