PREVIEW / stock_1hour / 2011-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-07.parquet
  size:    972 KB
  rows:    46,700
  symbols: 3,548

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
2011-07-07 05:00:00	AAPL	Stock	12.6089	12.6154	12.6089	12.6154	5600.0
2011-07-07 06:00:00	AAPL	Stock	12.6107	12.6107	12.6046	12.6046	16800.0
2011-07-07 07:00:00	AAPL	Stock	12.6039	12.6043	12.575	12.5964	105000.0
2011-07-07 08:00:00	AAPL	Stock	12.5964	12.6732	12.5718	12.6646	3352692.0
2011-07-07 09:00:00	AAPL	Stock	12.6675	12.7304	12.6429	12.7075	73778264.0
2011-07-07 10:00:00	AAPL	Stock	12.7082	12.7536	12.6825	12.7439	81854892.0
2011-07-07 11:00:00	AAPL	Stock	12.7432	12.7611	12.7211	12.7429	40802552.0
2011-07-07 12:00:00	AAPL	Stock	12.7429	12.7543	12.71	12.7525	42351120.0
2011-07-07 13:00:00	AAPL	Stock	12.7539	12.7857	12.7475	12.7629	38894940.0
2011-07-07 14:00:00	AAPL	Stock	12.7629	12.7854	12.7589	12.7791	30374456.0
2011-07-07 15:00:00	AAPL	Stock	12.7793	12.7857	12.7536	12.7575	71185436.0
2011-07-07 16:00:00	AAPL	Stock	12.7575	12.7727	12.7245	12.765	8451184.0
2011-07-07 17:00:00	AAPL	Stock	12.7693	12.7857	12.7571	12.7818	850640.0
2011-07-07 18:00:00	AAPL	Stock	12.7793	12.7839	12.7571	12.7804	416948.0
2011-07-07 19:00:00	AAPL	Stock	12.7818	12.7911	12.7814	12.7911	272944.0
2011-07-07 06:00:00	MSFT	Stock	26.39	26.39	26.39	26.39	100.0
2011-07-07 07:00:00	MSFT	Stock	26.42	26.46	26.41	26.46	1600.0
2011-07-07 08:00:00	MSFT	Stock	26.47	26.63	26.46	26.52	81663.0
2011-07-07 09:00:00	MSFT	Stock	26.52	26.7	26.36	26.7	8851286.0
2011-07-07 10:00:00	MSFT	Stock	26.69	26.77	26.59	26.64	8951240.0
2011-07-07 11:00:00	MSFT	Stock	26.64	26.67	26.61	26.67	4231798.0
2011-07-07 12:00:00	MSFT	Stock	26.67	26.75	26.65	26.735	4531993.0
2011-07-07 13:00:00	MSFT	Stock	26.74	26.8	26.73	26.75	4672754.0
2011-07-07 14:00:00	MSFT	Stock	26.75	26.85	26.75	26.85	6716538.0
2011-07-07 15:00:00	MSFT	Stock	26.85	26.88	26.725	26.77	10407086.0
2011-07-07 16:00:00	MSFT	Stock	26.76	26.84	26.671	26.8	2569530.0
2011-07-07 17:00:00	MSFT	Stock	26.692	26.85	26.692	26.81	104879.0
2011-07-07 18:00:00	MSFT	Stock	26.8	26.82	26.77	26.8	91273.0
2011-07-07 19:00:00	MSFT	Stock	26.79	26.79	26.78	26.79	3275.0
2011-07-07 08:00:00	NVDA	Stock	0.3958	0.3958	0.3938	0.3938	658000.0
2011-07-07 09:00:00	NVDA	Stock	0.3925	0.3955	0.3862	0.3878	188363920.0
2011-07-07 10:00:00	NVDA	Stock	0.3878	0.3922	0.387	0.3907	149780200.0
2011-07-07 11:00:00	NVDA	Stock	0.3905	0.3908	0.3885	0.3893	68264320.0
2011-07-07 12:00:00	NVDA	Stock	0.3891	0.3922	0.3888	0.3905	76711120.0
2011-07-07 13:00:00	NVDA	Stock	0.3904	0.3938	0.3898	0.393	112505120.0
2011-07-07 14:00:00	NVDA	Stock	0.3933	0.3953	0.3925	0.3948	142778240.0
2011-07-07 15:00:00	NVDA	Stock	0.3948	0.3958	0.392	0.393	206054840.0
2011-07-07 16:00:00	NVDA	Stock	0.393	0.394	0.3912	0.394	1571120.0
2011-07-07 17:00:00	NVDA	Stock	0.3942	0.3942	0.393	0.393	959240.0
2011-07-07 18:00:00	NVDA	Stock	0.393	0.393	0.39	0.39	314560.0
2011-07-07 19:00:00	NVDA	Stock	0.3913	0.393	0.3902	0.3913	189720.0
2011-07-07 07:00:00	AMZN	Stock	10.72	10.73	10.72	10.73	6640.0
2011-07-07 08:00:00	AMZN	Stock	10.715	10.77	10.693	10.765	238360.0
2011-07-07 09:00:00	AMZN	Stock	10.77	10.89	10.7545	10.8565	13515640.0
2011-07-07 10:00:00	AMZN	Stock	10.856	10.8705	10.7945	10.866	9655780.0
2011-07-07 11:00:00	AMZN	Stock	10.8655	10.875	10.8425	10.8425	5469960.0
2011-07-07 12:00:00	AMZN	Stock	10.8465	10.8715	10.841	10.859	4618540.0
2011-07-07 13:00:00	AMZN	Stock	10.8605	10.875	10.8175	10.822	6675340.0
2011-07-07 14:00:00	AMZN	Stock	10.822	10.888	10.822	10.8602	6822100.0
2011-07-07 15:00:00	AMZN	Stock	10.8608	10.8785	10.827	10.837	12680620.0

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

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