PREVIEW / stock_1hour / 2015-03-11

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-11.parquet
  size:    1.0 MB
  rows:    48,926
  symbols: 3,500

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-03-11 04:00:00	AAPL	Stock	30.875	31.255	30.875	31.2	30280.0
2015-03-11 05:00:00	AAPL	Stock	31.225	31.25	31.2025	31.225	34684.0
2015-03-11 06:00:00	AAPL	Stock	31.245	31.28	31.2025	31.2525	70372.0
2015-03-11 07:00:00	AAPL	Stock	31.25	31.275	31.175	31.21	119628.0
2015-03-11 08:00:00	AAPL	Stock	31.2175	31.3	31.195	31.285	604976.0
2015-03-11 09:00:00	AAPL	Stock	31.285	31.2975	30.605	30.745	55812540.0
2015-03-11 10:00:00	AAPL	Stock	30.7475	30.84	30.5275	30.6525	57614612.0
2015-03-11 11:00:00	AAPL	Stock	30.65	30.9275	30.6375	30.9275	33585604.0
2015-03-11 12:00:00	AAPL	Stock	30.9275	30.9775	30.805	30.9	20835912.0
2015-03-11 13:00:00	AAPL	Stock	30.9	30.965	30.72	30.7875	21169260.0
2015-03-11 14:00:00	AAPL	Stock	30.79	30.89	30.73	30.8138	17522864.0
2015-03-11 15:00:00	AAPL	Stock	30.8125	30.8275	30.5575	30.5625	38738172.0
2015-03-11 16:00:00	AAPL	Stock	30.56	30.7742	30.5575	30.625	11198344.0
2015-03-11 17:00:00	AAPL	Stock	30.625	30.7922	30.56	30.5975	225536.0
2015-03-11 18:00:00	AAPL	Stock	30.5975	30.61	30.56	30.5825	260828.0
2015-03-11 19:00:00	AAPL	Stock	30.5825	30.5825	30.5625	30.5775	101988.0
2015-03-11 04:00:00	MSFT	Stock	42.1	42.1	42.1	42.1	200.0
2015-03-11 05:00:00	MSFT	Stock	42.16	42.16	42.13	42.13	800.0
2015-03-11 06:00:00	MSFT	Stock	42.18	42.24	42.18	42.24	850.0
2015-03-11 07:00:00	MSFT	Stock	42.25	42.28	42.18	42.18	5800.0
2015-03-11 08:00:00	MSFT	Stock	42.28	42.28	42.18	42.19	5000.0
2015-03-11 09:00:00	MSFT	Stock	42.18	42.37	42.09	42.22	3377020.0
2015-03-11 10:00:00	MSFT	Stock	42.22	42.34	41.955	42.002	4832859.0
2015-03-11 11:00:00	MSFT	Stock	42.005	42.12	41.93	42.065	3075964.0
2015-03-11 12:00:00	MSFT	Stock	42.07	42.15	42.0	42.05	2218655.0
2015-03-11 13:00:00	MSFT	Stock	42.05	42.05	41.84	41.882	2951680.0
2015-03-11 14:00:00	MSFT	Stock	41.88	42.07	41.863	42.065	2303824.0
2015-03-11 15:00:00	MSFT	Stock	42.06	42.09	41.84	41.98	6226103.0
2015-03-11 16:00:00	MSFT	Stock	41.98	42.058	41.97	42.03	6034808.0
2015-03-11 17:00:00	MSFT	Stock	42.052	42.052	41.98	41.98	3837.0
2015-03-11 19:00:00	MSFT	Stock	42.0	42.03	42.0	42.03	300.0
2015-03-11 09:00:00	NVDA	Stock	0.58	0.5825	0.5734	0.5822	39298120.0
2015-03-11 10:00:00	NVDA	Stock	0.582	0.5822	0.5758	0.576	54852200.0
2015-03-11 11:00:00	NVDA	Stock	0.5761	0.5765	0.5718	0.5748	35519320.0
2015-03-11 12:00:00	NVDA	Stock	0.5748	0.5751	0.5716	0.5718	26178760.0
2015-03-11 13:00:00	NVDA	Stock	0.5718	0.5725	0.5704	0.5724	20178840.0
2015-03-11 14:00:00	NVDA	Stock	0.5722	0.575	0.5718	0.5738	19945880.0
2015-03-11 15:00:00	NVDA	Stock	0.5735	0.574	0.5715	0.5719	45690320.0
2015-03-11 16:00:00	NVDA	Stock	0.572	0.5798	0.5718	0.5752	7114880.0
2015-03-11 17:00:00	NVDA	Stock	0.5746	0.5746	0.5746	0.5746	276520.0
2015-03-11 06:00:00	AMZN	Stock	18.5565	18.5565	18.5565	18.5565	3000.0
2015-03-11 07:00:00	AMZN	Stock	18.5475	18.585	18.5385	18.5385	28200.0
2015-03-11 08:00:00	AMZN	Stock	18.56	18.575	18.56	18.562	21880.0
2015-03-11 09:00:00	AMZN	Stock	18.562	18.6675	18.514	18.5975	5866600.0
2015-03-11 10:00:00	AMZN	Stock	18.5888	18.65	18.413	18.487	7881100.0
2015-03-11 11:00:00	AMZN	Stock	18.4925	18.5825	18.462	18.5687	5390800.0
2015-03-11 12:00:00	AMZN	Stock	18.562	18.58	18.5075	18.534	2836920.0
2015-03-11 13:00:00	AMZN	Stock	18.5375	18.539	18.411	18.4505	3403220.0
2015-03-11 14:00:00	AMZN	Stock	18.4505	18.5185	18.426	18.451	3702440.0
2015-03-11 15:00:00	AMZN	Stock	18.452	18.4605	18.313	18.319	10945720.0

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

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