PREVIEW / stock_1hour / 2015-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-06.parquet
  size:    1.0 MB
  rows:    48,972
  symbols: 3,526

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-04-06 04:00:00	AAPL	Stock	31.2825	31.305	31.125	31.125	21512.0
2015-04-06 05:00:00	AAPL	Stock	31.125	31.125	31.125	31.125	3120.0
2015-04-06 06:00:00	AAPL	Stock	31.15	31.15	31.0925	31.0925	14804.0
2015-04-06 07:00:00	AAPL	Stock	31.135	31.17	31.125	31.15	147836.0
2015-04-06 08:00:00	AAPL	Stock	31.1575	31.165	31.085	31.1198	699528.0
2015-04-06 09:00:00	AAPL	Stock	31.115	31.4625	31.0825	31.4475	20340256.0
2015-04-06 10:00:00	AAPL	Stock	31.4498	31.79	31.4498	31.7475	33952440.0
2015-04-06 11:00:00	AAPL	Stock	31.7475	31.7975	31.6675	31.7835	16162180.0
2015-04-06 12:00:00	AAPL	Stock	31.7825	31.83	31.7575	31.7875	12430964.0
2015-04-06 13:00:00	AAPL	Stock	31.785	31.84	31.7825	31.798	9961624.0
2015-04-06 14:00:00	AAPL	Stock	31.8	31.81	31.735	31.81	10330896.0
2015-04-06 15:00:00	AAPL	Stock	31.8085	31.8775	31.775	31.835	23941980.0
2015-04-06 16:00:00	AAPL	Stock	31.8375	31.8625	31.674	31.85	6262308.0
2015-04-06 17:00:00	AAPL	Stock	31.85	31.8725	31.8375	31.8725	108904.0
2015-04-06 18:00:00	AAPL	Stock	31.8625	31.875	31.855	31.8698	110060.0
2015-04-06 19:00:00	AAPL	Stock	31.8698	31.8875	31.8625	31.8625	208692.0
2015-04-06 04:00:00	MSFT	Stock	40.15	40.15	40.15	40.15	100.0
2015-04-06 05:00:00	MSFT	Stock	40.27	40.27	40.25	40.27	2300.0
2015-04-06 06:00:00	MSFT	Stock	40.25	40.43	40.25	40.43	1700.0
2015-04-06 07:00:00	MSFT	Stock	40.43	40.51	40.43	40.51	4900.0
2015-04-06 08:00:00	MSFT	Stock	40.45	40.5	40.41	40.45	18396.0
2015-04-06 09:00:00	MSFT	Stock	40.44	40.65	40.18	40.58	4487604.0
2015-04-06 10:00:00	MSFT	Stock	40.59	40.97	40.55	40.945	4873125.0
2015-04-06 11:00:00	MSFT	Stock	40.94	41.13	40.94	41.105	3630513.0
2015-04-06 12:00:00	MSFT	Stock	41.11	41.31	41.08	41.3	2851579.0
2015-04-06 13:00:00	MSFT	Stock	41.3	41.47	41.3	41.447	3278663.0
2015-04-06 14:00:00	MSFT	Stock	41.44	41.53	41.39	41.51	2834933.0
2015-04-06 15:00:00	MSFT	Stock	41.51	41.78	41.495	41.55	11719378.0
2015-04-06 16:00:00	MSFT	Stock	41.545	41.6	41.2	41.2	4066566.0
2015-04-06 17:00:00	MSFT	Stock	41.53	41.54	41.5	41.54	2330.0
2015-04-06 18:00:00	MSFT	Stock	41.51	41.54	41.51	41.51	929.0
2015-04-06 19:00:00	MSFT	Stock	41.54	41.58	41.54	41.58	780.0
2015-04-06 04:00:00	NVDA	Stock	0.525	0.525	0.525	0.525	4000.0
2015-04-06 08:00:00	NVDA	Stock	0.525	0.525	0.525	0.525	8000.0
2015-04-06 09:00:00	NVDA	Stock	0.524	0.5253	0.5188	0.5235	28330680.0
2015-04-06 10:00:00	NVDA	Stock	0.5238	0.5285	0.523	0.5272	24205000.0
2015-04-06 11:00:00	NVDA	Stock	0.5272	0.5331	0.5262	0.5319	68238720.0
2015-04-06 12:00:00	NVDA	Stock	0.532	0.5356	0.5318	0.5348	26545920.0
2015-04-06 13:00:00	NVDA	Stock	0.535	0.5372	0.5348	0.5366	22022480.0
2015-04-06 14:00:00	NVDA	Stock	0.5365	0.5388	0.535	0.5367	37446120.0
2015-04-06 15:00:00	NVDA	Stock	0.5369	0.5435	0.5365	0.5418	250549520.0
2015-04-06 16:00:00	NVDA	Stock	0.5416	0.5416	0.541	0.541	1625920.0
2015-04-06 17:00:00	NVDA	Stock	0.5472	0.5472	0.5472	0.5472	4000.0
2015-04-06 08:00:00	AMZN	Stock	18.5	18.5625	18.475	18.5475	51920.0
2015-04-06 09:00:00	AMZN	Stock	18.494	18.696	18.468	18.674	4656260.0
2015-04-06 10:00:00	AMZN	Stock	18.6785	18.8295	18.6155	18.7715	8977120.0
2015-04-06 11:00:00	AMZN	Stock	18.768	18.7828	18.723	18.745	5280980.0
2015-04-06 12:00:00	AMZN	Stock	18.7435	18.8725	18.735	18.87	6272060.0
2015-04-06 13:00:00	AMZN	Stock	18.8675	18.9685	18.8675	18.9685	6470780.0
2015-04-06 14:00:00	AMZN	Stock	18.9655	19.01	18.9165	18.926	8235620.0

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

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