PREVIEW / stock_1hour / 2012-03-22

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-22.parquet
  size:    946 KB
  rows:    44,886
  symbols: 3,497

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
2012-03-22 04:00:00	AAPL	Stock	21.5714	21.5718	21.4579	21.4929	203560.0
2012-03-22 05:00:00	AAPL	Stock	21.4986	21.5	21.3929	21.3929	220472.0
2012-03-22 06:00:00	AAPL	Stock	21.3768	21.3929	21.365	21.365	209384.0
2012-03-22 07:00:00	AAPL	Stock	21.3821	21.4107	21.3439	21.3504	980952.0
2012-03-22 08:00:00	AAPL	Stock	21.3464	21.3929	21.3464	21.3793	5402292.0
2012-03-22 09:00:00	AAPL	Stock	21.38	21.5143	21.2689	21.4855	118368516.0
2012-03-22 10:00:00	AAPL	Stock	21.4857	21.5893	21.4446	21.4732	117888036.0
2012-03-22 11:00:00	AAPL	Stock	21.4782	21.5293	21.4446	21.4943	51952292.0
2012-03-22 12:00:00	AAPL	Stock	21.4939	21.5393	21.4932	21.5307	34276172.0
2012-03-22 13:00:00	AAPL	Stock	21.5293	21.5336	21.3889	21.4318	49918792.0
2012-03-22 14:00:00	AAPL	Stock	21.4275	21.4311	21.3571	21.3707	72186968.0
2012-03-22 15:00:00	AAPL	Stock	21.3718	21.4186	21.2704	21.4071	149378964.0
2012-03-22 16:00:00	AAPL	Stock	21.4032	21.4269	21.362	21.4071	15490188.0
2012-03-22 17:00:00	AAPL	Stock	21.4139	21.4157	21.3825	21.3825	738668.0
2012-03-22 18:00:00	AAPL	Stock	21.3857	21.4046	21.3825	21.3929	215908.0
2012-03-22 19:00:00	AAPL	Stock	21.3921	21.3929	21.3679	21.3696	224784.0
2012-03-22 05:00:00	MSFT	Stock	31.8	31.8	31.8	31.8	100.0
2012-03-22 06:00:00	MSFT	Stock	31.81	31.81	31.81	31.81	100.0
2012-03-22 07:00:00	MSFT	Stock	31.78	31.81	31.76	31.76	6999.0
2012-03-22 08:00:00	MSFT	Stock	31.81	31.9	31.76	31.8	11749.0
2012-03-22 09:00:00	MSFT	Stock	31.87	32.09	31.79	31.835	5890501.0
2012-03-22 10:00:00	MSFT	Stock	31.83	31.93	31.8	31.885	4236185.0
2012-03-22 11:00:00	MSFT	Stock	31.88	31.935	31.81	31.915	4150477.0
2012-03-22 12:00:00	MSFT	Stock	31.915	32.04	31.91	32.04	2602539.0
2012-03-22 13:00:00	MSFT	Stock	32.03	32.04	31.97	32.0	2125694.0
2012-03-22 14:00:00	MSFT	Stock	32.0	32.027	31.93	31.94	3025990.0
2012-03-22 15:00:00	MSFT	Stock	31.94	32.05	31.84	32.0	7537328.0
2012-03-22 16:00:00	MSFT	Stock	31.99	32.02	31.933	31.99	1808605.0
2012-03-22 17:00:00	MSFT	Stock	32.03	32.03	31.91	31.91	8497.0
2012-03-22 18:00:00	MSFT	Stock	31.97	31.97	31.97	31.97	200.0
2012-03-22 19:00:00	MSFT	Stock	32.03	32.03	32.03	32.03	100.0
2012-03-22 08:00:00	NVDA	Stock	0.3568	0.3602	0.3525	0.3602	48000.0
2012-03-22 09:00:00	NVDA	Stock	0.3605	0.364	0.3578	0.3605	63617120.0
2012-03-22 10:00:00	NVDA	Stock	0.3605	0.3619	0.359	0.3615	68703280.0
2012-03-22 11:00:00	NVDA	Stock	0.3614	0.3618	0.3598	0.3615	48592120.0
2012-03-22 12:00:00	NVDA	Stock	0.3615	0.363	0.3612	0.3628	38059560.0
2012-03-22 13:00:00	NVDA	Stock	0.3629	0.3629	0.3612	0.3616	35052240.0
2012-03-22 14:00:00	NVDA	Stock	0.3618	0.3618	0.3602	0.3605	18972600.0
2012-03-22 15:00:00	NVDA	Stock	0.3605	0.3622	0.3592	0.361	112590720.0
2012-03-22 16:00:00	NVDA	Stock	0.361	0.3614	0.3588	0.3608	33815760.0
2012-03-22 17:00:00	NVDA	Stock	0.361	0.3622	0.361	0.3622	20000.0
2012-03-22 18:00:00	NVDA	Stock	0.361	0.361	0.361	0.361	204000.0
2012-03-22 19:00:00	NVDA	Stock	0.3628	0.363	0.361	0.363	48000.0
2012-03-22 04:00:00	AMZN	Stock	9.5825	9.5825	9.5825	9.5825	2000.0
2012-03-22 07:00:00	AMZN	Stock	9.5005	9.5345	9.5005	9.5095	31520.0
2012-03-22 08:00:00	AMZN	Stock	9.51	9.56	9.505	9.535	168980.0
2012-03-22 09:00:00	AMZN	Stock	9.5355	9.6625	9.5015	9.6075	14687780.0
2012-03-22 10:00:00	AMZN	Stock	9.6095	9.6595	9.5605	9.576	11112940.0
2012-03-22 11:00:00	AMZN	Stock	9.5755	9.6275	9.5495	9.5985	9262740.0
2012-03-22 12:00:00	AMZN	Stock	9.6005	9.6995	9.599	9.6978	8004720.0

> showing 50 of 44,886 rows — these rows as CSV

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