PREVIEW / stock_1hour / 2017-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-07.parquet
  size:    1.1 MB
  rows:    47,902
  symbols: 2,988

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-08-07 04:00:00	AAPL	Stock	39.275	39.275	39.2375	39.2625	14560.0
2017-08-07 05:00:00	AAPL	Stock	39.2625	39.2675	39.2125	39.2425	7360.0
2017-08-07 06:00:00	AAPL	Stock	39.205	39.24	39.2025	39.225	13780.0
2017-08-07 07:00:00	AAPL	Stock	39.215	39.225	39.1875	39.21	80020.0
2017-08-07 08:00:00	AAPL	Stock	39.2125	39.2625	39.015	39.235	210812.0
2017-08-07 09:00:00	AAPL	Stock	39.2325	39.375	39.1675	39.3575	11716452.0
2017-08-07 10:00:00	AAPL	Stock	39.3612	39.4325	39.3125	39.385	11280308.0
2017-08-07 11:00:00	AAPL	Stock	39.3875	39.5375	39.3475	39.5095	9744196.0
2017-08-07 12:00:00	AAPL	Stock	39.503	39.5475	39.4175	39.485	7213116.0
2017-08-07 13:00:00	AAPL	Stock	39.485	39.4975	39.4575	39.4873	4639324.0
2017-08-07 14:00:00	AAPL	Stock	39.485	39.6125	39.4675	39.574	7465440.0
2017-08-07 15:00:00	AAPL	Stock	39.573	39.73	39.55	39.6975	17597492.0
2017-08-07 16:00:00	AAPL	Stock	39.7025	39.7175	39.6475	39.7075	8261392.0
2017-08-07 17:00:00	AAPL	Stock	39.7075	39.7075	39.67	39.675	30920.0
2017-08-07 18:00:00	AAPL	Stock	39.6825	39.6875	39.67	39.6725	16616.0
2017-08-07 19:00:00	AAPL	Stock	39.675	39.6875	39.675	39.6875	39932.0
2017-08-07 05:00:00	MSFT	Stock	72.84	72.84	72.84	72.84	1000.0
2017-08-07 07:00:00	MSFT	Stock	72.89	72.89	72.8	72.8	299.0
2017-08-07 08:00:00	MSFT	Stock	72.7	72.89	72.7	72.89	390.0
2017-08-07 09:00:00	MSFT	Stock	72.85	73.18	72.55	72.63	2042340.0
2017-08-07 10:00:00	MSFT	Stock	72.63	72.77	72.5	72.655	2160692.0
2017-08-07 11:00:00	MSFT	Stock	72.655	72.655	72.41	72.416	2094665.0
2017-08-07 12:00:00	MSFT	Stock	72.415	72.427	72.33	72.375	1511733.0
2017-08-07 13:00:00	MSFT	Stock	72.38	72.51	72.37	72.445	1019738.0
2017-08-07 14:00:00	MSFT	Stock	72.44	72.48	72.315	72.325	1456618.0
2017-08-07 15:00:00	MSFT	Stock	72.321	72.56	72.26	72.4	4599567.0
2017-08-07 16:00:00	MSFT	Stock	72.4	72.42	72.32	72.35	2516305.0
2017-08-07 17:00:00	MSFT	Stock	72.35	72.4	72.35	72.37	3833.0
2017-08-07 18:00:00	MSFT	Stock	72.38	72.38	72.38	72.38	941.0
2017-08-07 19:00:00	MSFT	Stock	72.38	72.38	72.38	72.38	285.0
2017-08-07 04:00:00	NVDA	Stock	4.1975	4.1975	4.1972	4.1975	97880.0
2017-08-07 05:00:00	NVDA	Stock	4.203	4.203	4.203	4.203	4000.0
2017-08-07 06:00:00	NVDA	Stock	4.2088	4.2112	4.2005	4.21	52640.0
2017-08-07 07:00:00	NVDA	Stock	4.2025	4.211	4.1987	4.2028	575640.0
2017-08-07 08:00:00	NVDA	Stock	4.204	4.216	4.1987	4.2078	2813840.0
2017-08-07 09:00:00	NVDA	Stock	4.2075	4.2478	4.2	4.2213	136794760.0
2017-08-07 10:00:00	NVDA	Stock	4.2213	4.2788	4.2128	4.277	147380280.0
2017-08-07 11:00:00	NVDA	Stock	4.2769	4.3035	4.2675	4.2862	107110280.0
2017-08-07 12:00:00	NVDA	Stock	4.2862	4.305	4.2862	4.3022	54441760.0
2017-08-07 13:00:00	NVDA	Stock	4.3028	4.3029	4.2687	4.2808	62701600.0
2017-08-07 14:00:00	NVDA	Stock	4.2808	4.3002	4.2753	4.2947	46222640.0
2017-08-07 15:00:00	NVDA	Stock	4.2952	4.3093	4.2938	4.308	98944320.0
2017-08-07 16:00:00	NVDA	Stock	4.3088	4.3288	4.3062	4.327	16534760.0
2017-08-07 17:00:00	NVDA	Stock	4.327	4.3295	4.325	4.3295	1501640.0
2017-08-07 18:00:00	NVDA	Stock	4.3295	4.336	4.3272	4.3355	1360920.0
2017-08-07 19:00:00	NVDA	Stock	4.3325	4.3425	4.3305	4.3425	938680.0
2017-08-07 04:00:00	AMZN	Stock	49.655	49.655	49.655	49.655	2200.0
2017-08-07 06:00:00	AMZN	Stock	49.5625	49.5625	49.5625	49.5625	2780.0
2017-08-07 07:00:00	AMZN	Stock	49.55	49.55	49.55	49.55	8600.0
2017-08-07 08:00:00	AMZN	Stock	49.5085	49.5375	49.464	49.529	52700.0

> showing 50 of 47,902 rows — these rows as CSV

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