PREVIEW / stock_1hour / 2017-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-07.parquet
  size:    1.0 MB
  rows:    48,111
  symbols: 3,074

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-03-07 05:00:00	AAPL	Stock	34.7625	34.7625	34.7625	34.7625	2156.0
2017-03-07 06:00:00	AAPL	Stock	34.765	34.765	34.765	34.765	432.0
2017-03-07 07:00:00	AAPL	Stock	34.775	34.78	34.765	34.78	56192.0
2017-03-07 08:00:00	AAPL	Stock	34.8	34.8	34.7525	34.78	100308.0
2017-03-07 09:00:00	AAPL	Stock	34.78	34.8775	34.6975	34.7725	10128828.0
2017-03-07 10:00:00	AAPL	Stock	34.771	34.995	34.76	34.935	12653960.0
2017-03-07 11:00:00	AAPL	Stock	34.935	34.9575	34.8775	34.9225	7457064.0
2017-03-07 12:00:00	AAPL	Stock	34.9212	34.9275	34.845	34.895	5294552.0
2017-03-07 13:00:00	AAPL	Stock	34.895	34.94	34.8662	34.8775	4574908.0
2017-03-07 14:00:00	AAPL	Stock	34.8787	34.925	34.8475	34.9212	5141928.0
2017-03-07 15:00:00	AAPL	Stock	34.9215	34.9225	34.7875	34.8725	10704696.0
2017-03-07 16:00:00	AAPL	Stock	34.88	34.88	34.83	34.88	5632816.0
2017-03-07 17:00:00	AAPL	Stock	34.88	34.88	34.855	34.875	466656.0
2017-03-07 18:00:00	AAPL	Stock	34.8575	34.8675	34.8575	34.8675	1200.0
2017-03-07 19:00:00	AAPL	Stock	34.855	34.8575	34.8325	34.84	17072.0
2017-03-07 05:00:00	MSFT	Stock	64.36	64.36	64.36	64.36	1697.0
2017-03-07 07:00:00	MSFT	Stock	64.31	64.31	64.31	64.31	180.0
2017-03-07 08:00:00	MSFT	Stock	64.3	64.35	64.3	64.3	2683.0
2017-03-07 09:00:00	MSFT	Stock	64.26	64.46	64.17	64.355	1383682.0
2017-03-07 10:00:00	MSFT	Stock	64.355	64.775	64.29	64.76	2088261.0
2017-03-07 11:00:00	MSFT	Stock	64.75	64.77	64.345	64.38	2667446.0
2017-03-07 12:00:00	MSFT	Stock	64.37	64.44	64.25	64.36	1476968.0
2017-03-07 13:00:00	MSFT	Stock	64.37	64.466	64.35	64.365	1232283.0
2017-03-07 14:00:00	MSFT	Stock	64.36	64.42	64.28	64.4	1629639.0
2017-03-07 15:00:00	MSFT	Stock	64.39	64.46	64.195	64.4	3828407.0
2017-03-07 16:00:00	MSFT	Stock	64.4	64.4	64.263	64.38	2658936.0
2017-03-07 17:00:00	MSFT	Stock	64.3	64.4	64.28	64.3	94266.0
2017-03-07 18:00:00	MSFT	Stock	64.3	64.3	64.3	64.3	900.0
2017-03-07 19:00:00	MSFT	Stock	64.31	64.31	64.31	64.31	100.0
2017-03-07 04:00:00	NVDA	Stock	2.442	2.442	2.44	2.44	20000.0
2017-03-07 05:00:00	NVDA	Stock	2.4452	2.4462	2.44	2.44	68480.0
2017-03-07 06:00:00	NVDA	Stock	2.4288	2.4288	2.4288	2.4288	6440.0
2017-03-07 07:00:00	NVDA	Stock	2.4328	2.4425	2.4328	2.4425	117600.0
2017-03-07 08:00:00	NVDA	Stock	2.442	2.4425	2.4325	2.44	396480.0
2017-03-07 09:00:00	NVDA	Stock	2.4375	2.463	2.4288	2.4438	102270640.0
2017-03-07 10:00:00	NVDA	Stock	2.4433	2.4883	2.4365	2.4732	145883200.0
2017-03-07 11:00:00	NVDA	Stock	2.473	2.473	2.454	2.4622	74570280.0
2017-03-07 12:00:00	NVDA	Stock	2.4625	2.4683	2.4545	2.456	38852480.0
2017-03-07 13:00:00	NVDA	Stock	2.4565	2.4658	2.4563	2.462	30956480.0
2017-03-07 14:00:00	NVDA	Stock	2.462	2.4823	2.457	2.4819	60948600.0
2017-03-07 15:00:00	NVDA	Stock	2.482	2.4845	2.4586	2.4683	112281200.0
2017-03-07 16:00:00	NVDA	Stock	2.4685	2.4723	2.4633	2.4633	17536320.0
2017-03-07 17:00:00	NVDA	Stock	2.4685	2.4725	2.4663	2.4723	4592680.0
2017-03-07 18:00:00	NVDA	Stock	2.468	2.4725	2.468	2.4725	144000.0
2017-03-07 19:00:00	NVDA	Stock	2.472	2.4725	2.4698	2.4725	84760.0
2017-03-07 05:00:00	AMZN	Stock	42.3005	42.3005	42.3005	42.3005	3420.0
2017-03-07 08:00:00	AMZN	Stock	42.24	42.24	42.24	42.24	10980.0
2017-03-07 09:00:00	AMZN	Stock	42.205	42.3955	42.1805	42.25	5763280.0
2017-03-07 10:00:00	AMZN	Stock	42.2485	42.423	42.216	42.3695	8562960.0
2017-03-07 11:00:00	AMZN	Stock	42.3755	42.394	42.24	42.286	3917100.0

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

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