PREVIEW / stock_1hour / 2018-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-09.parquet
  size:    1.1 MB
  rows:    49,081
  symbols: 2,868

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-03-09 04:00:00	AAPL	Stock	44.2675	44.335	44.2675	44.335	1372.0
2018-03-09 05:00:00	AAPL	Stock	44.2375	44.3475	44.235	44.235	10372.0
2018-03-09 06:00:00	AAPL	Stock	44.2475	44.2475	44.235	44.235	2400.0
2018-03-09 07:00:00	AAPL	Stock	44.23	44.3175	44.23	44.275	131556.0
2018-03-09 08:00:00	AAPL	Stock	44.275	44.5375	44.125	44.525	850652.0
2018-03-09 09:00:00	AAPL	Stock	44.5125	44.61	44.3475	44.495	15130844.0
2018-03-09 10:00:00	AAPL	Stock	44.495	44.7275	44.485	44.65	16729972.0
2018-03-09 11:00:00	AAPL	Stock	44.65	44.9075	44.6425	44.8575	15695876.0
2018-03-09 12:00:00	AAPL	Stock	44.8575	44.9125	44.7325	44.7725	10718940.0
2018-03-09 13:00:00	AAPL	Stock	44.7775	44.8825	44.73	44.8728	9275476.0
2018-03-09 14:00:00	AAPL	Stock	44.8775	44.9275	44.8175	44.91	9489608.0
2018-03-09 15:00:00	AAPL	Stock	44.9125	45.0	44.89	44.99	24632364.0
2018-03-09 16:00:00	AAPL	Stock	44.995	45.0	44.784	44.975	10763812.0
2018-03-09 17:00:00	AAPL	Stock	44.9675	44.9875	44.9525	44.9525	59036.0
2018-03-09 18:00:00	AAPL	Stock	44.9525	44.96	44.925	44.9475	25708.0
2018-03-09 19:00:00	AAPL	Stock	44.9275	44.975	44.925	44.9625	39500.0
2018-03-09 05:00:00	MSFT	Stock	94.26	94.26	94.26	94.26	500.0
2018-03-09 07:00:00	MSFT	Stock	94.45	94.45	94.45	94.45	200.0
2018-03-09 08:00:00	MSFT	Stock	94.55	95.3	94.4	95.21	77881.0
2018-03-09 09:00:00	MSFT	Stock	95.15	95.59	95.0	95.425	3837462.0
2018-03-09 10:00:00	MSFT	Stock	95.43	96.02	95.21	95.89	4812727.0
2018-03-09 11:00:00	MSFT	Stock	95.9	95.95	95.6	95.83	3443731.0
2018-03-09 12:00:00	MSFT	Stock	95.83	96.26	95.83	96.016	3982676.0
2018-03-09 13:00:00	MSFT	Stock	96.02	96.29	96.015	96.195	2595256.0
2018-03-09 14:00:00	MSFT	Stock	96.2	96.355	96.06	96.165	3019863.0
2018-03-09 15:00:00	MSFT	Stock	96.165	96.54	96.09	96.54	8358791.0
2018-03-09 16:00:00	MSFT	Stock	96.54	96.54	96.09	96.2	4448644.0
2018-03-09 17:00:00	MSFT	Stock	96.2	96.54	96.2	96.23	14739.0
2018-03-09 18:00:00	MSFT	Stock	96.23	96.3	96.17	96.26	6029.0
2018-03-09 19:00:00	MSFT	Stock	96.29	96.29	96.23	96.28	4427.0
2018-03-09 06:00:00	NVDA	Stock	6.0303	6.0303	6.0295	6.0295	26640.0
2018-03-09 07:00:00	NVDA	Stock	6.0295	6.0468	6.0295	6.04	161280.0
2018-03-09 08:00:00	NVDA	Stock	6.037	6.0813	6.015	6.07	4449760.0
2018-03-09 09:00:00	NVDA	Stock	6.0725	6.1233	6.0612	6.1193	107602960.0
2018-03-09 10:00:00	NVDA	Stock	6.1185	6.1462	6.11	6.1149	96619080.0
2018-03-09 11:00:00	NVDA	Stock	6.1155	6.135	6.1058	6.1234	48380680.0
2018-03-09 12:00:00	NVDA	Stock	6.1228	6.1365	6.1038	6.1038	42507160.0
2018-03-09 13:00:00	NVDA	Stock	6.104	6.1102	6.0825	6.1035	50049280.0
2018-03-09 14:00:00	NVDA	Stock	6.105	6.112	6.081	6.1025	45274960.0
2018-03-09 15:00:00	NVDA	Stock	6.1023	6.1332	6.098	6.1332	91032600.0
2018-03-09 16:00:00	NVDA	Stock	6.1332	6.1332	6.0972	6.1225	3704600.0
2018-03-09 17:00:00	NVDA	Stock	6.1275	6.1322	6.125	6.13	409720.0
2018-03-09 18:00:00	NVDA	Stock	6.125	6.1322	6.125	6.1322	105080.0
2018-03-09 19:00:00	NVDA	Stock	6.1322	6.1328	6.125	6.1322	132600.0
2018-03-09 05:00:00	AMZN	Stock	77.7	77.7	77.6255	77.6255	12000.0
2018-03-09 06:00:00	AMZN	Stock	77.714	77.7725	77.6925	77.7725	27020.0
2018-03-09 07:00:00	AMZN	Stock	77.6995	77.849	77.661	77.839	135360.0
2018-03-09 08:00:00	AMZN	Stock	77.7445	78.264	77.6695	78.218	718380.0
2018-03-09 09:00:00	AMZN	Stock	78.2045	78.256	77.954	78.0545	12448400.0
2018-03-09 10:00:00	AMZN	Stock	78.0555	78.2625	77.979	78.1905	8607000.0

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

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