PREVIEW / stock_1hour / 2015-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-21.parquet
  size:    1.0 MB
  rows:    48,931
  symbols: 3,470

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-07-21 04:00:00	AAPL	Stock	33.1875	33.25	33.1825	33.2475	25600.0
2015-07-21 05:00:00	AAPL	Stock	33.24	33.24	33.1975	33.2175	38732.0
2015-07-21 06:00:00	AAPL	Stock	33.2075	33.25	33.205	33.215	187660.0
2015-07-21 07:00:00	AAPL	Stock	33.21	33.32	33.21	33.2625	673304.0
2015-07-21 08:00:00	AAPL	Stock	33.26	33.3175	33.175	33.2	1657324.0
2015-07-21 09:00:00	AAPL	Stock	33.2025	33.2442	32.7025	32.9275	41272252.0
2015-07-21 10:00:00	AAPL	Stock	32.925	32.95	32.6075	32.6425	36612872.0
2015-07-21 11:00:00	AAPL	Stock	32.645	32.8	32.58	32.7725	25065340.0
2015-07-21 12:00:00	AAPL	Stock	32.7745	32.91	32.7712	32.8175	17235220.0
2015-07-21 13:00:00	AAPL	Stock	32.815	32.86	32.72	32.8125	14020048.0
2015-07-21 14:00:00	AAPL	Stock	32.8112	32.815	32.665	32.765	22940212.0
2015-07-21 15:00:00	AAPL	Stock	32.765	32.8025	32.635	32.6675	41419636.0
2015-07-21 16:00:00	AAPL	Stock	32.6875	33.0875	29.8	30.4125	56140248.0
2015-07-21 17:00:00	AAPL	Stock	30.4125	30.6675	30.125	30.5	16462432.0
2015-07-21 18:00:00	AAPL	Stock	30.505	30.6675	30.4125	30.505	4283196.0
2015-07-21 19:00:00	AAPL	Stock	30.51	30.52	30.4125	30.45	1942756.0
2015-07-21 04:00:00	MSFT	Stock	46.92	46.92	46.92	46.92	176.0
2015-07-21 05:00:00	MSFT	Stock	46.92	46.92	46.92	46.92	200.0
2015-07-21 06:00:00	MSFT	Stock	46.92	46.99	46.92	46.99	540.0
2015-07-21 07:00:00	MSFT	Stock	46.93	47.0	46.89	46.89	4000.0
2015-07-21 08:00:00	MSFT	Stock	46.89	46.98	46.85	46.85	44862.0
2015-07-21 09:00:00	MSFT	Stock	46.85	46.92	46.48	46.915	4155858.0
2015-07-21 10:00:00	MSFT	Stock	46.915	47.0	46.73	46.915	5077212.0
2015-07-21 11:00:00	MSFT	Stock	46.91	47.08	46.76	46.98	4775996.0
2015-07-21 12:00:00	MSFT	Stock	46.977	46.989	46.72	46.8	3818603.0
2015-07-21 13:00:00	MSFT	Stock	46.8	46.8	46.57	46.64	3342407.0
2015-07-21 14:00:00	MSFT	Stock	46.64	46.8	46.54	46.72	4111868.0
2015-07-21 15:00:00	MSFT	Stock	46.72	47.33	46.71	47.27	11754855.0
2015-07-21 16:00:00	MSFT	Stock	47.28	47.37	45.28	45.52	2959496.0
2015-07-21 17:00:00	MSFT	Stock	45.537	46.19	45.37	45.89	228750.0
2015-07-21 18:00:00	MSFT	Stock	45.96	46.2	45.37	45.4	210135.0
2015-07-21 19:00:00	MSFT	Stock	45.37	45.4	45.36	45.4	23246.0
2015-07-21 09:00:00	NVDA	Stock	0.492	0.5	0.4915	0.4998	20970000.0
2015-07-21 10:00:00	NVDA	Stock	0.5	0.5018	0.4975	0.4985	28460640.0
2015-07-21 11:00:00	NVDA	Stock	0.4988	0.499	0.4961	0.4985	19542800.0
2015-07-21 12:00:00	NVDA	Stock	0.4985	0.4986	0.4972	0.4978	11149280.0
2015-07-21 13:00:00	NVDA	Stock	0.4978	0.498	0.4954	0.4954	8382280.0
2015-07-21 14:00:00	NVDA	Stock	0.4955	0.4963	0.4945	0.4945	18010960.0
2015-07-21 15:00:00	NVDA	Stock	0.4948	0.4955	0.4932	0.4948	31135800.0
2015-07-21 16:00:00	NVDA	Stock	0.4948	0.495	0.4938	0.4938	6634280.0
2015-07-21 17:00:00	NVDA	Stock	0.495	0.495	0.495	0.495	17120.0
2015-07-21 18:00:00	NVDA	Stock	0.4948	0.4948	0.4948	0.4948	6840.0
2015-07-21 07:00:00	AMZN	Stock	24.45	24.5	24.421	24.5	48500.0
2015-07-21 08:00:00	AMZN	Stock	24.495	24.527	24.21	24.4105	126240.0
2015-07-21 09:00:00	AMZN	Stock	24.4	24.4	24.1315	24.285	9284980.0
2015-07-21 10:00:00	AMZN	Stock	24.2952	24.312	24.141	24.166	7749240.0
2015-07-21 11:00:00	AMZN	Stock	24.166	24.225	24.1275	24.2245	5711320.0
2015-07-21 12:00:00	AMZN	Stock	24.22	24.3315	24.22	24.2945	5277220.0
2015-07-21 13:00:00	AMZN	Stock	24.3045	24.375	24.2615	24.3475	5149400.0
2015-07-21 14:00:00	AMZN	Stock	24.3475	24.3945	24.3125	24.3785	5845540.0

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

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