PREVIEW / stock_1hour / 2011-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-18.parquet
  size:    906 KB
  rows:    43,095
  symbols: 3,510

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-11-18 04:00:00	AAPL	Stock	13.545	13.545	13.545	13.545	2800.0
2011-11-18 05:00:00	AAPL	Stock	13.545	13.545	13.5357	13.5357	26600.0
2011-11-18 06:00:00	AAPL	Stock	13.5357	13.5982	13.5354	13.5982	78400.0
2011-11-18 07:00:00	AAPL	Stock	13.5893	13.6607	13.5771	13.6161	538748.0
2011-11-18 08:00:00	AAPL	Stock	13.6286	13.63	13.5829	13.6	1019956.0
2011-11-18 09:00:00	AAPL	Stock	13.6	13.6	13.4375	13.5029	60875024.0
2011-11-18 10:00:00	AAPL	Stock	13.5	13.5554	13.4529	13.5396	56099008.0
2011-11-18 11:00:00	AAPL	Stock	13.5368	13.5711	13.4925	13.4982	38687656.0
2011-11-18 12:00:00	AAPL	Stock	13.5011	13.5018	13.4289	13.4671	36366008.0
2011-11-18 13:00:00	AAPL	Stock	13.4671	13.4929	13.4539	13.4587	21345968.0
2011-11-18 14:00:00	AAPL	Stock	13.46	13.48	13.3929	13.4018	48187468.0
2011-11-18 15:00:00	AAPL	Stock	13.4025	13.4282	13.3886	13.3911	71809948.0
2011-11-18 16:00:00	AAPL	Stock	13.3932	13.5162	13.3906	13.3943	13527220.0
2011-11-18 17:00:00	AAPL	Stock	13.3929	13.3932	13.3875	13.3911	529508.0
2011-11-18 18:00:00	AAPL	Stock	13.3893	13.3929	13.3882	13.3929	81284.0
2011-11-18 19:00:00	AAPL	Stock	13.3939	13.3939	13.3893	13.3929	77896.0
2011-11-18 07:00:00	MSFT	Stock	25.7	25.7	25.62	25.65	5700.0
2011-11-18 08:00:00	MSFT	Stock	25.65	25.71	25.63	25.71	28925.0
2011-11-18 09:00:00	MSFT	Stock	25.67	25.7	25.25	25.27	10549069.0
2011-11-18 10:00:00	MSFT	Stock	25.27	25.42	25.15	25.39	9402494.0
2011-11-18 11:00:00	MSFT	Stock	25.39	25.45	25.31	25.315	4881018.0
2011-11-18 12:00:00	MSFT	Stock	25.315	25.4	25.23	25.379	3585806.0
2011-11-18 13:00:00	MSFT	Stock	25.37	25.47	25.35	25.36	3885750.0
2011-11-18 14:00:00	MSFT	Stock	25.35	25.459	25.31	25.32	5120673.0
2011-11-18 15:00:00	MSFT	Stock	25.32	25.38	25.29	25.3	7065853.0
2011-11-18 16:00:00	MSFT	Stock	25.3	25.54	25.29	25.32	2125974.0
2011-11-18 17:00:00	MSFT	Stock	25.29	25.39	25.29	25.39	2150.0
2011-11-18 18:00:00	MSFT	Stock	25.38	25.4	25.3	25.3	10553.0
2011-11-18 19:00:00	MSFT	Stock	25.38	25.38	25.35	25.35	1050.0
2011-11-18 08:00:00	NVDA	Stock	0.355	0.3585	0.3538	0.3585	534600.0
2011-11-18 09:00:00	NVDA	Stock	0.3555	0.3555	0.3444	0.3478	86094440.0
2011-11-18 10:00:00	NVDA	Stock	0.3475	0.3498	0.3445	0.3482	96298440.0
2011-11-18 11:00:00	NVDA	Stock	0.3484	0.35	0.3475	0.348	70019680.0
2011-11-18 12:00:00	NVDA	Stock	0.348	0.3498	0.3455	0.3482	54315600.0
2011-11-18 13:00:00	NVDA	Stock	0.348	0.3513	0.3478	0.3493	34062960.0
2011-11-18 14:00:00	NVDA	Stock	0.3493	0.3514	0.348	0.3485	50570680.0
2011-11-18 15:00:00	NVDA	Stock	0.3482	0.3502	0.348	0.3482	98029920.0
2011-11-18 16:00:00	NVDA	Stock	0.3485	0.3515	0.3475	0.3482	1873200.0
2011-11-18 17:00:00	NVDA	Stock	0.3498	0.3498	0.3482	0.3498	56000.0
2011-11-18 18:00:00	NVDA	Stock	0.3482	0.3498	0.3482	0.3498	290080.0
2011-11-18 19:00:00	NVDA	Stock	0.3488	0.3488	0.3488	0.3488	12000.0
2011-11-18 06:00:00	AMZN	Stock	10.3065	10.3065	10.3065	10.3065	2000.0
2011-11-18 07:00:00	AMZN	Stock	10.324	10.328	10.296	10.3015	71800.0
2011-11-18 08:00:00	AMZN	Stock	10.3155	10.316	10.287	10.3075	145600.0
2011-11-18 09:00:00	AMZN	Stock	10.315	10.315	10.1525	10.158	19001920.0
2011-11-18 10:00:00	AMZN	Stock	10.1575	10.192	10.0255	10.125	24737100.0
2011-11-18 11:00:00	AMZN	Stock	10.1215	10.1465	9.987	9.996	16773060.0
2011-11-18 12:00:00	AMZN	Stock	9.9983	10.016	9.93	9.997	21147180.0
2011-11-18 13:00:00	AMZN	Stock	9.9945	10.0465	9.9596	9.9735	17142840.0
2011-11-18 14:00:00	AMZN	Stock	9.973	9.987	9.8966	9.9065	21605440.0

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

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