PREVIEW / stock_1hour / 2015-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-04.parquet
  size:    1.0 MB
  rows:    48,882
  symbols: 3,546

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
2015-02-04 04:00:00	AAPL	Stock	29.5975	29.5975	29.53	29.5625	3600.0
2015-02-04 05:00:00	AAPL	Stock	29.5875	29.6175	29.575	29.6175	5200.0
2015-02-04 06:00:00	AAPL	Stock	29.5775	29.6575	29.5775	29.645	11036.0
2015-02-04 07:00:00	AAPL	Stock	29.645	29.65	29.5625	29.59	105384.0
2015-02-04 08:00:00	AAPL	Stock	29.6	29.61	29.525	29.575	462688.0
2015-02-04 09:00:00	AAPL	Stock	29.575	29.9225	29.4925	29.89	35718068.0
2015-02-04 10:00:00	AAPL	Stock	29.895	29.9675	29.7925	29.9348	44990848.0
2015-02-04 11:00:00	AAPL	Stock	29.9325	30.0875	29.8925	29.995	53547948.0
2015-02-04 12:00:00	AAPL	Stock	29.99	30.04	29.8525	29.9525	29257080.0
2015-02-04 13:00:00	AAPL	Stock	29.955	30.075	29.9325	30.0425	19007372.0
2015-02-04 14:00:00	AAPL	Stock	30.0425	30.0825	29.945	30.0225	19928616.0
2015-02-04 15:00:00	AAPL	Stock	30.025	30.1275	29.8175	29.8875	50583396.0
2015-02-04 16:00:00	AAPL	Stock	29.8875	29.986	29.624	29.84	9240312.0
2015-02-04 17:00:00	AAPL	Stock	29.84	29.89	29.7575	29.8225	209540.0
2015-02-04 18:00:00	AAPL	Stock	29.8225	29.89	29.815	29.835	227720.0
2015-02-04 19:00:00	AAPL	Stock	29.83	29.8725	29.8275	29.83	320076.0
2015-02-04 04:00:00	MSFT	Stock	41.6	41.7	41.6	41.7	400.0
2015-02-04 06:00:00	MSFT	Stock	41.6	41.6	41.57	41.57	800.0
2015-02-04 07:00:00	MSFT	Stock	41.57	41.57	41.47	41.5	4197.0
2015-02-04 08:00:00	MSFT	Stock	41.57	41.57	41.46	41.55	14785.0
2015-02-04 09:00:00	MSFT	Stock	41.5	41.98	41.43	41.63	5181244.0
2015-02-04 10:00:00	MSFT	Stock	41.63	41.74	41.36	41.555	6282519.0
2015-02-04 11:00:00	MSFT	Stock	41.55	41.67	41.52	41.64	2743613.0
2015-02-04 12:00:00	MSFT	Stock	41.64	41.7	41.58	41.62	2635776.0
2015-02-04 13:00:00	MSFT	Stock	41.63	41.85	41.61	41.8	2860356.0
2015-02-04 14:00:00	MSFT	Stock	41.805	42.08	41.8	42.04	4804320.0
2015-02-04 15:00:00	MSFT	Stock	42.045	42.21	41.72	41.83	10564163.0
2015-02-04 16:00:00	MSFT	Stock	41.84	41.935	41.511	41.7	2799656.0
2015-02-04 17:00:00	MSFT	Stock	41.7	41.84	41.65	41.65	30217.0
2015-02-04 18:00:00	MSFT	Stock	41.65	41.75	41.65	41.66	13600.0
2015-02-04 19:00:00	MSFT	Stock	41.68	41.68	41.66	41.66	1825.0
2015-02-04 09:00:00	NVDA	Stock	0.5022	0.5075	0.5008	0.5022	30898920.0
2015-02-04 10:00:00	NVDA	Stock	0.5022	0.5032	0.4996	0.5018	14960760.0
2015-02-04 11:00:00	NVDA	Stock	0.5015	0.506	0.5013	0.5058	22703720.0
2015-02-04 12:00:00	NVDA	Stock	0.5056	0.5068	0.5028	0.5044	12798680.0
2015-02-04 13:00:00	NVDA	Stock	0.5045	0.5061	0.5043	0.5053	9945480.0
2015-02-04 14:00:00	NVDA	Stock	0.5053	0.5072	0.5045	0.5068	10626400.0
2015-02-04 15:00:00	NVDA	Stock	0.5068	0.5096	0.5035	0.5043	59903360.0
2015-02-04 16:00:00	NVDA	Stock	0.5043	0.5053	0.5012	0.5046	9293560.0
2015-02-04 19:00:00	NVDA	Stock	0.5025	0.5025	0.5025	0.5025	20000.0
2015-02-04 07:00:00	AMZN	Stock	18.1	18.1	18.1	18.1	11080.0
2015-02-04 08:00:00	AMZN	Stock	18.16	18.16	18.0735	18.0875	178940.0
2015-02-04 09:00:00	AMZN	Stock	18.07	18.284	17.9115	18.2595	13208900.0
2015-02-04 10:00:00	AMZN	Stock	18.255	18.3435	18.1605	18.2995	12061500.0
2015-02-04 11:00:00	AMZN	Stock	18.292	18.3608	18.2659	18.3031	10568460.0
2015-02-04 12:00:00	AMZN	Stock	18.3025	18.329	18.2755	18.309	5735700.0
2015-02-04 13:00:00	AMZN	Stock	18.3115	18.365	18.283	18.3085	7421320.0
2015-02-04 14:00:00	AMZN	Stock	18.3075	18.357	18.2681	18.325	8677700.0
2015-02-04 15:00:00	AMZN	Stock	18.325	18.375	18.198	18.2342	16756900.0
2015-02-04 16:00:00	AMZN	Stock	18.2375	18.3011	18.0835	18.2967	1021860.0

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

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