PREVIEW / stock_1hour / 2020-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-23.parquet
  size:    1.2 MB
  rows:    56,300
  symbols: 2,509

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-10-23 04:00:00	AAPL	Stock	116.25	116.65	116.1	116.29	70215.0
2020-10-23 05:00:00	AAPL	Stock	116.17	116.55	116.05	116.26	32252.0
2020-10-23 06:00:00	AAPL	Stock	116.29	116.5	115.88	116.35	28755.0
2020-10-23 07:00:00	AAPL	Stock	116.3	116.42	116.1	116.3	117707.0
2020-10-23 08:00:00	AAPL	Stock	116.27	116.48	116.03	116.26	321407.0
2020-10-23 09:00:00	AAPL	Stock	116.27	116.55	115.37	115.47	9235445.0
2020-10-23 10:00:00	AAPL	Stock	115.46	115.46	114.74	115.04	12972826.0
2020-10-23 11:00:00	AAPL	Stock	115.04	115.32	114.28	114.6	10772768.0
2020-10-23 12:00:00	AAPL	Stock	114.592	115.05	114.33	114.83	9936609.0
2020-10-23 13:00:00	AAPL	Stock	114.82	115.16	114.77	114.86	6482214.0
2020-10-23 14:00:00	AAPL	Stock	114.855	115.09	114.41	114.42	7342522.0
2020-10-23 15:00:00	AAPL	Stock	114.424	115.085	114.4	115.05	11736738.0
2020-10-23 16:00:00	AAPL	Stock	115.04	115.052	114.97	115.0	4274325.0
2020-10-23 17:00:00	AAPL	Stock	115.0	115.29	114.99	115.09	145958.0
2020-10-23 18:00:00	AAPL	Stock	115.07	115.22	115.03	115.08	116945.0
2020-10-23 19:00:00	AAPL	Stock	115.08	115.1	115.02	115.09	72592.0
2020-10-23 04:00:00	MSFT	Stock	215.2	215.2	215.0	215.0	3011.0
2020-10-23 05:00:00	MSFT	Stock	215.0	215.5	214.57	215.08	3854.0
2020-10-23 06:00:00	MSFT	Stock	214.79	214.82	214.07	214.82	1328.0
2020-10-23 07:00:00	MSFT	Stock	215.05	215.41	214.77	215.19	10298.0
2020-10-23 08:00:00	MSFT	Stock	215.36	215.51	214.9	215.5	21251.0
2020-10-23 09:00:00	MSFT	Stock	215.45	215.65	213.16	214.38	2346759.0
2020-10-23 10:00:00	MSFT	Stock	214.32	215.73	213.53	215.04	2040326.0
2020-10-23 11:00:00	MSFT	Stock	215.03	215.59	213.8	214.85	1745236.0
2020-10-23 12:00:00	MSFT	Stock	214.84	215.33	214.25	214.78	1733130.0
2020-10-23 13:00:00	MSFT	Stock	214.78	215.54	214.77	214.98	1086470.0
2020-10-23 14:00:00	MSFT	Stock	214.98	215.64	214.93	215.46	1451984.0
2020-10-23 15:00:00	MSFT	Stock	215.45	216.28	215.39	216.26	2652190.0
2020-10-23 16:00:00	MSFT	Stock	216.23	216.3	215.9	216.15	2511977.0
2020-10-23 17:00:00	MSFT	Stock	216.11	216.51	216.11	216.51	7955.0
2020-10-23 18:00:00	MSFT	Stock	216.5	216.9	216.35	216.61	23117.0
2020-10-23 19:00:00	MSFT	Stock	216.72	217.0	216.62	216.86	12347.0
2020-10-23 07:00:00	NVDA	Stock	13.3905	13.3905	13.375	13.375	128160.0
2020-10-23 08:00:00	NVDA	Stock	13.3995	13.4408	13.3788	13.4193	474480.0
2020-10-23 09:00:00	NVDA	Stock	13.425	13.4975	13.2912	13.475	36592440.0
2020-10-23 10:00:00	NVDA	Stock	13.4779	13.5577	13.3752	13.4465	42993960.0
2020-10-23 11:00:00	NVDA	Stock	13.4452	13.4998	13.346	13.4053	18963680.0
2020-10-23 12:00:00	NVDA	Stock	13.4058	13.5015	13.39	13.4692	21187640.0
2020-10-23 13:00:00	NVDA	Stock	13.4722	13.518	13.457	13.495	17432720.0
2020-10-23 14:00:00	NVDA	Stock	13.5	13.5512	13.4803	13.4882	19585960.0
2020-10-23 15:00:00	NVDA	Stock	13.4843	13.5932	13.483	13.5902	33481040.0
2020-10-23 16:00:00	NVDA	Stock	13.5902	13.6238	13.5889	13.6008	3913080.0
2020-10-23 17:00:00	NVDA	Stock	13.6	13.6	13.5912	13.6	99640.0
2020-10-23 18:00:00	NVDA	Stock	13.6115	13.6118	13.5988	13.5988	59440.0
2020-10-23 19:00:00	NVDA	Stock	13.5925	13.5998	13.5908	13.5998	113760.0
2020-10-23 07:00:00	AMZN	Stock	159.256	159.35	159.2	159.3475	59660.0
2020-10-23 08:00:00	AMZN	Stock	159.217	159.85	159.203	159.6025	142840.0
2020-10-23 09:00:00	AMZN	Stock	159.5	159.75	157.5875	157.6555	8897520.0
2020-10-23 10:00:00	AMZN	Stock	157.7025	158.3178	157.0	157.9945	8382660.0
2020-10-23 11:00:00	AMZN	Stock	157.9924	158.7585	157.445	157.8	6151580.0

> showing 50 of 56,300 rows — these rows as CSV

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