PREVIEW / stock_1hour / 2013-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-18.parquet
  size:    1.0 MB
  rows:    48,857
  symbols: 3,540

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-10-18 04:00:00	AAPL	Stock	18.0839	18.1429	18.0839	18.125	111608.0
2013-10-18 05:00:00	AAPL	Stock	18.1357	18.1393	18.0768	18.0829	134176.0
2013-10-18 06:00:00	AAPL	Stock	18.1071	18.1161	18.0982	18.1071	90244.0
2013-10-18 07:00:00	AAPL	Stock	18.1071	18.1607	18.1071	18.1268	788704.0
2013-10-18 08:00:00	AAPL	Stock	18.1268	18.1814	18.0	18.1536	3479588.0
2013-10-18 09:00:00	AAPL	Stock	18.1536	18.1643	18.0593	18.135	62835948.0
2013-10-18 10:00:00	AAPL	Stock	18.135	18.1879	18.1143	18.1761	51219392.0
2013-10-18 11:00:00	AAPL	Stock	18.1771	18.1846	18.1432	18.1714	24715348.0
2013-10-18 12:00:00	AAPL	Stock	18.1711	18.1718	18.1425	18.1571	21641368.0
2013-10-18 13:00:00	AAPL	Stock	18.1571	18.1625	18.1286	18.1535	19373984.0
2013-10-18 14:00:00	AAPL	Stock	18.1518	18.1636	18.1375	18.1614	21371952.0
2013-10-18 15:00:00	AAPL	Stock	18.1611	18.1782	18.1368	18.1725	54925248.0
2013-10-18 16:00:00	AAPL	Stock	18.1768	18.1857	17.9985	18.1779	14316400.0
2013-10-18 17:00:00	AAPL	Stock	18.1714	18.1857	18.1607	18.1786	438452.0
2013-10-18 18:00:00	AAPL	Stock	18.1768	18.1857	18.1768	18.1846	1009708.0
2013-10-18 19:00:00	AAPL	Stock	18.1807	18.1946	18.1714	18.1946	381052.0
2013-10-18 06:00:00	MSFT	Stock	34.94	34.94	34.94	34.94	150.0
2013-10-18 07:00:00	MSFT	Stock	35.06	35.06	34.8	34.92	1730.0
2013-10-18 08:00:00	MSFT	Stock	35.0	35.0	34.82	34.89	6040.0
2013-10-18 09:00:00	MSFT	Stock	34.89	34.91	34.33	34.56	11739578.0
2013-10-18 10:00:00	MSFT	Stock	34.57	34.8	34.5	34.765	5718272.0
2013-10-18 11:00:00	MSFT	Stock	34.76	34.83	34.6	34.709	4094292.0
2013-10-18 12:00:00	MSFT	Stock	34.709	34.78	34.68	34.75	2136000.0
2013-10-18 13:00:00	MSFT	Stock	34.749	34.96	34.745	34.955	2386906.0
2013-10-18 14:00:00	MSFT	Stock	34.96	34.96	34.85	34.86	2793408.0
2013-10-18 15:00:00	MSFT	Stock	34.86	34.99	34.84	34.99	6912601.0
2013-10-18 16:00:00	MSFT	Stock	34.955	35.0	34.734	34.99	4401900.0
2013-10-18 17:00:00	MSFT	Stock	34.99	34.99	34.96	34.96	4383.0
2013-10-18 18:00:00	MSFT	Stock	34.99	34.99	34.96	34.98	18167.0
2013-10-18 19:00:00	MSFT	Stock	34.99	34.99	34.98	34.98	2620.0
2013-10-18 08:00:00	NVDA	Stock	0.3905	0.3905	0.3905	0.3905	88000.0
2013-10-18 09:00:00	NVDA	Stock	0.389	0.3918	0.3885	0.3908	39447440.0
2013-10-18 10:00:00	NVDA	Stock	0.3908	0.3922	0.39	0.3922	46619160.0
2013-10-18 11:00:00	NVDA	Stock	0.3922	0.394	0.392	0.392	30141600.0
2013-10-18 12:00:00	NVDA	Stock	0.392	0.394	0.392	0.394	19297360.0
2013-10-18 13:00:00	NVDA	Stock	0.3939	0.3946	0.3935	0.3945	18587000.0
2013-10-18 14:00:00	NVDA	Stock	0.3945	0.3965	0.3942	0.3961	22226240.0
2013-10-18 15:00:00	NVDA	Stock	0.3961	0.3962	0.393	0.3951	55468280.0
2013-10-18 16:00:00	NVDA	Stock	0.3953	0.3953	0.3945	0.3953	21554600.0
2013-10-18 04:00:00	AMZN	Stock	15.88	15.902	15.83	15.8905	124160.0
2013-10-18 05:00:00	AMZN	Stock	15.9375	15.952	15.9	15.9	334000.0
2013-10-18 06:00:00	AMZN	Stock	15.925	15.962	15.925	15.962	13300.0
2013-10-18 07:00:00	AMZN	Stock	15.9475	15.983	15.9285	15.9645	159480.0
2013-10-18 08:00:00	AMZN	Stock	15.9445	15.9715	15.925	15.937	406940.0
2013-10-18 09:00:00	AMZN	Stock	15.935	15.9875	15.8375	15.979	20664680.0
2013-10-18 10:00:00	AMZN	Stock	15.975	16.16	15.961	16.1205	21943760.0
2013-10-18 11:00:00	AMZN	Stock	16.119	16.2825	16.1095	16.1755	11605340.0
2013-10-18 12:00:00	AMZN	Stock	16.1806	16.3735	16.1755	16.359	9822220.0
2013-10-18 13:00:00	AMZN	Stock	16.353	16.5895	16.3505	16.561	19512380.0
2013-10-18 14:00:00	AMZN	Stock	16.5595	16.5945	16.47	16.5005	9440700.0

> showing 50 of 48,857 rows — these rows as CSV

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