PREVIEW / stock_1hour / 2019-09-05

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-05.parquet
  size:    1.1 MB
  rows:    50,551
  symbols: 2,565

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-09-05 04:00:00	AAPL	Stock	52.65	52.875	52.65	52.875	15096.0
2019-09-05 05:00:00	AAPL	Stock	52.8975	53.0375	52.875	53.0	60896.0
2019-09-05 06:00:00	AAPL	Stock	53.005	53.0225	52.7675	52.93	44756.0
2019-09-05 07:00:00	AAPL	Stock	52.905	52.9575	52.765	52.765	228012.0
2019-09-05 08:00:00	AAPL	Stock	52.895	52.95	52.79	52.905	483608.0
2019-09-05 09:00:00	AAPL	Stock	52.91	53.4375	52.8725	53.275	15538484.0
2019-09-05 10:00:00	AAPL	Stock	53.2775	53.4925	53.15	53.2175	15458668.0
2019-09-05 11:00:00	AAPL	Stock	53.2175	53.315	53.1075	53.1075	6888160.0
2019-09-05 12:00:00	AAPL	Stock	53.105	53.175	53.03	53.0525	5070836.0
2019-09-05 13:00:00	AAPL	Stock	53.0525	53.1125	52.8775	53.0488	5926612.0
2019-09-05 14:00:00	AAPL	Stock	53.0475	53.2825	53.0112	53.275	6488992.0
2019-09-05 15:00:00	AAPL	Stock	53.275	53.3975	53.175	53.3175	11538640.0
2019-09-05 16:00:00	AAPL	Stock	53.3375	53.3375	53.2525	53.2725	10439472.0
2019-09-05 17:00:00	AAPL	Stock	53.2625	53.32	53.245	53.2875	76832.0
2019-09-05 18:00:00	AAPL	Stock	53.3325	53.3375	53.295	53.3375	39872.0
2019-09-05 19:00:00	AAPL	Stock	53.3375	53.4	53.33	53.4	80704.0
2019-09-05 04:00:00	MSFT	Stock	138.45	139.06	138.45	138.95	5553.0
2019-09-05 05:00:00	MSFT	Stock	139.08	139.3	139.0	139.29	4525.0
2019-09-05 06:00:00	MSFT	Stock	139.21	139.4	139.2	139.36	3330.0
2019-09-05 07:00:00	MSFT	Stock	139.23	139.49	139.07	139.12	35847.0
2019-09-05 08:00:00	MSFT	Stock	139.29	139.48	139.04	139.24	73326.0
2019-09-05 09:00:00	MSFT	Stock	139.24	139.67	138.76	139.47	3414855.0
2019-09-05 10:00:00	MSFT	Stock	139.48	140.384	139.44	139.88	4609927.0
2019-09-05 11:00:00	MSFT	Stock	139.89	140.05	139.36	139.4	1896671.0
2019-09-05 12:00:00	MSFT	Stock	139.406	139.66	139.364	139.38	1561960.0
2019-09-05 13:00:00	MSFT	Stock	139.38	139.54	139.205	139.435	1281115.0
2019-09-05 14:00:00	MSFT	Stock	139.435	139.778	139.38	139.599	1545619.0
2019-09-05 15:00:00	MSFT	Stock	139.6	140.05	139.59	140.05	3649431.0
2019-09-05 16:00:00	MSFT	Stock	139.99	140.12	139.81	139.9	2791546.0
2019-09-05 17:00:00	MSFT	Stock	139.87	139.92	139.87	139.91	1638.0
2019-09-05 18:00:00	MSFT	Stock	139.94	140.17	139.94	140.15	6436.0
2019-09-05 19:00:00	MSFT	Stock	140.19	140.3	140.13	140.26	10726.0
2019-09-05 04:00:00	NVDA	Stock	4.2565	4.2998	4.2565	4.2875	33480.0
2019-09-05 05:00:00	NVDA	Stock	4.293	4.2995	4.2925	4.2995	43800.0
2019-09-05 06:00:00	NVDA	Stock	4.3075	4.3078	4.2888	4.3018	48160.0
2019-09-05 07:00:00	NVDA	Stock	4.2943	4.3175	4.2913	4.31	691720.0
2019-09-05 08:00:00	NVDA	Stock	4.3115	4.3338	4.2913	4.325	1664000.0
2019-09-05 09:00:00	NVDA	Stock	4.322	4.4458	4.3125	4.428	127232320.0
2019-09-05 10:00:00	NVDA	Stock	4.4288	4.475	4.4178	4.46	124229000.0
2019-09-05 11:00:00	NVDA	Stock	4.46	4.485	4.4468	4.457	89872880.0
2019-09-05 12:00:00	NVDA	Stock	4.4565	4.4578	4.424	4.4502	53484080.0
2019-09-05 13:00:00	NVDA	Stock	4.4504	4.4648	4.4343	4.4645	42901920.0
2019-09-05 14:00:00	NVDA	Stock	4.465	4.475	4.4589	4.4668	44380360.0
2019-09-05 15:00:00	NVDA	Stock	4.4672	4.4998	4.4665	4.494	121144120.0
2019-09-05 16:00:00	NVDA	Stock	4.4935	4.4988	4.4888	4.4888	4401560.0
2019-09-05 17:00:00	NVDA	Stock	4.4868	4.4888	4.4788	4.4873	380240.0
2019-09-05 18:00:00	NVDA	Stock	4.485	4.4988	4.485	4.4942	323720.0
2019-09-05 19:00:00	NVDA	Stock	4.4953	4.5	4.4953	4.5	458160.0
2019-09-05 04:00:00	AMZN	Stock	90.6	90.975	90.6	90.975	31820.0
2019-09-05 05:00:00	AMZN	Stock	90.9875	91.0	90.9875	91.0	11360.0

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

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