PREVIEW / stock_1hour / 2012-04-09

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-09.parquet
  size:    951 KB
  rows:    45,716
  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-04-09 04:00:00	AAPL	Stock	22.4286	22.4357	22.4286	22.4357	12880.0
2012-04-09 05:00:00	AAPL	Stock	22.5	22.5104	22.5	22.5104	9800.0
2012-04-09 06:00:00	AAPL	Stock	22.4714	22.4714	22.2839	22.2857	272216.0
2012-04-09 07:00:00	AAPL	Stock	22.2839	22.4054	22.2696	22.3357	2095324.0
2012-04-09 08:00:00	AAPL	Stock	22.3461	22.4104	22.2696	22.3571	5371016.0
2012-04-09 09:00:00	AAPL	Stock	22.3571	22.4939	22.3082	22.4018	96138168.0
2012-04-09 10:00:00	AAPL	Stock	22.4021	22.7643	22.3968	22.7636	131223372.0
2012-04-09 11:00:00	AAPL	Stock	22.7611	22.7679	22.5939	22.7006	98237636.0
2012-04-09 12:00:00	AAPL	Stock	22.6993	22.7321	22.654	22.7268	37509136.0
2012-04-09 13:00:00	AAPL	Stock	22.725	22.7564	22.6579	22.7536	39897732.0
2012-04-09 14:00:00	AAPL	Stock	22.7537	22.8514	22.725	22.8193	73518172.0
2012-04-09 15:00:00	AAPL	Stock	22.8206	22.84	22.7179	22.7229	98104384.0
2012-04-09 16:00:00	AAPL	Stock	22.7225	22.7446	22.6445	22.6964	8577520.0
2012-04-09 17:00:00	AAPL	Stock	22.6911	22.7225	22.6661	22.6682	865536.0
2012-04-09 18:00:00	AAPL	Stock	22.6764	22.7054	22.6757	22.6893	315924.0
2012-04-09 19:00:00	AAPL	Stock	22.6875	22.7061	22.6836	22.6971	353668.0
2012-04-09 07:00:00	MSFT	Stock	31.28	31.28	31.19	31.19	2100.0
2012-04-09 08:00:00	MSFT	Stock	31.2	31.3	31.01	31.22	18499.0
2012-04-09 09:00:00	MSFT	Stock	31.22	31.28	30.97	30.99	4542498.0
2012-04-09 10:00:00	MSFT	Stock	31.0	31.28	30.99	31.232	4825093.0
2012-04-09 11:00:00	MSFT	Stock	31.232	31.26	31.13	31.25	3811682.0
2012-04-09 12:00:00	MSFT	Stock	31.245	31.4	31.24	31.38	2836049.0
2012-04-09 13:00:00	MSFT	Stock	31.38	31.387	31.27	31.307	1897942.0
2012-04-09 14:00:00	MSFT	Stock	31.305	31.33	31.24	31.29	3154433.0
2012-04-09 15:00:00	MSFT	Stock	31.29	31.3	31.1	31.1	7161683.0
2012-04-09 16:00:00	MSFT	Stock	31.11	31.52	31.08	31.1	2295615.0
2012-04-09 17:00:00	MSFT	Stock	31.1	31.13	31.1	31.13	90756.0
2012-04-09 18:00:00	MSFT	Stock	31.12	31.14	31.1	31.14	4568.0
2012-04-09 19:00:00	MSFT	Stock	31.12	31.15	31.12	31.15	3575.0
2012-04-09 05:00:00	NVDA	Stock	0.3658	0.3658	0.3658	0.3658	4000.0
2012-04-09 08:00:00	NVDA	Stock	0.3638	0.3638	0.3588	0.3588	320000.0
2012-04-09 09:00:00	NVDA	Stock	0.36	0.3615	0.356	0.356	51974400.0
2012-04-09 10:00:00	NVDA	Stock	0.3561	0.3592	0.3553	0.3582	49933600.0
2012-04-09 11:00:00	NVDA	Stock	0.3585	0.3585	0.354	0.3555	52757920.0
2012-04-09 12:00:00	NVDA	Stock	0.3555	0.3588	0.3545	0.3585	33254680.0
2012-04-09 13:00:00	NVDA	Stock	0.3585	0.3612	0.3582	0.3605	39858760.0
2012-04-09 14:00:00	NVDA	Stock	0.3603	0.3615	0.3594	0.3607	30430240.0
2012-04-09 15:00:00	NVDA	Stock	0.3605	0.3622	0.3602	0.361	75856080.0
2012-04-09 16:00:00	NVDA	Stock	0.361	0.3658	0.3557	0.3605	29387840.0
2012-04-09 17:00:00	NVDA	Stock	0.3588	0.361	0.3588	0.3588	284840.0
2012-04-09 19:00:00	NVDA	Stock	0.3612	0.3612	0.36	0.36	12000.0
2012-04-09 08:00:00	AMZN	Stock	9.6315	9.6895	9.5915	9.6175	225480.0
2012-04-09 09:00:00	AMZN	Stock	9.6195	9.6395	9.525	9.568	9643280.0
2012-04-09 10:00:00	AMZN	Stock	9.5665	9.71	9.5615	9.667	15066400.0
2012-04-09 11:00:00	AMZN	Stock	9.668	9.668	9.5981	9.6215	9921040.0
2012-04-09 12:00:00	AMZN	Stock	9.62	9.662	9.6075	9.662	3775620.0
2012-04-09 13:00:00	AMZN	Stock	9.6605	9.6755	9.6381	9.6575	8084000.0
2012-04-09 14:00:00	AMZN	Stock	9.6575	9.658	9.634	9.646	4067780.0
2012-04-09 15:00:00	AMZN	Stock	9.647	9.65	9.592	9.5955	9040480.0
2012-04-09 16:00:00	AMZN	Stock	9.5935	9.7195	9.5815	9.5815	2656660.0

> showing 50 of 45,716 rows — these rows as CSV

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