PREVIEW / stock_1hour / 2016-12-02

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-02.parquet
  size:    1.0 MB
  rows:    48,393
  symbols: 3,150

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
2016-12-02 04:00:00	AAPL	Stock	27.325	27.325	27.215	27.225	6328.0
2016-12-02 05:00:00	AAPL	Stock	27.2	27.225	27.19	27.225	4912.0
2016-12-02 06:00:00	AAPL	Stock	27.25	27.26	27.25	27.25	1728.0
2016-12-02 07:00:00	AAPL	Stock	27.2675	27.3275	27.2675	27.3	28172.0
2016-12-02 08:00:00	AAPL	Stock	27.3025	27.385	27.295	27.3425	146296.0
2016-12-02 09:00:00	AAPL	Stock	27.34	27.5225	27.25	27.3775	17205840.0
2016-12-02 10:00:00	AAPL	Stock	27.3775	27.4222	27.2125	27.325	17157284.0
2016-12-02 11:00:00	AAPL	Stock	27.3275	27.4825	27.32	27.4	9933344.0
2016-12-02 12:00:00	AAPL	Stock	27.3975	27.48	27.39	27.4775	7136364.0
2016-12-02 13:00:00	AAPL	Stock	27.4775	27.48	27.3775	27.4075	5751216.0
2016-12-02 14:00:00	AAPL	Stock	27.4075	27.4775	27.37	27.4675	7871840.0
2016-12-02 15:00:00	AAPL	Stock	27.4698	27.4975	27.3988	27.4725	17133640.0
2016-12-02 16:00:00	AAPL	Stock	27.475	27.495	27.4375	27.465	9095280.0
2016-12-02 17:00:00	AAPL	Stock	27.4675	27.47	27.4625	27.47	39924.0
2016-12-02 18:00:00	AAPL	Stock	27.4725	27.4725	27.44	27.44	20140.0
2016-12-02 19:00:00	AAPL	Stock	27.44	27.46	27.4375	27.46	18192.0
2016-12-02 07:00:00	MSFT	Stock	58.9	58.93	58.74	58.75	3022.0
2016-12-02 08:00:00	MSFT	Stock	58.9	59.11	58.9	59.0	4737.0
2016-12-02 09:00:00	MSFT	Stock	59.0	59.47	58.835	59.065	3386181.0
2016-12-02 10:00:00	MSFT	Stock	59.07	59.35	58.8	59.19	3258822.0
2016-12-02 11:00:00	MSFT	Stock	59.19	59.38	59.06	59.12	3135186.0
2016-12-02 12:00:00	MSFT	Stock	59.12	59.34	59.06	59.28	2093453.0
2016-12-02 13:00:00	MSFT	Stock	59.289	59.37	59.12	59.27	2163417.0
2016-12-02 14:00:00	MSFT	Stock	59.27	59.33	59.19	59.24	2058731.0
2016-12-02 15:00:00	MSFT	Stock	59.24	59.384	59.19	59.26	4208500.0
2016-12-02 16:00:00	MSFT	Stock	59.25	59.38	59.25	59.38	3458928.0
2016-12-02 17:00:00	MSFT	Stock	59.25	59.3	59.25	59.3	50300.0
2016-12-02 18:00:00	MSFT	Stock	59.21	59.21	59.21	59.21	100.0
2016-12-02 19:00:00	MSFT	Stock	59.21	59.21	59.21	59.21	750.0
2016-12-02 04:00:00	NVDA	Stock	2.1725	2.1748	2.1725	2.1748	20000.0
2016-12-02 05:00:00	NVDA	Stock	2.1688	2.17	2.1688	2.1688	40000.0
2016-12-02 06:00:00	NVDA	Stock	2.1712	2.1712	2.1498	2.1498	163320.0
2016-12-02 07:00:00	NVDA	Stock	2.1498	2.1575	2.1388	2.1562	399360.0
2016-12-02 08:00:00	NVDA	Stock	2.1402	2.1712	2.1263	2.165	1211000.0
2016-12-02 09:00:00	NVDA	Stock	2.1675	2.22	2.128	2.1935	101881480.0
2016-12-02 10:00:00	NVDA	Stock	2.195	2.2075	2.153	2.1892	95370080.0
2016-12-02 11:00:00	NVDA	Stock	2.1898	2.2108	2.1832	2.2064	64673320.0
2016-12-02 12:00:00	NVDA	Stock	2.206	2.2185	2.2025	2.2085	45002720.0
2016-12-02 13:00:00	NVDA	Stock	2.2087	2.2125	2.1945	2.2085	38589840.0
2016-12-02 14:00:00	NVDA	Stock	2.2082	2.2095	2.1955	2.2068	47335040.0
2016-12-02 15:00:00	NVDA	Stock	2.207	2.2125	2.2018	2.2112	68503040.0
2016-12-02 16:00:00	NVDA	Stock	2.2112	2.214	2.21	2.2138	2122800.0
2016-12-02 17:00:00	NVDA	Stock	2.2125	2.2125	2.2112	2.2112	23400.0
2016-12-02 18:00:00	NVDA	Stock	2.2112	2.2125	2.2112	2.2125	144400.0
2016-12-02 19:00:00	NVDA	Stock	2.2125	2.2225	2.2125	2.2225	296600.0
2016-12-02 04:00:00	AMZN	Stock	37.106	37.106	37.093	37.093	12520.0
2016-12-02 07:00:00	AMZN	Stock	36.995	37.025	36.9635	37.0105	10600.0
2016-12-02 08:00:00	AMZN	Stock	37.05	37.225	37.025	37.075	103520.0
2016-12-02 09:00:00	AMZN	Stock	37.1495	37.4245	36.835	37.0533	17761080.0
2016-12-02 10:00:00	AMZN	Stock	37.056	37.2425	36.9675	37.169	12755820.0

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

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