PREVIEW / stock_1hour / 2011-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-04.parquet
  size:    945 KB
  rows:    45,456
  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
2011-02-04 05:00:00	AAPL	Stock	12.2979	12.2979	12.2979	12.2979	9240.0
2011-02-04 06:00:00	AAPL	Stock	12.2946	12.2946	12.2946	12.2946	14000.0
2011-02-04 07:00:00	AAPL	Stock	12.2911	12.3282	12.2761	12.3164	293244.0
2011-02-04 08:00:00	AAPL	Stock	12.315	12.3179	12.26	12.2875	3568040.0
2011-02-04 09:00:00	AAPL	Stock	12.2911	12.3571	12.2664	12.3571	70200928.0
2011-02-04 10:00:00	AAPL	Stock	12.3554	12.3714	12.3043	12.3172	69891248.0
2011-02-04 11:00:00	AAPL	Stock	12.3186	12.3504	12.3032	12.3277	34302604.0
2011-02-04 12:00:00	AAPL	Stock	12.3275	12.3482	12.3232	12.3454	16127356.0
2011-02-04 13:00:00	AAPL	Stock	12.3464	12.3675	12.3364	12.3607	28033908.0
2011-02-04 14:00:00	AAPL	Stock	12.3625	12.3625	12.3432	12.3575	22229396.0
2011-02-04 15:00:00	AAPL	Stock	12.3582	12.3821	12.3571	12.375	60772628.0
2011-02-04 16:00:00	AAPL	Stock	12.375	12.3786	12.3445	12.3725	8799280.0
2011-02-04 17:00:00	AAPL	Stock	12.2657	12.3743	12.2657	12.3718	139048.0
2011-02-04 18:00:00	AAPL	Stock	12.375	12.375	12.3714	12.3714	176848.0
2011-02-04 19:00:00	AAPL	Stock	12.3718	12.375	12.3668	12.3743	227444.0
2011-02-04 07:00:00	MSFT	Stock	27.71	27.75	27.71	27.75	1000.0
2011-02-04 08:00:00	MSFT	Stock	27.75	27.75	27.66	27.7	34676.0
2011-02-04 09:00:00	MSFT	Stock	27.7	27.76	27.51	27.63	6740530.0
2011-02-04 10:00:00	MSFT	Stock	27.625	27.71	27.58	27.651	8188128.0
2011-02-04 11:00:00	MSFT	Stock	27.648	27.77	27.58	27.69	5365385.0
2011-02-04 12:00:00	MSFT	Stock	27.7	27.76	27.63	27.758	3522893.0
2011-02-04 13:00:00	MSFT	Stock	27.76	27.84	27.72	27.772	4282916.0
2011-02-04 14:00:00	MSFT	Stock	27.775	27.78	27.7	27.76	3551178.0
2011-02-04 15:00:00	MSFT	Stock	27.751	27.79	27.71	27.775	7050103.0
2011-02-04 16:00:00	MSFT	Stock	27.77	27.775	27.693	27.74	1483664.0
2011-02-04 17:00:00	MSFT	Stock	27.65	27.77	27.625	27.71	8024.0
2011-02-04 18:00:00	MSFT	Stock	27.71	27.77	27.71	27.74	4130.0
2011-02-04 19:00:00	MSFT	Stock	27.73	27.73	27.72	27.72	1372.0
2011-02-04 07:00:00	NVDA	Stock	0.637	0.6375	0.637	0.637	32000.0
2011-02-04 08:00:00	NVDA	Stock	0.6385	0.6385	0.632	0.6332	2001400.0
2011-02-04 09:00:00	NVDA	Stock	0.6332	0.6468	0.6332	0.6395	174750560.0
2011-02-04 10:00:00	NVDA	Stock	0.6395	0.6448	0.6338	0.6365	130168560.0
2011-02-04 11:00:00	NVDA	Stock	0.6362	0.639	0.634	0.6372	75882120.0
2011-02-04 12:00:00	NVDA	Stock	0.637	0.641	0.635	0.6398	55864840.0
2011-02-04 13:00:00	NVDA	Stock	0.6398	0.6455	0.6393	0.6425	105052920.0
2011-02-04 14:00:00	NVDA	Stock	0.6428	0.6433	0.6379	0.6405	117045600.0
2011-02-04 15:00:00	NVDA	Stock	0.6405	0.6433	0.6388	0.6423	182506440.0
2011-02-04 16:00:00	NVDA	Stock	0.6423	0.6425	0.6404	0.6423	12742040.0
2011-02-04 17:00:00	NVDA	Stock	0.6418	0.6425	0.6394	0.6418	10878800.0
2011-02-04 18:00:00	NVDA	Stock	0.6418	0.6425	0.6418	0.6418	236000.0
2011-02-04 19:00:00	NVDA	Stock	0.6423	0.6438	0.6423	0.6438	168000.0
2011-02-04 08:00:00	AMZN	Stock	8.7	8.7205	8.6625	8.6625	134980.0
2011-02-04 09:00:00	AMZN	Stock	8.68	8.75	8.68	8.719	12095400.0
2011-02-04 10:00:00	AMZN	Stock	8.7155	8.8	8.7125	8.7735	19582520.0
2011-02-04 11:00:00	AMZN	Stock	8.771	8.7936	8.743	8.7742	8075700.0
2011-02-04 12:00:00	AMZN	Stock	8.774	8.8075	8.769	8.8065	6484780.0
2011-02-04 13:00:00	AMZN	Stock	8.8062	8.8595	8.794	8.8455	10541220.0
2011-02-04 14:00:00	AMZN	Stock	8.8465	8.852	8.8235	8.8385	8187760.0
2011-02-04 15:00:00	AMZN	Stock	8.8395	8.846	8.7768	8.794	19676360.0
2011-02-04 16:00:00	AMZN	Stock	8.7915	8.8055	8.7915	8.8005	366200.0

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

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