PREVIEW / stock_1hour / 2012-12-05

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-05.parquet
  size:    946 KB
  rows:    44,675
  symbols: 3,475

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-12-05 04:00:00	AAPL	Stock	20.5	20.5	20.3214	20.3218	137312.0
2012-12-05 05:00:00	AAPL	Stock	20.3018	20.3571	20.2968	20.3214	54684.0
2012-12-05 06:00:00	AAPL	Stock	20.3214	20.3604	20.3214	20.3604	121296.0
2012-12-05 07:00:00	AAPL	Stock	20.3414	20.3839	20.3143	20.375	891912.0
2012-12-05 08:00:00	AAPL	Stock	20.3807	20.3857	20.2446	20.3571	4608436.0
2012-12-05 09:00:00	AAPL	Stock	20.3625	20.4371	19.9146	19.965	148040116.0
2012-12-05 10:00:00	AAPL	Stock	19.9654	20.0054	19.4843	19.5786	267063412.0
2012-12-05 11:00:00	AAPL	Stock	19.5843	19.8371	19.5396	19.7304	153620740.0
2012-12-05 12:00:00	AAPL	Stock	19.7307	19.7936	19.6286	19.7014	70587272.0
2012-12-05 13:00:00	AAPL	Stock	19.7018	19.7393	19.5368	19.5368	64265180.0
2012-12-05 14:00:00	AAPL	Stock	19.5384	19.6907	19.5293	19.5585	78544984.0
2012-12-05 15:00:00	AAPL	Stock	19.5589	19.71	19.2418	19.2429	195455288.0
2012-12-05 16:00:00	AAPL	Stock	19.243	19.7138	19.1811	19.1968	32240880.0
2012-12-05 17:00:00	AAPL	Stock	19.2054	19.3922	19.1393	19.1582	5186692.0
2012-12-05 18:00:00	AAPL	Stock	19.1521	19.1736	19.1507	19.1732	947380.0
2012-12-05 19:00:00	AAPL	Stock	19.1675	19.1746	19.1411	19.1429	909552.0
2012-12-05 06:00:00	MSFT	Stock	26.49	26.52	26.49	26.52	1000.0
2012-12-05 07:00:00	MSFT	Stock	26.49	26.49	26.38	26.45	9300.0
2012-12-05 08:00:00	MSFT	Stock	26.42	26.45	26.39	26.45	33358.0
2012-12-05 09:00:00	MSFT	Stock	26.45	26.49	26.35	26.43	5874953.0
2012-12-05 10:00:00	MSFT	Stock	26.43	26.45	26.26	26.32	9191887.0
2012-12-05 11:00:00	MSFT	Stock	26.31	26.525	26.3	26.48	7685740.0
2012-12-05 12:00:00	MSFT	Stock	26.48	26.93	26.48	26.75	10981536.0
2012-12-05 13:00:00	MSFT	Stock	26.755	26.755	26.68	26.68	4221835.0
2012-12-05 14:00:00	MSFT	Stock	26.69	26.76	26.66	26.74	4448945.0
2012-12-05 15:00:00	MSFT	Stock	26.73	26.85	26.62	26.67	11374677.0
2012-12-05 16:00:00	MSFT	Stock	26.68	26.83	26.363	26.66	2346294.0
2012-12-05 17:00:00	MSFT	Stock	26.65	26.88	26.65	26.84	10851173.0
2012-12-05 18:00:00	MSFT	Stock	26.84	26.85	26.76	26.76	14114.0
2012-12-05 19:00:00	MSFT	Stock	26.76	26.78	26.75	26.78	2566.0
2012-12-05 06:00:00	NVDA	Stock	0.3028	0.3028	0.3028	0.3028	4800.0
2012-12-05 08:00:00	NVDA	Stock	0.2992	0.2992	0.2955	0.2975	300000.0
2012-12-05 09:00:00	NVDA	Stock	0.2988	0.302	0.2972	0.299	68486960.0
2012-12-05 10:00:00	NVDA	Stock	0.2992	0.3002	0.2955	0.297	120825720.0
2012-12-05 11:00:00	NVDA	Stock	0.2969	0.2972	0.2948	0.296	98623320.0
2012-12-05 12:00:00	NVDA	Stock	0.2961	0.298	0.2959	0.2972	66919960.0
2012-12-05 13:00:00	NVDA	Stock	0.2972	0.298	0.2968	0.2969	50106960.0
2012-12-05 14:00:00	NVDA	Stock	0.2968	0.2978	0.2962	0.2972	42224560.0
2012-12-05 15:00:00	NVDA	Stock	0.2974	0.3001	0.2972	0.2988	166453640.0
2012-12-05 16:00:00	NVDA	Stock	0.2988	0.299	0.2975	0.2975	1903480.0
2012-12-05 17:00:00	NVDA	Stock	0.298	0.2998	0.298	0.2998	5979240.0
2012-12-05 19:00:00	NVDA	Stock	0.2985	0.2985	0.2985	0.2985	40000.0
2012-12-05 05:00:00	AMZN	Stock	12.6495	12.6495	12.6495	12.6495	2000.0
2012-12-05 07:00:00	AMZN	Stock	12.6365	12.6675	12.633	12.6675	32000.0
2012-12-05 08:00:00	AMZN	Stock	12.659	12.659	12.6315	12.65	112680.0
2012-12-05 09:00:00	AMZN	Stock	12.641	12.7075	12.6	12.6125	8867420.0
2012-12-05 10:00:00	AMZN	Stock	12.623	12.6625	12.519	12.56	12982720.0
2012-12-05 11:00:00	AMZN	Stock	12.5615	12.69	12.54	12.6765	5648100.0
2012-12-05 12:00:00	AMZN	Stock	12.681	12.725	12.6725	12.7004	5999000.0
2012-12-05 13:00:00	AMZN	Stock	12.7035	12.7495	12.6875	12.6885	4301460.0

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

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