PREVIEW / stock_1hour / 2014-12-02

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-02.parquet
  size:    1.1 MB
  rows:    50,095
  symbols: 3,558

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-12-02 04:00:00	AAPL	Stock	28.775	28.995	28.775	28.98	87020.0
2014-12-02 05:00:00	AAPL	Stock	28.94	28.9675	28.875	28.875	104484.0
2014-12-02 06:00:00	AAPL	Stock	28.865	28.9025	28.815	28.9025	207028.0
2014-12-02 07:00:00	AAPL	Stock	28.885	28.9475	28.555	28.635	640364.0
2014-12-02 08:00:00	AAPL	Stock	28.645	28.9375	28.475	28.5	4403972.0
2014-12-02 09:00:00	AAPL	Stock	28.4875	28.61	28.1875	28.4838	59425980.0
2014-12-02 10:00:00	AAPL	Stock	28.48	28.87	28.465	28.7612	45311532.0
2014-12-02 11:00:00	AAPL	Stock	28.76	28.9175	28.64	28.9	21775500.0
2014-12-02 12:00:00	AAPL	Stock	28.8975	28.9375	28.6725	28.8325	19293740.0
2014-12-02 13:00:00	AAPL	Stock	28.83	28.845	28.7412	28.765	11579780.0
2014-12-02 14:00:00	AAPL	Stock	28.765	28.8	28.6875	28.78	11831480.0
2014-12-02 15:00:00	AAPL	Stock	28.7812	28.81	28.5875	28.655	26418408.0
2014-12-02 16:00:00	AAPL	Stock	28.6575	28.8205	28.5975	28.72	8149244.0
2014-12-02 17:00:00	AAPL	Stock	28.6575	28.6925	28.6325	28.6325	459144.0
2014-12-02 18:00:00	AAPL	Stock	28.6375	28.6575	28.58	28.5975	174184.0
2014-12-02 19:00:00	AAPL	Stock	28.5975	28.625	28.5875	28.625	118444.0
2014-12-02 05:00:00	MSFT	Stock	48.79	48.84	48.76	48.76	2800.0
2014-12-02 06:00:00	MSFT	Stock	48.78	48.8	48.78	48.78	1600.0
2014-12-02 07:00:00	MSFT	Stock	48.78	48.89	48.76	48.88	8492.0
2014-12-02 08:00:00	MSFT	Stock	48.9	49.02	48.62	48.9	20959.0
2014-12-02 09:00:00	MSFT	Stock	48.88	49.05	48.6	48.67	3762692.0
2014-12-02 10:00:00	MSFT	Stock	48.67	48.83	48.38	48.41	3939353.0
2014-12-02 11:00:00	MSFT	Stock	48.41	48.51	48.345	48.46	2614651.0
2014-12-02 12:00:00	MSFT	Stock	48.46	48.5	48.3	48.32	1727017.0
2014-12-02 13:00:00	MSFT	Stock	48.32	48.41	48.2	48.405	4587510.0
2014-12-02 14:00:00	MSFT	Stock	48.41	48.6	48.34	48.56	1826302.0
2014-12-02 15:00:00	MSFT	Stock	48.57	48.59	48.365	48.46	3765608.0
2014-12-02 16:00:00	MSFT	Stock	48.46	48.6	48.417	48.507	2419543.0
2014-12-02 17:00:00	MSFT	Stock	48.54	48.54	48.54	48.54	100.0
2014-12-02 18:00:00	MSFT	Stock	48.43	48.519	48.43	48.5	520.0
2014-12-02 19:00:00	MSFT	Stock	48.52	48.59	48.52	48.59	4700.0
2014-12-02 09:00:00	NVDA	Stock	0.513	0.5175	0.5093	0.5102	32206480.0
2014-12-02 10:00:00	NVDA	Stock	0.5101	0.5122	0.5095	0.51	28854840.0
2014-12-02 11:00:00	NVDA	Stock	0.5102	0.5118	0.5096	0.5114	29871520.0
2014-12-02 12:00:00	NVDA	Stock	0.5115	0.5115	0.5095	0.51	12017280.0
2014-12-02 13:00:00	NVDA	Stock	0.5102	0.5122	0.5098	0.5115	18463400.0
2014-12-02 14:00:00	NVDA	Stock	0.5116	0.5128	0.511	0.5125	25220760.0
2014-12-02 15:00:00	NVDA	Stock	0.5128	0.5155	0.5125	0.5152	43517640.0
2014-12-02 16:00:00	NVDA	Stock	0.5152	0.5175	0.5109	0.5109	23009800.0
2014-12-02 06:00:00	AMZN	Stock	16.325	16.34	16.254	16.34	42000.0
2014-12-02 07:00:00	AMZN	Stock	16.3685	16.398	16.35	16.357	56540.0
2014-12-02 08:00:00	AMZN	Stock	16.3645	16.385	16.3	16.366	137020.0
2014-12-02 09:00:00	AMZN	Stock	16.3735	16.3965	16.226	16.306	8957920.0
2014-12-02 10:00:00	AMZN	Stock	16.306	16.385	16.2	16.2106	9967340.0
2014-12-02 11:00:00	AMZN	Stock	16.2085	16.2575	16.1625	16.2575	6040920.0
2014-12-02 12:00:00	AMZN	Stock	16.245	16.255	16.169	16.181	3943520.0
2014-12-02 13:00:00	AMZN	Stock	16.1765	16.292	16.173	16.2545	5148660.0
2014-12-02 14:00:00	AMZN	Stock	16.258	16.265	16.2105	16.246	4522040.0
2014-12-02 15:00:00	AMZN	Stock	16.2465	16.3238	16.2465	16.3155	9094700.0
2014-12-02 16:00:00	AMZN	Stock	16.3155	16.3415	16.2512	16.2512	3080560.0

> showing 50 of 50,095 rows — these rows as CSV

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