PREVIEW / stock_1hour / 2018-12-17

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-17.parquet
  size:    1.1 MB
  rows:    50,465
  symbols: 2,730

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-12-17 04:00:00	AAPL	Stock	41.42	41.5725	41.375	41.47	25476.0
2018-12-17 05:00:00	AAPL	Stock	41.47	41.47	41.375	41.47	7656.0
2018-12-17 06:00:00	AAPL	Stock	41.38	41.4025	41.125	41.275	57140.0
2018-12-17 07:00:00	AAPL	Stock	41.275	41.395	41.2275	41.25	161340.0
2018-12-17 08:00:00	AAPL	Stock	41.37	41.395	41.1525	41.1875	453380.0
2018-12-17 09:00:00	AAPL	Stock	41.19	41.865	41.19	41.625	21563948.0
2018-12-17 10:00:00	AAPL	Stock	41.623	41.9725	41.5275	41.9222	21356620.0
2018-12-17 11:00:00	AAPL	Stock	41.9225	42.0875	41.805	42.01	13285620.0
2018-12-17 12:00:00	AAPL	Stock	42.0125	42.0725	41.505	41.5208	12055384.0
2018-12-17 13:00:00	AAPL	Stock	41.52	41.555	41.1475	41.1875	18841420.0
2018-12-17 14:00:00	AAPL	Stock	41.1925	41.2775	41.0375	41.1272	14052208.0
2018-12-17 15:00:00	AAPL	Stock	41.125	41.155	40.6825	41.0525	34867396.0
2018-12-17 16:00:00	AAPL	Stock	40.985	41.0775	40.95	41.0225	17343960.0
2018-12-17 17:00:00	AAPL	Stock	41.015	41.06	41.0125	41.06	93156.0
2018-12-17 18:00:00	AAPL	Stock	41.0675	41.18	41.0625	41.155	135472.0
2018-12-17 19:00:00	AAPL	Stock	41.1575	41.1825	41.0875	41.175	84976.0
2018-12-17 04:00:00	MSFT	Stock	106.3	106.4	106.19	106.3	2800.0
2018-12-17 05:00:00	MSFT	Stock	106.5	106.51	106.45	106.5	400.0
2018-12-17 06:00:00	MSFT	Stock	106.51	106.51	106.2	106.3	4029.0
2018-12-17 07:00:00	MSFT	Stock	106.06	106.3	105.99	106.08	7810.0
2018-12-17 08:00:00	MSFT	Stock	106.19	106.193	105.43	105.43	41323.0
2018-12-17 09:00:00	MSFT	Stock	105.45	105.82	103.87	104.41	5119583.0
2018-12-17 10:00:00	MSFT	Stock	104.42	105.358	104.2	105.05	4363522.0
2018-12-17 11:00:00	MSFT	Stock	105.05	105.59	104.75	105.33	3179512.0
2018-12-17 12:00:00	MSFT	Stock	105.35	105.8	104.23	104.33	3549962.0
2018-12-17 13:00:00	MSFT	Stock	104.32	104.58	103.09	103.2	4679628.0
2018-12-17 14:00:00	MSFT	Stock	103.2	103.31	102.23	102.48	5747826.0
2018-12-17 15:00:00	MSFT	Stock	102.48	102.99	101.71	102.98	11801954.0
2018-12-17 16:00:00	MSFT	Stock	102.89	103.18	102.8	103.1	13945639.0
2018-12-17 17:00:00	MSFT	Stock	103.16	103.29	103.02	103.29	13866.0
2018-12-17 18:00:00	MSFT	Stock	103.3	103.55	103.3	103.48	9437.0
2018-12-17 19:00:00	MSFT	Stock	103.38	103.63	103.36	103.63	8031.0
2018-12-17 04:00:00	NVDA	Stock	3.6772	3.7013	3.6772	3.6803	35960.0
2018-12-17 05:00:00	NVDA	Stock	3.675	3.675	3.675	3.675	4000.0
2018-12-17 06:00:00	NVDA	Stock	3.675	3.675	3.6403	3.6403	87080.0
2018-12-17 07:00:00	NVDA	Stock	3.65	3.6675	3.65	3.6558	418200.0
2018-12-17 08:00:00	NVDA	Stock	3.6672	3.6725	3.628	3.6288	1736360.0
2018-12-17 09:00:00	NVDA	Stock	3.635	3.6518	3.531	3.58	97375360.0
2018-12-17 10:00:00	NVDA	Stock	3.5788	3.6755	3.5705	3.6595	113865400.0
2018-12-17 11:00:00	NVDA	Stock	3.6612	3.6965	3.6545	3.6938	52765520.0
2018-12-17 12:00:00	NVDA	Stock	3.6948	3.7038	3.6316	3.633	63897080.0
2018-12-17 13:00:00	NVDA	Stock	3.6308	3.6382	3.5888	3.6035	64785880.0
2018-12-17 14:00:00	NVDA	Stock	3.6012	3.623	3.5803	3.5943	48086520.0
2018-12-17 15:00:00	NVDA	Stock	3.5938	3.6025	3.557	3.5903	99785560.0
2018-12-17 16:00:00	NVDA	Stock	3.5895	3.6015	3.5812	3.6015	28785040.0
2018-12-17 17:00:00	NVDA	Stock	3.5938	3.6022	3.5915	3.6	498640.0
2018-12-17 18:00:00	NVDA	Stock	3.6025	3.6125	3.6025	3.6088	115720.0
2018-12-17 19:00:00	NVDA	Stock	3.6075	3.62	3.6005	3.6125	311200.0
2018-12-17 04:00:00	AMZN	Stock	79.4	79.455	79.4	79.455	13300.0
2018-12-17 05:00:00	AMZN	Stock	79.4495	79.4495	79.4495	79.4495	4000.0

> showing 50 of 50,465 rows — these rows as CSV

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