PREVIEW / stock_1hour / 2014-10-08

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-08.parquet
  size:    1.0 MB
  rows:    48,732
  symbols: 3,548

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-08 04:00:00	AAPL	Stock	24.6375	24.6375	24.5875	24.5875	10600.0
2014-10-08 05:00:00	AAPL	Stock	24.5975	24.6525	24.5625	24.64	49640.0
2014-10-08 06:00:00	AAPL	Stock	24.655	24.75	24.615	24.7125	128928.0
2014-10-08 07:00:00	AAPL	Stock	24.7125	24.7775	24.675	24.765	106132.0
2014-10-08 08:00:00	AAPL	Stock	24.7625	24.795	24.6875	24.7225	479544.0
2014-10-08 09:00:00	AAPL	Stock	24.72	24.84	24.6375	24.6375	22323312.0
2014-10-08 10:00:00	AAPL	Stock	24.64	24.7775	24.6025	24.625	27041964.0
2014-10-08 11:00:00	AAPL	Stock	24.625	24.8125	24.5775	24.7825	19964616.0
2014-10-08 12:00:00	AAPL	Stock	24.7825	24.82	24.75	24.7975	14716520.0
2014-10-08 13:00:00	AAPL	Stock	24.8	24.8975	24.7925	24.8875	13981328.0
2014-10-08 14:00:00	AAPL	Stock	24.8875	25.17	24.8862	25.1625	54907088.0
2014-10-08 15:00:00	AAPL	Stock	25.1625	25.2775	25.1525	25.1935	53864064.0
2014-10-08 16:00:00	AAPL	Stock	25.2	25.2288	24.6908	25.2	11292084.0
2014-10-08 17:00:00	AAPL	Stock	25.2	25.205	25.0422	25.195	116024.0
2014-10-08 18:00:00	AAPL	Stock	25.1925	25.2	25.1825	25.1825	108904.0
2014-10-08 19:00:00	AAPL	Stock	25.1875	25.2	25.1825	25.195	107280.0
2014-10-08 05:00:00	MSFT	Stock	45.42	45.42	45.42	45.42	1000.0
2014-10-08 06:00:00	MSFT	Stock	45.42	45.42	45.42	45.42	4000.0
2014-10-08 07:00:00	MSFT	Stock	45.53	45.58	45.47	45.47	2053.0
2014-10-08 08:00:00	MSFT	Stock	45.45	45.5	45.45	45.46	6654.0
2014-10-08 09:00:00	MSFT	Stock	45.45	45.89	45.34	45.66	2618891.0
2014-10-08 10:00:00	MSFT	Stock	45.67	45.9	45.58	45.62	3178550.0
2014-10-08 11:00:00	MSFT	Stock	45.61	45.9	45.54	45.895	2399632.0
2014-10-08 12:00:00	MSFT	Stock	45.89	46.12	45.865	46.11	2640481.0
2014-10-08 13:00:00	MSFT	Stock	46.11	46.23	46.07	46.22	1963346.0
2014-10-08 14:00:00	MSFT	Stock	46.215	46.68	46.21	46.586	6531855.0
2014-10-08 15:00:00	MSFT	Stock	46.58	46.89	46.53	46.74	9495013.0
2014-10-08 16:00:00	MSFT	Stock	46.78	46.8	45.716	46.78	3111111.0
2014-10-08 17:00:00	MSFT	Stock	46.491	46.78	46.491	46.76	19156.0
2014-10-08 18:00:00	MSFT	Stock	46.78	46.78	46.75	46.75	33522.0
2014-10-08 19:00:00	MSFT	Stock	46.73	46.73	46.7	46.7	800.0
2014-10-08 09:00:00	NVDA	Stock	0.4478	0.45	0.446	0.446	19093200.0
2014-10-08 10:00:00	NVDA	Stock	0.446	0.4492	0.4449	0.4455	25168480.0
2014-10-08 11:00:00	NVDA	Stock	0.4452	0.4478	0.4442	0.4468	25687240.0
2014-10-08 12:00:00	NVDA	Stock	0.447	0.4475	0.4455	0.4461	15310760.0
2014-10-08 13:00:00	NVDA	Stock	0.4461	0.4508	0.4461	0.4505	25517840.0
2014-10-08 14:00:00	NVDA	Stock	0.4505	0.4555	0.4505	0.4549	27835840.0
2014-10-08 15:00:00	NVDA	Stock	0.455	0.4588	0.4548	0.4565	90388960.0
2014-10-08 16:00:00	NVDA	Stock	0.4565	0.4566	0.4452	0.4565	26156480.0
2014-10-08 17:00:00	NVDA	Stock	0.4565	0.4565	0.4565	0.4565	793600.0
2014-10-08 05:00:00	AMZN	Stock	15.849	15.849	15.849	15.849	2000.0
2014-10-08 06:00:00	AMZN	Stock	15.8	15.85	15.8	15.85	6000.0
2014-10-08 07:00:00	AMZN	Stock	15.85	15.875	15.85	15.875	8000.0
2014-10-08 08:00:00	AMZN	Stock	15.853	15.8825	15.853	15.86	33400.0
2014-10-08 09:00:00	AMZN	Stock	15.86	15.9	15.7205	15.7885	7136980.0
2014-10-08 10:00:00	AMZN	Stock	15.7915	15.864	15.7355	15.7528	12312300.0
2014-10-08 11:00:00	AMZN	Stock	15.7525	15.9885	15.707	15.9625	9365040.0
2014-10-08 12:00:00	AMZN	Stock	15.961	15.9865	15.8565	15.8875	3598360.0
2014-10-08 13:00:00	AMZN	Stock	15.884	15.968	15.881	15.95	3238500.0
2014-10-08 14:00:00	AMZN	Stock	15.952	16.145	15.952	16.1025	10411640.0

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

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