PREVIEW / stock_1hour / 2017-10-02

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-02.parquet
  size:    1.1 MB
  rows:    48,583
  symbols: 2,955

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-10-02 04:00:00	AAPL	Stock	38.53	38.535	38.53	38.535	800.0
2017-10-02 05:00:00	AAPL	Stock	38.5375	38.5375	38.53	38.53	42000.0
2017-10-02 06:00:00	AAPL	Stock	38.5475	38.5625	38.5	38.56	38868.0
2017-10-02 07:00:00	AAPL	Stock	38.5525	38.625	38.5525	38.6	179576.0
2017-10-02 08:00:00	AAPL	Stock	38.6125	38.62	38.5375	38.55	274232.0
2017-10-02 09:00:00	AAPL	Stock	38.5625	38.6125	38.355	38.4825	9495392.0
2017-10-02 10:00:00	AAPL	Stock	38.485	38.4875	38.3662	38.4422	10338132.0
2017-10-02 11:00:00	AAPL	Stock	38.445	38.4725	38.25	38.2575	9135568.0
2017-10-02 12:00:00	AAPL	Stock	38.2575	38.2825	38.18	38.2775	8356932.0
2017-10-02 13:00:00	AAPL	Stock	38.2775	38.435	38.245	38.4302	6455804.0
2017-10-02 14:00:00	AAPL	Stock	38.435	38.505	38.385	38.4162	7308084.0
2017-10-02 15:00:00	AAPL	Stock	38.4175	38.4875	38.38	38.4525	11778300.0
2017-10-02 16:00:00	AAPL	Stock	38.4525	38.46	38.3365	38.4325	3899980.0
2017-10-02 17:00:00	AAPL	Stock	38.4425	38.445	38.435	38.4375	11200.0
2017-10-02 18:00:00	AAPL	Stock	38.4375	38.4425	38.425	38.425	9372.0
2017-10-02 19:00:00	AAPL	Stock	38.435	38.4375	38.425	38.4375	32284.0
2017-10-02 07:00:00	MSFT	Stock	74.7	74.7	74.7	74.7	200.0
2017-10-02 08:00:00	MSFT	Stock	74.65	74.67	74.49	74.62	5419.0
2017-10-02 09:00:00	MSFT	Stock	74.62	74.96	74.55	74.88	1645559.0
2017-10-02 10:00:00	MSFT	Stock	74.89	75.01	74.7	74.89	2173543.0
2017-10-02 11:00:00	MSFT	Stock	74.885	74.99	74.42	74.435	1767396.0
2017-10-02 12:00:00	MSFT	Stock	74.435	74.6	74.295	74.595	1152810.0
2017-10-02 13:00:00	MSFT	Stock	74.59	74.66	74.51	74.625	1016008.0
2017-10-02 14:00:00	MSFT	Stock	74.625	74.81	74.58	74.75	1172137.0
2017-10-02 15:00:00	MSFT	Stock	74.74	74.74	74.55	74.6	2489212.0
2017-10-02 16:00:00	MSFT	Stock	74.61	74.61	74.55	74.6	1629126.0
2017-10-02 17:00:00	MSFT	Stock	74.61	74.61	74.61	74.61	300.0
2017-10-02 18:00:00	MSFT	Stock	74.59	74.59	74.55	74.55	377.0
2017-10-02 19:00:00	MSFT	Stock	74.55	74.59	74.55	74.59	1715.0
2017-10-02 04:00:00	NVDA	Stock	4.4748	4.496	4.4748	4.4942	52400.0
2017-10-02 05:00:00	NVDA	Stock	4.5045	4.5112	4.5045	4.5112	13680.0
2017-10-02 06:00:00	NVDA	Stock	4.5125	4.534	4.5	4.5072	325000.0
2017-10-02 07:00:00	NVDA	Stock	4.51	4.5425	4.5	4.5375	1812040.0
2017-10-02 08:00:00	NVDA	Stock	4.525	4.5475	4.5195	4.5392	3118560.0
2017-10-02 09:00:00	NVDA	Stock	4.54	4.5495	4.4818	4.5093	107269000.0
2017-10-02 10:00:00	NVDA	Stock	4.507	4.5153	4.4818	4.496	71725760.0
2017-10-02 11:00:00	NVDA	Stock	4.4962	4.4984	4.4423	4.4423	78527440.0
2017-10-02 12:00:00	NVDA	Stock	4.4427	4.4648	4.425	4.4635	52412040.0
2017-10-02 13:00:00	NVDA	Stock	4.4637	4.4688	4.4462	4.456	31690360.0
2017-10-02 14:00:00	NVDA	Stock	4.4562	4.481	4.4538	4.477	36050880.0
2017-10-02 15:00:00	NVDA	Stock	4.4773	4.4812	4.459	4.4732	48882280.0
2017-10-02 16:00:00	NVDA	Stock	4.475	4.477	4.4682	4.473	10951320.0
2017-10-02 17:00:00	NVDA	Stock	4.473	4.476	4.4693	4.476	275840.0
2017-10-02 18:00:00	NVDA	Stock	4.476	4.479	4.4752	4.4775	253040.0
2017-10-02 19:00:00	NVDA	Stock	4.4788	4.4798	4.4762	4.4785	354680.0
2017-10-02 04:00:00	AMZN	Stock	48.155	48.25	48.155	48.2005	10620.0
2017-10-02 06:00:00	AMZN	Stock	48.108	48.108	48.05	48.05	38840.0
2017-10-02 07:00:00	AMZN	Stock	48.1945	48.25	48.15	48.25	59140.0
2017-10-02 08:00:00	AMZN	Stock	48.185	48.25	48.165	48.225	91080.0
2017-10-02 09:00:00	AMZN	Stock	48.2035	48.3653	48.0345	48.2326	7102580.0

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

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