PREVIEW / stock_1hour / 2017-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-08.parquet
  size:    1.0 MB
  rows:    47,993
  symbols: 2,999

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-08 06:00:00	AAPL	Stock	39.6875	39.695	39.63	39.65	7728.0
2017-08-08 07:00:00	AAPL	Stock	39.675	39.675	39.5875	39.625	44152.0
2017-08-08 08:00:00	AAPL	Stock	39.65	39.6825	39.6125	39.6425	158696.0
2017-08-08 09:00:00	AAPL	Stock	39.65	39.8888	39.5675	39.8575	14041964.0
2017-08-08 10:00:00	AAPL	Stock	39.86	40.295	39.8475	40.2912	31414292.0
2017-08-08 11:00:00	AAPL	Stock	40.2875	40.4575	40.26	40.3612	21847484.0
2017-08-08 12:00:00	AAPL	Stock	40.36	40.4378	40.2375	40.3	13788736.0
2017-08-08 13:00:00	AAPL	Stock	40.2983	40.33	40.155	40.294	11819428.0
2017-08-08 14:00:00	AAPL	Stock	40.295	40.325	40.2472	40.305	7155944.0
2017-08-08 15:00:00	AAPL	Stock	40.305	40.3095	39.8775	40.025	25659848.0
2017-08-08 16:00:00	AAPL	Stock	40.02	40.1355	39.8825	40.0	5157768.0
2017-08-08 17:00:00	AAPL	Stock	39.9775	40.0	39.94	39.98	81844.0
2017-08-08 18:00:00	AAPL	Stock	39.975	39.98	39.9175	39.9175	133336.0
2017-08-08 19:00:00	AAPL	Stock	39.925	39.9425	39.845	39.885	105272.0
2017-08-08 07:00:00	MSFT	Stock	72.4	72.4	72.4	72.4	100.0
2017-08-08 08:00:00	MSFT	Stock	72.3	72.3	72.22	72.25	24385.0
2017-08-08 09:00:00	MSFT	Stock	72.25	72.41	71.75	72.335	3046683.0
2017-08-08 10:00:00	MSFT	Stock	72.34	72.55	72.23	72.54	1963729.0
2017-08-08 11:00:00	MSFT	Stock	72.531	72.985	72.44	72.943	1932161.0
2017-08-08 12:00:00	MSFT	Stock	72.945	73.13	72.9	72.94	1952566.0
2017-08-08 13:00:00	MSFT	Stock	72.94	73.09	72.9	73.02	1616357.0
2017-08-08 14:00:00	MSFT	Stock	73.02	73.06	72.895	72.955	1516305.0
2017-08-08 15:00:00	MSFT	Stock	72.955	73.01	72.53	72.78	4935651.0
2017-08-08 16:00:00	MSFT	Stock	72.79	72.85	72.61	72.61	3252087.0
2017-08-08 17:00:00	MSFT	Stock	72.65	72.75	72.65	72.66	3456.0
2017-08-08 18:00:00	MSFT	Stock	72.65	72.65	72.62	72.62	454.0
2017-08-08 19:00:00	MSFT	Stock	72.63	72.63	72.61	72.61	3570.0
2017-08-08 04:00:00	NVDA	Stock	4.3425	4.3475	4.3348	4.3348	96400.0
2017-08-08 05:00:00	NVDA	Stock	4.3375	4.3432	4.3365	4.3432	66680.0
2017-08-08 06:00:00	NVDA	Stock	4.3432	4.3495	4.3355	4.345	458520.0
2017-08-08 07:00:00	NVDA	Stock	4.3425	4.3545	4.3375	4.3498	2056880.0
2017-08-08 08:00:00	NVDA	Stock	4.34	4.3865	4.34	4.372	6982680.0
2017-08-08 09:00:00	NVDA	Stock	4.371	4.3775	4.2925	4.3139	161681880.0
2017-08-08 10:00:00	NVDA	Stock	4.3142	4.315	4.2563	4.2913	153249800.0
2017-08-08 11:00:00	NVDA	Stock	4.293	4.3158	4.28	4.2848	87898080.0
2017-08-08 12:00:00	NVDA	Stock	4.2848	4.2925	4.2688	4.275	56272800.0
2017-08-08 13:00:00	NVDA	Stock	4.2745	4.2913	4.265	4.2749	47355320.0
2017-08-08 14:00:00	NVDA	Stock	4.2748	4.29	4.2682	4.2865	39428560.0
2017-08-08 15:00:00	NVDA	Stock	4.2862	4.2875	4.2178	4.257	155418440.0
2017-08-08 16:00:00	NVDA	Stock	4.2575	4.2722	4.25	4.254	6569040.0
2017-08-08 17:00:00	NVDA	Stock	4.254	4.2612	4.2533	4.258	831040.0
2017-08-08 18:00:00	NVDA	Stock	4.2563	4.2563	4.2498	4.2552	976480.0
2017-08-08 19:00:00	NVDA	Stock	4.2555	4.2555	4.2255	4.23	1221720.0
2017-08-08 04:00:00	AMZN	Stock	49.6565	49.658	49.6565	49.657	6000.0
2017-08-08 06:00:00	AMZN	Stock	49.75	49.75	49.75	49.75	3000.0
2017-08-08 07:00:00	AMZN	Stock	49.744	49.744	49.6945	49.6995	16060.0
2017-08-08 08:00:00	AMZN	Stock	49.7	49.75	49.6005	49.694	141400.0
2017-08-08 09:00:00	AMZN	Stock	49.7	49.75	49.4365	49.535	5993880.0
2017-08-08 10:00:00	AMZN	Stock	49.555	49.575	49.4105	49.5041	6016480.0
2017-08-08 11:00:00	AMZN	Stock	49.507	49.7885	49.468	49.7786	6922360.0

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

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