PREVIEW / stock_1hour / 2013-02-12

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-12.parquet
  size:    959 KB
  rows:    45,027
  symbols: 3,479

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-12 04:00:00	AAPL	Stock	17.1246	17.1246	17.1246	17.1246	2800.0
2013-02-12 05:00:00	AAPL	Stock	17.1071	17.15	17.1071	17.15	37212.0
2013-02-12 06:00:00	AAPL	Stock	17.1714	17.1714	17.1071	17.1071	96628.0
2013-02-12 07:00:00	AAPL	Stock	17.0907	17.1664	17.0893	17.1436	443800.0
2013-02-12 08:00:00	AAPL	Stock	17.1429	17.1607	17.0464	17.1321	2025744.0
2013-02-12 09:00:00	AAPL	Stock	17.1325	17.2279	16.9843	16.9893	73832836.0
2013-02-12 10:00:00	AAPL	Stock	16.9894	17.1696	16.9036	17.0071	128168012.0
2013-02-12 11:00:00	AAPL	Stock	17.005	17.0079	16.7093	16.8036	117033252.0
2013-02-12 12:00:00	AAPL	Stock	16.8043	16.9439	16.7609	16.9176	60343108.0
2013-02-12 13:00:00	AAPL	Stock	16.9196	16.9546	16.8149	16.8305	36293292.0
2013-02-12 14:00:00	AAPL	Stock	16.8304	16.86	16.7668	16.7732	55583080.0
2013-02-12 15:00:00	AAPL	Stock	16.7743	16.8021	16.7051	16.7086	86496648.0
2013-02-12 16:00:00	AAPL	Stock	16.7089	16.8981	16.6964	16.7089	12078444.0
2013-02-12 17:00:00	AAPL	Stock	16.7089	16.7107	16.6929	16.7057	1015224.0
2013-02-12 18:00:00	AAPL	Stock	16.7089	16.7089	16.6736	16.6768	534408.0
2013-02-12 19:00:00	AAPL	Stock	16.6786	16.6793	16.6393	16.6393	1198988.0
2013-02-12 07:00:00	MSFT	Stock	27.87	27.87	27.87	27.87	100.0
2013-02-12 08:00:00	MSFT	Stock	27.76	27.9	27.75	27.9	15440.0
2013-02-12 09:00:00	MSFT	Stock	27.88	27.91	27.78	27.827	4043794.0
2013-02-12 10:00:00	MSFT	Stock	27.83	27.95	27.8	27.86	5728758.0
2013-02-12 11:00:00	MSFT	Stock	27.855	27.86	27.75	27.822	4246743.0
2013-02-12 12:00:00	MSFT	Stock	27.825	27.98	27.81	27.97	3726280.0
2013-02-12 13:00:00	MSFT	Stock	27.965	27.98	27.93	27.94	2704281.0
2013-02-12 14:00:00	MSFT	Stock	27.94	28.0	27.92	27.95	4228026.0
2013-02-12 15:00:00	MSFT	Stock	27.95	27.96	27.84	27.88	8303150.0
2013-02-12 16:00:00	MSFT	Stock	27.88	27.97	27.81	27.91	1854878.0
2013-02-12 17:00:00	MSFT	Stock	27.94	27.94	27.88	27.91	92824.0
2013-02-12 18:00:00	MSFT	Stock	27.91	27.91	27.91	27.91	300.0
2013-02-12 19:00:00	MSFT	Stock	27.89	27.89	27.89	27.89	200.0
2013-02-12 07:00:00	NVDA	Stock	0.313	0.313	0.3125	0.3125	52000.0
2013-02-12 08:00:00	NVDA	Stock	0.3118	0.3125	0.3118	0.3125	205040.0
2013-02-12 09:00:00	NVDA	Stock	0.3118	0.3135	0.3093	0.3125	67865280.0
2013-02-12 10:00:00	NVDA	Stock	0.3126	0.3141	0.3111	0.3115	63961240.0
2013-02-12 11:00:00	NVDA	Stock	0.3115	0.3125	0.31	0.3104	28660680.0
2013-02-12 12:00:00	NVDA	Stock	0.3105	0.3125	0.3103	0.3118	24113280.0
2013-02-12 13:00:00	NVDA	Stock	0.3118	0.3123	0.311	0.3111	22515720.0
2013-02-12 14:00:00	NVDA	Stock	0.311	0.3118	0.311	0.311	16909560.0
2013-02-12 15:00:00	NVDA	Stock	0.311	0.3113	0.3103	0.311	38976440.0
2013-02-12 16:00:00	NVDA	Stock	0.311	0.3118	0.3108	0.3108	4375080.0
2013-02-12 17:00:00	NVDA	Stock	0.3108	0.3125	0.3108	0.3125	1520400.0
2013-02-12 19:00:00	NVDA	Stock	0.3113	0.3128	0.3113	0.3128	28000.0
2013-02-12 06:00:00	AMZN	Stock	12.9	12.9	12.862	12.9	10000.0
2013-02-12 07:00:00	AMZN	Stock	12.915	12.958	12.907	12.955	105960.0
2013-02-12 08:00:00	AMZN	Stock	12.955	13.0375	12.8655	13.0	546720.0
2013-02-12 09:00:00	AMZN	Stock	13.0	13.025	12.85	12.9395	7798440.0
2013-02-12 10:00:00	AMZN	Stock	12.9385	13.008	12.895	13.0012	13763180.0
2013-02-12 11:00:00	AMZN	Stock	13.0023	13.0065	12.9425	12.9851	6552900.0
2013-02-12 12:00:00	AMZN	Stock	12.9845	13.0075	12.9415	12.9935	6305620.0
2013-02-12 13:00:00	AMZN	Stock	12.992	13.0	12.926	12.932	4461700.0
2013-02-12 14:00:00	AMZN	Stock	12.931	12.9665	12.911	12.952	4866800.0

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

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