PREVIEW / stock_1hour / 2017-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-02.parquet
  size:    1.1 MB
  rows:    48,379
  symbols: 3,070

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
2017-05-02 04:00:00	AAPL	Stock	36.645	36.7	36.6375	36.6575	22524.0
2017-05-02 05:00:00	AAPL	Stock	36.6575	36.685	36.6	36.685	11940.0
2017-05-02 06:00:00	AAPL	Stock	36.685	36.73	36.685	36.6875	33752.0
2017-05-02 07:00:00	AAPL	Stock	36.7025	36.7425	36.6375	36.7175	304240.0
2017-05-02 08:00:00	AAPL	Stock	36.725	36.835	36.66	36.8125	806080.0
2017-05-02 09:00:00	AAPL	Stock	36.8125	36.9225	36.745	36.8475	22089820.0
2017-05-02 10:00:00	AAPL	Stock	36.85	36.945	36.7625	36.9138	17776540.0
2017-05-02 11:00:00	AAPL	Stock	36.9125	37.0225	36.8925	36.9233	17947216.0
2017-05-02 12:00:00	AAPL	Stock	36.9238	36.965	36.8425	36.8525	10654440.0
2017-05-02 13:00:00	AAPL	Stock	36.855	36.87	36.71	36.7403	14130236.0
2017-05-02 14:00:00	AAPL	Stock	36.74	36.8475	36.7375	36.8162	13415624.0
2017-05-02 15:00:00	AAPL	Stock	36.8175	36.91	36.8125	36.8675	30049668.0
2017-05-02 16:00:00	AAPL	Stock	36.8675	37.25	36.075	36.1	19332844.0
2017-05-02 17:00:00	AAPL	Stock	36.1	36.3125	35.9525	36.0625	4526320.0
2017-05-02 18:00:00	AAPL	Stock	36.0625	36.22	36.0375	36.1625	1054356.0
2017-05-02 19:00:00	AAPL	Stock	36.165	36.25	36.1625	36.2	621388.0
2017-05-02 04:00:00	MSFT	Stock	69.6	69.6	69.6	69.6	299.0
2017-05-02 06:00:00	MSFT	Stock	69.58	69.6	69.58	69.6	3667.0
2017-05-02 07:00:00	MSFT	Stock	69.59	69.59	69.54	69.54	258.0
2017-05-02 08:00:00	MSFT	Stock	69.59	69.67	69.59	69.62	8747.0
2017-05-02 09:00:00	MSFT	Stock	69.61	69.74	69.27	69.36	2679614.0
2017-05-02 10:00:00	MSFT	Stock	69.36	69.48	69.33	69.465	3319175.0
2017-05-02 11:00:00	MSFT	Stock	69.46	69.55	69.41	69.455	1967014.0
2017-05-02 12:00:00	MSFT	Stock	69.46	69.685	69.455	69.65	1926061.0
2017-05-02 13:00:00	MSFT	Stock	69.65	69.71	69.59	69.6	1283148.0
2017-05-02 14:00:00	MSFT	Stock	69.605	69.65	69.45	69.46	2251188.0
2017-05-02 15:00:00	MSFT	Stock	69.465	69.5	69.13	69.3	5761564.0
2017-05-02 16:00:00	MSFT	Stock	69.29	69.42	69.19	69.25	2464924.0
2017-05-02 17:00:00	MSFT	Stock	69.2	69.24	69.02	69.05	6110.0
2017-05-02 18:00:00	MSFT	Stock	69.0	69.13	69.0	69.01	1950.0
2017-05-02 19:00:00	MSFT	Stock	69.05	69.1	69.0	69.0	1780.0
2017-05-02 06:00:00	NVDA	Stock	2.6438	2.6438	2.6438	2.6438	4000.0
2017-05-02 07:00:00	NVDA	Stock	2.6413	2.6413	2.6338	2.6375	322440.0
2017-05-02 08:00:00	NVDA	Stock	2.6413	2.6512	2.637	2.6503	1310360.0
2017-05-02 09:00:00	NVDA	Stock	2.6525	2.6525	2.572	2.5992	135086600.0
2017-05-02 10:00:00	NVDA	Stock	2.5992	2.6205	2.58	2.6095	123944440.0
2017-05-02 11:00:00	NVDA	Stock	2.6095	2.635	2.5958	2.5978	52958000.0
2017-05-02 12:00:00	NVDA	Stock	2.5976	2.5996	2.5835	2.5855	55493360.0
2017-05-02 13:00:00	NVDA	Stock	2.5854	2.59	2.5738	2.5795	62754920.0
2017-05-02 14:00:00	NVDA	Stock	2.5795	2.5815	2.564	2.5658	65172360.0
2017-05-02 15:00:00	NVDA	Stock	2.5658	2.587	2.5655	2.587	82082920.0
2017-05-02 16:00:00	NVDA	Stock	2.587	2.59	2.5825	2.5825	34116160.0
2017-05-02 17:00:00	NVDA	Stock	2.582	2.5862	2.575	2.575	261240.0
2017-05-02 18:00:00	NVDA	Stock	2.5762	2.5788	2.5728	2.575	242640.0
2017-05-02 19:00:00	NVDA	Stock	2.5762	2.58	2.5762	2.58	109760.0
2017-05-02 04:00:00	AMZN	Stock	47.5575	47.5575	47.5575	47.5575	2000.0
2017-05-02 05:00:00	AMZN	Stock	47.6095	47.6095	47.6095	47.6095	2000.0
2017-05-02 06:00:00	AMZN	Stock	47.6115	47.65	47.6115	47.65	12420.0
2017-05-02 07:00:00	AMZN	Stock	47.65	47.689	47.565	47.5875	77600.0
2017-05-02 08:00:00	AMZN	Stock	47.65	47.65	47.4995	47.55	267420.0

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

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