PREVIEW / stock_1hour / 2014-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-23.parquet
  size:    1017 KB
  rows:    46,982
  symbols: 3,534

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-05-23 04:00:00	AAPL	Stock	21.6804	21.6839	21.6804	21.6839	16800.0
2014-05-23 05:00:00	AAPL	Stock	21.6914	21.6925	21.6914	21.6925	5600.0
2014-05-23 06:00:00	AAPL	Stock	21.6993	21.6993	21.6993	21.6993	2800.0
2014-05-23 07:00:00	AAPL	Stock	21.6907	21.6907	21.6761	21.6761	39200.0
2014-05-23 08:00:00	AAPL	Stock	21.6786	21.6964	21.6514	21.6657	246484.0
2014-05-23 09:00:00	AAPL	Stock	21.6639	21.7475	21.6571	21.7268	30990932.0
2014-05-23 10:00:00	AAPL	Stock	21.7339	21.7439	21.6596	21.7011	28078848.0
2014-05-23 11:00:00	AAPL	Stock	21.7029	21.7404	21.6979	21.725	17129364.0
2014-05-23 12:00:00	AAPL	Stock	21.7243	21.7739	21.7243	21.7589	16237620.0
2014-05-23 13:00:00	AAPL	Stock	21.7589	21.8071	21.7568	21.7964	19532016.0
2014-05-23 14:00:00	AAPL	Stock	21.7964	21.8457	21.7921	21.8454	18757816.0
2014-05-23 15:00:00	AAPL	Stock	21.8445	21.9546	21.8429	21.9336	51495276.0
2014-05-23 16:00:00	AAPL	Stock	21.9332	21.9336	21.6567	21.9332	8601656.0
2014-05-23 17:00:00	AAPL	Stock	21.9089	21.9271	21.9089	21.9271	123144.0
2014-05-23 18:00:00	AAPL	Stock	21.9332	21.9332	21.9196	21.9229	153160.0
2014-05-23 19:00:00	AAPL	Stock	21.9221	21.9271	21.9182	21.9271	183876.0
2014-05-23 09:00:00	MSFT	Stock	40.14	40.42	40.02	40.2	2902319.0
2014-05-23 10:00:00	MSFT	Stock	40.2	40.27	40.04	40.085	2736502.0
2014-05-23 11:00:00	MSFT	Stock	40.09	40.14	40.04	40.085	1913521.0
2014-05-23 12:00:00	MSFT	Stock	40.085	40.12	40.02	40.06	1375952.0
2014-05-23 13:00:00	MSFT	Stock	40.06	40.08	40.0	40.08	1831211.0
2014-05-23 14:00:00	MSFT	Stock	40.07	40.12	40.07	40.11	1338074.0
2014-05-23 15:00:00	MSFT	Stock	40.11	40.13	40.06	40.12	2972956.0
2014-05-23 16:00:00	MSFT	Stock	40.12	40.166	40.06	40.12	2315351.0
2014-05-23 17:00:00	MSFT	Stock	40.07	40.07	40.02	40.02	7568.0
2014-05-23 18:00:00	MSFT	Stock	40.06	40.06	40.03	40.03	250.0
2014-05-23 19:00:00	MSFT	Stock	40.05	40.05	40.04	40.04	400.0
2014-05-23 06:00:00	NVDA	Stock	0.462	0.462	0.462	0.462	20000.0
2014-05-23 07:00:00	NVDA	Stock	0.4605	0.4605	0.4605	0.4605	20000.0
2014-05-23 08:00:00	NVDA	Stock	0.46	0.4605	0.46	0.4605	32800.0
2014-05-23 09:00:00	NVDA	Stock	0.46	0.4612	0.4578	0.4612	24851080.0
2014-05-23 10:00:00	NVDA	Stock	0.4612	0.4645	0.4606	0.4625	30949480.0
2014-05-23 11:00:00	NVDA	Stock	0.4625	0.4625	0.4603	0.462	22917800.0
2014-05-23 12:00:00	NVDA	Stock	0.4622	0.463	0.4618	0.4624	12378160.0
2014-05-23 13:00:00	NVDA	Stock	0.4624	0.463	0.4615	0.4624	9016000.0
2014-05-23 14:00:00	NVDA	Stock	0.4622	0.4628	0.4618	0.4624	16009240.0
2014-05-23 15:00:00	NVDA	Stock	0.4622	0.463	0.462	0.462	34606760.0
2014-05-23 16:00:00	NVDA	Stock	0.4622	0.4633	0.4587	0.4628	1902360.0
2014-05-23 05:00:00	AMZN	Stock	15.287	15.287	15.287	15.287	2000.0
2014-05-23 08:00:00	AMZN	Stock	15.3475	15.3475	15.2055	15.225	142780.0
2014-05-23 09:00:00	AMZN	Stock	15.229	15.3944	15.229	15.3901	6843260.0
2014-05-23 10:00:00	AMZN	Stock	15.3885	15.455	15.3445	15.3695	9292100.0
2014-05-23 11:00:00	AMZN	Stock	15.3705	15.4425	15.3645	15.431	4696100.0
2014-05-23 12:00:00	AMZN	Stock	15.436	15.4645	15.405	15.4585	4269660.0
2014-05-23 13:00:00	AMZN	Stock	15.46	15.462	15.427	15.4575	4846160.0
2014-05-23 14:00:00	AMZN	Stock	15.453	15.55	15.4525	15.5472	6314640.0
2014-05-23 15:00:00	AMZN	Stock	15.5495	15.6175	15.5488	15.6125	16667920.0
2014-05-23 16:00:00	AMZN	Stock	15.612	15.651	15.466	15.621	1091840.0
2014-05-23 17:00:00	AMZN	Stock	15.618	15.625	15.606	15.616	17860.0
2014-05-23 18:00:00	AMZN	Stock	15.612	15.612	15.588	15.588	50400.0

> showing 50 of 46,982 rows — these rows as CSV

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