PREVIEW / stock_1hour / 2018-06-05

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-05.parquet
  size:    1.1 MB
  rows:    49,878
  symbols: 2,850

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-06-05 04:00:00	AAPL	Stock	48.0525	48.1875	48.0525	48.1875	16252.0
2018-06-05 05:00:00	AAPL	Stock	48.1875	48.2125	48.17	48.21	15952.0
2018-06-05 06:00:00	AAPL	Stock	48.1675	48.175	48.125	48.1675	26032.0
2018-06-05 07:00:00	AAPL	Stock	48.165	48.3125	48.15	48.2875	336544.0
2018-06-05 08:00:00	AAPL	Stock	48.1975	48.325	48.125	48.15	561184.0
2018-06-05 09:00:00	AAPL	Stock	48.1375	48.3525	47.9575	48.25	12814900.0
2018-06-05 10:00:00	AAPL	Stock	48.2525	48.485	48.2362	48.4225	15450552.0
2018-06-05 11:00:00	AAPL	Stock	48.4225	48.435	48.225	48.3	9950824.0
2018-06-05 12:00:00	AAPL	Stock	48.2988	48.315	48.165	48.275	6214868.0
2018-06-05 13:00:00	AAPL	Stock	48.2738	48.31	48.23	48.264	4673792.0
2018-06-05 14:00:00	AAPL	Stock	48.265	48.32	48.2125	48.3075	5369776.0
2018-06-05 15:00:00	AAPL	Stock	48.3075	48.395	48.2125	48.3275	14327576.0
2018-06-05 16:00:00	AAPL	Stock	48.3275	48.3525	48.275	48.335	6908588.0
2018-06-05 17:00:00	AAPL	Stock	48.3275	48.3725	48.325	48.3675	51948.0
2018-06-05 18:00:00	AAPL	Stock	48.3675	48.3675	48.3	48.325	38500.0
2018-06-05 19:00:00	AAPL	Stock	48.325	48.3275	48.305	48.325	16280.0
2018-06-05 04:00:00	MSFT	Stock	102.0	102.39	102.0	102.39	300.0
2018-06-05 05:00:00	MSFT	Stock	102.25	102.25	102.25	102.25	2700.0
2018-06-05 06:00:00	MSFT	Stock	102.3	102.3	102.07	102.07	1267.0
2018-06-05 07:00:00	MSFT	Stock	102.05	102.15	102.01	102.08	3663.0
2018-06-05 08:00:00	MSFT	Stock	102.01	102.279	101.85	101.99	31991.0
2018-06-05 09:00:00	MSFT	Stock	101.951	102.11	101.53	102.1	3226262.0
2018-06-05 10:00:00	MSFT	Stock	102.1	102.21	101.9	102.205	3256841.0
2018-06-05 11:00:00	MSFT	Stock	102.2	102.25	101.71	101.985	2562400.0
2018-06-05 12:00:00	MSFT	Stock	101.985	101.995	101.54	101.79	1753305.0
2018-06-05 13:00:00	MSFT	Stock	101.8	102.037	101.71	102.035	1317634.0
2018-06-05 14:00:00	MSFT	Stock	102.04	102.27	101.88	102.24	1657212.0
2018-06-05 15:00:00	MSFT	Stock	102.238	102.33	102.03	102.2	3492200.0
2018-06-05 16:00:00	MSFT	Stock	102.19	102.34	102.19	102.34	3231488.0
2018-06-05 17:00:00	MSFT	Stock	102.34	102.34	102.23	102.25	2370.0
2018-06-05 18:00:00	MSFT	Stock	102.25	102.25	102.25	102.25	265.0
2018-06-05 19:00:00	MSFT	Stock	102.27	102.32	102.27	102.32	2443.0
2018-06-05 04:00:00	NVDA	Stock	6.6495	6.65	6.6495	6.65	59480.0
2018-06-05 05:00:00	NVDA	Stock	6.65	6.6718	6.6463	6.6718	36720.0
2018-06-05 06:00:00	NVDA	Stock	6.6705	6.6705	6.645	6.6548	151560.0
2018-06-05 07:00:00	NVDA	Stock	6.66	6.66	6.6388	6.64	764680.0
2018-06-05 08:00:00	NVDA	Stock	6.6507	6.653	6.6265	6.6325	1526440.0
2018-06-05 09:00:00	NVDA	Stock	6.6278	6.6648	6.5793	6.6425	73824360.0
2018-06-05 10:00:00	NVDA	Stock	6.6434	6.6543	6.6068	6.645	72482160.0
2018-06-05 11:00:00	NVDA	Stock	6.6448	6.6485	6.5975	6.6134	54529080.0
2018-06-05 12:00:00	NVDA	Stock	6.613	6.635	6.5928	6.6335	32862120.0
2018-06-05 13:00:00	NVDA	Stock	6.6328	6.645	6.6252	6.628	22813200.0
2018-06-05 14:00:00	NVDA	Stock	6.628	6.638	6.6179	6.635	24772280.0
2018-06-05 15:00:00	NVDA	Stock	6.6348	6.6378	6.613	6.6273	44606240.0
2018-06-05 16:00:00	NVDA	Stock	6.6268	6.6312	6.62	6.6312	11475040.0
2018-06-05 17:00:00	NVDA	Stock	6.635	6.635	6.625	6.635	121560.0
2018-06-05 18:00:00	NVDA	Stock	6.6335	6.6335	6.6268	6.6268	111520.0
2018-06-05 19:00:00	NVDA	Stock	6.6275	6.63	6.6268	6.6298	238520.0
2018-06-05 04:00:00	AMZN	Stock	83.7	83.7	83.7	83.7	3360.0
2018-06-05 05:00:00	AMZN	Stock	83.867	83.867	83.845	83.845	7040.0

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

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