PREVIEW / stock_1hour / 2013-05-21

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-21.parquet
  size:    997 KB
  rows:    46,244
  symbols: 3,508

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
2013-05-21 04:00:00	AAPL	Stock	15.7157	15.7157	15.6786	15.7154	16800.0
2013-05-21 05:00:00	AAPL	Stock	15.6786	15.6786	15.6786	15.6786	8400.0
2013-05-21 06:00:00	AAPL	Stock	15.6718	15.6764	15.6604	15.6604	62636.0
2013-05-21 07:00:00	AAPL	Stock	15.6607	15.7107	15.6607	15.6793	139384.0
2013-05-21 08:00:00	AAPL	Stock	15.6857	15.8121	15.6514	15.7075	1690332.0
2013-05-21 09:00:00	AAPL	Stock	15.7139	15.7407	15.5071	15.6275	84720188.0
2013-05-21 10:00:00	AAPL	Stock	15.63	15.6789	15.5089	15.6457	74257932.0
2013-05-21 11:00:00	AAPL	Stock	15.6504	15.7757	15.6336	15.7243	67136300.0
2013-05-21 12:00:00	AAPL	Stock	15.7246	15.9086	15.6971	15.9014	64897056.0
2013-05-21 13:00:00	AAPL	Stock	15.9011	15.91	15.7589	15.8186	52579856.0
2013-05-21 14:00:00	AAPL	Stock	15.8143	15.8343	15.6607	15.6946	40688172.0
2013-05-21 15:00:00	AAPL	Stock	15.6964	15.7861	15.6918	15.7021	49123620.0
2013-05-21 16:00:00	AAPL	Stock	15.7021	15.8121	15.6077	15.7021	13411020.0
2013-05-21 17:00:00	AAPL	Stock	15.6907	15.6921	15.6818	15.6818	32536.0
2013-05-21 18:00:00	AAPL	Stock	15.6904	15.7339	15.6904	15.7321	509516.0
2013-05-21 19:00:00	AAPL	Stock	15.7339	15.7339	15.7143	15.7214	101976.0
2013-05-21 06:00:00	MSFT	Stock	34.99	34.99	34.99	34.99	945.0
2013-05-21 07:00:00	MSFT	Stock	35.1	35.14	35.1	35.14	4650.0
2013-05-21 08:00:00	MSFT	Stock	35.29	35.29	34.9	35.2	242649.0
2013-05-21 09:00:00	MSFT	Stock	35.22	35.29	35.07	35.11	7651003.0
2013-05-21 10:00:00	MSFT	Stock	35.1	35.14	34.91	34.955	10337532.0
2013-05-21 11:00:00	MSFT	Stock	34.96	35.02	34.8	34.88	5695819.0
2013-05-21 12:00:00	MSFT	Stock	34.89	35.02	34.885	34.993	3594832.0
2013-05-21 13:00:00	MSFT	Stock	35.0	35.08	34.99	35.04	4197643.0
2013-05-21 14:00:00	MSFT	Stock	35.03	35.059	34.72	34.84	6444143.0
2013-05-21 15:00:00	MSFT	Stock	34.845	34.9	34.79	34.85	6977401.0
2013-05-21 16:00:00	MSFT	Stock	34.855	35.06	34.8	34.85	1530617.0
2013-05-21 17:00:00	MSFT	Stock	34.8	34.85	34.78	34.85	647.0
2013-05-21 18:00:00	MSFT	Stock	34.85	34.85	34.8	34.8	9933.0
2013-05-21 19:00:00	MSFT	Stock	34.85	34.87	34.85	34.87	2000.0
2013-05-21 08:00:00	NVDA	Stock	0.369	0.3698	0.369	0.3698	20000.0
2013-05-21 09:00:00	NVDA	Stock	0.3698	0.372	0.3698	0.37	20872400.0
2013-05-21 10:00:00	NVDA	Stock	0.37	0.3713	0.3669	0.369	57883000.0
2013-05-21 11:00:00	NVDA	Stock	0.3692	0.3698	0.3682	0.369	29995640.0
2013-05-21 12:00:00	NVDA	Stock	0.369	0.3721	0.369	0.3719	38875200.0
2013-05-21 13:00:00	NVDA	Stock	0.3718	0.3743	0.3718	0.374	51099040.0
2013-05-21 14:00:00	NVDA	Stock	0.374	0.3745	0.3735	0.3735	38973880.0
2013-05-21 15:00:00	NVDA	Stock	0.3735	0.374	0.3728	0.373	60675520.0
2013-05-21 16:00:00	NVDA	Stock	0.373	0.3733	0.3717	0.373	37464560.0
2013-05-21 17:00:00	NVDA	Stock	0.3738	0.3738	0.3738	0.3738	4000.0
2013-05-21 18:00:00	NVDA	Stock	0.373	0.373	0.373	0.373	17160.0
2013-05-21 08:00:00	AMZN	Stock	13.3275	13.3815	13.3275	13.3815	196000.0
2013-05-21 09:00:00	AMZN	Stock	13.3865	13.5385	13.383	13.4558	6461340.0
2013-05-21 10:00:00	AMZN	Stock	13.4585	13.466	13.389	13.449	6762320.0
2013-05-21 11:00:00	AMZN	Stock	13.4485	13.4945	13.438	13.4681	3052020.0
2013-05-21 12:00:00	AMZN	Stock	13.4655	13.51	13.451	13.4835	2707680.0
2013-05-21 13:00:00	AMZN	Stock	13.4844	13.505	13.452	13.472	1826380.0
2013-05-21 14:00:00	AMZN	Stock	13.4695	13.506	13.461	13.4795	4414060.0
2013-05-21 15:00:00	AMZN	Stock	13.4825	13.5028	13.439	13.444	6858700.0
2013-05-21 16:00:00	AMZN	Stock	13.443	13.4893	13.3815	13.443	2063320.0

> showing 50 of 46,244 rows — these rows as CSV

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