PREVIEW / stock_1hour / 2013-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-03.parquet
  size:    981 KB
  rows:    45,546
  symbols: 3,484

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-04-03 04:00:00	AAPL	Stock	15.4	15.4107	15.4	15.4107	11088.0
2013-04-03 06:00:00	AAPL	Stock	15.4	15.4	15.3929	15.3929	16744.0
2013-04-03 07:00:00	AAPL	Stock	15.3929	15.4425	15.3929	15.4389	257236.0
2013-04-03 08:00:00	AAPL	Stock	15.4321	15.4425	15.25	15.3821	1581580.0
2013-04-03 09:00:00	AAPL	Stock	15.3921	15.561	15.3497	15.5354	58769760.0
2013-04-03 10:00:00	AAPL	Stock	15.5321	15.6171	15.4762	15.5464	72284464.0
2013-04-03 11:00:00	AAPL	Stock	15.55	15.57	15.5054	15.5257	41035652.0
2013-04-03 12:00:00	AAPL	Stock	15.5243	15.5282	15.4014	15.4561	39886168.0
2013-04-03 13:00:00	AAPL	Stock	15.4564	15.4564	15.3682	15.3839	32534376.0
2013-04-03 14:00:00	AAPL	Stock	15.3872	15.4943	15.3796	15.4732	37227120.0
2013-04-03 15:00:00	AAPL	Stock	15.4754	15.4754	15.3832	15.4232	51799720.0
2013-04-03 16:00:00	AAPL	Stock	15.4232	15.5406	15.4217	15.4368	6202392.0
2013-04-03 17:00:00	AAPL	Stock	15.4382	15.4411	15.4232	15.4232	1067220.0
2013-04-03 18:00:00	AAPL	Stock	15.4268	15.4286	15.4232	15.4286	132076.0
2013-04-03 19:00:00	AAPL	Stock	15.425	15.4504	15.425	15.4504	207732.0
2013-04-03 05:00:00	MSFT	Stock	28.8	28.84	28.8	28.84	1200.0
2013-04-03 06:00:00	MSFT	Stock	28.89	28.89	28.75	28.75	400.0
2013-04-03 07:00:00	MSFT	Stock	28.8	28.82	28.8	28.82	1185.0
2013-04-03 08:00:00	MSFT	Stock	28.65	28.79	28.65	28.77	6500.0
2013-04-03 09:00:00	MSFT	Stock	28.77	28.89	28.74	28.887	3488560.0
2013-04-03 10:00:00	MSFT	Stock	28.88	28.93	28.78	28.893	6227053.0
2013-04-03 11:00:00	MSFT	Stock	28.9	28.95	28.83	28.945	3947054.0
2013-04-03 12:00:00	MSFT	Stock	28.94	28.95	28.84	28.85	3283319.0
2013-04-03 13:00:00	MSFT	Stock	28.855	28.88	28.67	28.69	5861470.0
2013-04-03 14:00:00	MSFT	Stock	28.69	28.72	28.62	28.675	3883292.0
2013-04-03 15:00:00	MSFT	Stock	28.68	28.68	28.54	28.56	6408544.0
2013-04-03 16:00:00	MSFT	Stock	28.565	28.845	28.557	28.62	1626101.0
2013-04-03 17:00:00	MSFT	Stock	28.56	28.87	28.53	28.87	18817.0
2013-04-03 18:00:00	MSFT	Stock	28.56	28.59	28.56	28.59	700.0
2013-04-03 19:00:00	MSFT	Stock	28.59	28.6	28.56	28.6	1499.0
2013-04-03 08:00:00	NVDA	Stock	0.31	0.3105	0.31	0.3105	24000.0
2013-04-03 09:00:00	NVDA	Stock	0.3065	0.3083	0.3056	0.3065	24046560.0
2013-04-03 10:00:00	NVDA	Stock	0.3065	0.3065	0.3048	0.3048	40212000.0
2013-04-03 11:00:00	NVDA	Stock	0.3048	0.3055	0.3038	0.305	38849840.0
2013-04-03 12:00:00	NVDA	Stock	0.305	0.3052	0.3021	0.3025	36806160.0
2013-04-03 13:00:00	NVDA	Stock	0.3025	0.3036	0.301	0.3012	44677360.0
2013-04-03 14:00:00	NVDA	Stock	0.301	0.304	0.301	0.303	47692080.0
2013-04-03 15:00:00	NVDA	Stock	0.3032	0.3032	0.301	0.303	93713320.0
2013-04-03 16:00:00	NVDA	Stock	0.3032	0.3035	0.3032	0.3032	25806720.0
2013-04-03 17:00:00	NVDA	Stock	0.3032	0.3032	0.3025	0.3025	153880.0
2013-04-03 19:00:00	NVDA	Stock	0.3032	0.3032	0.303	0.303	635160.0
2013-04-03 08:00:00	AMZN	Stock	13.1661	13.1661	13.1661	13.1661	3600.0
2013-04-03 09:00:00	AMZN	Stock	13.1525	13.1835	13.0625	13.12	7318340.0
2013-04-03 10:00:00	AMZN	Stock	13.1155	13.133	13.022	13.0308	8771040.0
2013-04-03 11:00:00	AMZN	Stock	13.0315	13.0435	12.995	13.0075	6395580.0
2013-04-03 12:00:00	AMZN	Stock	13.006	13.0245	12.9675	12.9799	4650920.0
2013-04-03 13:00:00	AMZN	Stock	12.981	12.9945	12.902	12.9095	6058400.0
2013-04-03 14:00:00	AMZN	Stock	12.9085	12.976	12.9062	12.9518	4684600.0
2013-04-03 15:00:00	AMZN	Stock	12.9545	12.968	12.8875	12.952	8099340.0
2013-04-03 16:00:00	AMZN	Stock	12.9515	13.0065	12.9332	12.9332	1695660.0

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

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