PREVIEW / stock_1hour / 2012-03-12

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-12.parquet
  size:    934 KB
  rows:    44,378
  symbols: 3,512

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-12 05:00:00	AAPL	Stock	19.4643	19.4643	19.4414	19.4564	54208.0
2012-03-12 06:00:00	AAPL	Stock	19.4557	19.4557	19.4536	19.4546	39200.0
2012-03-12 07:00:00	AAPL	Stock	19.4607	19.4993	19.4607	19.4793	806008.0
2012-03-12 08:00:00	AAPL	Stock	19.4793	19.6107	19.4761	19.5832	6942880.0
2012-03-12 09:00:00	AAPL	Stock	19.5843	19.6936	19.5796	19.6104	88314688.0
2012-03-12 10:00:00	AAPL	Stock	19.6111	19.6446	19.5357	19.6246	81642484.0
2012-03-12 11:00:00	AAPL	Stock	19.6241	19.6286	19.5689	19.6093	37884056.0
2012-03-12 12:00:00	AAPL	Stock	19.6093	19.6925	19.5914	19.6904	48367760.0
2012-03-12 13:00:00	AAPL	Stock	19.6921	19.7093	19.6539	19.6832	36544928.0
2012-03-12 14:00:00	AAPL	Stock	19.685	19.7021	19.67	19.6857	23085888.0
2012-03-12 15:00:00	AAPL	Stock	19.6871	19.7143	19.6504	19.7143	59697428.0
2012-03-12 16:00:00	AAPL	Stock	19.7143	19.7354	19.6068	19.7321	12204948.0
2012-03-12 17:00:00	AAPL	Stock	19.7321	19.7357	19.7261	19.7343	564732.0
2012-03-12 18:00:00	AAPL	Stock	19.7339	19.7857	19.7329	19.775	2235940.0
2012-03-12 19:00:00	AAPL	Stock	19.775	19.7846	19.77	19.7764	847700.0
2012-03-12 07:00:00	MSFT	Stock	31.99	31.99	31.99	31.99	100.0
2012-03-12 08:00:00	MSFT	Stock	31.95	31.99	31.9	31.91	2608.0
2012-03-12 09:00:00	MSFT	Stock	31.91	32.1	31.82	32.07	3307794.0
2012-03-12 10:00:00	MSFT	Stock	32.07	32.09	31.96	32.08	6207675.0
2012-03-12 11:00:00	MSFT	Stock	32.075	32.1	32.0	32.06	4629788.0
2012-03-12 12:00:00	MSFT	Stock	32.05	32.13	32.03	32.1	3969882.0
2012-03-12 13:00:00	MSFT	Stock	32.097	32.2	32.06	32.14	2812523.0
2012-03-12 14:00:00	MSFT	Stock	32.14	32.16	32.08	32.12	3117942.0
2012-03-12 15:00:00	MSFT	Stock	32.115	32.12	32.02	32.05	7426000.0
2012-03-12 16:00:00	MSFT	Stock	32.05	32.11	31.994	32.04	1786297.0
2012-03-12 17:00:00	MSFT	Stock	32.04	32.08	32.04	32.08	991.0
2012-03-12 18:00:00	MSFT	Stock	32.04	32.04	32.04	32.04	100.0
2012-03-12 19:00:00	MSFT	Stock	32.07	32.08	32.04	32.08	3091.0
2012-03-12 08:00:00	NVDA	Stock	0.3738	0.3738	0.3738	0.3738	7920.0
2012-03-12 09:00:00	NVDA	Stock	0.3733	0.3745	0.3705	0.3725	30548640.0
2012-03-12 10:00:00	NVDA	Stock	0.372	0.3723	0.365	0.3655	58607720.0
2012-03-12 11:00:00	NVDA	Stock	0.3655	0.3679	0.3642	0.3664	59772880.0
2012-03-12 12:00:00	NVDA	Stock	0.3662	0.3679	0.365	0.3651	34958640.0
2012-03-12 13:00:00	NVDA	Stock	0.3651	0.3652	0.3638	0.3642	25444560.0
2012-03-12 14:00:00	NVDA	Stock	0.3642	0.3655	0.3642	0.365	21051680.0
2012-03-12 15:00:00	NVDA	Stock	0.3652	0.3654	0.364	0.3648	54738880.0
2012-03-12 16:00:00	NVDA	Stock	0.3645	0.3668	0.3638	0.3638	1627680.0
2012-03-12 17:00:00	NVDA	Stock	0.3638	0.3638	0.3638	0.3638	76000.0
2012-03-12 19:00:00	NVDA	Stock	0.3638	0.3638	0.3638	0.3638	4000.0
2012-03-12 08:00:00	AMZN	Stock	9.223	9.235	9.1975	9.2	111340.0
2012-03-12 09:00:00	AMZN	Stock	9.198	9.27	9.175	9.25	7104400.0
2012-03-12 10:00:00	AMZN	Stock	9.25	9.2545	9.139	9.162	12774060.0
2012-03-12 11:00:00	AMZN	Stock	9.161	9.168	9.11	9.168	8006500.0
2012-03-12 12:00:00	AMZN	Stock	9.1677	9.18	9.14	9.1445	4485360.0
2012-03-12 13:00:00	AMZN	Stock	9.145	9.165	9.125	9.16	3972340.0
2012-03-12 14:00:00	AMZN	Stock	9.16	9.17	9.135	9.1483	5442300.0
2012-03-12 15:00:00	AMZN	Stock	9.1485	9.1725	9.143	9.1715	7669280.0
2012-03-12 16:00:00	AMZN	Stock	9.1695	9.1762	9.1505	9.1695	1976560.0
2012-03-12 17:00:00	AMZN	Stock	9.1635	9.1685	9.1635	9.1635	19800.0
2012-03-12 19:00:00	AMZN	Stock	9.1525	9.1635	9.1525	9.1635	9500.0

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

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