PREVIEW / stock_1hour / 2013-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-02.parquet
  size:    981 KB
  rows:    45,784
  symbols: 3,503

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-07-02 04:00:00	AAPL	Stock	14.6829	14.6893	14.6829	14.6893	25200.0
2013-07-02 05:00:00	AAPL	Stock	14.6821	14.6821	14.6821	14.6821	2800.0
2013-07-02 06:00:00	AAPL	Stock	14.655	14.6779	14.6518	14.6779	14000.0
2013-07-02 07:00:00	AAPL	Stock	14.6729	14.7357	14.6607	14.6804	864556.0
2013-07-02 08:00:00	AAPL	Stock	14.6843	14.7321	14.5875	14.6375	2602012.0
2013-07-02 09:00:00	AAPL	Stock	14.6375	14.9139	14.6143	14.9007	92355956.0
2013-07-02 10:00:00	AAPL	Stock	14.9029	14.9811	14.8846	14.9654	87734164.0
2013-07-02 11:00:00	AAPL	Stock	14.9675	15.0582	14.9432	15.0239	56547876.0
2013-07-02 12:00:00	AAPL	Stock	15.0235	15.0429	14.9346	14.9636	35620900.0
2013-07-02 13:00:00	AAPL	Stock	14.9622	14.9786	14.8268	14.856	47909260.0
2013-07-02 14:00:00	AAPL	Stock	14.8543	14.8692	14.7768	14.8421	51678144.0
2013-07-02 15:00:00	AAPL	Stock	14.8457	14.9786	14.8218	14.9468	69286924.0
2013-07-02 16:00:00	AAPL	Stock	14.9468	14.9626	14.8487	14.9625	19030424.0
2013-07-02 17:00:00	AAPL	Stock	14.9621	14.9721	14.9468	14.9696	3139192.0
2013-07-02 18:00:00	AAPL	Stock	14.9625	14.9711	14.9571	14.9643	180572.0
2013-07-02 19:00:00	AAPL	Stock	14.9643	14.9746	14.9589	14.9732	137144.0
2013-07-02 08:00:00	MSFT	Stock	34.41	34.41	34.18	34.36	42224.0
2013-07-02 09:00:00	MSFT	Stock	34.26	34.48	34.0	34.29	5898465.0
2013-07-02 10:00:00	MSFT	Stock	34.29	34.36	34.21	34.28	5691249.0
2013-07-02 11:00:00	MSFT	Stock	34.285	34.31	34.08	34.2	3624137.0
2013-07-02 12:00:00	MSFT	Stock	34.21	34.21	33.98	34.075	2895124.0
2013-07-02 13:00:00	MSFT	Stock	34.08	34.08	33.83	33.889	2781054.0
2013-07-02 14:00:00	MSFT	Stock	33.89	33.895	33.63	33.765	4994988.0
2013-07-02 15:00:00	MSFT	Stock	33.76	34.0	33.75	33.95	7974237.0
2013-07-02 16:00:00	MSFT	Stock	33.96	34.256	33.75	33.94	2691028.0
2013-07-02 17:00:00	MSFT	Stock	33.87	33.98	33.87	33.98	853770.0
2013-07-02 18:00:00	MSFT	Stock	33.94	33.99	33.87	33.87	3650.0
2013-07-02 19:00:00	MSFT	Stock	33.93	33.93	33.9	33.9	1400.0
2013-07-02 09:00:00	NVDA	Stock	0.3505	0.3575	0.3502	0.3558	26355240.0
2013-07-02 10:00:00	NVDA	Stock	0.356	0.3572	0.355	0.3562	33496360.0
2013-07-02 11:00:00	NVDA	Stock	0.3562	0.3565	0.355	0.355	22306160.0
2013-07-02 12:00:00	NVDA	Stock	0.3553	0.3555	0.3538	0.3548	23952680.0
2013-07-02 13:00:00	NVDA	Stock	0.3549	0.355	0.3516	0.3529	17148720.0
2013-07-02 14:00:00	NVDA	Stock	0.3529	0.353	0.349	0.3499	27906360.0
2013-07-02 15:00:00	NVDA	Stock	0.3498	0.3533	0.3495	0.352	74149440.0
2013-07-02 16:00:00	NVDA	Stock	0.3522	0.3533	0.3505	0.3505	9955920.0
2013-07-02 17:00:00	NVDA	Stock	0.3522	0.3522	0.3522	0.3522	2592000.0
2013-07-02 05:00:00	AMZN	Stock	14.1105	14.1105	14.1105	14.1105	2000.0
2013-07-02 07:00:00	AMZN	Stock	14.122	14.1255	14.12	14.12	21000.0
2013-07-02 08:00:00	AMZN	Stock	14.1105	14.1105	14.0555	14.105	103960.0
2013-07-02 09:00:00	AMZN	Stock	14.085	14.275	14.0075	14.1675	12499460.0
2013-07-02 10:00:00	AMZN	Stock	14.173	14.254	14.0925	14.249	11627420.0
2013-07-02 11:00:00	AMZN	Stock	14.253	14.314	14.1855	14.2995	8685080.0
2013-07-02 12:00:00	AMZN	Stock	14.3	14.329	14.24	14.305	7706040.0
2013-07-02 13:00:00	AMZN	Stock	14.3065	14.3065	14.168	14.1938	6843240.0
2013-07-02 14:00:00	AMZN	Stock	14.192	14.1925	14.113	14.144	6082960.0
2013-07-02 15:00:00	AMZN	Stock	14.1475	14.2025	14.1185	14.1865	7750680.0
2013-07-02 16:00:00	AMZN	Stock	14.186	14.218	14.152	14.1865	2300760.0
2013-07-02 17:00:00	AMZN	Stock	14.1865	14.1865	14.1785	14.179	899220.0
2013-07-02 19:00:00	AMZN	Stock	14.18	14.184	14.18	14.184	10200.0

> showing 50 of 45,784 rows — these rows as CSV

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