PREVIEW / stock_1hour / 2013-02-05

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-05.parquet
  size:    962 KB
  rows:    45,244
  symbols: 3,491

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-02-05 04:00:00	AAPL	Stock	15.8357	15.8536	15.8357	15.8536	48720.0
2013-02-05 05:00:00	AAPL	Stock	15.8696	15.8743	15.8304	15.8743	31836.0
2013-02-05 06:00:00	AAPL	Stock	15.875	15.875	15.8236	15.8304	126140.0
2013-02-05 07:00:00	AAPL	Stock	15.8389	15.9464	15.8389	15.9025	924364.0
2013-02-05 08:00:00	AAPL	Stock	15.8939	15.9411	15.8411	15.9154	2620660.0
2013-02-05 09:00:00	AAPL	Stock	15.9171	15.9721	15.7936	15.8546	70052024.0
2013-02-05 10:00:00	AAPL	Stock	15.8539	16.0261	15.7989	15.9957	90373192.0
2013-02-05 11:00:00	AAPL	Stock	16.0	16.1321	15.9957	16.11	68866840.0
2013-02-05 12:00:00	AAPL	Stock	16.1068	16.2021	16.0893	16.2	52421712.0
2013-02-05 13:00:00	AAPL	Stock	16.1982	16.3539	16.1939	16.3004	90328532.0
2013-02-05 14:00:00	AAPL	Stock	16.3	16.4054	16.2993	16.3764	74692772.0
2013-02-05 15:00:00	AAPL	Stock	16.3764	16.4193	16.3304	16.3507	98665224.0
2013-02-05 16:00:00	AAPL	Stock	16.3507	16.3813	16.0269	16.3525	16985360.0
2013-02-05 17:00:00	AAPL	Stock	16.3525	16.3679	16.3507	16.3571	749196.0
2013-02-05 18:00:00	AAPL	Stock	16.3564	16.375	16.3507	16.3625	825020.0
2013-02-05 19:00:00	AAPL	Stock	16.3625	16.3893	16.3614	16.3893	296660.0
2013-02-05 07:00:00	MSFT	Stock	27.69	27.7	27.62	27.62	3900.0
2013-02-05 08:00:00	MSFT	Stock	27.56	27.65	27.5	27.6	14225.0
2013-02-05 09:00:00	MSFT	Stock	27.59	27.63	27.36	27.58	5065632.0
2013-02-05 10:00:00	MSFT	Stock	27.58	27.66	27.49	27.52	5404525.0
2013-02-05 11:00:00	MSFT	Stock	27.52	27.63	27.51	27.575	4325076.0
2013-02-05 12:00:00	MSFT	Stock	27.575	27.6	27.53	27.565	3464135.0
2013-02-05 13:00:00	MSFT	Stock	27.56	27.6	27.555	27.57	2438918.0
2013-02-05 14:00:00	MSFT	Stock	27.56	27.62	27.55	27.577	3529367.0
2013-02-05 15:00:00	MSFT	Stock	27.58	27.58	27.47	27.49	8404026.0
2013-02-05 16:00:00	MSFT	Stock	27.49	27.58	27.46	27.47	2523032.0
2013-02-05 17:00:00	MSFT	Stock	27.49	27.49	27.47	27.48	13900.0
2013-02-05 18:00:00	MSFT	Stock	27.48	27.49	27.44	27.47	12502.0
2013-02-05 19:00:00	MSFT	Stock	27.49	27.49	27.49	27.49	21850.0
2013-02-05 08:00:00	NVDA	Stock	0.3068	0.3068	0.3062	0.3068	122320.0
2013-02-05 09:00:00	NVDA	Stock	0.304	0.3088	0.304	0.3085	37236120.0
2013-02-05 10:00:00	NVDA	Stock	0.3085	0.3093	0.3055	0.3065	58664000.0
2013-02-05 11:00:00	NVDA	Stock	0.3065	0.3085	0.306	0.3074	46731880.0
2013-02-05 12:00:00	NVDA	Stock	0.3075	0.31	0.3075	0.3098	41584040.0
2013-02-05 13:00:00	NVDA	Stock	0.3095	0.312	0.3095	0.3115	43107640.0
2013-02-05 14:00:00	NVDA	Stock	0.3115	0.3128	0.311	0.3111	50101400.0
2013-02-05 15:00:00	NVDA	Stock	0.3111	0.3118	0.3105	0.311	74288720.0
2013-02-05 16:00:00	NVDA	Stock	0.311	0.3118	0.3094	0.3118	10081200.0
2013-02-05 18:00:00	NVDA	Stock	0.311	0.311	0.311	0.311	32160.0
2013-02-05 19:00:00	NVDA	Stock	0.311	0.311	0.311	0.311	56000.0
2013-02-05 05:00:00	AMZN	Stock	13.037	13.037	13.037	13.037	2000.0
2013-02-05 08:00:00	AMZN	Stock	13.0625	13.0875	13.0575	13.063	268380.0
2013-02-05 09:00:00	AMZN	Stock	13.0705	13.224	12.999	13.166	12442480.0
2013-02-05 10:00:00	AMZN	Stock	13.168	13.35	13.1555	13.318	16049160.0
2013-02-05 11:00:00	AMZN	Stock	13.3232	13.3935	13.206	13.2595	15737280.0
2013-02-05 12:00:00	AMZN	Stock	13.261	13.354	13.2505	13.301	8512660.0
2013-02-05 13:00:00	AMZN	Stock	13.3035	13.3482	13.286	13.29	4298440.0
2013-02-05 14:00:00	AMZN	Stock	13.2885	13.4015	13.2885	13.352	7785160.0
2013-02-05 15:00:00	AMZN	Stock	13.3545	13.379	13.3165	13.3445	13049360.0
2013-02-05 16:00:00	AMZN	Stock	13.3445	13.364	13.2851	13.3635	378860.0

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

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