PREVIEW / stock_1hour / 2017-12-14

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-14.parquet
  size:    1.1 MB
  rows:    49,374
  symbols: 2,931

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-12-14 06:00:00	AAPL	Stock	43.1275	43.1275	43.1275	43.1275	400.0
2017-12-14 07:00:00	AAPL	Stock	43.1425	43.1625	43.1	43.125	38544.0
2017-12-14 08:00:00	AAPL	Stock	43.1362	43.1775	43.1125	43.13	79708.0
2017-12-14 09:00:00	AAPL	Stock	43.1275	43.2825	43.0775	43.0975	11405144.0
2017-12-14 10:00:00	AAPL	Stock	43.0975	43.2	43.0525	43.085	12130700.0
2017-12-14 11:00:00	AAPL	Stock	43.085	43.1275	42.9125	43.0712	11980752.0
2017-12-14 12:00:00	AAPL	Stock	43.0688	43.1225	43.015	43.0295	5688876.0
2017-12-14 13:00:00	AAPL	Stock	43.0275	43.1025	42.9225	43.0325	7668416.0
2017-12-14 14:00:00	AAPL	Stock	43.0325	43.0975	42.9625	43.0575	6267392.0
2017-12-14 15:00:00	AAPL	Stock	43.05	43.1075	43.0125	43.055	11317776.0
2017-12-14 16:00:00	AAPL	Stock	43.0625	43.1075	43.0525	43.0825	5917304.0
2017-12-14 17:00:00	AAPL	Stock	43.075	43.08	43.025	43.08	31892.0
2017-12-14 18:00:00	AAPL	Stock	43.075	43.0825	43.065	43.08	24752.0
2017-12-14 19:00:00	AAPL	Stock	43.075	43.11	43.06	43.11	81516.0
2017-12-14 05:00:00	MSFT	Stock	85.6	85.6	85.6	85.6	100.0
2017-12-14 07:00:00	MSFT	Stock	85.6	85.6	85.6	85.6	3799.0
2017-12-14 08:00:00	MSFT	Stock	85.5	85.6	85.49	85.54	5065.0
2017-12-14 09:00:00	MSFT	Stock	85.55	85.87	85.353	85.57	1694800.0
2017-12-14 10:00:00	MSFT	Stock	85.56	85.6	85.25	85.37	1631359.0
2017-12-14 11:00:00	MSFT	Stock	85.38	85.42	84.955	84.98	1907658.0
2017-12-14 12:00:00	MSFT	Stock	84.98	85.05	84.78	84.82	1325652.0
2017-12-14 13:00:00	MSFT	Stock	84.82	84.96	84.637	84.91	1643675.0
2017-12-14 14:00:00	MSFT	Stock	84.91	84.96	84.53	84.765	1910816.0
2017-12-14 15:00:00	MSFT	Stock	84.761	84.95	84.56	84.72	3494193.0
2017-12-14 16:00:00	MSFT	Stock	84.69	85.189	84.69	84.7	3964157.0
2017-12-14 17:00:00	MSFT	Stock	84.5	84.7	84.5	84.5	414.0
2017-12-14 18:00:00	MSFT	Stock	84.65	84.65	84.6	84.6	1153.0
2017-12-14 19:00:00	MSFT	Stock	84.6	84.75	84.6	84.75	1450.0
2017-12-14 04:00:00	NVDA	Stock	4.67	4.6725	4.6475	4.6725	59560.0
2017-12-14 05:00:00	NVDA	Stock	4.6712	4.6712	4.6712	4.6712	4000.0
2017-12-14 06:00:00	NVDA	Stock	4.6725	4.6725	4.6722	4.6725	12000.0
2017-12-14 07:00:00	NVDA	Stock	4.6732	4.6732	4.6575	4.66	366600.0
2017-12-14 08:00:00	NVDA	Stock	4.679	4.679	4.6525	4.6675	1371040.0
2017-12-14 09:00:00	NVDA	Stock	4.67	4.6983	4.615	4.6905	90452480.0
2017-12-14 10:00:00	NVDA	Stock	4.69	4.7335	4.6695	4.7038	88438520.0
2017-12-14 11:00:00	NVDA	Stock	4.7048	4.708	4.6738	4.696	49925600.0
2017-12-14 12:00:00	NVDA	Stock	4.6953	4.7048	4.6818	4.6862	28760360.0
2017-12-14 13:00:00	NVDA	Stock	4.6855	4.6875	4.661	4.6725	27055160.0
2017-12-14 14:00:00	NVDA	Stock	4.674	4.684	4.6562	4.678	29696840.0
2017-12-14 15:00:00	NVDA	Stock	4.6775	4.683	4.6575	4.6618	58542200.0
2017-12-14 16:00:00	NVDA	Stock	4.6618	4.6715	4.6618	4.67	16272760.0
2017-12-14 17:00:00	NVDA	Stock	4.6633	4.6858	4.6633	4.6792	376800.0
2017-12-14 18:00:00	NVDA	Stock	4.6763	4.6875	4.6763	4.6875	146960.0
2017-12-14 19:00:00	NVDA	Stock	4.69	4.7	4.6875	4.6918	501280.0
2017-12-14 04:00:00	AMZN	Stock	58.2495	58.2495	58.2495	58.2495	2000.0
2017-12-14 05:00:00	AMZN	Stock	58.25	58.25	58.25	58.25	2160.0
2017-12-14 06:00:00	AMZN	Stock	58.3065	58.3135	58.3065	58.3135	4000.0
2017-12-14 07:00:00	AMZN	Stock	58.2975	58.345	58.081	58.153	47260.0
2017-12-14 08:00:00	AMZN	Stock	58.345	58.345	58.166	58.2685	93740.0
2017-12-14 09:00:00	AMZN	Stock	58.2625	58.594	58.1225	58.4625	9418680.0

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

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