PREVIEW / stock_1hour / 2012-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-17.parquet
  size:    916 KB
  rows:    43,338
  symbols: 3,480

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-08-17 04:00:00	AAPL	Stock	22.7214	22.7214	22.7214	22.7214	28000.0
2012-08-17 05:00:00	AAPL	Stock	22.7507	22.7843	22.7493	22.7643	178080.0
2012-08-17 06:00:00	AAPL	Stock	22.7843	22.8118	22.7843	22.8118	33880.0
2012-08-17 07:00:00	AAPL	Stock	22.7911	22.8054	22.7714	22.8054	627536.0
2012-08-17 08:00:00	AAPL	Stock	22.8014	22.8318	22.7264	22.7946	2970492.0
2012-08-17 09:00:00	AAPL	Stock	22.7946	22.9896	22.7946	22.9843	119362180.0
2012-08-17 10:00:00	AAPL	Stock	22.9857	23.0046	22.9164	22.9661	75752264.0
2012-08-17 11:00:00	AAPL	Stock	22.9661	22.9886	22.94	22.9854	31477880.0
2012-08-17 12:00:00	AAPL	Stock	22.9871	23.0529	22.9825	23.0008	55165404.0
2012-08-17 13:00:00	AAPL	Stock	23.0007	23.0439	22.9907	23.0336	25872560.0
2012-08-17 14:00:00	AAPL	Stock	23.0318	23.0832	23.0218	23.0818	35581784.0
2012-08-17 15:00:00	AAPL	Stock	23.0821	23.1496	23.0661	23.1486	78856260.0
2012-08-17 16:00:00	AAPL	Stock	23.1464	23.1821	22.991	23.1732	8432200.0
2012-08-17 17:00:00	AAPL	Stock	23.1721	23.1786	23.1629	23.1629	962528.0
2012-08-17 18:00:00	AAPL	Stock	23.1661	23.1739	23.1536	23.1704	240100.0
2012-08-17 19:00:00	AAPL	Stock	23.1707	23.18	23.1686	23.175	246680.0
2012-08-17 07:00:00	MSFT	Stock	30.96	30.97	30.92	30.92	3000.0
2012-08-17 08:00:00	MSFT	Stock	30.82	30.9	30.81	30.88	3700.0
2012-08-17 09:00:00	MSFT	Stock	30.78	30.98	30.65	30.784	10471487.0
2012-08-17 10:00:00	MSFT	Stock	30.79	30.8	30.59	30.655	5420392.0
2012-08-17 11:00:00	MSFT	Stock	30.66	30.83	30.61	30.819	3773299.0
2012-08-17 12:00:00	MSFT	Stock	30.81	30.82	30.72	30.745	1491273.0
2012-08-17 13:00:00	MSFT	Stock	30.74	30.81	30.74	30.766	1374464.0
2012-08-17 14:00:00	MSFT	Stock	30.77	30.86	30.76	30.855	1636669.0
2012-08-17 15:00:00	MSFT	Stock	30.85	30.91	30.82	30.9	5553057.0
2012-08-17 16:00:00	MSFT	Stock	30.9	30.95	30.798	30.9	2218636.0
2012-08-17 17:00:00	MSFT	Stock	30.9	30.94	30.86	30.94	4630.0
2012-08-17 19:00:00	MSFT	Stock	30.92	30.95	30.92	30.95	7600.0
2012-08-17 09:00:00	NVDA	Stock	0.3692	0.3695	0.3655	0.3672	52528200.0
2012-08-17 10:00:00	NVDA	Stock	0.367	0.368	0.363	0.3645	94263840.0
2012-08-17 11:00:00	NVDA	Stock	0.3645	0.3658	0.3632	0.3652	28209520.0
2012-08-17 12:00:00	NVDA	Stock	0.3652	0.3655	0.3648	0.365	28822280.0
2012-08-17 13:00:00	NVDA	Stock	0.3651	0.3655	0.365	0.3652	9730000.0
2012-08-17 14:00:00	NVDA	Stock	0.3655	0.366	0.365	0.3652	27565120.0
2012-08-17 15:00:00	NVDA	Stock	0.3654	0.3665	0.3649	0.3662	59874800.0
2012-08-17 16:00:00	NVDA	Stock	0.3662	0.3675	0.365	0.3653	7543880.0
2012-08-17 17:00:00	NVDA	Stock	0.3652	0.3652	0.3652	0.3652	32000.0
2012-08-17 18:00:00	NVDA	Stock	0.3655	0.3655	0.3652	0.3652	60400.0
2012-08-17 08:00:00	AMZN	Stock	12.055	12.1025	12.055	12.075	32840.0
2012-08-17 09:00:00	AMZN	Stock	12.0605	12.1675	11.985	12.1305	20875980.0
2012-08-17 10:00:00	AMZN	Stock	12.1295	12.144	12.0235	12.068	10418620.0
2012-08-17 11:00:00	AMZN	Stock	12.066	12.106	12.035	12.073	6059760.0
2012-08-17 12:00:00	AMZN	Stock	12.0735	12.098	12.0455	12.0965	5252240.0
2012-08-17 13:00:00	AMZN	Stock	12.0935	12.1012	12.066	12.0701	3761640.0
2012-08-17 14:00:00	AMZN	Stock	12.0696	12.078	12.0255	12.0505	5088200.0
2012-08-17 15:00:00	AMZN	Stock	12.053	12.0739	12.035	12.0555	7781420.0
2012-08-17 16:00:00	AMZN	Stock	12.0585	12.074	12.0415	12.074	1764000.0
2012-08-17 17:00:00	AMZN	Stock	12.0575	12.062	12.0575	12.062	12000.0
2012-08-17 18:00:00	AMZN	Stock	12.0555	12.0555	12.0555	12.0555	4000.0
2012-08-17 19:00:00	AMZN	Stock	12.0735	12.0735	12.0735	12.0735	2200.0

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

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