PREVIEW / stock_1hour / 2016-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-07.parquet
  size:    1.1 MB
  rows:    50,794
  symbols: 3,420

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-01-07 04:00:00	AAPL	Stock	23.9975	25.1475	23.9975	24.375	368804.0
2016-01-07 05:00:00	AAPL	Stock	24.39	24.49	24.3	24.3675	214392.0
2016-01-07 06:00:00	AAPL	Stock	24.375	24.5125	24.325	24.335	268320.0
2016-01-07 07:00:00	AAPL	Stock	24.35	24.5	24.325	24.4675	743400.0
2016-01-07 08:00:00	AAPL	Stock	24.485	24.7175	24.325	24.705	1945320.0
2016-01-07 09:00:00	AAPL	Stock	24.7	24.9075	24.44	24.7475	49136248.0
2016-01-07 10:00:00	AAPL	Stock	24.7475	25.0	24.6075	24.9475	42393284.0
2016-01-07 11:00:00	AAPL	Stock	24.949	25.0325	24.7025	24.7512	25625576.0
2016-01-07 12:00:00	AAPL	Stock	24.7525	24.7825	24.5175	24.546	22599120.0
2016-01-07 13:00:00	AAPL	Stock	24.5425	24.5575	24.4175	24.4455	38952312.0
2016-01-07 14:00:00	AAPL	Stock	24.4475	24.4675	24.17	24.2925	38899264.0
2016-01-07 15:00:00	AAPL	Stock	24.2875	24.3675	24.1075	24.135	55793676.0
2016-01-07 16:00:00	AAPL	Stock	24.1125	24.2325	23.9025	24.0	18415464.0
2016-01-07 17:00:00	AAPL	Stock	23.975	24.1125	23.95	23.975	741216.0
2016-01-07 18:00:00	AAPL	Stock	23.9675	23.995	23.925	23.93	539832.0
2016-01-07 19:00:00	AAPL	Stock	23.93	23.9375	23.85	23.9025	363244.0
2016-01-07 04:00:00	MSFT	Stock	53.61	53.61	52.47	52.65	4748.0
2016-01-07 05:00:00	MSFT	Stock	52.63	52.63	52.63	52.63	500.0
2016-01-07 06:00:00	MSFT	Stock	52.51	52.73	52.43	52.43	17676.0
2016-01-07 07:00:00	MSFT	Stock	52.46	52.74	52.43	52.65	30805.0
2016-01-07 08:00:00	MSFT	Stock	52.65	52.73	52.25	52.7	115014.0
2016-01-07 09:00:00	MSFT	Stock	52.65	52.96	52.07	52.73	8093548.0
2016-01-07 10:00:00	MSFT	Stock	52.72	53.485	52.54	53.305	8607290.0
2016-01-07 11:00:00	MSFT	Stock	53.305	53.33	52.79	52.85	4781189.0
2016-01-07 12:00:00	MSFT	Stock	52.856	52.91	52.74	52.78	3047436.0
2016-01-07 13:00:00	MSFT	Stock	52.777	52.83	52.325	52.44	5247170.0
2016-01-07 14:00:00	MSFT	Stock	52.44	52.68	52.24	52.44	5752162.0
2016-01-07 15:00:00	MSFT	Stock	52.43	52.767	52.17	52.19	11516317.0
2016-01-07 16:00:00	MSFT	Stock	52.17	52.641	52.17	52.2	5458481.0
2016-01-07 17:00:00	MSFT	Stock	52.19	52.29	52.18	52.18	645682.0
2016-01-07 18:00:00	MSFT	Stock	52.17	52.25	52.1	52.15	4952.0
2016-01-07 19:00:00	MSFT	Stock	52.24	52.25	52.1	52.12	4062.0
2016-01-07 04:00:00	NVDA	Stock	0.775	0.775	0.772	0.772	88000.0
2016-01-07 06:00:00	NVDA	Stock	0.7655	0.7655	0.7655	0.7655	36000.0
2016-01-07 07:00:00	NVDA	Stock	0.7702	0.7725	0.7528	0.7625	98600.0
2016-01-07 08:00:00	NVDA	Stock	0.769	0.7763	0.7603	0.7688	454160.0
2016-01-07 09:00:00	NVDA	Stock	0.7678	0.7713	0.7525	0.762	73207960.0
2016-01-07 10:00:00	NVDA	Stock	0.7618	0.7708	0.747	0.7708	120181720.0
2016-01-07 11:00:00	NVDA	Stock	0.7706	0.7738	0.7644	0.7665	71749760.0
2016-01-07 12:00:00	NVDA	Stock	0.7665	0.769	0.7596	0.76	62268840.0
2016-01-07 13:00:00	NVDA	Stock	0.7601	0.7603	0.7494	0.7525	57181960.0
2016-01-07 14:00:00	NVDA	Stock	0.7524	0.7585	0.7513	0.7551	51348440.0
2016-01-07 15:00:00	NVDA	Stock	0.7551	0.7608	0.7524	0.7568	124177200.0
2016-01-07 16:00:00	NVDA	Stock	0.757	0.7583	0.7525	0.7525	11037920.0
2016-01-07 18:00:00	NVDA	Stock	0.7515	0.755	0.7515	0.755	48520.0
2016-01-07 19:00:00	NVDA	Stock	0.7563	0.7563	0.7515	0.7515	63200.0
2016-01-07 04:00:00	AMZN	Stock	31.0275	31.0275	30.55	30.75	70220.0
2016-01-07 05:00:00	AMZN	Stock	30.7775	30.842	30.71	30.7705	186380.0
2016-01-07 06:00:00	AMZN	Stock	30.8	30.9	30.75	30.804	97200.0
2016-01-07 07:00:00	AMZN	Stock	30.8095	31.059	30.8025	31.0	369380.0

> showing 50 of 50,794 rows — these rows as CSV

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