PREVIEW / stock_1hour / 2011-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-02.parquet
  size:    955 KB
  rows:    44,954
  symbols: 3,517

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-08-02 04:00:00	AAPL	Stock	14.1343	14.1471	14.1343	14.1429	14000.0
2011-08-02 05:00:00	AAPL	Stock	14.1343	14.1961	14.1279	14.1279	30800.0
2011-08-02 06:00:00	AAPL	Stock	14.1286	14.1482	14.1286	14.1425	48720.0
2011-08-02 07:00:00	AAPL	Stock	14.1529	14.1907	14.1214	14.1554	628852.0
2011-08-02 08:00:00	AAPL	Stock	14.1518	14.1643	14.0893	14.1593	3470992.0
2011-08-02 09:00:00	AAPL	Stock	14.1568	14.2107	14.1136	14.15	84003864.0
2011-08-02 10:00:00	AAPL	Stock	14.1493	14.1893	14.1161	14.1329	84826280.0
2011-08-02 11:00:00	AAPL	Stock	14.1329	14.14	14.0839	14.1226	62859664.0
2011-08-02 12:00:00	AAPL	Stock	14.1239	14.1511	14.025	14.0446	69102628.0
2011-08-02 13:00:00	AAPL	Stock	14.0439	14.0936	13.9068	13.9282	90654004.0
2011-08-02 14:00:00	AAPL	Stock	13.9296	14.0414	13.9246	14.0254	83394472.0
2011-08-02 15:00:00	AAPL	Stock	14.0232	14.0318	13.8696	13.89	128237760.0
2011-08-02 16:00:00	AAPL	Stock	13.8836	14.1728	13.8779	13.8893	25225844.0
2011-08-02 17:00:00	AAPL	Stock	13.8954	13.9211	13.8839	13.8996	797608.0
2011-08-02 18:00:00	AAPL	Stock	13.8996	13.9211	13.8879	13.9136	598136.0
2011-08-02 19:00:00	AAPL	Stock	13.9139	13.9232	13.9082	13.9107	363888.0
2011-08-02 07:00:00	MSFT	Stock	27.1	27.1	27.05	27.05	1500.0
2011-08-02 08:00:00	MSFT	Stock	27.09	27.27	26.85	27.04	102089.0
2011-08-02 09:00:00	MSFT	Stock	27.04	27.36	26.89	27.31	5748783.0
2011-08-02 10:00:00	MSFT	Stock	27.32	27.45	27.12	27.246	10761993.0
2011-08-02 11:00:00	MSFT	Stock	27.24	27.28	27.08	27.19	7666654.0
2011-08-02 12:00:00	MSFT	Stock	27.19	27.33	27.025	27.07	7281369.0
2011-08-02 13:00:00	MSFT	Stock	27.07	27.24	27.0	27.015	6367408.0
2011-08-02 14:00:00	MSFT	Stock	27.014	27.136	26.96	27.08	6381654.0
2011-08-02 15:00:00	MSFT	Stock	27.075	27.11	26.76	26.81	14827934.0
2011-08-02 16:00:00	MSFT	Stock	26.81	27.182	26.79	26.84	4247122.0
2011-08-02 17:00:00	MSFT	Stock	26.81	26.81	26.78	26.8	117204.0
2011-08-02 18:00:00	MSFT	Stock	26.78	26.8	26.72	26.72	61449.0
2011-08-02 19:00:00	MSFT	Stock	26.75	26.79	26.7	26.72	5489.0
2011-08-02 08:00:00	NVDA	Stock	0.3675	0.3675	0.3612	0.3645	339160.0
2011-08-02 09:00:00	NVDA	Stock	0.3645	0.3768	0.3615	0.3755	174172600.0
2011-08-02 10:00:00	NVDA	Stock	0.3758	0.3845	0.374	0.3778	320159720.0
2011-08-02 11:00:00	NVDA	Stock	0.3778	0.3778	0.3728	0.3743	145119520.0
2011-08-02 12:00:00	NVDA	Stock	0.374	0.3765	0.3682	0.3692	124160800.0
2011-08-02 13:00:00	NVDA	Stock	0.3691	0.3713	0.3625	0.3635	127864200.0
2011-08-02 14:00:00	NVDA	Stock	0.3632	0.369	0.363	0.3677	226382440.0
2011-08-02 15:00:00	NVDA	Stock	0.3675	0.3678	0.3605	0.3608	218975720.0
2011-08-02 16:00:00	NVDA	Stock	0.3612	0.371	0.3604	0.3612	6939840.0
2011-08-02 17:00:00	NVDA	Stock	0.361	0.3612	0.3605	0.3612	384520.0
2011-08-02 18:00:00	NVDA	Stock	0.361	0.3615	0.36	0.3612	362000.0
2011-08-02 19:00:00	NVDA	Stock	0.3605	0.3612	0.3605	0.3605	22000.0
2011-08-02 04:00:00	AMZN	Stock	11.05	11.05	11.05	11.05	2000.0
2011-08-02 07:00:00	AMZN	Stock	11.0	11.0	10.995	10.995	6000.0
2011-08-02 08:00:00	AMZN	Stock	11.028	11.031	10.95	10.99	264800.0
2011-08-02 09:00:00	AMZN	Stock	10.9985	11.1215	10.928	10.9801	11261420.0
2011-08-02 10:00:00	AMZN	Stock	10.9855	11.0175	10.8795	10.885	14816780.0
2011-08-02 11:00:00	AMZN	Stock	10.883	10.9	10.8165	10.8315	17241560.0
2011-08-02 12:00:00	AMZN	Stock	10.8295	10.873	10.744	10.753	16415180.0
2011-08-02 13:00:00	AMZN	Stock	10.7535	10.7775	10.645	10.6505	16281000.0
2011-08-02 14:00:00	AMZN	Stock	10.655	10.7558	10.6505	10.733	12785580.0

> showing 50 of 44,954 rows — these rows as CSV

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