PREVIEW / stock_1hour / 2017-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-04.parquet
  size:    1.1 MB
  rows:    48,446
  symbols: 2,956

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
2017-10-04 05:00:00	AAPL	Stock	38.625	38.6625	38.625	38.6625	9540.0
2017-10-04 06:00:00	AAPL	Stock	38.635	38.635	38.5775	38.585	41948.0
2017-10-04 07:00:00	AAPL	Stock	38.6	38.62	38.3275	38.4675	291376.0
2017-10-04 08:00:00	AAPL	Stock	38.575	38.705	38.32	38.335	507724.0
2017-10-04 09:00:00	AAPL	Stock	38.35	38.435	38.2725	38.3838	12957528.0
2017-10-04 10:00:00	AAPL	Stock	38.3875	38.39	38.115	38.2562	16742388.0
2017-10-04 11:00:00	AAPL	Stock	38.26	38.4575	38.26	38.369	11125472.0
2017-10-04 12:00:00	AAPL	Stock	38.375	38.465	38.35	38.395	5974588.0
2017-10-04 13:00:00	AAPL	Stock	38.3975	38.41	38.28	38.34	5622288.0
2017-10-04 14:00:00	AAPL	Stock	38.34	38.36	38.2948	38.3475	4937544.0
2017-10-04 15:00:00	AAPL	Stock	38.3475	38.4075	38.295	38.3675	9670304.0
2017-10-04 16:00:00	AAPL	Stock	38.3675	38.4	38.3475	38.38	4469908.0
2017-10-04 17:00:00	AAPL	Stock	38.4	38.4275	38.3875	38.4	183084.0
2017-10-04 18:00:00	AAPL	Stock	38.4025	38.4075	38.3825	38.3975	67648.0
2017-10-04 19:00:00	AAPL	Stock	38.3975	38.3975	38.385	38.385	32168.0
2017-10-04 07:00:00	MSFT	Stock	74.3	74.3	74.3	74.3	200.0
2017-10-04 08:00:00	MSFT	Stock	74.22	74.22	74.22	74.22	800.0
2017-10-04 09:00:00	MSFT	Stock	74.22	74.25	73.82	73.88	1608307.0
2017-10-04 10:00:00	MSFT	Stock	73.89	73.97	73.71	73.91	1519639.0
2017-10-04 11:00:00	MSFT	Stock	73.905	74.18	73.905	74.13	1107914.0
2017-10-04 12:00:00	MSFT	Stock	74.14	74.44	74.125	74.22	949003.0
2017-10-04 13:00:00	MSFT	Stock	74.23	74.26	73.93	74.185	1002902.0
2017-10-04 14:00:00	MSFT	Stock	74.19	74.55	74.18	74.53	1412332.0
2017-10-04 15:00:00	MSFT	Stock	74.53	74.72	74.415	74.68	3225905.0
2017-10-04 16:00:00	MSFT	Stock	74.68	74.72	74.6	74.69	1324468.0
2017-10-04 17:00:00	MSFT	Stock	74.65	74.65	74.65	74.65	100.0
2017-10-04 18:00:00	MSFT	Stock	74.62	74.69	74.62	74.69	311.0
2017-10-04 19:00:00	MSFT	Stock	74.65	74.65	74.65	74.65	100.0
2017-10-04 04:00:00	NVDA	Stock	4.5	4.5063	4.5	4.5063	25280.0
2017-10-04 05:00:00	NVDA	Stock	4.5063	4.511	4.5	4.511	312600.0
2017-10-04 06:00:00	NVDA	Stock	4.5055	4.5055	4.5	4.5	27600.0
2017-10-04 07:00:00	NVDA	Stock	4.5	4.5	4.485	4.4938	236240.0
2017-10-04 08:00:00	NVDA	Stock	4.485	4.5	4.485	4.4875	1168040.0
2017-10-04 09:00:00	NVDA	Stock	4.4875	4.5	4.4535	4.4846	56402760.0
2017-10-04 10:00:00	NVDA	Stock	4.4848	4.518	4.483	4.502	76357400.0
2017-10-04 11:00:00	NVDA	Stock	4.5018	4.5443	4.5018	4.5322	75714000.0
2017-10-04 12:00:00	NVDA	Stock	4.5333	4.5428	4.5165	4.5232	38539920.0
2017-10-04 13:00:00	NVDA	Stock	4.5228	4.528	4.4941	4.5058	40278520.0
2017-10-04 14:00:00	NVDA	Stock	4.506	4.513	4.4975	4.5093	27270880.0
2017-10-04 15:00:00	NVDA	Stock	4.5095	4.526	4.506	4.5208	54695240.0
2017-10-04 16:00:00	NVDA	Stock	4.5218	4.5222	4.5124	4.5208	7184920.0
2017-10-04 17:00:00	NVDA	Stock	4.5182	4.5202	4.5155	4.5188	151640.0
2017-10-04 18:00:00	NVDA	Stock	4.5168	4.5188	4.5165	4.518	176400.0
2017-10-04 19:00:00	NVDA	Stock	4.5188	4.52	4.5175	4.5198	296360.0
2017-10-04 05:00:00	AMZN	Stock	47.7	47.7	47.568	47.568	4000.0
2017-10-04 07:00:00	AMZN	Stock	47.6	47.6395	47.568	47.625	43400.0
2017-10-04 08:00:00	AMZN	Stock	47.65	47.6995	47.6	47.6995	132060.0
2017-10-04 09:00:00	AMZN	Stock	47.6995	48.1344	47.6995	48.0822	7898920.0
2017-10-04 10:00:00	AMZN	Stock	48.0655	48.2755	48.034	48.269	8168220.0
2017-10-04 11:00:00	AMZN	Stock	48.271	48.384	48.1408	48.3232	6500540.0

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

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