PREVIEW / stock_1hour / 2011-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-08.parquet
  size:    910 KB
  rows:    43,582
  symbols: 3,505

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
2011-09-08 05:00:00	AAPL	Stock	13.7679	13.7679	13.7571	13.7571	16800.0
2011-09-08 06:00:00	AAPL	Stock	13.75	13.7857	13.75	13.775	117600.0
2011-09-08 07:00:00	AAPL	Stock	13.7607	13.7857	13.7096	13.7136	708708.0
2011-09-08 08:00:00	AAPL	Stock	13.7143	13.725	13.6379	13.6461	2969036.0
2011-09-08 09:00:00	AAPL	Stock	13.6443	13.7493	13.6164	13.7275	61387004.0
2011-09-08 10:00:00	AAPL	Stock	13.7293	13.8632	13.6979	13.8614	82263552.0
2011-09-08 11:00:00	AAPL	Stock	13.8635	13.8789	13.7536	13.7661	52487484.0
2011-09-08 12:00:00	AAPL	Stock	13.7664	13.8111	13.745	13.8018	37406964.0
2011-09-08 13:00:00	AAPL	Stock	13.8036	13.8179	13.7071	13.75	44843176.0
2011-09-08 14:00:00	AAPL	Stock	13.75	13.7961	13.7261	13.761	44538676.0
2011-09-08 15:00:00	AAPL	Stock	13.7593	13.7754	13.6889	13.7211	76908356.0
2011-09-08 16:00:00	AAPL	Stock	13.7199	13.805	13.6599	13.6599	10657808.0
2011-09-08 17:00:00	AAPL	Stock	13.7229	13.7229	13.7107	13.7168	130760.0
2011-09-08 18:00:00	AAPL	Stock	13.7157	13.7386	13.7157	13.7296	237244.0
2011-09-08 19:00:00	AAPL	Stock	13.7293	13.7418	13.7	13.7143	507332.0
2011-09-08 06:00:00	MSFT	Stock	26.06	26.07	26.06	26.07	900.0
2011-09-08 07:00:00	MSFT	Stock	26.09	26.09	25.98	25.98	3034.0
2011-09-08 08:00:00	MSFT	Stock	26.0	26.0	25.81	25.85	22599.0
2011-09-08 09:00:00	MSFT	Stock	25.84	26.46	25.84	26.45	7638202.0
2011-09-08 10:00:00	MSFT	Stock	26.46	26.63	26.35	26.615	10909125.0
2011-09-08 11:00:00	MSFT	Stock	26.62	26.66	26.49	26.505	7994265.0
2011-09-08 12:00:00	MSFT	Stock	26.5	26.5	26.32	26.32	9256088.0
2011-09-08 13:00:00	MSFT	Stock	26.32	26.33	26.18	26.3	9573545.0
2011-09-08 14:00:00	MSFT	Stock	26.305	26.37	26.25	26.335	6642189.0
2011-09-08 15:00:00	MSFT	Stock	26.33	26.39	26.2	26.21	10638771.0
2011-09-08 16:00:00	MSFT	Stock	26.22	26.402	26.005	26.005	2130619.0
2011-09-08 17:00:00	MSFT	Stock	26.25	26.26	26.23	26.26	1500.0
2011-09-08 18:00:00	MSFT	Stock	26.22	26.25	26.22	26.24	25470.0
2011-09-08 19:00:00	MSFT	Stock	26.29	26.3	26.19	26.19	5400.0
2011-09-08 07:00:00	NVDA	Stock	0.3535	0.3535	0.3535	0.3535	4000.0
2011-09-08 08:00:00	NVDA	Stock	0.3562	0.3562	0.3488	0.3513	584640.0
2011-09-08 09:00:00	NVDA	Stock	0.3513	0.3572	0.3498	0.357	91584000.0
2011-09-08 10:00:00	NVDA	Stock	0.3572	0.3612	0.3533	0.3595	158810720.0
2011-09-08 11:00:00	NVDA	Stock	0.3598	0.3602	0.3538	0.355	84463440.0
2011-09-08 12:00:00	NVDA	Stock	0.3548	0.3562	0.3522	0.353	95946720.0
2011-09-08 13:00:00	NVDA	Stock	0.353	0.354	0.3488	0.3508	121201800.0
2011-09-08 14:00:00	NVDA	Stock	0.3508	0.357	0.35	0.353	113463760.0
2011-09-08 15:00:00	NVDA	Stock	0.353	0.3555	0.351	0.3548	183331760.0
2011-09-08 16:00:00	NVDA	Stock	0.3545	0.3562	0.353	0.3545	28385200.0
2011-09-08 17:00:00	NVDA	Stock	0.3545	0.3555	0.3545	0.3555	124000.0
2011-09-08 18:00:00	NVDA	Stock	0.3553	0.3553	0.3545	0.3545	36000.0
2011-09-08 19:00:00	NVDA	Stock	0.3553	0.3555	0.3538	0.3538	163000.0
2011-09-08 05:00:00	AMZN	Stock	11.0075	11.0075	11.0075	11.0075	2000.0
2011-09-08 07:00:00	AMZN	Stock	10.995	10.995	10.966	10.966	10000.0
2011-09-08 08:00:00	AMZN	Stock	10.975	10.995	10.861	10.9	232840.0
2011-09-08 09:00:00	AMZN	Stock	10.9	10.9535	10.817	10.8759	17978400.0
2011-09-08 10:00:00	AMZN	Stock	10.876	11.032	10.838	11.015	17734000.0
2011-09-08 11:00:00	AMZN	Stock	11.013	11.025	10.893	10.914	7361720.0
2011-09-08 12:00:00	AMZN	Stock	10.9155	10.9441	10.8755	10.9398	6332160.0
2011-09-08 13:00:00	AMZN	Stock	10.944	10.9795	10.8545	10.8705	9315500.0

> showing 50 of 43,582 rows — these rows as CSV

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