PREVIEW / stock_1hour / 2018-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-09.parquet
  size:    1.1 MB
  rows:    48,631
  symbols: 2,782

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-08-09 04:00:00	AAPL	Stock	51.725	51.725	51.6125	51.7225	22048.0
2018-08-09 05:00:00	AAPL	Stock	51.725	51.8	51.725	51.8	48824.0
2018-08-09 06:00:00	AAPL	Stock	51.8	51.81	51.8	51.81	1800.0
2018-08-09 07:00:00	AAPL	Stock	51.745	51.8025	51.7375	51.785	63248.0
2018-08-09 08:00:00	AAPL	Stock	51.7725	51.8375	51.7488	51.8325	101416.0
2018-08-09 09:00:00	AAPL	Stock	51.8175	52.1825	51.8	52.1325	11167284.0
2018-08-09 10:00:00	AAPL	Stock	52.1345	52.3975	52.1275	52.215	16212356.0
2018-08-09 11:00:00	AAPL	Stock	52.216	52.3225	52.0575	52.2375	13286424.0
2018-08-09 12:00:00	AAPL	Stock	52.2375	52.39	52.2262	52.39	7612452.0
2018-08-09 13:00:00	AAPL	Stock	52.39	52.4375	52.325	52.37	6639292.0
2018-08-09 14:00:00	AAPL	Stock	52.37	52.445	52.3475	52.3538	6600180.0
2018-08-09 15:00:00	AAPL	Stock	52.3525	52.42	52.2062	52.2225	13772576.0
2018-08-09 16:00:00	AAPL	Stock	52.22	52.2675	52.175	52.2075	5714164.0
2018-08-09 17:00:00	AAPL	Stock	52.2	52.22	52.1875	52.215	317824.0
2018-08-09 18:00:00	AAPL	Stock	52.2	52.215	52.18	52.18	37380.0
2018-08-09 19:00:00	AAPL	Stock	52.195	52.21	52.175	52.21	55752.0
2018-08-09 06:00:00	MSFT	Stock	109.74	109.74	109.5	109.5	732.0
2018-08-09 07:00:00	MSFT	Stock	109.49	109.49	109.46	109.46	1796.0
2018-08-09 08:00:00	MSFT	Stock	109.49	109.75	109.2	109.6	35011.0
2018-08-09 09:00:00	MSFT	Stock	109.66	110.16	109.65	109.91	2022197.0
2018-08-09 10:00:00	MSFT	Stock	109.92	110.05	109.71	109.94	1896570.0
2018-08-09 11:00:00	MSFT	Stock	109.95	110.105	109.77	109.905	1407850.0
2018-08-09 12:00:00	MSFT	Stock	109.903	110.04	109.85	110.015	1051870.0
2018-08-09 13:00:00	MSFT	Stock	110.01	110.06	109.91	110.04	846029.0
2018-08-09 14:00:00	MSFT	Stock	110.04	110.04	109.77	109.86	1177244.0
2018-08-09 15:00:00	MSFT	Stock	109.852	109.875	109.6	109.67	2444108.0
2018-08-09 16:00:00	MSFT	Stock	109.67	109.81	109.6	109.614	1593419.0
2018-08-09 17:00:00	MSFT	Stock	109.62	109.79	109.62	109.62	1810.0
2018-08-09 18:00:00	MSFT	Stock	109.77	109.77	109.62	109.66	10077.0
2018-08-09 19:00:00	MSFT	Stock	109.62	109.78	109.62	109.63	6219.0
2018-08-09 04:00:00	NVDA	Stock	6.4503	6.4503	6.4503	6.4503	12000.0
2018-08-09 06:00:00	NVDA	Stock	6.4668	6.4668	6.4578	6.4578	12000.0
2018-08-09 07:00:00	NVDA	Stock	6.4578	6.4745	6.45	6.464	214000.0
2018-08-09 08:00:00	NVDA	Stock	6.4605	6.479	6.445	6.475	630400.0
2018-08-09 09:00:00	NVDA	Stock	6.4788	6.4825	6.4174	6.4328	37008120.0
2018-08-09 10:00:00	NVDA	Stock	6.4325	6.475	6.4325	6.4375	28959520.0
2018-08-09 11:00:00	NVDA	Stock	6.4376	6.4532	6.4325	6.4388	18888520.0
2018-08-09 12:00:00	NVDA	Stock	6.439	6.4503	6.4175	6.4267	17483640.0
2018-08-09 13:00:00	NVDA	Stock	6.4272	6.435	6.4152	6.4324	13062560.0
2018-08-09 14:00:00	NVDA	Stock	6.4323	6.4375	6.4175	6.429	14594920.0
2018-08-09 15:00:00	NVDA	Stock	6.429	6.4325	6.4037	6.4112	28906680.0
2018-08-09 16:00:00	NVDA	Stock	6.4115	6.4158	6.4022	6.4075	4250720.0
2018-08-09 17:00:00	NVDA	Stock	6.4037	6.4075	6.4025	6.4025	128400.0
2018-08-09 18:00:00	NVDA	Stock	6.4058	6.4138	6.4058	6.4088	186000.0
2018-08-09 19:00:00	NVDA	Stock	6.4112	6.4158	6.4	6.4075	173800.0
2018-08-09 04:00:00	AMZN	Stock	94.3155	94.3155	94.3155	94.3155	2000.0
2018-08-09 05:00:00	AMZN	Stock	94.325	94.325	94.28	94.28	24620.0
2018-08-09 06:00:00	AMZN	Stock	94.28	94.325	94.28	94.325	8400.0
2018-08-09 07:00:00	AMZN	Stock	94.2105	94.2375	94.15	94.2375	65000.0
2018-08-09 08:00:00	AMZN	Stock	94.2	94.29	94.15	94.2555	279280.0

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

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