PREVIEW / stock_1hour / 2018-02-16

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-16.parquet
  size:    1.1 MB
  rows:    48,813
  symbols: 2,890

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
2018-02-16 04:00:00	AAPL	Stock	43.3375	43.565	43.3375	43.5	68144.0
2018-02-16 05:00:00	AAPL	Stock	43.5	43.525	43.3	43.3	73732.0
2018-02-16 06:00:00	AAPL	Stock	43.305	43.4125	43.14	43.2375	116680.0
2018-02-16 07:00:00	AAPL	Stock	43.2375	43.31	43.1875	43.2	349540.0
2018-02-16 08:00:00	AAPL	Stock	43.225	43.305	43.0875	43.1	768984.0
2018-02-16 09:00:00	AAPL	Stock	43.1	43.475	42.9425	43.3175	24229272.0
2018-02-16 10:00:00	AAPL	Stock	43.3188	43.6455	43.155	43.505	27278116.0
2018-02-16 11:00:00	AAPL	Stock	43.5125	43.64	43.445	43.575	14777452.0
2018-02-16 12:00:00	AAPL	Stock	43.58	43.705	43.459	43.575	14589864.0
2018-02-16 13:00:00	AAPL	Stock	43.585	43.625	43.17	43.2765	18475388.0
2018-02-16 14:00:00	AAPL	Stock	43.2775	43.44	43.1275	43.3498	15567396.0
2018-02-16 15:00:00	AAPL	Stock	43.345	43.4525	43.1075	43.1125	20744532.0
2018-02-16 16:00:00	AAPL	Stock	43.1075	43.5097	43.1	43.1375	8042744.0
2018-02-16 17:00:00	AAPL	Stock	43.1	43.1225	43.0575	43.0625	71440.0
2018-02-16 18:00:00	AAPL	Stock	43.0625	43.0625	42.98	42.9875	114320.0
2018-02-16 19:00:00	AAPL	Stock	43.0125	43.0375	42.9875	42.9875	68280.0
2018-02-16 04:00:00	MSFT	Stock	93.19	93.51	93.19	93.51	5648.0
2018-02-16 05:00:00	MSFT	Stock	93.15	93.21	93.1	93.16	6977.0
2018-02-16 06:00:00	MSFT	Stock	93.11	93.15	92.86	93.09	8085.0
2018-02-16 07:00:00	MSFT	Stock	93.0	93.12	92.89	93.0	22536.0
2018-02-16 08:00:00	MSFT	Stock	93.0	93.1	92.5	92.65	52639.0
2018-02-16 09:00:00	MSFT	Stock	92.53	92.9	92.36	92.58	4086935.0
2018-02-16 10:00:00	MSFT	Stock	92.59	93.275	92.45	92.935	3294871.0
2018-02-16 11:00:00	MSFT	Stock	92.93	93.245	92.79	93.185	2109870.0
2018-02-16 12:00:00	MSFT	Stock	93.185	93.5	92.88	93.0	2554864.0
2018-02-16 13:00:00	MSFT	Stock	93.015	93.15	92.05	92.216	4266053.0
2018-02-16 14:00:00	MSFT	Stock	92.21	92.46	91.81	92.44	2869913.0
2018-02-16 15:00:00	MSFT	Stock	92.45	92.625	91.93	91.93	5412114.0
2018-02-16 16:00:00	MSFT	Stock	92.0	92.17	91.91	92.0	3810938.0
2018-02-16 17:00:00	MSFT	Stock	92.0	92.03	91.96	92.0	2095.0
2018-02-16 18:00:00	MSFT	Stock	92.0	92.0	91.98	92.0	4242.0
2018-02-16 19:00:00	MSFT	Stock	92.0	92.0	92.0	92.0	3668.0
2018-02-16 04:00:00	NVDA	Stock	6.2	6.2198	6.1803	6.1803	128360.0
2018-02-16 05:00:00	NVDA	Stock	6.18	6.18	6.1763	6.1778	88680.0
2018-02-16 06:00:00	NVDA	Stock	6.1808	6.182	6.1655	6.1655	98920.0
2018-02-16 07:00:00	NVDA	Stock	6.1785	6.1875	6.169	6.1788	515080.0
2018-02-16 08:00:00	NVDA	Stock	6.182	6.1875	6.1535	6.1612	3460080.0
2018-02-16 09:00:00	NVDA	Stock	6.1545	6.25	6.1119	6.2013	138544120.0
2018-02-16 10:00:00	NVDA	Stock	6.205	6.227	6.164	6.1899	96489520.0
2018-02-16 11:00:00	NVDA	Stock	6.189	6.2063	6.174	6.1888	52761400.0
2018-02-16 12:00:00	NVDA	Stock	6.1882	6.195	6.1528	6.1645	41514840.0
2018-02-16 13:00:00	NVDA	Stock	6.1675	6.173	6.0868	6.1238	75793360.0
2018-02-16 14:00:00	NVDA	Stock	6.1224	6.1465	6.0938	6.131	47369800.0
2018-02-16 15:00:00	NVDA	Stock	6.1302	6.135	6.0928	6.096	58336800.0
2018-02-16 16:00:00	NVDA	Stock	6.096	6.1245	6.0875	6.1245	10827560.0
2018-02-16 17:00:00	NVDA	Stock	6.1163	6.1163	6.1062	6.1118	85800.0
2018-02-16 18:00:00	NVDA	Stock	6.1083	6.115	6.1065	6.1098	273400.0
2018-02-16 19:00:00	NVDA	Stock	6.1123	6.1123	6.105	6.11	142160.0
2018-02-16 04:00:00	AMZN	Stock	73.495	73.553	73.495	73.5475	13940.0
2018-02-16 05:00:00	AMZN	Stock	73.5	73.5	73.419	73.419	26720.0

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

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