PREVIEW / stock_1hour / 2020-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-03.parquet
  size:    1.2 MB
  rows:    51,686
  symbols: 2,431

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
2020-02-03 04:00:00	AAPL	Stock	77.5525	77.6875	76.76	76.8	111008.0
2020-02-03 05:00:00	AAPL	Stock	76.6875	76.71	76.25	76.71	89296.0
2020-02-03 06:00:00	AAPL	Stock	76.68	76.8875	76.68	76.8425	79808.0
2020-02-03 07:00:00	AAPL	Stock	76.7875	77.02	76.375	76.75	686020.0
2020-02-03 08:00:00	AAPL	Stock	76.5	77.0225	76.375	76.7375	1256376.0
2020-02-03 09:00:00	AAPL	Stock	76.7485	77.75	75.555	77.694	37565504.0
2020-02-03 10:00:00	AAPL	Stock	77.7	78.3125	77.68	78.0833	24981080.0
2020-02-03 11:00:00	AAPL	Stock	78.09	78.3725	77.9075	77.995	14452688.0
2020-02-03 12:00:00	AAPL	Stock	77.9825	78.03	77.1625	77.18	14622660.0
2020-02-03 13:00:00	AAPL	Stock	77.1825	77.255	76.53	76.9475	16858724.0
2020-02-03 14:00:00	AAPL	Stock	76.9512	77.0575	76.6675	76.77	10341924.0
2020-02-03 15:00:00	AAPL	Stock	76.7725	77.325	76.755	77.1775	16578164.0
2020-02-03 16:00:00	AAPL	Stock	77.1775	77.1875	76.8425	77.0725	8211624.0
2020-02-03 17:00:00	AAPL	Stock	77.07	77.07	77.0	77.0125	67024.0
2020-02-03 18:00:00	AAPL	Stock	77.0075	77.0075	76.8125	76.95	125584.0
2020-02-03 19:00:00	AAPL	Stock	76.9325	77.045	76.925	77.025	90696.0
2020-02-03 04:00:00	MSFT	Stock	171.01	171.2	170.8	170.8	10575.0
2020-02-03 05:00:00	MSFT	Stock	170.8	170.8	170.5	170.75	9180.0
2020-02-03 06:00:00	MSFT	Stock	170.66	171.3	170.66	171.3	7568.0
2020-02-03 07:00:00	MSFT	Stock	171.16	171.23	170.85	171.0	37600.0
2020-02-03 08:00:00	MSFT	Stock	171.104	171.48	170.85	171.375	93421.0
2020-02-03 09:00:00	MSFT	Stock	171.375	172.22	170.25	172.22	3714243.0
2020-02-03 10:00:00	MSFT	Stock	172.23	173.13	171.95	172.57	3853876.0
2020-02-03 11:00:00	MSFT	Stock	172.58	172.95	172.08	172.57	2389844.0
2020-02-03 12:00:00	MSFT	Stock	172.57	174.02	172.4	173.87	2266424.0
2020-02-03 13:00:00	MSFT	Stock	173.877	173.91	173.3	173.815	1686172.0
2020-02-03 14:00:00	MSFT	Stock	173.81	174.365	173.435	174.268	2434757.0
2020-02-03 15:00:00	MSFT	Stock	174.27	174.5	173.76	174.39	4369892.0
2020-02-03 16:00:00	MSFT	Stock	174.38	174.5	172.434	174.36	3903030.0
2020-02-03 17:00:00	MSFT	Stock	174.36	174.4	174.2	174.31	8954.0
2020-02-03 18:00:00	MSFT	Stock	174.31	174.4	174.02	174.35	23180.0
2020-02-03 19:00:00	MSFT	Stock	174.33	174.67	174.3	174.6	22952.0
2020-02-03 04:00:00	NVDA	Stock	5.935	5.935	5.925	5.925	26240.0
2020-02-03 06:00:00	NVDA	Stock	5.9322	5.9375	5.9243	5.9375	95360.0
2020-02-03 07:00:00	NVDA	Stock	5.9303	5.9375	5.925	5.925	329920.0
2020-02-03 08:00:00	NVDA	Stock	5.9213	5.944	5.9025	5.9121	1543120.0
2020-02-03 09:00:00	NVDA	Stock	5.9125	5.9848	5.875	5.9684	42972880.0
2020-02-03 10:00:00	NVDA	Stock	5.9693	6.0278	5.961	6.0038	37601960.0
2020-02-03 11:00:00	NVDA	Stock	6.0037	6.025	5.9865	5.998	39320920.0
2020-02-03 12:00:00	NVDA	Stock	5.9972	6.0188	5.9895	6.0138	23325680.0
2020-02-03 13:00:00	NVDA	Stock	6.0148	6.0185	5.9825	5.9934	19308280.0
2020-02-03 14:00:00	NVDA	Stock	5.9928	6.0055	5.9758	5.9983	14533360.0
2020-02-03 15:00:00	NVDA	Stock	5.9984	6.019	5.991	6.0082	31356720.0
2020-02-03 16:00:00	NVDA	Stock	6.0082	6.0082	5.9803	6.0075	19085800.0
2020-02-03 17:00:00	NVDA	Stock	6.0075	6.0075	5.9925	5.9925	60760.0
2020-02-03 18:00:00	NVDA	Stock	5.9925	5.995	5.9875	5.995	295720.0
2020-02-03 19:00:00	NVDA	Stock	5.9878	6.0052	5.9875	6.0	206160.0
2020-02-03 04:00:00	AMZN	Stock	100.748	101.0	100.695	100.81	41000.0
2020-02-03 05:00:00	AMZN	Stock	100.6245	100.625	100.496	100.625	9620.0
2020-02-03 06:00:00	AMZN	Stock	100.771	100.7735	100.6675	100.6675	11880.0

> showing 50 of 51,686 rows — these rows as CSV

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