PREVIEW / stock_1hour / 2019-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-04.parquet
  size:    1.1 MB
  rows:    50,286
  symbols: 2,601

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
2019-06-04 04:00:00	AAPL	Stock	43.575	43.6875	43.525	43.675	48352.0
2019-06-04 05:00:00	AAPL	Stock	43.7425	43.7425	43.6	43.6875	39824.0
2019-06-04 06:00:00	AAPL	Stock	43.7125	43.745	43.5925	43.5925	25800.0
2019-06-04 07:00:00	AAPL	Stock	43.625	43.8	43.45	43.675	314660.0
2019-06-04 08:00:00	AAPL	Stock	43.6125	43.8725	43.45	43.8025	643272.0
2019-06-04 09:00:00	AAPL	Stock	43.805	44.1	43.63	44.0255	17657960.0
2019-06-04 10:00:00	AAPL	Stock	44.025	44.725	43.8575	44.5675	18856880.0
2019-06-04 11:00:00	AAPL	Stock	44.5625	44.9375	44.53	44.6325	16380872.0
2019-06-04 12:00:00	AAPL	Stock	44.6325	44.695	44.4925	44.6572	10814868.0
2019-06-04 13:00:00	AAPL	Stock	44.655	44.9025	44.48	44.8787	9409944.0
2019-06-04 14:00:00	AAPL	Stock	44.88	44.9	44.675	44.7627	7538200.0
2019-06-04 15:00:00	AAPL	Stock	44.7675	44.9575	44.7675	44.9175	14805832.0
2019-06-04 16:00:00	AAPL	Stock	44.91	44.975	44.8	44.975	9583456.0
2019-06-04 17:00:00	AAPL	Stock	44.975	45.0875	44.975	45.04	81596.0
2019-06-04 18:00:00	AAPL	Stock	45.0625	45.2	45.0625	45.165	81248.0
2019-06-04 19:00:00	AAPL	Stock	45.14	45.375	45.135	45.375	190372.0
2019-06-04 04:00:00	MSFT	Stock	120.28	120.62	120.25	120.47	12169.0
2019-06-04 05:00:00	MSFT	Stock	120.47	121.0	120.47	120.9	6104.0
2019-06-04 06:00:00	MSFT	Stock	120.9	120.9	120.45	120.57	3257.0
2019-06-04 07:00:00	MSFT	Stock	120.5	121.0	120.34	120.84	47457.0
2019-06-04 08:00:00	MSFT	Stock	120.55	121.4	120.13	121.18	80867.0
2019-06-04 09:00:00	MSFT	Stock	121.15	122.08	120.652	121.338	3965565.0
2019-06-04 10:00:00	MSFT	Stock	121.31	122.146	121.2	121.9	4736928.0
2019-06-04 11:00:00	MSFT	Stock	121.9	122.66	121.8	122.37	3328079.0
2019-06-04 12:00:00	MSFT	Stock	122.38	122.59	122.046	122.48	1952860.0
2019-06-04 13:00:00	MSFT	Stock	122.48	122.81	122.391	122.74	1591172.0
2019-06-04 14:00:00	MSFT	Stock	122.72	122.79	122.22	122.34	1555986.0
2019-06-04 15:00:00	MSFT	Stock	122.34	123.28	122.34	123.2	3737121.0
2019-06-04 16:00:00	MSFT	Stock	123.16	123.51	123.11	123.5	3784417.0
2019-06-04 17:00:00	MSFT	Stock	123.54	123.66	123.52	123.61	8336.0
2019-06-04 18:00:00	MSFT	Stock	123.61	123.9	123.61	123.83	13662.0
2019-06-04 19:00:00	MSFT	Stock	123.88	123.97	123.8	123.85	9754.0
2019-06-04 05:00:00	NVDA	Stock	3.387	3.3888	3.3812	3.3888	169760.0
2019-06-04 06:00:00	NVDA	Stock	3.3812	3.3812	3.3812	3.3812	30560.0
2019-06-04 07:00:00	NVDA	Stock	3.3822	3.394	3.37	3.385	344000.0
2019-06-04 08:00:00	NVDA	Stock	3.38	3.4175	3.3748	3.4088	2975320.0
2019-06-04 09:00:00	NVDA	Stock	3.412	3.4242	3.3867	3.421	58757720.0
2019-06-04 10:00:00	NVDA	Stock	3.4212	3.5078	3.4145	3.5066	129299640.0
2019-06-04 11:00:00	NVDA	Stock	3.5062	3.5305	3.5002	3.5152	75147320.0
2019-06-04 12:00:00	NVDA	Stock	3.5152	3.524	3.5035	3.5202	54029520.0
2019-06-04 13:00:00	NVDA	Stock	3.5198	3.5594	3.5182	3.5562	62553160.0
2019-06-04 14:00:00	NVDA	Stock	3.5562	3.5658	3.5416	3.5525	81361040.0
2019-06-04 15:00:00	NVDA	Stock	3.5525	3.5803	3.551	3.5755	100062160.0
2019-06-04 16:00:00	NVDA	Stock	3.5755	3.5935	3.57	3.5925	35514440.0
2019-06-04 17:00:00	NVDA	Stock	3.5925	3.6112	3.5925	3.6112	1030280.0
2019-06-04 18:00:00	NVDA	Stock	3.6115	3.6225	3.6055	3.6112	844160.0
2019-06-04 19:00:00	NVDA	Stock	3.6065	3.6212	3.6065	3.6212	327120.0
2019-06-04 04:00:00	AMZN	Stock	85.105	85.105	85.0	85.05	9920.0
2019-06-04 05:00:00	AMZN	Stock	85.1675	85.1725	85.1	85.15	36780.0
2019-06-04 06:00:00	AMZN	Stock	85.2525	85.2525	84.96	84.96	27400.0

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

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