PREVIEW / stock_1hour / 2019-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-01.parquet
  size:    1.1 MB
  rows:    50,076
  symbols: 2,665

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-03-01 04:00:00	AAPL	Stock	43.5125	43.6475	43.5125	43.61	6488.0
2019-03-01 05:00:00	AAPL	Stock	43.5925	43.6025	43.5925	43.5925	1676.0
2019-03-01 06:00:00	AAPL	Stock	43.5925	43.6	43.575	43.575	1600.0
2019-03-01 07:00:00	AAPL	Stock	43.585	43.625	43.5775	43.6	76988.0
2019-03-01 08:00:00	AAPL	Stock	43.6075	43.6375	43.2875	43.505	227900.0
2019-03-01 09:00:00	AAPL	Stock	43.5175	43.62	43.3948	43.555	8888820.0
2019-03-01 10:00:00	AAPL	Stock	43.5525	43.5538	43.345	43.42	9905532.0
2019-03-01 11:00:00	AAPL	Stock	43.4212	43.4263	43.2225	43.3348	10574660.0
2019-03-01 12:00:00	AAPL	Stock	43.335	43.56	43.325	43.5475	9690672.0
2019-03-01 13:00:00	AAPL	Stock	43.5475	43.6575	43.505	43.6287	7206236.0
2019-03-01 14:00:00	AAPL	Stock	43.63	43.7875	43.5825	43.7445	11069320.0
2019-03-01 15:00:00	AAPL	Stock	43.745	43.7825	43.67	43.7425	15398084.0
2019-03-01 16:00:00	AAPL	Stock	43.7425	43.77	43.7125	43.7475	17003208.0
2019-03-01 17:00:00	AAPL	Stock	43.75	43.7575	43.7375	43.7575	30024.0
2019-03-01 18:00:00	AAPL	Stock	43.7575	43.775	43.755	43.77	13248.0
2019-03-01 19:00:00	AAPL	Stock	43.7575	43.78	43.7575	43.78	30432.0
2019-03-01 04:00:00	MSFT	Stock	113.0	113.0	112.83	112.83	1090.0
2019-03-01 05:00:00	MSFT	Stock	112.95	112.98	112.93	112.98	2852.0
2019-03-01 06:00:00	MSFT	Stock	112.98	113.2	112.98	113.0	7899.0
2019-03-01 07:00:00	MSFT	Stock	112.89	113.06	112.78	112.8	36735.0
2019-03-01 08:00:00	MSFT	Stock	112.95	113.0	112.7	112.75	34853.0
2019-03-01 09:00:00	MSFT	Stock	112.78	113.02	112.36	112.49	2985855.0
2019-03-01 10:00:00	MSFT	Stock	112.46	112.53	111.955	112.077	2485898.0
2019-03-01 11:00:00	MSFT	Stock	112.08	112.121	111.665	111.83	1945557.0
2019-03-01 12:00:00	MSFT	Stock	111.82	112.41	111.764	112.37	1587499.0
2019-03-01 13:00:00	MSFT	Stock	112.36	112.52	112.28	112.45	1296451.0
2019-03-01 14:00:00	MSFT	Stock	112.45	112.77	112.36	112.57	1792733.0
2019-03-01 15:00:00	MSFT	Stock	112.58	112.7	112.41	112.52	3324751.0
2019-03-01 16:00:00	MSFT	Stock	112.52	112.6	112.0	112.55	3462121.0
2019-03-01 17:00:00	MSFT	Stock	112.55	112.6	112.53	112.6	10397.0
2019-03-01 18:00:00	MSFT	Stock	112.5	112.6	112.5	112.6	1147.0
2019-03-01 19:00:00	MSFT	Stock	112.6	112.61	112.55	112.55	4095.0
2019-03-01 04:00:00	NVDA	Stock	3.8812	3.92	3.8812	3.92	18360.0
2019-03-01 06:00:00	NVDA	Stock	3.9038	3.9038	3.9038	3.9038	4000.0
2019-03-01 07:00:00	NVDA	Stock	3.9112	3.9202	3.887	3.9138	1219680.0
2019-03-01 08:00:00	NVDA	Stock	3.892	3.9212	3.8565	3.915	1924000.0
2019-03-01 09:00:00	NVDA	Stock	3.916	3.9537	3.9068	3.9358	75986600.0
2019-03-01 10:00:00	NVDA	Stock	3.935	3.9367	3.8878	3.8958	49154800.0
2019-03-01 11:00:00	NVDA	Stock	3.896	3.8972	3.848	3.8632	38359480.0
2019-03-01 12:00:00	NVDA	Stock	3.8617	3.8916	3.8592	3.885	24055320.0
2019-03-01 13:00:00	NVDA	Stock	3.8846	3.905	3.883	3.901	20434720.0
2019-03-01 14:00:00	NVDA	Stock	3.8998	3.9285	3.8952	3.9146	31123800.0
2019-03-01 15:00:00	NVDA	Stock	3.9148	3.9195	3.8992	3.911	50467640.0
2019-03-01 16:00:00	NVDA	Stock	3.9112	3.9165	3.8996	3.9165	16733760.0
2019-03-01 17:00:00	NVDA	Stock	3.9112	3.917	3.9062	3.9162	306000.0
2019-03-01 18:00:00	NVDA	Stock	3.917	3.917	3.9115	3.9118	34640.0
2019-03-01 19:00:00	NVDA	Stock	3.9138	3.9148	3.9112	3.9112	87600.0
2019-03-01 04:00:00	AMZN	Stock	82.526	82.526	82.41	82.41	12880.0
2019-03-01 05:00:00	AMZN	Stock	82.45	82.45	82.45	82.45	4280.0
2019-03-01 06:00:00	AMZN	Stock	82.5045	82.55	82.5045	82.55	23120.0

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

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