PREVIEW / stock_1hour / 2014-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-19.parquet
  size:    1.0 MB
  rows:    47,827
  symbols: 3,552

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
2014-05-19 04:00:00	AAPL	Stock	21.3036	21.3036	21.25	21.25	123200.0
2014-05-19 05:00:00	AAPL	Stock	21.2539	21.2657	21.2489	21.2657	47600.0
2014-05-19 06:00:00	AAPL	Stock	21.2657	21.3	21.2589	21.2864	79100.0
2014-05-19 07:00:00	AAPL	Stock	21.2864	21.3464	21.2821	21.3214	354032.0
2014-05-19 08:00:00	AAPL	Stock	21.3293	21.3382	21.2889	21.3257	873852.0
2014-05-19 09:00:00	AAPL	Stock	21.3264	21.63	21.3264	21.5704	77302736.0
2014-05-19 10:00:00	AAPL	Stock	21.5704	21.6411	21.5554	21.6014	45363556.0
2014-05-19 11:00:00	AAPL	Stock	21.6021	21.6811	21.5975	21.6743	33344080.0
2014-05-19 12:00:00	AAPL	Stock	21.6727	21.6904	21.6332	21.6596	19921356.0
2014-05-19 13:00:00	AAPL	Stock	21.6618	21.6679	21.6179	21.6525	14649096.0
2014-05-19 14:00:00	AAPL	Stock	21.6521	21.6632	21.6111	21.6236	15214164.0
2014-05-19 15:00:00	AAPL	Stock	21.6239	21.628	21.5371	21.5857	41249208.0
2014-05-19 16:00:00	AAPL	Stock	21.5925	21.6144	21.586	21.5929	10671584.0
2014-05-19 17:00:00	AAPL	Stock	21.5911	21.5929	21.5732	21.5768	2137240.0
2014-05-19 18:00:00	AAPL	Stock	21.5732	21.5925	21.5732	21.5786	143304.0
2014-05-19 19:00:00	AAPL	Stock	21.5796	21.5804	21.5714	21.5714	223832.0
2014-05-19 07:00:00	MSFT	Stock	39.81	39.81	39.81	39.81	100.0
2014-05-19 08:00:00	MSFT	Stock	39.88	39.88	39.74	39.74	1000.0
2014-05-19 09:00:00	MSFT	Stock	39.79	39.8	39.46	39.67	3644343.0
2014-05-19 10:00:00	MSFT	Stock	39.66	39.71	39.52	39.585	2984516.0
2014-05-19 11:00:00	MSFT	Stock	39.585	39.68	39.56	39.66	2327178.0
2014-05-19 12:00:00	MSFT	Stock	39.66	39.67	39.605	39.65	1332671.0
2014-05-19 13:00:00	MSFT	Stock	39.645	39.73	39.6	39.72	1803333.0
2014-05-19 14:00:00	MSFT	Stock	39.73	39.82	39.72	39.736	1659778.0
2014-05-19 15:00:00	MSFT	Stock	39.74	39.81	39.7	39.74	3340533.0
2014-05-19 16:00:00	MSFT	Stock	39.75	39.81	39.608	39.75	5796989.0
2014-05-19 17:00:00	MSFT	Stock	39.75	39.75	39.7	39.7	883215.0
2014-05-19 18:00:00	MSFT	Stock	39.69	39.75	39.67	39.7	13186.0
2014-05-19 09:00:00	NVDA	Stock	0.4535	0.4615	0.4518	0.4595	52988280.0
2014-05-19 10:00:00	NVDA	Stock	0.4595	0.465	0.4594	0.4622	81904480.0
2014-05-19 11:00:00	NVDA	Stock	0.4624	0.4658	0.4622	0.4656	53800320.0
2014-05-19 12:00:00	NVDA	Stock	0.4658	0.466	0.4626	0.4626	32220600.0
2014-05-19 13:00:00	NVDA	Stock	0.4626	0.4638	0.4609	0.4635	23560800.0
2014-05-19 14:00:00	NVDA	Stock	0.4636	0.4638	0.4619	0.4633	20277120.0
2014-05-19 15:00:00	NVDA	Stock	0.463	0.4643	0.4618	0.4635	69848480.0
2014-05-19 16:00:00	NVDA	Stock	0.4635	0.4639	0.4635	0.4635	1055520.0
2014-05-19 17:00:00	NVDA	Stock	0.4652	0.4662	0.4652	0.4662	32000.0
2014-05-19 18:00:00	NVDA	Stock	0.4648	0.4648	0.4648	0.4648	4000.0
2014-05-19 06:00:00	AMZN	Stock	14.781	14.781	14.7335	14.775	33020.0
2014-05-19 07:00:00	AMZN	Stock	14.8175	14.825	14.8175	14.825	10000.0
2014-05-19 08:00:00	AMZN	Stock	14.825	14.871	14.8035	14.8035	18000.0
2014-05-19 09:00:00	AMZN	Stock	14.8085	14.824	14.6905	14.783	7483380.0
2014-05-19 10:00:00	AMZN	Stock	14.792	14.8855	14.75	14.8425	5667200.0
2014-05-19 11:00:00	AMZN	Stock	14.8425	14.95	14.8365	14.9005	4704160.0
2014-05-19 12:00:00	AMZN	Stock	14.8995	14.925	14.8462	14.8605	3246220.0
2014-05-19 13:00:00	AMZN	Stock	14.855	14.8895	14.7765	14.8055	4058080.0
2014-05-19 14:00:00	AMZN	Stock	14.8125	14.8282	14.7585	14.793	4052980.0
2014-05-19 15:00:00	AMZN	Stock	14.797	14.875	14.749	14.845	9887120.0
2014-05-19 16:00:00	AMZN	Stock	14.845	14.852	14.8272	14.845	1976700.0
2014-05-19 18:00:00	AMZN	Stock	14.845	14.845	14.845	14.845	20000.0

> showing 50 of 47,827 rows — these rows as CSV

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