PREVIEW / stock_1hour / 2020-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-14.parquet
  size:    1.2 MB
  rows:    57,358
  symbols: 2,447

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-07-14 04:00:00	AAPL	Stock	95.9	96.33	95.9	96.2475	55824.0
2020-07-14 05:00:00	AAPL	Stock	96.2	96.315	96.0	96.105	22688.0
2020-07-14 06:00:00	AAPL	Stock	96.135	96.1425	95.7575	95.7575	22808.0
2020-07-14 07:00:00	AAPL	Stock	95.845	96.7	95.765	96.6	506200.0
2020-07-14 08:00:00	AAPL	Stock	95.924	96.6975	95.0025	95.01	788088.0
2020-07-14 09:00:00	AAPL	Stock	95.05	96.6125	94.5775	95.3875	23298100.0
2020-07-14 10:00:00	AAPL	Stock	95.3725	95.4375	93.8775	94.8375	23269516.0
2020-07-14 11:00:00	AAPL	Stock	94.84	96.08	94.5078	95.5265	15224160.0
2020-07-14 12:00:00	AAPL	Stock	95.55	96.025	95.2775	95.37	7965324.0
2020-07-14 13:00:00	AAPL	Stock	95.35	96.1998	95.005	95.748	9498648.0
2020-07-14 14:00:00	AAPL	Stock	95.7625	96.8675	95.6425	96.6425	15893360.0
2020-07-14 15:00:00	AAPL	Stock	96.6475	97.255	95.7175	97.0525	23019140.0
2020-07-14 16:00:00	AAPL	Stock	97.0575	97.125	96.88	96.9375	10493132.0
2020-07-14 17:00:00	AAPL	Stock	96.925	97.7425	96.9175	97.425	323748.0
2020-07-14 18:00:00	AAPL	Stock	97.45	97.75	97.4	97.725	164888.0
2020-07-14 19:00:00	AAPL	Stock	97.725	97.7875	97.575	97.78	120412.0
2020-07-14 04:00:00	MSFT	Stock	207.78	207.99	206.9	207.71	14296.0
2020-07-14 05:00:00	MSFT	Stock	207.73	207.95	207.51	207.65	4635.0
2020-07-14 06:00:00	MSFT	Stock	207.72	207.75	206.65	207.29	4664.0
2020-07-14 07:00:00	MSFT	Stock	207.31	208.81	207.0	208.71	76045.0
2020-07-14 08:00:00	MSFT	Stock	207.0	209.69	205.0	205.13	190453.0
2020-07-14 09:00:00	MSFT	Stock	205.15	208.3	202.03	204.0	5640106.0
2020-07-14 10:00:00	MSFT	Stock	203.98	206.35	202.09	205.012	5757883.0
2020-07-14 11:00:00	MSFT	Stock	205.03	206.79	204.26	206.06	2946816.0
2020-07-14 12:00:00	MSFT	Stock	206.02	207.1	205.48	205.91	2186896.0
2020-07-14 13:00:00	MSFT	Stock	205.89	207.49	205.278	206.608	2254829.0
2020-07-14 14:00:00	MSFT	Stock	206.6	207.6	206.28	206.94	2380162.0
2020-07-14 15:00:00	MSFT	Stock	206.95	208.85	205.23	208.39	4896953.0
2020-07-14 16:00:00	MSFT	Stock	208.39	208.74	207.6	208.17	3100441.0
2020-07-14 17:00:00	MSFT	Stock	208.15	209.63	208.15	208.89	51092.0
2020-07-14 18:00:00	MSFT	Stock	208.86	209.85	208.63	209.0	34276.0
2020-07-14 19:00:00	MSFT	Stock	209.09	209.33	208.8	209.0	21787.0
2020-07-14 04:00:00	NVDA	Stock	10.18	10.18	10.18	10.18	4000.0
2020-07-14 05:00:00	NVDA	Stock	10.1582	10.1582	10.157	10.157	8000.0
2020-07-14 06:00:00	NVDA	Stock	10.157	10.157	10.0995	10.0995	17000.0
2020-07-14 07:00:00	NVDA	Stock	10.1245	10.252	10.1	10.25	702800.0
2020-07-14 08:00:00	NVDA	Stock	10.1251	10.2638	10.0688	10.0815	2266200.0
2020-07-14 09:00:00	NVDA	Stock	10.0972	10.2339	9.7855	9.9655	74994240.0
2020-07-14 10:00:00	NVDA	Stock	9.9623	10.0944	9.804	9.9886	66134000.0
2020-07-14 11:00:00	NVDA	Stock	9.9905	10.2152	9.9125	10.1243	54651800.0
2020-07-14 12:00:00	NVDA	Stock	10.124	10.2071	10.0673	10.0955	34638760.0
2020-07-14 13:00:00	NVDA	Stock	10.0972	10.273	10.0436	10.2435	30573760.0
2020-07-14 14:00:00	NVDA	Stock	10.24	10.3325	10.2148	10.305	37419160.0
2020-07-14 15:00:00	NVDA	Stock	10.3061	10.4028	10.1931	10.3805	65186880.0
2020-07-14 16:00:00	NVDA	Stock	10.377	10.4028	10.3628	10.375	14953240.0
2020-07-14 17:00:00	NVDA	Stock	10.3663	10.4235	10.3663	10.385	1131320.0
2020-07-14 18:00:00	NVDA	Stock	10.3873	10.45	10.3873	10.44	597800.0
2020-07-14 19:00:00	NVDA	Stock	10.4412	10.4488	10.4058	10.4488	659320.0
2020-07-14 04:00:00	AMZN	Stock	156.0	156.754	156.0	156.55	28300.0
2020-07-14 06:00:00	AMZN	Stock	156.3165	156.3165	155.914	155.914	43080.0

> showing 50 of 57,358 rows — these rows as CSV

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