PREVIEW / stock_1hour / 2019-02-19

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-19.parquet
  size:    1.1 MB
  rows:    50,321
  symbols: 2,662

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-02-19 04:00:00	AAPL	Stock	42.6175	42.6175	42.475	42.475	6420.0
2019-02-19 05:00:00	AAPL	Stock	42.5	42.525	42.45	42.475	14700.0
2019-02-19 06:00:00	AAPL	Stock	42.47	42.5	42.375	42.375	20500.0
2019-02-19 07:00:00	AAPL	Stock	42.44	42.5125	42.44	42.5	87968.0
2019-02-19 08:00:00	AAPL	Stock	42.4578	42.525	42.3525	42.4625	289276.0
2019-02-19 09:00:00	AAPL	Stock	42.4675	42.75	42.3575	42.525	11401656.0
2019-02-19 10:00:00	AAPL	Stock	42.525	42.5625	42.3787	42.5325	11762100.0
2019-02-19 11:00:00	AAPL	Stock	42.5338	42.6975	42.51	42.6875	7564876.0
2019-02-19 12:00:00	AAPL	Stock	42.68	42.6975	42.6275	42.64	5616780.0
2019-02-19 13:00:00	AAPL	Stock	42.6388	42.675	42.5775	42.655	3689372.0
2019-02-19 14:00:00	AAPL	Stock	42.655	42.86	42.65	42.852	6542812.0
2019-02-19 15:00:00	AAPL	Stock	42.8525	42.855	42.685	42.735	9768608.0
2019-02-19 16:00:00	AAPL	Stock	42.7325	42.7328	42.5868	42.7325	7504380.0
2019-02-19 17:00:00	AAPL	Stock	42.725	42.7325	42.715	42.7175	22064.0
2019-02-19 18:00:00	AAPL	Stock	42.7125	42.735	42.7075	42.71	14552.0
2019-02-19 19:00:00	AAPL	Stock	42.7075	42.75	42.7075	42.75	22856.0
2019-02-19 04:00:00	MSFT	Stock	108.23	108.23	108.1	108.1	600.0
2019-02-19 05:00:00	MSFT	Stock	108.03	108.1	108.0	108.1	469.0
2019-02-19 06:00:00	MSFT	Stock	107.95	108.0	107.95	108.0	300.0
2019-02-19 07:00:00	MSFT	Stock	107.93	108.03	107.87	108.03	5188.0
2019-02-19 08:00:00	MSFT	Stock	107.98	108.1	107.85	108.06	11635.0
2019-02-19 09:00:00	MSFT	Stock	107.92	108.21	107.72	108.043	2080959.0
2019-02-19 10:00:00	MSFT	Stock	108.05	108.28	107.95	108.19	1947254.0
2019-02-19 11:00:00	MSFT	Stock	108.19	108.61	107.98	108.59	2083457.0
2019-02-19 12:00:00	MSFT	Stock	108.59	108.66	108.45	108.45	1399295.0
2019-02-19 13:00:00	MSFT	Stock	108.46	108.48	108.215	108.3	1192438.0
2019-02-19 14:00:00	MSFT	Stock	108.292	108.51	108.26	108.494	1634511.0
2019-02-19 15:00:00	MSFT	Stock	108.5	108.505	108.09	108.24	3156303.0
2019-02-19 16:00:00	MSFT	Stock	108.17	108.17	108.06	108.07	1983247.0
2019-02-19 17:00:00	MSFT	Stock	108.23	108.24	108.22	108.22	1347.0
2019-02-19 18:00:00	MSFT	Stock	108.18	108.18	108.12	108.16	5136.0
2019-02-19 19:00:00	MSFT	Stock	108.13	108.17	108.08	108.17	5373.0
2019-02-19 04:00:00	NVDA	Stock	3.925	3.93	3.925	3.925	98000.0
2019-02-19 05:00:00	NVDA	Stock	3.93	3.9425	3.93	3.934	119320.0
2019-02-19 06:00:00	NVDA	Stock	3.9263	3.9263	3.9263	3.9263	7440.0
2019-02-19 07:00:00	NVDA	Stock	3.9242	3.9242	3.9005	3.9198	519480.0
2019-02-19 08:00:00	NVDA	Stock	3.9052	3.9238	3.9002	3.91	1316720.0
2019-02-19 09:00:00	NVDA	Stock	3.9085	3.9972	3.9028	3.9757	104972160.0
2019-02-19 10:00:00	NVDA	Stock	3.9752	3.9948	3.9678	3.9755	84352480.0
2019-02-19 11:00:00	NVDA	Stock	3.976	3.99	3.9642	3.9788	60398520.0
2019-02-19 12:00:00	NVDA	Stock	3.9786	3.9788	3.9438	3.9462	43512360.0
2019-02-19 13:00:00	NVDA	Stock	3.946	3.9605	3.9438	3.9589	28144800.0
2019-02-19 14:00:00	NVDA	Stock	3.9583	3.9678	3.9498	3.9537	39217400.0
2019-02-19 15:00:00	NVDA	Stock	3.9538	3.956	3.91	3.9158	88954160.0
2019-02-19 16:00:00	NVDA	Stock	3.916	3.9185	3.9088	3.9168	22378640.0
2019-02-19 17:00:00	NVDA	Stock	3.9148	3.92	3.9118	3.9188	411320.0
2019-02-19 18:00:00	NVDA	Stock	3.9218	3.9218	3.9162	3.9188	67400.0
2019-02-19 19:00:00	NVDA	Stock	3.9182	3.9263	3.9175	3.925	378720.0
2019-02-19 04:00:00	AMZN	Stock	80.8	80.8	80.4	80.4	9580.0
2019-02-19 06:00:00	AMZN	Stock	80.325	80.325	80.15	80.175	15360.0

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

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