PREVIEW / stock_1hour / 2017-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-01.parquet
  size:    1.1 MB
  rows:    48,724
  symbols: 2,928

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
2017-11-01 04:00:00	AAPL	Stock	42.375	42.4625	42.375	42.39	31280.0
2017-11-01 05:00:00	AAPL	Stock	42.405	42.5	42.38	42.405	26948.0
2017-11-01 06:00:00	AAPL	Stock	42.485	42.5475	42.425	42.4325	84456.0
2017-11-01 07:00:00	AAPL	Stock	42.4375	42.5225	42.2	42.275	637960.0
2017-11-01 08:00:00	AAPL	Stock	42.2775	42.525	42.2275	42.3925	568372.0
2017-11-01 09:00:00	AAPL	Stock	42.3775	42.485	41.8275	41.9625	23775088.0
2017-11-01 10:00:00	AAPL	Stock	41.9525	41.965	41.6425	41.762	27147460.0
2017-11-01 11:00:00	AAPL	Stock	41.765	41.9	41.545	41.5575	14003228.0
2017-11-01 12:00:00	AAPL	Stock	41.5625	41.7675	41.545	41.64	9442652.0
2017-11-01 13:00:00	AAPL	Stock	41.64	41.7918	41.4025	41.5575	12495904.0
2017-11-01 14:00:00	AAPL	Stock	41.5575	41.6875	41.525	41.6698	10188348.0
2017-11-01 15:00:00	AAPL	Stock	41.6682	41.7225	41.6282	41.7175	14933328.0
2017-11-01 16:00:00	AAPL	Stock	41.7225	41.8475	41.655	41.835	6996552.0
2017-11-01 17:00:00	AAPL	Stock	41.825	41.825	41.7225	41.7825	420064.0
2017-11-01 18:00:00	AAPL	Stock	41.7825	41.8125	41.7325	41.7375	105236.0
2017-11-01 19:00:00	AAPL	Stock	41.735	41.745	41.68	41.68	216984.0
2017-11-01 04:00:00	MSFT	Stock	83.49	83.5	83.49	83.5	1100.0
2017-11-01 06:00:00	MSFT	Stock	83.67	83.74	83.67	83.7	2634.0
2017-11-01 07:00:00	MSFT	Stock	83.69	83.69	83.53	83.54	22341.0
2017-11-01 08:00:00	MSFT	Stock	83.6	83.68	83.53	83.55	6546.0
2017-11-01 09:00:00	MSFT	Stock	83.6	83.76	83.4	83.675	1934629.0
2017-11-01 10:00:00	MSFT	Stock	83.675	83.69	83.15	83.171	3474353.0
2017-11-01 11:00:00	MSFT	Stock	83.18	83.31	82.88	82.96	2669868.0
2017-11-01 12:00:00	MSFT	Stock	82.97	83.28	82.96	83.22	1625806.0
2017-11-01 13:00:00	MSFT	Stock	83.22	83.23	83.0	83.155	1808625.0
2017-11-01 14:00:00	MSFT	Stock	83.16	83.22	82.99	83.07	2606406.0
2017-11-01 15:00:00	MSFT	Stock	83.07	83.2	82.99	83.16	4398319.0
2017-11-01 16:00:00	MSFT	Stock	83.18	83.26	83.08	83.24	1784043.0
2017-11-01 17:00:00	MSFT	Stock	83.18	83.18	83.02	83.02	25019.0
2017-11-01 18:00:00	MSFT	Stock	83.0	83.0	83.0	83.0	400.0
2017-11-01 19:00:00	MSFT	Stock	83.01	83.18	83.01	83.18	3725.0
2017-11-01 04:00:00	NVDA	Stock	5.2005	5.2282	5.2005	5.2275	69080.0
2017-11-01 05:00:00	NVDA	Stock	5.2275	5.2285	5.2275	5.2275	53080.0
2017-11-01 06:00:00	NVDA	Stock	5.24	5.2495	5.236	5.236	74640.0
2017-11-01 07:00:00	NVDA	Stock	5.235	5.239	5.214	5.2145	424880.0
2017-11-01 08:00:00	NVDA	Stock	5.2182	5.23	5.214	5.2215	2221680.0
2017-11-01 09:00:00	NVDA	Stock	5.2202	5.2492	5.2075	5.23	82218720.0
2017-11-01 10:00:00	NVDA	Stock	5.2293	5.232	5.1882	5.2048	76701280.0
2017-11-01 11:00:00	NVDA	Stock	5.2068	5.2293	5.1908	5.192	48367560.0
2017-11-01 12:00:00	NVDA	Stock	5.1921	5.2087	5.182	5.1843	30655400.0
2017-11-01 13:00:00	NVDA	Stock	5.1855	5.1855	5.115	5.152	97079040.0
2017-11-01 14:00:00	NVDA	Stock	5.1525	5.1888	5.147	5.1782	45683680.0
2017-11-01 15:00:00	NVDA	Stock	5.1768	5.1858	5.1652	5.18	45339360.0
2017-11-01 16:00:00	NVDA	Stock	5.18	5.1949	5.1702	5.175	10572800.0
2017-11-01 17:00:00	NVDA	Stock	5.17	5.1875	5.1675	5.1738	657560.0
2017-11-01 18:00:00	NVDA	Stock	5.17	5.1708	5.1378	5.145	2422160.0
2017-11-01 19:00:00	NVDA	Stock	5.145	5.155	5.1425	5.155	854360.0
2017-11-01 04:00:00	AMZN	Stock	55.459	55.46	55.459	55.46	11240.0
2017-11-01 06:00:00	AMZN	Stock	55.55	55.55	55.5	55.5	96140.0
2017-11-01 07:00:00	AMZN	Stock	55.475	55.5	55.425	55.425	106520.0

> showing 50 of 48,724 rows — these rows as CSV

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