PREVIEW / stock_1hour / 2015-12-02

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-02.parquet
  size:    1.0 MB
  rows:    48,500
  symbols: 3,445

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-12-02 04:00:00	AAPL	Stock	29.3425	29.3725	29.3425	29.3725	2400.0
2015-12-02 05:00:00	AAPL	Stock	29.365	29.365	29.35	29.35	800.0
2015-12-02 06:00:00	AAPL	Stock	29.35	29.3725	29.335	29.335	11036.0
2015-12-02 07:00:00	AAPL	Stock	29.335	29.34	29.2875	29.29	58316.0
2015-12-02 08:00:00	AAPL	Stock	29.3	29.335	29.225	29.2425	283632.0
2015-12-02 09:00:00	AAPL	Stock	29.2475	29.45	29.235	29.405	14786680.0
2015-12-02 10:00:00	AAPL	Stock	29.405	29.5275	29.335	29.47	20991140.0
2015-12-02 11:00:00	AAPL	Stock	29.47	29.5025	29.415	29.4388	12647264.0
2015-12-02 12:00:00	AAPL	Stock	29.44	29.5175	29.4	29.4825	9387212.0
2015-12-02 13:00:00	AAPL	Stock	29.48	29.4925	29.31	29.3225	9106324.0
2015-12-02 14:00:00	AAPL	Stock	29.32	29.32	29.0845	29.1275	18155576.0
2015-12-02 15:00:00	AAPL	Stock	29.13	29.2125	29.02	29.075	25302504.0
2015-12-02 16:00:00	AAPL	Stock	29.07	29.11	29.07	29.0975	13160136.0
2015-12-02 17:00:00	AAPL	Stock	29.0975	29.105	29.055	29.0975	184452.0
2015-12-02 18:00:00	AAPL	Stock	29.09	29.11	29.0625	29.1	52360.0
2015-12-02 19:00:00	AAPL	Stock	29.105	29.11	29.095	29.1075	65240.0
2015-12-02 05:00:00	MSFT	Stock	55.33	55.33	55.33	55.33	400.0
2015-12-02 06:00:00	MSFT	Stock	55.26	55.26	55.26	55.26	300.0
2015-12-02 07:00:00	MSFT	Stock	55.3	55.3	55.17	55.17	4997.0
2015-12-02 08:00:00	MSFT	Stock	55.35	55.38	55.16	55.18	32911.0
2015-12-02 09:00:00	MSFT	Stock	55.22	55.79	55.17	55.706	4942269.0
2015-12-02 10:00:00	MSFT	Stock	55.7	55.96	55.6	55.69	6532249.0
2015-12-02 11:00:00	MSFT	Stock	55.68	55.78	55.56	55.73	5362778.0
2015-12-02 12:00:00	MSFT	Stock	55.725	55.91	55.68	55.8	3977790.0
2015-12-02 13:00:00	MSFT	Stock	55.8	55.86	55.39	55.444	4138431.0
2015-12-02 14:00:00	MSFT	Stock	55.45	55.495	55.06	55.12	4923431.0
2015-12-02 15:00:00	MSFT	Stock	55.125	55.31	55.06	55.23	8411103.0
2015-12-02 16:00:00	MSFT	Stock	55.21	55.555	55.21	55.35	6344090.0
2015-12-02 17:00:00	MSFT	Stock	55.3	55.4	55.3	55.4	4985.0
2015-12-02 18:00:00	MSFT	Stock	55.34	55.4	55.3	55.3	2100.0
2015-12-02 19:00:00	MSFT	Stock	55.39	55.4	55.32	55.32	2300.0
2015-12-02 08:00:00	NVDA	Stock	0.8198	0.8198	0.8195	0.8195	20000.0
2015-12-02 09:00:00	NVDA	Stock	0.82	0.8285	0.8165	0.8264	35542240.0
2015-12-02 10:00:00	NVDA	Stock	0.8265	0.8285	0.8203	0.8205	58012800.0
2015-12-02 11:00:00	NVDA	Stock	0.8203	0.822	0.8168	0.8176	32885080.0
2015-12-02 12:00:00	NVDA	Stock	0.8178	0.8222	0.815	0.82	25463200.0
2015-12-02 13:00:00	NVDA	Stock	0.82	0.8212	0.818	0.8189	30550800.0
2015-12-02 14:00:00	NVDA	Stock	0.819	0.819	0.812	0.814	37108560.0
2015-12-02 15:00:00	NVDA	Stock	0.814	0.8158	0.8108	0.8125	51628480.0
2015-12-02 16:00:00	NVDA	Stock	0.8125	0.8195	0.8125	0.817	3995800.0
2015-12-02 18:00:00	NVDA	Stock	0.8125	0.82	0.8125	0.8175	17400.0
2015-12-02 19:00:00	NVDA	Stock	0.813	0.813	0.8128	0.8128	8000.0
2015-12-02 04:00:00	AMZN	Stock	33.9505	33.9505	33.9505	33.9505	2020.0
2015-12-02 07:00:00	AMZN	Stock	34.0495	34.0495	33.9	33.9745	102620.0
2015-12-02 08:00:00	AMZN	Stock	33.95	34.0475	33.92	33.9405	184020.0
2015-12-02 09:00:00	AMZN	Stock	33.945	34.237	33.8555	34.2	13454880.0
2015-12-02 10:00:00	AMZN	Stock	34.188	34.241	34.028	34.075	11831680.0
2015-12-02 11:00:00	AMZN	Stock	34.0806	34.1505	33.863	34.1135	9454740.0
2015-12-02 12:00:00	AMZN	Stock	34.0979	34.1995	34.0255	34.123	8196720.0
2015-12-02 13:00:00	AMZN	Stock	34.1103	34.149	33.9842	34.002	7069600.0

> showing 50 of 48,500 rows — these rows as CSV

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