PREVIEW / stock_1hour / 2013-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-25.parquet
  size:    998 KB
  rows:    46,396
  symbols: 3,521

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-06-25 04:00:00	AAPL	Stock	14.3789	14.3789	14.3789	14.3789	5600.0
2013-06-25 05:00:00	AAPL	Stock	14.4411	14.4464	14.4182	14.4464	32536.0
2013-06-25 06:00:00	AAPL	Stock	14.4643	14.4643	14.4296	14.4296	54824.0
2013-06-25 07:00:00	AAPL	Stock	14.4489	14.5157	14.4489	14.5071	428624.0
2013-06-25 08:00:00	AAPL	Stock	14.4929	14.5071	14.3571	14.4736	1060388.0
2013-06-25 09:00:00	AAPL	Stock	14.4714	14.5639	14.3321	14.365	54038012.0
2013-06-25 10:00:00	AAPL	Stock	14.3634	14.3929	14.2439	14.3636	74330760.0
2013-06-25 11:00:00	AAPL	Stock	14.3619	14.3704	14.2768	14.3406	29504580.0
2013-06-25 12:00:00	AAPL	Stock	14.3411	14.3554	14.2946	14.2982	22265180.0
2013-06-25 13:00:00	AAPL	Stock	14.3045	14.3257	14.265	14.2982	24972276.0
2013-06-25 14:00:00	AAPL	Stock	14.2946	14.3711	14.2843	14.342	29954036.0
2013-06-25 15:00:00	AAPL	Stock	14.3439	14.4536	14.3325	14.3779	53091080.0
2013-06-25 16:00:00	AAPL	Stock	14.3796	14.4041	14.3243	14.3661	20755756.0
2013-06-25 17:00:00	AAPL	Stock	14.3643	14.4121	14.3593	14.3625	62580.0
2013-06-25 18:00:00	AAPL	Stock	14.3625	14.3639	14.3393	14.3393	116760.0
2013-06-25 19:00:00	AAPL	Stock	14.3411	14.3411	14.3214	14.3268	83636.0
2013-06-25 06:00:00	MSFT	Stock	33.86	33.86	33.86	33.86	100.0
2013-06-25 07:00:00	MSFT	Stock	33.88	34.12	33.88	34.12	7800.0
2013-06-25 08:00:00	MSFT	Stock	33.9	34.0	33.71	33.95	74100.0
2013-06-25 09:00:00	MSFT	Stock	33.98	34.38	33.89	33.99	6664423.0
2013-06-25 10:00:00	MSFT	Stock	33.98	34.08	33.46	33.655	9292760.0
2013-06-25 11:00:00	MSFT	Stock	33.655	33.76	33.61	33.75	3359371.0
2013-06-25 12:00:00	MSFT	Stock	33.75	33.815	33.61	33.66	3410705.0
2013-06-25 13:00:00	MSFT	Stock	33.656	33.66	33.51	33.54	3259149.0
2013-06-25 14:00:00	MSFT	Stock	33.545	33.62	33.5	33.56	3757509.0
2013-06-25 15:00:00	MSFT	Stock	33.56	33.74	33.54	33.65	8615799.0
2013-06-25 16:00:00	MSFT	Stock	33.71	33.748	33.628	33.67	5137763.0
2013-06-25 17:00:00	MSFT	Stock	33.63	33.7	33.63	33.63	5712.0
2013-06-25 18:00:00	MSFT	Stock	33.7	33.73	33.7	33.73	8109.0
2013-06-25 19:00:00	MSFT	Stock	33.72	33.73	33.61	33.61	14154.0
2013-06-25 08:00:00	NVDA	Stock	0.3575	0.3575	0.3575	0.3575	12000.0
2013-06-25 09:00:00	NVDA	Stock	0.3572	0.3575	0.3518	0.3555	37985880.0
2013-06-25 10:00:00	NVDA	Stock	0.3553	0.3566	0.3519	0.354	57572640.0
2013-06-25 11:00:00	NVDA	Stock	0.3542	0.3562	0.3535	0.3553	38512080.0
2013-06-25 12:00:00	NVDA	Stock	0.3554	0.357	0.3546	0.355	25920720.0
2013-06-25 13:00:00	NVDA	Stock	0.355	0.3569	0.3541	0.3555	25750360.0
2013-06-25 14:00:00	NVDA	Stock	0.3556	0.3565	0.3548	0.3554	33415320.0
2013-06-25 15:00:00	NVDA	Stock	0.3555	0.3574	0.354	0.3555	122408960.0
2013-06-25 16:00:00	NVDA	Stock	0.3555	0.357	0.3551	0.3555	96631280.0
2013-06-25 17:00:00	NVDA	Stock	0.3555	0.3555	0.3555	0.3555	16320.0
2013-06-25 19:00:00	NVDA	Stock	0.3555	0.3555	0.3555	0.3555	52000.0
2013-06-25 05:00:00	AMZN	Stock	13.612	13.612	13.594	13.594	8000.0
2013-06-25 06:00:00	AMZN	Stock	13.5905	13.598	13.58	13.598	12000.0
2013-06-25 07:00:00	AMZN	Stock	13.6015	13.6015	13.6	13.6	18220.0
2013-06-25 08:00:00	AMZN	Stock	13.633	13.6535	13.625	13.625	100120.0
2013-06-25 09:00:00	AMZN	Stock	13.622	13.669	13.51	13.5555	10376020.0
2013-06-25 10:00:00	AMZN	Stock	13.5562	13.5745	13.45	13.543	10175060.0
2013-06-25 11:00:00	AMZN	Stock	13.542	13.596	13.4805	13.581	5086520.0
2013-06-25 12:00:00	AMZN	Stock	13.578	13.6085	13.5635	13.5675	2772700.0
2013-06-25 13:00:00	AMZN	Stock	13.572	13.579	13.501	13.5085	3319560.0

> showing 50 of 46,396 rows — these rows as CSV

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