PREVIEW / stock_1hour / 2012-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-23.parquet
  size:    962 KB
  rows:    45,631
  symbols: 3,525

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-23 04:00:00	AAPL	Stock	18.3929	18.4054	18.3596	18.3821	92120.0
2012-02-23 05:00:00	AAPL	Stock	18.375	18.3786	18.3407	18.3571	110320.0
2012-02-23 06:00:00	AAPL	Stock	18.3679	18.3707	18.3571	18.3679	111160.0
2012-02-23 07:00:00	AAPL	Stock	18.3736	18.4171	18.3571	18.4061	992488.0
2012-02-23 08:00:00	AAPL	Stock	18.4	18.4282	18.38	18.4014	3980424.0
2012-02-23 09:00:00	AAPL	Stock	18.4029	18.4364	18.3268	18.3875	68495616.0
2012-02-23 10:00:00	AAPL	Stock	18.3875	18.4046	18.3361	18.3857	65242436.0
2012-02-23 11:00:00	AAPL	Stock	18.3871	18.4939	18.3761	18.4196	72507008.0
2012-02-23 12:00:00	AAPL	Stock	18.4179	18.4618	18.2643	18.3193	77444332.0
2012-02-23 13:00:00	AAPL	Stock	18.3199	18.3904	18.1964	18.3068	108227644.0
2012-02-23 14:00:00	AAPL	Stock	18.3087	18.4494	18.2729	18.4036	77294392.0
2012-02-23 15:00:00	AAPL	Stock	18.4036	18.4732	18.3911	18.4397	74791304.0
2012-02-23 16:00:00	AAPL	Stock	18.4425	18.4625	18.3754	18.46	9422868.0
2012-02-23 17:00:00	AAPL	Stock	18.4561	18.4561	18.4179	18.4425	798028.0
2012-02-23 18:00:00	AAPL	Stock	18.4425	18.4604	18.4425	18.4571	480676.0
2012-02-23 19:00:00	AAPL	Stock	18.4521	18.46	18.4507	18.4557	218344.0
2012-02-23 07:00:00	MSFT	Stock	31.23	31.23	31.17	31.22	510.0
2012-02-23 08:00:00	MSFT	Stock	31.2	31.4	31.18	31.37	47845.0
2012-02-23 09:00:00	MSFT	Stock	31.36	31.37	31.0	31.22	5292822.0
2012-02-23 10:00:00	MSFT	Stock	31.22	31.495	31.21	31.475	7332237.0
2012-02-23 11:00:00	MSFT	Stock	31.48	31.59	31.435	31.46	4314455.0
2012-02-23 12:00:00	MSFT	Stock	31.47	31.49	31.37	31.395	3687203.0
2012-02-23 13:00:00	MSFT	Stock	31.4	31.4	31.31	31.37	2490877.0
2012-02-23 14:00:00	MSFT	Stock	31.37	31.39	31.28	31.32	3153366.0
2012-02-23 15:00:00	MSFT	Stock	31.32	31.46	31.3	31.375	5564335.0
2012-02-23 16:00:00	MSFT	Stock	31.37	31.45	31.337	31.38	1723765.0
2012-02-23 17:00:00	MSFT	Stock	31.42	31.42	31.37	31.37	3664.0
2012-02-23 18:00:00	MSFT	Stock	31.37	31.4	31.37	31.4	5276.0
2012-02-23 19:00:00	MSFT	Stock	31.45	31.46	31.45	31.46	700.0
2012-02-23 08:00:00	NVDA	Stock	0.3973	0.3993	0.397	0.3993	52000.0
2012-02-23 09:00:00	NVDA	Stock	0.3993	0.4003	0.39	0.3922	49421880.0
2012-02-23 10:00:00	NVDA	Stock	0.3924	0.3982	0.3922	0.3978	71107520.0
2012-02-23 11:00:00	NVDA	Stock	0.3979	0.4	0.397	0.3973	41043880.0
2012-02-23 12:00:00	NVDA	Stock	0.397	0.399	0.3958	0.3968	32651640.0
2012-02-23 13:00:00	NVDA	Stock	0.3966	0.397	0.3945	0.3965	33053200.0
2012-02-23 14:00:00	NVDA	Stock	0.3966	0.398	0.396	0.3973	31540400.0
2012-02-23 15:00:00	NVDA	Stock	0.3973	0.399	0.3965	0.398	55120680.0
2012-02-23 16:00:00	NVDA	Stock	0.398	0.3987	0.3963	0.3978	2794480.0
2012-02-23 17:00:00	NVDA	Stock	0.3958	0.3998	0.3958	0.3978	347360.0
2012-02-23 06:00:00	AMZN	Stock	9.038	9.038	9.0195	9.025	11800.0
2012-02-23 07:00:00	AMZN	Stock	9.0255	9.029	9.0	9.025	43700.0
2012-02-23 08:00:00	AMZN	Stock	9.001	9.0135	8.9765	8.9915	302500.0
2012-02-23 09:00:00	AMZN	Stock	8.988	8.988	8.855	8.895	19046460.0
2012-02-23 10:00:00	AMZN	Stock	8.8975	8.979	8.848	8.961	21979780.0
2012-02-23 11:00:00	AMZN	Stock	8.961	9.0375	8.9575	9.005	14916820.0
2012-02-23 12:00:00	AMZN	Stock	9.008	9.0085	8.958	8.9625	8294560.0
2012-02-23 13:00:00	AMZN	Stock	8.9605	8.963	8.894	8.897	11515740.0
2012-02-23 14:00:00	AMZN	Stock	8.899	8.9325	8.889	8.924	8901940.0
2012-02-23 15:00:00	AMZN	Stock	8.928	8.976	8.914	8.9435	15443200.0
2012-02-23 16:00:00	AMZN	Stock	8.9445	8.9582	8.9341	8.956	2358580.0

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

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