PREVIEW / stock_1hour / 2018-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-09.parquet
  size:    1.1 MB
  rows:    49,701
  symbols: 2,909

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-09 04:00:00	AAPL	Stock	43.6975	43.6975	43.6275	43.6275	2044.0
2018-01-09 05:00:00	AAPL	Stock	43.625	43.625	43.625	43.625	400.0
2018-01-09 06:00:00	AAPL	Stock	43.6	43.6625	43.5875	43.6325	39400.0
2018-01-09 07:00:00	AAPL	Stock	43.625	43.675	43.595	43.635	139768.0
2018-01-09 08:00:00	AAPL	Stock	43.675	43.7225	43.6	43.68	213672.0
2018-01-09 09:00:00	AAPL	Stock	43.68	43.7125	43.3525	43.405	14844060.0
2018-01-09 10:00:00	AAPL	Stock	43.4075	43.5462	43.3525	43.5025	12433460.0
2018-01-09 11:00:00	AAPL	Stock	43.505	43.6525	43.4812	43.635	8767220.0
2018-01-09 12:00:00	AAPL	Stock	43.6375	43.7275	43.5875	43.695	7385604.0
2018-01-09 13:00:00	AAPL	Stock	43.695	43.765	43.675	43.6875	6790376.0
2018-01-09 14:00:00	AAPL	Stock	43.69	43.6975	43.61	43.6975	6009496.0
2018-01-09 15:00:00	AAPL	Stock	43.6962	43.7025	43.55	43.5825	12982944.0
2018-01-09 16:00:00	AAPL	Stock	43.5825	43.5875	43.4775	43.5175	5863424.0
2018-01-09 17:00:00	AAPL	Stock	43.5125	43.525	43.5	43.5	39152.0
2018-01-09 18:00:00	AAPL	Stock	43.49	43.525	43.4875	43.5125	44532.0
2018-01-09 19:00:00	AAPL	Stock	43.51	43.52	43.5	43.5	19124.0
2018-01-09 06:00:00	MSFT	Stock	88.28	88.28	88.28	88.28	500.0
2018-01-09 07:00:00	MSFT	Stock	88.37	88.57	88.35	88.57	8108.0
2018-01-09 08:00:00	MSFT	Stock	88.59	88.59	88.51	88.55	10617.0
2018-01-09 09:00:00	MSFT	Stock	88.51	88.75	87.86	87.98	3327696.0
2018-01-09 10:00:00	MSFT	Stock	87.98	88.485	87.95	88.48	2253624.0
2018-01-09 11:00:00	MSFT	Stock	88.48	88.7	88.39	88.415	1759928.0
2018-01-09 12:00:00	MSFT	Stock	88.416	88.56	88.21	88.56	1529925.0
2018-01-09 13:00:00	MSFT	Stock	88.56	88.727	88.46	88.49	1480641.0
2018-01-09 14:00:00	MSFT	Stock	88.49	88.51	88.31	88.32	1497321.0
2018-01-09 15:00:00	MSFT	Stock	88.32	88.35	88.04	88.23	3733949.0
2018-01-09 16:00:00	MSFT	Stock	88.22	88.28	88.11	88.11	2310606.0
2018-01-09 17:00:00	MSFT	Stock	88.12	88.22	88.11	88.22	2634.0
2018-01-09 18:00:00	MSFT	Stock	88.2	88.22	88.01	88.22	761.0
2018-01-09 19:00:00	MSFT	Stock	88.1	88.22	88.1	88.22	671.0
2018-01-09 05:00:00	NVDA	Stock	5.5875	5.5875	5.587	5.587	23640.0
2018-01-09 06:00:00	NVDA	Stock	5.575	5.5868	5.57	5.5725	115600.0
2018-01-09 07:00:00	NVDA	Stock	5.5593	5.5712	5.55	5.5625	1523680.0
2018-01-09 08:00:00	NVDA	Stock	5.5623	5.575	5.555	5.5625	3820840.0
2018-01-09 09:00:00	NVDA	Stock	5.565	5.5748	5.466	5.4935	115149120.0
2018-01-09 10:00:00	NVDA	Stock	5.4945	5.5413	5.4743	5.5111	79623040.0
2018-01-09 11:00:00	NVDA	Stock	5.5105	5.5685	5.509	5.5658	62822880.0
2018-01-09 12:00:00	NVDA	Stock	5.5642	5.5955	5.55	5.5742	51937080.0
2018-01-09 13:00:00	NVDA	Stock	5.5733	5.587	5.5615	5.5785	27080160.0
2018-01-09 14:00:00	NVDA	Stock	5.578	5.5825	5.5635	5.5801	25001120.0
2018-01-09 15:00:00	NVDA	Stock	5.5803	5.5918	5.5458	5.5488	54356800.0
2018-01-09 16:00:00	NVDA	Stock	5.5485	5.5495	5.525	5.5263	2793720.0
2018-01-09 17:00:00	NVDA	Stock	5.5485	5.5485	5.523	5.5275	22745320.0
2018-01-09 18:00:00	NVDA	Stock	5.5312	5.5375	5.5263	5.5375	166160.0
2018-01-09 19:00:00	NVDA	Stock	5.535	5.55	5.535	5.5375	266600.0
2018-01-09 04:00:00	AMZN	Stock	62.413	62.413	62.413	62.413	6780.0
2018-01-09 05:00:00	AMZN	Stock	62.4	62.4	62.4	62.4	2000.0
2018-01-09 06:00:00	AMZN	Stock	62.521	62.5295	62.515	62.525	10720.0
2018-01-09 07:00:00	AMZN	Stock	62.5975	62.75	62.5975	62.6875	153860.0
2018-01-09 08:00:00	AMZN	Stock	62.69	62.75	62.653	62.7	469700.0

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

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