PREVIEW / stock_1hour / 2018-01-11

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-11.parquet
  size:    1.1 MB
  rows:    50,118
  symbols: 2,906

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-01-11 04:00:00	AAPL	Stock	43.62	43.62	43.5725	43.5725	800.0
2018-01-11 05:00:00	AAPL	Stock	43.5625	43.5625	43.5	43.5	7200.0
2018-01-11 06:00:00	AAPL	Stock	43.5875	43.5875	43.525	43.525	2800.0
2018-01-11 07:00:00	AAPL	Stock	43.595	43.6875	43.575	43.675	64464.0
2018-01-11 08:00:00	AAPL	Stock	43.675	43.7	43.5775	43.65	183788.0
2018-01-11 09:00:00	AAPL	Stock	43.6475	43.87	43.585	43.775	12741852.0
2018-01-11 10:00:00	AAPL	Stock	43.7775	43.8722	43.705	43.8105	9930824.0
2018-01-11 11:00:00	AAPL	Stock	43.81	43.8475	43.745	43.77	7585708.0
2018-01-11 12:00:00	AAPL	Stock	43.7712	43.8225	43.7375	43.8025	6728428.0
2018-01-11 13:00:00	AAPL	Stock	43.805	43.8175	43.725	43.759	4267632.0
2018-01-11 14:00:00	AAPL	Stock	43.7575	43.8013	43.7375	43.765	4687804.0
2018-01-11 15:00:00	AAPL	Stock	43.7625	43.8375	43.7475	43.8175	11047660.0
2018-01-11 16:00:00	AAPL	Stock	43.82	43.8375	43.5125	43.82	7476960.0
2018-01-11 17:00:00	AAPL	Stock	43.82	43.83	43.8	43.8225	3016412.0
2018-01-11 18:00:00	AAPL	Stock	43.815	43.8225	43.8025	43.8025	22456.0
2018-01-11 19:00:00	AAPL	Stock	43.8125	43.8125	43.7875	43.81	20652.0
2018-01-11 04:00:00	MSFT	Stock	87.96	87.99	87.96	87.99	364.0
2018-01-11 07:00:00	MSFT	Stock	88.03	88.2	88.03	88.2	933.0
2018-01-11 08:00:00	MSFT	Stock	88.03	88.15	88.03	88.1	17896.0
2018-01-11 09:00:00	MSFT	Stock	88.1	88.13	87.24	87.75	2391945.0
2018-01-11 10:00:00	MSFT	Stock	87.745	87.97	87.52	87.649	2186540.0
2018-01-11 11:00:00	MSFT	Stock	87.65	87.865	87.644	87.855	1343453.0
2018-01-11 12:00:00	MSFT	Stock	87.86	88.09	87.79	88.025	1770704.0
2018-01-11 13:00:00	MSFT	Stock	88.027	88.065	87.85	87.91	1017496.0
2018-01-11 14:00:00	MSFT	Stock	87.91	87.945	87.705	87.725	1181208.0
2018-01-11 15:00:00	MSFT	Stock	87.725	88.08	87.67	88.06	3575783.0
2018-01-11 16:00:00	MSFT	Stock	88.08	88.2	87.847	88.11	1959154.0
2018-01-11 17:00:00	MSFT	Stock	88.11	88.26	88.08	88.26	914891.0
2018-01-11 18:00:00	MSFT	Stock	88.2	88.25	88.2	88.25	3864.0
2018-01-11 19:00:00	MSFT	Stock	88.25	88.27	88.16	88.27	4450.0
2018-01-11 04:00:00	NVDA	Stock	5.59	5.59	5.59	5.59	39640.0
2018-01-11 06:00:00	NVDA	Stock	5.592	5.6002	5.59	5.59	109040.0
2018-01-11 07:00:00	NVDA	Stock	5.597	5.6175	5.597	5.6158	578400.0
2018-01-11 08:00:00	NVDA	Stock	5.5998	5.6188	5.5975	5.615	1526080.0
2018-01-11 09:00:00	NVDA	Stock	5.6112	5.6568	5.5925	5.6178	107384360.0
2018-01-11 10:00:00	NVDA	Stock	5.62	5.6315	5.5803	5.622	79497920.0
2018-01-11 11:00:00	NVDA	Stock	5.6214	5.6388	5.6103	5.6225	44684960.0
2018-01-11 12:00:00	NVDA	Stock	5.6225	5.6288	5.612	5.622	26509040.0
2018-01-11 13:00:00	NVDA	Stock	5.623	5.6275	5.5963	5.61	26684920.0
2018-01-11 14:00:00	NVDA	Stock	5.61	5.6215	5.6096	5.6195	17089240.0
2018-01-11 15:00:00	NVDA	Stock	5.6188	5.6193	5.597	5.6012	48472720.0
2018-01-11 16:00:00	NVDA	Stock	5.602	5.6045	5.5938	5.6005	4117440.0
2018-01-11 17:00:00	NVDA	Stock	5.6038	5.6038	5.5963	5.5998	288320.0
2018-01-11 18:00:00	NVDA	Stock	5.5998	5.603	5.5988	5.5988	94280.0
2018-01-11 19:00:00	NVDA	Stock	5.5985	5.5985	5.5875	5.589	442040.0
2018-01-11 06:00:00	AMZN	Stock	62.85	62.925	62.85	62.925	4000.0
2018-01-11 07:00:00	AMZN	Stock	62.91	63.0935	62.91	63.0565	115880.0
2018-01-11 08:00:00	AMZN	Stock	63.0695	63.097	62.95	62.9795	372960.0
2018-01-11 09:00:00	AMZN	Stock	62.965	63.15	62.823	62.9065	9720380.0
2018-01-11 10:00:00	AMZN	Stock	62.9345	63.0935	62.915	63.0027	7419720.0

> showing 50 of 50,118 rows — these rows as CSV

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