PREVIEW / stock_1hour / 2014-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-29.parquet
  size:    1.0 MB
  rows:    49,212
  symbols: 3,553

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-04-29 04:00:00	AAPL	Stock	21.2857	21.2857	21.2536	21.2621	12180.0
2014-04-29 05:00:00	AAPL	Stock	21.2668	21.2821	21.25	21.2821	22400.0
2014-04-29 06:00:00	AAPL	Stock	21.2857	21.3025	21.2821	21.3025	54852.0
2014-04-29 07:00:00	AAPL	Stock	21.2732	21.3386	21.2639	21.3175	836864.0
2014-04-29 08:00:00	AAPL	Stock	21.3075	21.3214	21.2536	21.26	2248708.0
2014-04-29 09:00:00	AAPL	Stock	21.2604	21.285	21.0539	21.1189	69837012.0
2014-04-29 10:00:00	AAPL	Stock	21.1132	21.2625	21.0625	21.1811	54773376.0
2014-04-29 11:00:00	AAPL	Stock	21.1793	21.2107	21.1011	21.1443	26060048.0
2014-04-29 12:00:00	AAPL	Stock	21.15	21.1993	21.1179	21.1725	21035756.0
2014-04-29 13:00:00	AAPL	Stock	21.1704	21.2436	21.1357	21.2221	25367552.0
2014-04-29 14:00:00	AAPL	Stock	21.225	21.2489	21.1786	21.2043	20769056.0
2014-04-29 15:00:00	AAPL	Stock	21.2046	21.2159	21.1364	21.1586	34655180.0
2014-04-29 16:00:00	AAPL	Stock	21.1546	21.1859	21.1075	21.1075	22486492.0
2014-04-29 17:00:00	AAPL	Stock	21.1107	21.1546	21.0825	21.0857	244132.0
2014-04-29 18:00:00	AAPL	Stock	21.0861	21.1546	21.0718	21.0846	539420.0
2014-04-29 19:00:00	AAPL	Stock	21.0768	21.0893	21.0714	21.0714	248780.0
2014-04-29 05:00:00	MSFT	Stock	41.04	41.04	41.04	41.04	300.0
2014-04-29 06:00:00	MSFT	Stock	41.04	41.14	41.04	41.14	3081.0
2014-04-29 07:00:00	MSFT	Stock	41.14	41.23	41.14	41.17	3084.0
2014-04-29 08:00:00	MSFT	Stock	41.17	41.17	41.04	41.07	12246.0
2014-04-29 09:00:00	MSFT	Stock	41.1	41.19	40.75	40.75	4115267.0
2014-04-29 10:00:00	MSFT	Stock	40.76	40.81	40.39	40.68	5376277.0
2014-04-29 11:00:00	MSFT	Stock	40.68	40.745	40.55	40.6	3050913.0
2014-04-29 12:00:00	MSFT	Stock	40.61	40.69	40.53	40.68	2377375.0
2014-04-29 13:00:00	MSFT	Stock	40.67	40.685	40.53	40.6	2281325.0
2014-04-29 14:00:00	MSFT	Stock	40.592	40.61	40.54	40.6	3439459.0
2014-04-29 15:00:00	MSFT	Stock	40.59	40.61	40.49	40.5	6201344.0
2014-04-29 16:00:00	MSFT	Stock	40.51	40.66	40.45	40.55	1870711.0
2014-04-29 17:00:00	MSFT	Stock	40.58	40.58	40.51	40.52	10335.0
2014-04-29 18:00:00	MSFT	Stock	40.5	40.55	40.5	40.55	1900.0
2014-04-29 19:00:00	MSFT	Stock	40.55	40.55	40.55	40.55	500.0
2014-04-29 09:00:00	NVDA	Stock	0.4685	0.4689	0.4635	0.464	19623520.0
2014-04-29 10:00:00	NVDA	Stock	0.464	0.465	0.462	0.4635	31183160.0
2014-04-29 11:00:00	NVDA	Stock	0.4635	0.4649	0.4625	0.4638	22092800.0
2014-04-29 12:00:00	NVDA	Stock	0.4638	0.466	0.4635	0.4656	20010040.0
2014-04-29 13:00:00	NVDA	Stock	0.4658	0.4673	0.465	0.4673	15362120.0
2014-04-29 14:00:00	NVDA	Stock	0.4673	0.4675	0.4666	0.4673	16706440.0
2014-04-29 15:00:00	NVDA	Stock	0.4673	0.4675	0.466	0.467	27571440.0
2014-04-29 16:00:00	NVDA	Stock	0.467	0.4673	0.4654	0.4673	3794640.0
2014-04-29 17:00:00	NVDA	Stock	0.465	0.4673	0.465	0.4673	30800.0
2014-04-29 18:00:00	NVDA	Stock	0.469	0.469	0.4688	0.469	240000.0
2014-04-29 19:00:00	NVDA	Stock	0.469	0.469	0.469	0.469	20000.0
2014-04-29 04:00:00	AMZN	Stock	14.8895	14.8895	14.8835	14.8835	6000.0
2014-04-29 05:00:00	AMZN	Stock	14.892	14.892	14.892	14.892	4000.0
2014-04-29 06:00:00	AMZN	Stock	14.882	14.89	14.813	14.813	7840.0
2014-04-29 07:00:00	AMZN	Stock	14.874	14.882	14.848	14.8625	28400.0
2014-04-29 08:00:00	AMZN	Stock	14.8645	14.8645	14.6565	14.7	236880.0
2014-04-29 09:00:00	AMZN	Stock	14.7	14.946	14.6935	14.7932	20672920.0
2014-04-29 10:00:00	AMZN	Stock	14.804	14.8185	14.5225	14.7135	29332420.0
2014-04-29 11:00:00	AMZN	Stock	14.7135	14.9395	14.6855	14.8855	14790140.0

> showing 50 of 49,212 rows — these rows as CSV

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