PREVIEW / stock_1hour / 2014-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-04.parquet
  size:    1.0 MB
  rows:    48,094
  symbols: 3,536

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
2014-02-04 04:00:00	AAPL	Stock	17.9629	17.9629	17.9464	17.9464	8400.0
2014-02-04 05:00:00	AAPL	Stock	17.9286	17.9286	17.9286	17.9286	2800.0
2014-02-04 06:00:00	AAPL	Stock	17.9289	17.9532	17.9232	17.9439	120540.0
2014-02-04 07:00:00	AAPL	Stock	17.9714	18.0193	17.9632	18.0032	460656.0
2014-02-04 08:00:00	AAPL	Stock	18.0054	18.1286	17.9379	18.1189	2604700.0
2014-02-04 09:00:00	AAPL	Stock	18.1082	18.1207	17.9557	18.1089	60056332.0
2014-02-04 10:00:00	AAPL	Stock	18.1132	18.1311	18.0086	18.0396	48036968.0
2014-02-04 11:00:00	AAPL	Stock	18.045	18.1864	18.0314	18.1861	49207396.0
2014-02-04 12:00:00	AAPL	Stock	18.1857	18.195	18.1507	18.1764	22044736.0
2014-02-04 13:00:00	AAPL	Stock	18.1771	18.1929	18.1159	18.125	22392972.0
2014-02-04 14:00:00	AAPL	Stock	18.1266	18.1764	18.1093	18.1746	18226432.0
2014-02-04 15:00:00	AAPL	Stock	18.1729	18.1814	18.1114	18.1711	38682448.0
2014-02-04 16:00:00	AAPL	Stock	18.1711	18.1747	18.047	18.1504	16338840.0
2014-02-04 17:00:00	AAPL	Stock	18.1554	18.1589	18.1429	18.1446	99568.0
2014-02-04 18:00:00	AAPL	Stock	18.1514	18.1514	18.1439	18.145	61600.0
2014-02-04 19:00:00	AAPL	Stock	18.1514	18.1554	18.1375	18.15	188916.0
2014-02-04 05:00:00	MSFT	Stock	36.42	36.42	36.42	36.42	100.0
2014-02-04 07:00:00	MSFT	Stock	36.46	36.46	36.46	36.46	300.0
2014-02-04 08:00:00	MSFT	Stock	36.5	36.74	36.5	36.7	19239.0
2014-02-04 09:00:00	MSFT	Stock	36.74	37.44	36.51	36.8	10552584.0
2014-02-04 10:00:00	MSFT	Stock	36.8	36.85	36.25	36.29	9368314.0
2014-02-04 11:00:00	MSFT	Stock	36.29	36.67	36.26	36.62	7760540.0
2014-02-04 12:00:00	MSFT	Stock	36.62	36.64	36.54	36.602	3789919.0
2014-02-04 13:00:00	MSFT	Stock	36.61	36.64	36.48	36.51	4189166.0
2014-02-04 14:00:00	MSFT	Stock	36.502	36.61	36.43	36.56	4010379.0
2014-02-04 15:00:00	MSFT	Stock	36.56	36.59	36.34	36.34	10689469.0
2014-02-04 16:00:00	MSFT	Stock	36.35	36.606	36.31	36.475	3266003.0
2014-02-04 17:00:00	MSFT	Stock	36.31	36.35	36.3	36.31	5336.0
2014-02-04 18:00:00	MSFT	Stock	36.31	36.31	36.25	36.3	4100.0
2014-02-04 19:00:00	MSFT	Stock	36.35	36.35	36.26	36.3	822669.0
2014-02-04 08:00:00	NVDA	Stock	0.3842	0.3875	0.384	0.3875	39400.0
2014-02-04 09:00:00	NVDA	Stock	0.3875	0.3893	0.3855	0.3882	30399800.0
2014-02-04 10:00:00	NVDA	Stock	0.3882	0.3893	0.3868	0.3873	45828520.0
2014-02-04 11:00:00	NVDA	Stock	0.3873	0.3873	0.385	0.3873	36834720.0
2014-02-04 12:00:00	NVDA	Stock	0.3874	0.3888	0.3862	0.3885	21055160.0
2014-02-04 13:00:00	NVDA	Stock	0.3888	0.3888	0.3868	0.3873	33179240.0
2014-02-04 14:00:00	NVDA	Stock	0.3871	0.3898	0.387	0.3891	28602800.0
2014-02-04 15:00:00	NVDA	Stock	0.3893	0.3902	0.3876	0.3895	61707280.0
2014-02-04 16:00:00	NVDA	Stock	0.3895	0.3896	0.3873	0.3873	10515560.0
2014-02-04 04:00:00	AMZN	Stock	17.378	17.378	17.378	17.378	2000.0
2014-02-04 05:00:00	AMZN	Stock	17.3395	17.35	17.3	17.3	23000.0
2014-02-04 06:00:00	AMZN	Stock	17.295	17.295	17.295	17.295	2000.0
2014-02-04 07:00:00	AMZN	Stock	17.24	17.257	17.24	17.255	16520.0
2014-02-04 08:00:00	AMZN	Stock	17.235	17.475	17.235	17.475	621940.0
2014-02-04 09:00:00	AMZN	Stock	17.475	17.483	17.201	17.3835	15019000.0
2014-02-04 10:00:00	AMZN	Stock	17.3835	17.6999	17.3835	17.525	20393560.0
2014-02-04 11:00:00	AMZN	Stock	17.522	17.65	17.4602	17.515	9203020.0
2014-02-04 12:00:00	AMZN	Stock	17.513	17.53	17.4205	17.505	6932260.0
2014-02-04 13:00:00	AMZN	Stock	17.5035	17.5488	17.3735	17.386	8950780.0
2014-02-04 14:00:00	AMZN	Stock	17.3885	17.5045	17.35	17.4995	7491880.0

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

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