PREVIEW / stock_1hour / 2013-04-15

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-15.parquet
  size:    997 KB
  rows:    46,129
  symbols: 3,500

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-15 05:00:00	AAPL	Stock	15.2889	15.2889	15.2889	15.2889	5600.0
2013-04-15 06:00:00	AAPL	Stock	15.25	15.2546	15.2486	15.2546	20608.0
2013-04-15 07:00:00	AAPL	Stock	15.2507	15.2639	15.2321	15.25	251048.0
2013-04-15 08:00:00	AAPL	Stock	15.2629	15.3214	15.2386	15.2589	580720.0
2013-04-15 09:00:00	AAPL	Stock	15.2536	15.2818	15.1964	15.2375	40703992.0
2013-04-15 10:00:00	AAPL	Stock	15.2361	15.2446	15.1321	15.1839	51846564.0
2013-04-15 11:00:00	AAPL	Stock	15.1807	15.1839	15.1329	15.1389	31771656.0
2013-04-15 12:00:00	AAPL	Stock	15.1425	15.1479	15.0768	15.0896	30169580.0
2013-04-15 13:00:00	AAPL	Stock	15.0904	15.1125	15.0725	15.0818	15265152.0
2013-04-15 14:00:00	AAPL	Stock	15.0821	15.1032	15.0271	15.0386	37861124.0
2013-04-15 15:00:00	AAPL	Stock	15.0383	15.06	14.9839	14.995	70697844.0
2013-04-15 16:00:00	AAPL	Stock	14.9946	15.159	14.9504	14.9643	33875884.0
2013-04-15 17:00:00	AAPL	Stock	14.9646	15.2337	14.9625	14.9732	415156.0
2013-04-15 18:00:00	AAPL	Stock	14.9732	14.995	14.9725	14.9946	502824.0
2013-04-15 19:00:00	AAPL	Stock	14.995	15.0232	14.9896	15.0179	387716.0
2013-04-15 05:00:00	MSFT	Stock	28.55	28.55	28.55	28.55	200.0
2013-04-15 07:00:00	MSFT	Stock	28.61	28.61	28.6	28.6	2100.0
2013-04-15 08:00:00	MSFT	Stock	28.61	28.75	28.6	28.67	11707.0
2013-04-15 09:00:00	MSFT	Stock	28.7	28.79	28.51	28.78	7638829.0
2013-04-15 10:00:00	MSFT	Stock	28.78	28.97	28.68	28.87	7831185.0
2013-04-15 11:00:00	MSFT	Stock	28.865	28.98	28.83	28.86	4231147.0
2013-04-15 12:00:00	MSFT	Stock	28.855	28.89	28.78	28.85	6317405.0
2013-04-15 13:00:00	MSFT	Stock	28.85	28.9	28.83	28.855	3908282.0
2013-04-15 14:00:00	MSFT	Stock	28.85	28.91	28.7	28.725	6871093.0
2013-04-15 15:00:00	MSFT	Stock	28.725	28.79	28.62	28.68	16040193.0
2013-04-15 16:00:00	MSFT	Stock	28.68	28.86	28.56	28.6	3121688.0
2013-04-15 17:00:00	MSFT	Stock	28.59	28.69	28.57	28.57	8272.0
2013-04-15 18:00:00	MSFT	Stock	28.58	28.58	28.58	28.58	250.0
2013-04-15 19:00:00	MSFT	Stock	28.64	28.66	28.6	28.66	2436.0
2013-04-15 04:00:00	NVDA	Stock	0.3243	0.3243	0.3243	0.3243	4000.0
2013-04-15 07:00:00	NVDA	Stock	0.3243	0.3243	0.3243	0.3243	4000.0
2013-04-15 08:00:00	NVDA	Stock	0.3243	0.3243	0.3243	0.3243	68000.0
2013-04-15 09:00:00	NVDA	Stock	0.3238	0.3271	0.3238	0.3253	41594360.0
2013-04-15 10:00:00	NVDA	Stock	0.325	0.3273	0.3228	0.3255	73614640.0
2013-04-15 11:00:00	NVDA	Stock	0.3255	0.326	0.3235	0.3241	42769720.0
2013-04-15 12:00:00	NVDA	Stock	0.3243	0.3254	0.3225	0.3243	42275120.0
2013-04-15 13:00:00	NVDA	Stock	0.3243	0.3248	0.3225	0.3228	27498200.0
2013-04-15 14:00:00	NVDA	Stock	0.3228	0.3235	0.321	0.3213	41102400.0
2013-04-15 15:00:00	NVDA	Stock	0.3213	0.3218	0.3185	0.3208	136993040.0
2013-04-15 16:00:00	NVDA	Stock	0.3205	0.3273	0.319	0.3205	23998320.0
2013-04-15 17:00:00	NVDA	Stock	0.3195	0.3195	0.3188	0.319	232000.0
2013-04-15 19:00:00	NVDA	Stock	0.3205	0.3205	0.3205	0.3205	48000.0
2013-04-15 05:00:00	AMZN	Stock	13.5675	13.5675	13.5675	13.5675	2000.0
2013-04-15 08:00:00	AMZN	Stock	13.6	13.6	13.5385	13.555	171000.0
2013-04-15 09:00:00	AMZN	Stock	13.5515	13.6825	13.525	13.671	10513480.0
2013-04-15 10:00:00	AMZN	Stock	13.673	13.756	13.6086	13.7355	15134760.0
2013-04-15 11:00:00	AMZN	Stock	13.7275	13.734	13.5785	13.5855	6508460.0
2013-04-15 12:00:00	AMZN	Stock	13.5885	13.6296	13.455	13.485	7606240.0
2013-04-15 13:00:00	AMZN	Stock	13.4882	13.535	13.464	13.481	3769920.0
2013-04-15 14:00:00	AMZN	Stock	13.47	13.532	13.405	13.4325	6281700.0

> showing 50 of 46,129 rows — these rows as CSV

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