PREVIEW / stock_1hour / 2018-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-12.parquet
  size:    1.1 MB
  rows:    49,427
  symbols: 2,791

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-09-12 04:00:00	AAPL	Stock	56.25	56.375	56.25	56.32	81440.0
2018-09-12 05:00:00	AAPL	Stock	56.31	56.31	56.255	56.2875	34884.0
2018-09-12 06:00:00	AAPL	Stock	56.285	56.285	56.19	56.245	70856.0
2018-09-12 07:00:00	AAPL	Stock	56.205	56.325	56.1275	56.21	475160.0
2018-09-12 08:00:00	AAPL	Stock	56.22	56.325	56.095	56.13	954508.0
2018-09-12 09:00:00	AAPL	Stock	56.135	56.25	55.0675	55.2065	26328360.0
2018-09-12 10:00:00	AAPL	Stock	55.2125	55.53	54.96	55.01	20605192.0
2018-09-12 11:00:00	AAPL	Stock	55.008	55.775	54.98	55.2175	21769396.0
2018-09-12 12:00:00	AAPL	Stock	55.2175	55.4975	55.2075	55.2862	10198308.0
2018-09-12 13:00:00	AAPL	Stock	55.2855	56.105	55.2825	55.4945	30356512.0
2018-09-12 14:00:00	AAPL	Stock	55.4925	55.57	54.97	55.0942	22166864.0
2018-09-12 15:00:00	AAPL	Stock	55.0938	55.62	55.09	55.265	26019120.0
2018-09-12 16:00:00	AAPL	Stock	55.2675	55.305	55.2275	55.2825	8504936.0
2018-09-12 17:00:00	AAPL	Stock	55.2675	55.37	55.25	55.3062	240824.0
2018-09-12 18:00:00	AAPL	Stock	55.31	55.325	55.2225	55.2675	112956.0
2018-09-12 19:00:00	AAPL	Stock	55.2875	55.3	55.2	55.225	67912.0
2018-09-12 04:00:00	MSFT	Stock	111.58	111.8	111.5	111.79	3661.0
2018-09-12 05:00:00	MSFT	Stock	111.75	111.9	111.65	111.69	5697.0
2018-09-12 06:00:00	MSFT	Stock	111.7	111.7	111.7	111.7	1993.0
2018-09-12 07:00:00	MSFT	Stock	111.7	111.7	111.24	111.3	7085.0
2018-09-12 08:00:00	MSFT	Stock	111.38	111.69	111.2	111.27	19557.0
2018-09-12 09:00:00	MSFT	Stock	111.33	111.641	111.0	111.22	1987489.0
2018-09-12 10:00:00	MSFT	Stock	111.22	111.68	110.51	110.775	2794146.0
2018-09-12 11:00:00	MSFT	Stock	110.78	111.6	110.67	110.68	2718104.0
2018-09-12 12:00:00	MSFT	Stock	110.68	111.45	110.67	111.295	1343864.0
2018-09-12 13:00:00	MSFT	Stock	111.295	111.44	111.04	111.19	1033065.0
2018-09-12 14:00:00	MSFT	Stock	111.19	111.33	111.04	111.296	1034765.0
2018-09-12 15:00:00	MSFT	Stock	111.3	111.85	111.3	111.67	2850385.0
2018-09-12 16:00:00	MSFT	Stock	111.71	111.72	111.62	111.72	3003983.0
2018-09-12 17:00:00	MSFT	Stock	111.71	111.74	111.65	111.65	34619.0
2018-09-12 18:00:00	MSFT	Stock	111.65	111.67	111.56	111.56	3014.0
2018-09-12 19:00:00	MSFT	Stock	111.65	111.65	111.65	111.65	697.0
2018-09-12 05:00:00	NVDA	Stock	6.8345	6.8345	6.8345	6.8345	12000.0
2018-09-12 06:00:00	NVDA	Stock	6.8168	6.8298	6.8168	6.8298	35920.0
2018-09-12 07:00:00	NVDA	Stock	6.82	6.83	6.803	6.808	541240.0
2018-09-12 08:00:00	NVDA	Stock	6.8175	6.8248	6.8	6.8015	556480.0
2018-09-12 09:00:00	NVDA	Stock	6.7998	6.8235	6.6124	6.6276	76227960.0
2018-09-12 10:00:00	NVDA	Stock	6.6238	6.6437	6.548	6.5905	91419880.0
2018-09-12 11:00:00	NVDA	Stock	6.589	6.6831	6.5828	6.6224	60371720.0
2018-09-12 12:00:00	NVDA	Stock	6.624	6.7025	6.622	6.6578	35197560.0
2018-09-12 13:00:00	NVDA	Stock	6.6592	6.695	6.6582	6.6628	25266280.0
2018-09-12 14:00:00	NVDA	Stock	6.6625	6.6758	6.6448	6.655	18630040.0
2018-09-12 15:00:00	NVDA	Stock	6.6555	6.7073	6.655	6.705	51063120.0
2018-09-12 16:00:00	NVDA	Stock	6.705	6.706	6.6802	6.6989	4246400.0
2018-09-12 17:00:00	NVDA	Stock	6.705	6.705	6.6822	6.6822	158960.0
2018-09-12 18:00:00	NVDA	Stock	6.6875	6.69	6.6812	6.6848	123240.0
2018-09-12 19:00:00	NVDA	Stock	6.6775	6.68	6.6662	6.6662	87560.0
2018-09-12 04:00:00	AMZN	Stock	99.95	100.006	99.9125	99.9125	62520.0
2018-09-12 05:00:00	AMZN	Stock	99.85	99.9625	99.7	99.9625	24740.0
2018-09-12 06:00:00	AMZN	Stock	99.8845	99.8845	99.8025	99.8025	20020.0

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

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