PREVIEW / stock_1hour / 2015-08-13

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-13.parquet
  size:    1.0 MB
  rows:    48,125
  symbols: 3,456

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
2015-08-13 04:00:00	AAPL	Stock	28.9	29.0975	28.9	28.975	76972.0
2015-08-13 05:00:00	AAPL	Stock	28.98	28.9875	28.925	28.925	37240.0
2015-08-13 06:00:00	AAPL	Stock	28.97	29.045	28.97	29.025	69044.0
2015-08-13 07:00:00	AAPL	Stock	29.0125	29.025	28.9675	28.9925	238644.0
2015-08-13 08:00:00	AAPL	Stock	28.9975	29.025	28.8525	28.8725	1412760.0
2015-08-13 09:00:00	AAPL	Stock	28.86	29.1	28.635	28.73	39825544.0
2015-08-13 10:00:00	AAPL	Stock	28.7288	29.035	28.6525	28.8525	38331612.0
2015-08-13 11:00:00	AAPL	Stock	28.8588	29.0	28.7925	28.975	21775744.0
2015-08-13 12:00:00	AAPL	Stock	28.9738	28.985	28.8775	28.9385	16124568.0
2015-08-13 13:00:00	AAPL	Stock	28.94	29.05	28.935	28.9835	14342656.0
2015-08-13 14:00:00	AAPL	Stock	28.9838	29.0925	28.9638	29.05	17161480.0
2015-08-13 15:00:00	AAPL	Stock	29.0475	29.05	28.78	28.7925	28440800.0
2015-08-13 16:00:00	AAPL	Stock	28.7875	28.8075	28.6615	28.77	5187784.0
2015-08-13 17:00:00	AAPL	Stock	28.7692	28.775	28.655	28.68	346812.0
2015-08-13 18:00:00	AAPL	Stock	28.6925	28.72	28.675	28.705	162392.0
2015-08-13 19:00:00	AAPL	Stock	28.6925	28.7125	28.635	28.6475	93780.0
2015-08-13 04:00:00	MSFT	Stock	47.11	47.13	47.11	47.13	400.0
2015-08-13 05:00:00	MSFT	Stock	47.2	47.2	47.2	47.2	2000.0
2015-08-13 06:00:00	MSFT	Stock	47.2	47.28	47.2	47.27	3300.0
2015-08-13 07:00:00	MSFT	Stock	47.27	47.27	47.25	47.25	1600.0
2015-08-13 08:00:00	MSFT	Stock	47.27	47.4	47.15	47.15	12270.0
2015-08-13 09:00:00	MSFT	Stock	47.11	47.2	46.656	46.71	3158262.0
2015-08-13 10:00:00	MSFT	Stock	46.7	46.89	46.49	46.77	3274862.0
2015-08-13 11:00:00	MSFT	Stock	46.78	46.81	46.56	46.65	2553995.0
2015-08-13 12:00:00	MSFT	Stock	46.65	46.966	46.57	46.925	2858890.0
2015-08-13 13:00:00	MSFT	Stock	46.92	47.04	46.84	46.89	1677366.0
2015-08-13 14:00:00	MSFT	Stock	46.896	47.06	46.84	47.05	1547257.0
2015-08-13 15:00:00	MSFT	Stock	47.045	47.07	46.71	46.74	4513172.0
2015-08-13 16:00:00	MSFT	Stock	46.73	46.85	46.73	46.8	1999835.0
2015-08-13 17:00:00	MSFT	Stock	46.8	46.8	46.8	46.8	100.0
2015-08-13 18:00:00	MSFT	Stock	46.72	46.75	46.72	46.75	300.0
2015-08-13 19:00:00	MSFT	Stock	46.72	46.72	46.68	46.68	2234.0
2015-08-13 08:00:00	NVDA	Stock	0.5973	0.5973	0.593	0.593	16000.0
2015-08-13 09:00:00	NVDA	Stock	0.5875	0.595	0.5865	0.5926	24084080.0
2015-08-13 10:00:00	NVDA	Stock	0.5925	0.5948	0.5905	0.591	56334280.0
2015-08-13 11:00:00	NVDA	Stock	0.5908	0.592	0.5891	0.5915	39694640.0
2015-08-13 12:00:00	NVDA	Stock	0.5918	0.594	0.5915	0.5934	25127000.0
2015-08-13 13:00:00	NVDA	Stock	0.5933	0.5945	0.5905	0.5915	22813600.0
2015-08-13 14:00:00	NVDA	Stock	0.5915	0.5935	0.5908	0.5915	17412560.0
2015-08-13 15:00:00	NVDA	Stock	0.5912	0.5918	0.5875	0.588	64513440.0
2015-08-13 16:00:00	NVDA	Stock	0.588	0.588	0.5878	0.5878	321600.0
2015-08-13 17:00:00	NVDA	Stock	0.5878	0.5878	0.5878	0.5878	16000.0
2015-08-13 18:00:00	NVDA	Stock	0.5883	0.5883	0.5883	0.5883	16000.0
2015-08-13 19:00:00	NVDA	Stock	0.5883	0.5883	0.5883	0.5883	12000.0
2015-08-13 07:00:00	AMZN	Stock	26.4345	26.457	26.4185	26.42	35000.0
2015-08-13 08:00:00	AMZN	Stock	26.385	26.4595	26.34	26.379	156380.0
2015-08-13 09:00:00	AMZN	Stock	26.3855	26.549	26.2742	26.53	6849060.0
2015-08-13 10:00:00	AMZN	Stock	26.535	26.6945	26.408	26.6	11918240.0
2015-08-13 11:00:00	AMZN	Stock	26.605	26.6665	26.5015	26.625	5374060.0
2015-08-13 12:00:00	AMZN	Stock	26.632	26.725	26.605	26.689	5805200.0

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

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