PREVIEW / stock_1hour / 2015-10-22

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-22.parquet
  size:    1.0 MB
  rows:    48,422
  symbols: 3,416

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-10-22 06:00:00	AAPL	Stock	28.525	28.5475	28.4775	28.4775	9000.0
2015-10-22 07:00:00	AAPL	Stock	28.5125	28.525	28.4725	28.495	44720.0
2015-10-22 08:00:00	AAPL	Stock	28.49	28.6225	28.3875	28.62	452372.0
2015-10-22 09:00:00	AAPL	Stock	28.6075	28.745	28.535	28.6725	18965344.0
2015-10-22 10:00:00	AAPL	Stock	28.6725	28.795	28.587	28.765	22511816.0
2015-10-22 11:00:00	AAPL	Stock	28.7625	28.7975	28.525	28.6775	25173808.0
2015-10-22 12:00:00	AAPL	Stock	28.68	28.78	28.68	28.7548	16897552.0
2015-10-22 13:00:00	AAPL	Stock	28.755	28.7775	28.6625	28.715	14939124.0
2015-10-22 14:00:00	AAPL	Stock	28.715	28.86	28.635	28.86	20422592.0
2015-10-22 15:00:00	AAPL	Stock	28.86	28.875	28.8002	28.8725	26034828.0
2015-10-22 16:00:00	AAPL	Stock	28.875	29.04	28.84	28.9825	9665896.0
2015-10-22 17:00:00	AAPL	Stock	29.0	29.035	28.9625	29.02	365816.0
2015-10-22 18:00:00	AAPL	Stock	29.015	29.07	29.0	29.07	180592.0
2015-10-22 19:00:00	AAPL	Stock	29.0725	29.1375	29.04	29.125	275496.0
2015-10-22 07:00:00	MSFT	Stock	47.4	47.4	47.39	47.39	200.0
2015-10-22 08:00:00	MSFT	Stock	47.3	47.45	47.3	47.44	14417.0
2015-10-22 09:00:00	MSFT	Stock	47.4	47.975	47.09	47.965	5283716.0
2015-10-22 10:00:00	MSFT	Stock	47.94	48.64	47.876	48.54	8123710.0
2015-10-22 11:00:00	MSFT	Stock	48.54	48.705	48.383	48.575	4575012.0
2015-10-22 12:00:00	MSFT	Stock	48.58	48.77	48.474	48.69	4490473.0
2015-10-22 13:00:00	MSFT	Stock	48.7	48.95	48.62	48.735	4736510.0
2015-10-22 14:00:00	MSFT	Stock	48.73	48.79	48.39	48.59	5469230.0
2015-10-22 15:00:00	MSFT	Stock	48.6	48.75	47.57	48.03	15923901.0
2015-10-22 16:00:00	MSFT	Stock	48.01	51.9	46.4	51.0	4890333.0
2015-10-22 17:00:00	MSFT	Stock	51.0	51.75	51.0	51.4	367462.0
2015-10-22 18:00:00	MSFT	Stock	51.37	52.7	51.11	51.8	341030.0
2015-10-22 19:00:00	MSFT	Stock	51.8	52.07	51.6	51.81	85578.0
2015-10-22 08:00:00	NVDA	Stock	0.69	0.69	0.69	0.69	20000.0
2015-10-22 09:00:00	NVDA	Stock	0.6935	0.705	0.6922	0.7015	41287400.0
2015-10-22 10:00:00	NVDA	Stock	0.7015	0.705	0.7	0.7039	40318520.0
2015-10-22 11:00:00	NVDA	Stock	0.7038	0.7085	0.7029	0.7062	29510640.0
2015-10-22 12:00:00	NVDA	Stock	0.7061	0.71	0.7051	0.7091	27555760.0
2015-10-22 13:00:00	NVDA	Stock	0.709	0.7123	0.7062	0.7064	55464720.0
2015-10-22 14:00:00	NVDA	Stock	0.7065	0.709	0.7025	0.7075	39415480.0
2015-10-22 15:00:00	NVDA	Stock	0.7078	0.7113	0.7072	0.7098	49410440.0
2015-10-22 16:00:00	NVDA	Stock	0.7098	0.7105	0.709	0.71	10681600.0
2015-10-22 17:00:00	NVDA	Stock	0.71	0.71	0.71	0.71	61880.0
2015-10-22 19:00:00	NVDA	Stock	0.7113	0.7113	0.7113	0.7113	94240.0
2015-10-22 04:00:00	AMZN	Stock	27.879	27.879	27.879	27.879	2180.0
2015-10-22 06:00:00	AMZN	Stock	27.975	28.0	27.975	28.0	10380.0
2015-10-22 07:00:00	AMZN	Stock	28.0515	28.075	28.0	28.0	60920.0
2015-10-22 08:00:00	AMZN	Stock	28.0385	28.12	27.9625	28.12	186340.0
2015-10-22 09:00:00	AMZN	Stock	28.122	28.2494	27.9	28.1055	10169360.0
2015-10-22 10:00:00	AMZN	Stock	28.126	28.175	27.93	28.1625	10077000.0
2015-10-22 11:00:00	AMZN	Stock	28.1625	28.4573	28.1575	28.423	14579460.0
2015-10-22 12:00:00	AMZN	Stock	28.419	28.44	28.2075	28.291	9907960.0
2015-10-22 13:00:00	AMZN	Stock	28.2908	28.4	28.15	28.168	9648320.0
2015-10-22 14:00:00	AMZN	Stock	28.167	28.205	27.95	28.025	11237800.0
2015-10-22 15:00:00	AMZN	Stock	28.026	28.2015	27.8335	28.1952	25877760.0
2015-10-22 16:00:00	AMZN	Stock	28.1955	31.75	28.1107	31.2	24102420.0

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

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