PREVIEW / stock_1hour / 2014-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-01.parquet
  size:    1.1 MB
  rows:    50,426
  symbols: 3,566

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-01 04:00:00	AAPL	Stock	19.1854	19.1889	19.1854	19.1889	5600.0
2014-04-01 05:00:00	AAPL	Stock	19.1786	19.1786	19.1786	19.1786	2800.0
2014-04-01 06:00:00	AAPL	Stock	19.1786	19.1893	19.1786	19.1893	11760.0
2014-04-01 07:00:00	AAPL	Stock	19.1968	19.2143	19.1964	19.2054	161504.0
2014-04-01 08:00:00	AAPL	Stock	19.2057	19.2321	19.1693	19.2321	445256.0
2014-04-01 09:00:00	AAPL	Stock	19.2257	19.2604	19.1804	19.1929	24828188.0
2014-04-01 10:00:00	AAPL	Stock	19.1893	19.2379	19.1704	19.2296	22996680.0
2014-04-01 11:00:00	AAPL	Stock	19.2321	19.2821	19.1971	19.2629	28399840.0
2014-04-01 12:00:00	AAPL	Stock	19.2654	19.2782	19.2164	19.24	15794520.0
2014-04-01 13:00:00	AAPL	Stock	19.2379	19.2475	19.22	19.2339	7002492.0
2014-04-01 14:00:00	AAPL	Stock	19.2343	19.2884	19.2343	19.2837	17901968.0
2014-04-01 15:00:00	AAPL	Stock	19.2836	19.3525	19.2554	19.3479	32576404.0
2014-04-01 16:00:00	AAPL	Stock	19.3473	19.355	19.2197	19.3532	18360944.0
2014-04-01 17:00:00	AAPL	Stock	19.3532	19.355	19.2498	19.3493	186284.0
2014-04-01 18:00:00	AAPL	Stock	19.3486	19.355	19.3482	19.355	110180.0
2014-04-01 19:00:00	AAPL	Stock	19.355	19.3568	19.3486	19.3486	207508.0
2014-04-01 07:00:00	MSFT	Stock	41.08	41.09	41.06	41.07	1154.0
2014-04-01 08:00:00	MSFT	Stock	41.09	41.19	40.92	41.14	29679.0
2014-04-01 09:00:00	MSFT	Stock	41.13	41.44	41.06	41.41	4333765.0
2014-04-01 10:00:00	MSFT	Stock	41.41	41.59	41.36	41.436	7055103.0
2014-04-01 11:00:00	MSFT	Stock	41.44	41.44	41.31	41.325	3697789.0
2014-04-01 12:00:00	MSFT	Stock	41.324	41.38	41.2	41.38	2403389.0
2014-04-01 13:00:00	MSFT	Stock	41.38	41.41	41.275	41.39	2454243.0
2014-04-01 14:00:00	MSFT	Stock	41.384	41.46	41.38	41.44	2284143.0
2014-04-01 15:00:00	MSFT	Stock	41.445	41.45	41.232	41.41	7246208.0
2014-04-01 16:00:00	MSFT	Stock	41.42	41.42	41.33	41.38	1704319.0
2014-04-01 17:00:00	MSFT	Stock	41.4	41.45	41.368	41.43	45439.0
2014-04-01 18:00:00	MSFT	Stock	41.41	41.43	41.41	41.43	1215.0
2014-04-01 19:00:00	MSFT	Stock	41.41	41.43	41.41	41.43	3400.0
2014-04-01 04:00:00	NVDA	Stock	0.4545	0.455	0.4545	0.455	48000.0
2014-04-01 07:00:00	NVDA	Stock	0.4622	0.4633	0.4622	0.4625	80000.0
2014-04-01 08:00:00	NVDA	Stock	0.461	0.465	0.46	0.462	1254120.0
2014-04-01 09:00:00	NVDA	Stock	0.4612	0.47	0.4565	0.469	139132840.0
2014-04-01 10:00:00	NVDA	Stock	0.469	0.4718	0.4635	0.4668	127503480.0
2014-04-01 11:00:00	NVDA	Stock	0.4665	0.4668	0.4644	0.4652	58990520.0
2014-04-01 12:00:00	NVDA	Stock	0.4652	0.4655	0.462	0.4622	41692640.0
2014-04-01 13:00:00	NVDA	Stock	0.4621	0.4625	0.4593	0.4616	33766920.0
2014-04-01 14:00:00	NVDA	Stock	0.4616	0.464	0.4608	0.4618	56505000.0
2014-04-01 15:00:00	NVDA	Stock	0.4618	0.467	0.4608	0.4662	165700680.0
2014-04-01 16:00:00	NVDA	Stock	0.4662	0.467	0.4642	0.467	17222520.0
2014-04-01 17:00:00	NVDA	Stock	0.4675	0.4675	0.4675	0.4675	8000.0
2014-04-01 18:00:00	NVDA	Stock	0.4662	0.4662	0.4662	0.4662	12000.0
2014-04-01 19:00:00	NVDA	Stock	0.4678	0.4678	0.4678	0.4678	40000.0
2014-04-01 08:00:00	AMZN	Stock	16.875	16.875	16.8183	16.838	41720.0
2014-04-01 09:00:00	AMZN	Stock	16.8645	17.193	16.838	17.0885	13523040.0
2014-04-01 10:00:00	AMZN	Stock	17.0964	17.2215	17.0935	17.1962	10265560.0
2014-04-01 11:00:00	AMZN	Stock	17.207	17.207	17.0595	17.1205	7323100.0
2014-04-01 12:00:00	AMZN	Stock	17.109	17.1845	17.0965	17.1	4947220.0
2014-04-01 13:00:00	AMZN	Stock	17.1	17.154	17.067	17.13	4779620.0
2014-04-01 14:00:00	AMZN	Stock	17.131	17.1545	17.0438	17.0945	6195940.0

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

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