PREVIEW / stock_1hour / 2015-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-02.parquet
  size:    1.0 MB
  rows:    49,304
  symbols: 3,528

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
2015-02-02 04:00:00	AAPL	Stock	29.4375	29.45	29.3975	29.4475	9696.0
2015-02-02 05:00:00	AAPL	Stock	29.4	29.4125	29.3925	29.4	13032.0
2015-02-02 06:00:00	AAPL	Stock	29.4125	29.4225	29.375	29.415	24412.0
2015-02-02 07:00:00	AAPL	Stock	29.395	29.42	29.375	29.4175	91528.0
2015-02-02 08:00:00	AAPL	Stock	29.3925	29.4625	29.25	29.425	2212908.0
2015-02-02 09:00:00	AAPL	Stock	29.4275	29.5962	29.16	29.1705	35478304.0
2015-02-02 10:00:00	AAPL	Stock	29.17	29.3675	29.02	29.3225	39509068.0
2015-02-02 11:00:00	AAPL	Stock	29.325	29.5962	29.3225	29.4825	33538248.0
2015-02-02 12:00:00	AAPL	Stock	29.485	29.5	29.24	29.2622	20226196.0
2015-02-02 13:00:00	AAPL	Stock	29.26	29.3975	29.1625	29.2388	24957012.0
2015-02-02 14:00:00	AAPL	Stock	29.236	29.4275	29.235	29.275	20966568.0
2015-02-02 15:00:00	AAPL	Stock	29.2742	29.7925	29.185	29.655	47023276.0
2015-02-02 16:00:00	AAPL	Stock	29.64	29.6625	29.2425	29.6375	8729620.0
2015-02-02 17:00:00	AAPL	Stock	29.6525	29.6575	29.6175	29.63	605328.0
2015-02-02 18:00:00	AAPL	Stock	29.625	29.6575	29.5725	29.5725	282628.0
2015-02-02 19:00:00	AAPL	Stock	29.5825	29.6225	29.52	29.5375	352616.0
2015-02-02 04:00:00	MSFT	Stock	40.65	40.65	40.59	40.59	400.0
2015-02-02 05:00:00	MSFT	Stock	40.59	40.61	40.59	40.61	2008.0
2015-02-02 07:00:00	MSFT	Stock	40.56	40.68	40.55	40.55	12087.0
2015-02-02 08:00:00	MSFT	Stock	40.6	40.6	40.45	40.46	25449.0
2015-02-02 09:00:00	MSFT	Stock	40.48	40.765	40.4	40.54	6879037.0
2015-02-02 10:00:00	MSFT	Stock	40.53	40.64	40.23	40.5	8605826.0
2015-02-02 11:00:00	MSFT	Stock	40.5	40.89	40.48	40.858	6843696.0
2015-02-02 12:00:00	MSFT	Stock	40.86	40.97	40.69	40.71	4402833.0
2015-02-02 13:00:00	MSFT	Stock	40.7	40.95	40.635	40.67	4904965.0
2015-02-02 14:00:00	MSFT	Stock	40.67	40.99	40.65	40.855	4139559.0
2015-02-02 15:00:00	MSFT	Stock	40.85	41.37	40.81	41.28	8684921.0
2015-02-02 16:00:00	MSFT	Stock	41.28	41.29	40.594	41.28	3426386.0
2015-02-02 17:00:00	MSFT	Stock	41.25	41.28	41.25	41.25	159025.0
2015-02-02 18:00:00	MSFT	Stock	41.25	41.3	41.25	41.26	27149.0
2015-02-02 19:00:00	MSFT	Stock	41.26	41.26	41.2	41.2	5315.0
2015-02-02 09:00:00	NVDA	Stock	0.4801	0.484	0.476	0.4765	24873600.0
2015-02-02 10:00:00	NVDA	Stock	0.4763	0.4818	0.4735	0.4816	51226360.0
2015-02-02 11:00:00	NVDA	Stock	0.4815	0.488	0.4812	0.4855	33242960.0
2015-02-02 12:00:00	NVDA	Stock	0.4855	0.4878	0.4846	0.485	26687280.0
2015-02-02 13:00:00	NVDA	Stock	0.485	0.4878	0.4825	0.4825	24725200.0
2015-02-02 14:00:00	NVDA	Stock	0.4825	0.489	0.4822	0.485	21656800.0
2015-02-02 15:00:00	NVDA	Stock	0.485	0.4925	0.4845	0.4904	61838280.0
2015-02-02 16:00:00	NVDA	Stock	0.4905	0.4915	0.4842	0.4905	4222360.0
2015-02-02 17:00:00	NVDA	Stock	0.4905	0.4905	0.4905	0.4905	341960.0
2015-02-02 04:00:00	AMZN	Stock	17.73	17.75	17.7265	17.7265	55900.0
2015-02-02 05:00:00	AMZN	Stock	17.725	17.725	17.725	17.725	8000.0
2015-02-02 06:00:00	AMZN	Stock	17.725	17.729	17.725	17.7285	36800.0
2015-02-02 07:00:00	AMZN	Stock	17.7285	17.736	17.7	17.7	156080.0
2015-02-02 08:00:00	AMZN	Stock	17.6885	17.74	17.6	17.701	1133140.0
2015-02-02 09:00:00	AMZN	Stock	17.72	17.7795	17.5005	17.5875	29877120.0
2015-02-02 10:00:00	AMZN	Stock	17.587	18.06	17.52	17.982	48096700.0
2015-02-02 11:00:00	AMZN	Stock	17.9735	18.2	17.9585	18.0425	30431980.0
2015-02-02 12:00:00	AMZN	Stock	18.0535	18.1075	17.9532	17.9711	14790820.0
2015-02-02 13:00:00	AMZN	Stock	17.9745	18.0955	17.94	18.0545	13934240.0

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

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