PREVIEW / stock_1hour / 2014-10-15

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-15.parquet
  size:    1.1 MB
  rows:    49,643
  symbols: 3,570

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-10-15 04:00:00	AAPL	Stock	24.7525	24.7525	24.675	24.7025	11960.0
2014-10-15 05:00:00	AAPL	Stock	24.7	24.78	24.6275	24.775	17644.0
2014-10-15 06:00:00	AAPL	Stock	24.7825	24.7925	24.7725	24.7925	25388.0
2014-10-15 07:00:00	AAPL	Stock	24.7625	24.82	24.6475	24.7375	773936.0
2014-10-15 08:00:00	AAPL	Stock	24.735	24.875	24.625	24.64	2419408.0
2014-10-15 09:00:00	AAPL	Stock	24.6425	24.7325	24.45	24.575	46550452.0
2014-10-15 10:00:00	AAPL	Stock	24.575	24.7875	24.5175	24.62	42955236.0
2014-10-15 11:00:00	AAPL	Stock	24.615	24.6975	24.415	24.54	32049848.0
2014-10-15 12:00:00	AAPL	Stock	24.5382	24.5425	23.795	24.0	67210980.0
2014-10-15 13:00:00	AAPL	Stock	24.0	24.215	23.8125	24.0415	63213548.0
2014-10-15 14:00:00	AAPL	Stock	24.04	24.3275	23.9625	24.2775	45450948.0
2014-10-15 15:00:00	AAPL	Stock	24.2788	24.515	24.155	24.39	60970392.0
2014-10-15 16:00:00	AAPL	Stock	24.385	24.6498	24.2	24.2975	12683288.0
2014-10-15 17:00:00	AAPL	Stock	24.2975	24.2975	22.8752	24.25	142296.0
2014-10-15 18:00:00	AAPL	Stock	24.385	24.385	24.225	24.235	3510712.0
2014-10-15 19:00:00	AAPL	Stock	24.2375	24.2625	24.225	24.2425	150036.0
2014-10-15 05:00:00	MSFT	Stock	43.8	43.8	43.72	43.72	700.0
2014-10-15 07:00:00	MSFT	Stock	43.7	43.7	43.47	43.53	32264.0
2014-10-15 08:00:00	MSFT	Stock	43.53	43.58	43.25	43.3	27738.0
2014-10-15 09:00:00	MSFT	Stock	43.3	43.73	42.1	42.53	12138981.0
2014-10-15 10:00:00	MSFT	Stock	42.53	43.0	42.429	42.92	7362057.0
2014-10-15 11:00:00	MSFT	Stock	42.91	43.0	42.45	42.71	5868354.0
2014-10-15 12:00:00	MSFT	Stock	42.7	42.705	42.38	42.52	5289732.0
2014-10-15 13:00:00	MSFT	Stock	42.52	42.675	42.22	42.425	6428842.0
2014-10-15 14:00:00	MSFT	Stock	42.421	42.87	42.285	42.745	5046116.0
2014-10-15 15:00:00	MSFT	Stock	42.75	43.39	42.685	43.23	11059791.0
2014-10-15 16:00:00	MSFT	Stock	43.23	43.257	42.73	43.04	4139703.0
2014-10-15 17:00:00	MSFT	Stock	43.05	43.1	42.99	43.0	2700.0
2014-10-15 18:00:00	MSFT	Stock	43.01	43.22	43.0	43.1	28862.0
2014-10-15 19:00:00	MSFT	Stock	43.1	43.1	43.0	43.09	1400.0
2014-10-15 08:00:00	NVDA	Stock	0.4295	0.4295	0.4295	0.4295	12000.0
2014-10-15 09:00:00	NVDA	Stock	0.4225	0.4342	0.4213	0.4325	38009640.0
2014-10-15 10:00:00	NVDA	Stock	0.4325	0.4342	0.4278	0.4288	56035840.0
2014-10-15 11:00:00	NVDA	Stock	0.4288	0.433	0.4253	0.4261	36296520.0
2014-10-15 12:00:00	NVDA	Stock	0.426	0.4262	0.4219	0.423	25329640.0
2014-10-15 13:00:00	NVDA	Stock	0.423	0.426	0.4204	0.4235	41282120.0
2014-10-15 14:00:00	NVDA	Stock	0.4237	0.4288	0.4222	0.4278	50897080.0
2014-10-15 15:00:00	NVDA	Stock	0.428	0.4382	0.4272	0.4359	129767720.0
2014-10-15 16:00:00	NVDA	Stock	0.436	0.4361	0.4287	0.4361	1932600.0
2014-10-15 17:00:00	NVDA	Stock	0.4355	0.4355	0.4355	0.4355	4000.0
2014-10-15 18:00:00	NVDA	Stock	0.4318	0.4318	0.4318	0.4318	8000.0
2014-10-15 19:00:00	NVDA	Stock	0.4358	0.4358	0.4358	0.4358	10000.0
2014-10-15 08:00:00	AMZN	Stock	15.4155	15.4155	15.2	15.2	207580.0
2014-10-15 09:00:00	AMZN	Stock	15.2	15.315	15.0675	15.182	14686900.0
2014-10-15 10:00:00	AMZN	Stock	15.175	15.317	15.1004	15.188	17205220.0
2014-10-15 11:00:00	AMZN	Stock	15.185	15.294	15.11	15.1695	10045520.0
2014-10-15 12:00:00	AMZN	Stock	15.1695	15.1875	15.0381	15.1075	8622140.0
2014-10-15 13:00:00	AMZN	Stock	15.104	15.1455	14.9551	15.0455	13219040.0
2014-10-15 14:00:00	AMZN	Stock	15.0405	15.1885	15.0173	15.155	8977780.0
2014-10-15 15:00:00	AMZN	Stock	15.157	15.395	15.091	15.298	19950520.0

> showing 50 of 49,643 rows — these rows as CSV

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