PREVIEW / stock_1hour / 2019-12-16

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-16.parquet
  size:    1.2 MB
  rows:    51,826
  symbols: 2,521

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
2019-12-16 04:00:00	AAPL	Stock	68.94	69.205	68.94	69.205	33276.0
2019-12-16 05:00:00	AAPL	Stock	69.1775	69.1775	69.05	69.1125	37564.0
2019-12-16 06:00:00	AAPL	Stock	69.1325	69.2	69.1125	69.1625	8888.0
2019-12-16 07:00:00	AAPL	Stock	69.125	69.2375	69.085	69.235	210100.0
2019-12-16 08:00:00	AAPL	Stock	69.1125	69.3575	69.085	69.2875	824808.0
2019-12-16 09:00:00	AAPL	Stock	69.3	69.8725	69.1875	69.75	20976820.0
2019-12-16 10:00:00	AAPL	Stock	69.7488	70.0412	69.7175	69.8675	18655048.0
2019-12-16 11:00:00	AAPL	Stock	69.8688	70.1175	69.8662	70.09	10021324.0
2019-12-16 12:00:00	AAPL	Stock	70.09	70.1975	70.0375	70.0468	8277972.0
2019-12-16 13:00:00	AAPL	Stock	70.0462	70.125	69.9583	70.1088	6032660.0
2019-12-16 14:00:00	AAPL	Stock	70.1075	70.15	69.9475	70.0375	7929136.0
2019-12-16 15:00:00	AAPL	Stock	70.04	70.125	69.9	69.965	13321052.0
2019-12-16 16:00:00	AAPL	Stock	69.965	70.095	69.9425	70.0625	16385672.0
2019-12-16 17:00:00	AAPL	Stock	70.0625	70.0625	70.0275	70.03	34952.0
2019-12-16 18:00:00	AAPL	Stock	70.0475	70.0625	70.005	70.015	47828.0
2019-12-16 19:00:00	AAPL	Stock	70.02	70.0625	69.965	70.0625	75696.0
2019-12-16 04:00:00	MSFT	Stock	155.2	155.4	155.2	155.25	5340.0
2019-12-16 05:00:00	MSFT	Stock	155.39	155.43	155.1	155.1	2300.0
2019-12-16 06:00:00	MSFT	Stock	155.17	155.34	155.17	155.24	872.0
2019-12-16 07:00:00	MSFT	Stock	155.17	155.35	155.15	155.29	13322.0
2019-12-16 08:00:00	MSFT	Stock	155.15	155.43	155.15	155.3	50328.0
2019-12-16 09:00:00	MSFT	Stock	155.2	155.9	154.53	155.57	2992784.0
2019-12-16 10:00:00	MSFT	Stock	155.57	155.61	155.16	155.318	2297292.0
2019-12-16 11:00:00	MSFT	Stock	155.32	155.35	155.13	155.25	1417239.0
2019-12-16 12:00:00	MSFT	Stock	155.244	155.36	155.18	155.265	1356757.0
2019-12-16 13:00:00	MSFT	Stock	155.265	155.595	155.2	155.54	1277177.0
2019-12-16 14:00:00	MSFT	Stock	155.55	155.6	155.21	155.435	1126985.0
2019-12-16 15:00:00	MSFT	Stock	155.438	155.85	155.325	155.54	2819221.0
2019-12-16 16:00:00	MSFT	Stock	155.53	155.65	155.413	155.65	5728367.0
2019-12-16 17:00:00	MSFT	Stock	155.6	155.6	155.56	155.57	4980.0
2019-12-16 18:00:00	MSFT	Stock	155.57	155.6	155.53	155.53	1411.0
2019-12-16 19:00:00	MSFT	Stock	155.6	155.61	155.45	155.6	5893.0
2019-12-16 04:00:00	NVDA	Stock	5.625	5.65	5.625	5.65	16120.0
2019-12-16 05:00:00	NVDA	Stock	5.6565	5.6565	5.65	5.65	18720.0
2019-12-16 06:00:00	NVDA	Stock	5.65	5.6585	5.65	5.6585	12000.0
2019-12-16 07:00:00	NVDA	Stock	5.6562	5.6585	5.6468	5.6575	290960.0
2019-12-16 08:00:00	NVDA	Stock	5.6571	5.67	5.6468	5.6688	1086920.0
2019-12-16 09:00:00	NVDA	Stock	5.6688	5.6875	5.6193	5.6528	51803360.0
2019-12-16 10:00:00	NVDA	Stock	5.6537	5.6828	5.6265	5.6752	60215000.0
2019-12-16 11:00:00	NVDA	Stock	5.6752	5.6932	5.6615	5.6845	36051040.0
2019-12-16 12:00:00	NVDA	Stock	5.6846	5.7016	5.6688	5.669	25824880.0
2019-12-16 13:00:00	NVDA	Stock	5.6686	5.6751	5.6639	5.6688	35492640.0
2019-12-16 14:00:00	NVDA	Stock	5.6693	5.6728	5.6373	5.6412	17826320.0
2019-12-16 15:00:00	NVDA	Stock	5.6413	5.6548	5.6275	5.63	32160000.0
2019-12-16 16:00:00	NVDA	Stock	5.6288	5.6348	5.6268	5.634	23194600.0
2019-12-16 17:00:00	NVDA	Stock	5.6343	5.6375	5.63	5.635	145160.0
2019-12-16 18:00:00	NVDA	Stock	5.6338	5.6368	5.6295	5.6313	136920.0
2019-12-16 19:00:00	NVDA	Stock	5.6272	5.631	5.625	5.631	160120.0
2019-12-16 06:00:00	AMZN	Stock	88.45	88.45	88.45	88.45	2000.0
2019-12-16 07:00:00	AMZN	Stock	88.39	88.4	88.3155	88.4	86040.0

> showing 50 of 51,826 rows — these rows as CSV

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