PREVIEW / stock_1hour / 2018-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-31.parquet
  size:    1.1 MB
  rows:    49,432
  symbols: 2,818

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-07-31 04:00:00	AAPL	Stock	47.5825	47.5825	47.5425	47.5475	9776.0
2018-07-31 05:00:00	AAPL	Stock	47.5525	47.57	47.515	47.5375	37720.0
2018-07-31 06:00:00	AAPL	Stock	47.5225	47.5625	47.5225	47.56	30476.0
2018-07-31 07:00:00	AAPL	Stock	47.5525	47.7125	47.54	47.7075	169780.0
2018-07-31 08:00:00	AAPL	Stock	47.7025	47.7082	47.5538	47.6025	262220.0
2018-07-31 09:00:00	AAPL	Stock	47.61	47.7675	47.4775	47.5522	11801744.0
2018-07-31 10:00:00	AAPL	Stock	47.55	47.5975	47.335	47.4175	13223696.0
2018-07-31 11:00:00	AAPL	Stock	47.415	47.6375	47.4125	47.635	10143108.0
2018-07-31 12:00:00	AAPL	Stock	47.6375	48.035	47.6375	47.9075	15758340.0
2018-07-31 13:00:00	AAPL	Stock	47.91	47.9915	47.74	47.835	12058320.0
2018-07-31 14:00:00	AAPL	Stock	47.8375	47.9675	47.7225	47.895	9440688.0
2018-07-31 15:00:00	AAPL	Stock	47.895	47.8975	47.5875	47.645	23702980.0
2018-07-31 16:00:00	AAPL	Stock	47.655	49.1625	47.4775	48.925	27775728.0
2018-07-31 17:00:00	AAPL	Stock	48.93	49.4325	48.012	49.25	6900396.0
2018-07-31 18:00:00	AAPL	Stock	49.25	49.5	49.1975	49.2975	2578452.0
2018-07-31 19:00:00	AAPL	Stock	49.2875	49.5	49.2275	49.4875	1349096.0
2018-07-31 04:00:00	MSFT	Stock	106.0	106.25	105.93	105.97	6269.0
2018-07-31 05:00:00	MSFT	Stock	105.87	105.87	105.7	105.86	3971.0
2018-07-31 06:00:00	MSFT	Stock	105.63	105.94	105.57	105.94	3330.0
2018-07-31 07:00:00	MSFT	Stock	105.92	105.95	105.7	105.9	6717.0
2018-07-31 08:00:00	MSFT	Stock	105.8	106.04	105.73	105.73	65656.0
2018-07-31 09:00:00	MSFT	Stock	105.73	106.7	105.7	105.77	4129976.0
2018-07-31 10:00:00	MSFT	Stock	105.765	106.07	105.38	105.72	3705462.0
2018-07-31 11:00:00	MSFT	Stock	105.71	106.495	105.69	106.385	2598428.0
2018-07-31 12:00:00	MSFT	Stock	106.385	106.72	106.24	106.38	1848850.0
2018-07-31 13:00:00	MSFT	Stock	106.38	106.48	106.105	106.45	1438929.0
2018-07-31 14:00:00	MSFT	Stock	106.46	106.48	106.04	106.3	1756269.0
2018-07-31 15:00:00	MSFT	Stock	106.3	106.3	105.93	106.1	4172588.0
2018-07-31 16:00:00	MSFT	Stock	106.11	106.5	105.37	106.35	4976806.0
2018-07-31 17:00:00	MSFT	Stock	106.22	107.06	105.036	106.54	73941.0
2018-07-31 18:00:00	MSFT	Stock	106.52	106.52	105.48	105.84	45892.0
2018-07-31 19:00:00	MSFT	Stock	105.71	106.23	105.5	106.23	31107.0
2018-07-31 05:00:00	NVDA	Stock	6.0875	6.0875	6.0875	6.0875	12000.0
2018-07-31 07:00:00	NVDA	Stock	6.112	6.1275	6.112	6.125	72440.0
2018-07-31 08:00:00	NVDA	Stock	6.112	6.1423	6.112	6.1175	421120.0
2018-07-31 09:00:00	NVDA	Stock	6.12	6.1748	6.0751	6.1065	37594160.0
2018-07-31 10:00:00	NVDA	Stock	6.1066	6.1345	6.0535	6.1155	45579040.0
2018-07-31 11:00:00	NVDA	Stock	6.1176	6.1825	6.1176	6.1775	30923680.0
2018-07-31 12:00:00	NVDA	Stock	6.1788	6.197	6.1539	6.1718	20651640.0
2018-07-31 13:00:00	NVDA	Stock	6.1715	6.1782	6.1545	6.168	15540400.0
2018-07-31 14:00:00	NVDA	Stock	6.1672	6.1818	6.1515	6.1722	17945800.0
2018-07-31 15:00:00	NVDA	Stock	6.1718	6.1718	6.0815	6.1208	57193480.0
2018-07-31 16:00:00	NVDA	Stock	6.1215	6.17	6.0988	6.1665	20741960.0
2018-07-31 17:00:00	NVDA	Stock	6.1625	6.1781	6.0612	6.1675	904560.0
2018-07-31 18:00:00	NVDA	Stock	6.167	6.1725	6.125	6.1375	700320.0
2018-07-31 19:00:00	NVDA	Stock	6.139	6.1585	6.1388	6.1585	259640.0
2018-07-31 04:00:00	AMZN	Stock	89.3505	89.45	89.3505	89.4295	17760.0
2018-07-31 05:00:00	AMZN	Stock	89.386	89.386	89.26	89.26	10000.0
2018-07-31 06:00:00	AMZN	Stock	89.35	89.3845	89.325	89.3535	14460.0
2018-07-31 07:00:00	AMZN	Stock	89.3535	89.575	89.3535	89.55	39780.0

> showing 50 of 49,432 rows — these rows as CSV

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