PREVIEW / stock_1hour / 2020-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-13.parquet
  size:    1.3 MB
  rows:    58,498
  symbols: 2,458

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-13 04:00:00	AAPL	Stock	96.6	96.9225	96.575	96.875	128976.0
2020-07-13 05:00:00	AAPL	Stock	96.9625	97.025	96.7575	97.0	43388.0
2020-07-13 06:00:00	AAPL	Stock	97.0	97.1675	96.9	97.0	21052.0
2020-07-13 07:00:00	AAPL	Stock	97.0625	97.125	96.875	97.015	508368.0
2020-07-13 08:00:00	AAPL	Stock	97.0062	97.1875	96.85	97.1425	684080.0
2020-07-13 09:00:00	AAPL	Stock	97.1408	98.6875	97.0875	98.435	20267924.0
2020-07-13 10:00:00	AAPL	Stock	98.44	99.8675	98.4	99.295	26292348.0
2020-07-13 11:00:00	AAPL	Stock	99.2875	99.955	99.195	99.4162	17258456.0
2020-07-13 12:00:00	AAPL	Stock	99.4225	99.6225	98.755	98.8	11107876.0
2020-07-13 13:00:00	AAPL	Stock	98.8075	99.175	98.34	98.39	11886292.0
2020-07-13 14:00:00	AAPL	Stock	98.38	98.4675	96.6375	97.8125	22578212.0
2020-07-13 15:00:00	AAPL	Stock	97.805	97.8275	95.2575	95.4775	29897852.0
2020-07-13 16:00:00	AAPL	Stock	95.4775	95.785	95.24	95.6	14113908.0
2020-07-13 17:00:00	AAPL	Stock	95.62	95.6275	95.375	95.455	113444.0
2020-07-13 18:00:00	AAPL	Stock	95.5	96.1425	95.5	95.9	168836.0
2020-07-13 19:00:00	AAPL	Stock	95.875	96.22	95.8025	96.125	125044.0
2020-07-13 04:00:00	MSFT	Stock	215.01	215.01	214.11	214.79	14005.0
2020-07-13 05:00:00	MSFT	Stock	214.82	214.87	214.5	214.56	7062.0
2020-07-13 06:00:00	MSFT	Stock	214.63	215.15	214.51	215.04	15198.0
2020-07-13 07:00:00	MSFT	Stock	215.04	215.45	214.85	215.14	62463.0
2020-07-13 08:00:00	MSFT	Stock	215.09	215.45	214.2	215.14	93933.0
2020-07-13 09:00:00	MSFT	Stock	215.15	215.22	214.2	214.44	3521997.0
2020-07-13 10:00:00	MSFT	Stock	214.44	214.85	213.71	214.5	3411571.0
2020-07-13 11:00:00	MSFT	Stock	214.51	215.623	214.34	215.04	2894809.0
2020-07-13 12:00:00	MSFT	Stock	215.07	215.8	213.8	214.121	2437907.0
2020-07-13 13:00:00	MSFT	Stock	214.14	215.17	213.93	214.02	2095729.0
2020-07-13 14:00:00	MSFT	Stock	214.013	214.284	211.12	212.386	4392157.0
2020-07-13 15:00:00	MSFT	Stock	212.38	212.47	206.5	207.1	8036761.0
2020-07-13 16:00:00	MSFT	Stock	207.07	207.6	206.62	207.25	4131516.0
2020-07-13 17:00:00	MSFT	Stock	207.2	207.3	207.07	207.25	25285.0
2020-07-13 18:00:00	MSFT	Stock	207.25	208.79	207.25	208.17	47257.0
2020-07-13 19:00:00	MSFT	Stock	208.16	208.73	208.16	208.73	19198.0
2020-07-13 04:00:00	NVDA	Stock	10.6005	10.6005	10.6005	10.6005	4760.0
2020-07-13 05:00:00	NVDA	Stock	10.6	10.6375	10.6	10.6375	16000.0
2020-07-13 06:00:00	NVDA	Stock	10.625	10.625	10.604	10.604	31520.0
2020-07-13 07:00:00	NVDA	Stock	10.6313	10.6313	10.5802	10.615	375920.0
2020-07-13 08:00:00	NVDA	Stock	10.6	10.6313	10.5052	10.6284	942400.0
2020-07-13 09:00:00	NVDA	Stock	10.6275	10.7923	10.5888	10.73	57825600.0
2020-07-13 10:00:00	NVDA	Stock	10.739	10.7533	10.6412	10.7168	38673160.0
2020-07-13 11:00:00	NVDA	Stock	10.7153	10.7313	10.637	10.676	28516040.0
2020-07-13 12:00:00	NVDA	Stock	10.6733	10.6838	10.5788	10.5817	31717320.0
2020-07-13 13:00:00	NVDA	Stock	10.5812	10.6125	10.521	10.5315	33341960.0
2020-07-13 14:00:00	NVDA	Stock	10.5293	10.5428	10.2775	10.4162	61950920.0
2020-07-13 15:00:00	NVDA	Stock	10.4162	10.4178	10.025	10.0568	78343520.0
2020-07-13 16:00:00	NVDA	Stock	10.0523	10.0788	10.0315	10.0458	13919440.0
2020-07-13 17:00:00	NVDA	Stock	10.055	10.0925	10.05	10.082	290920.0
2020-07-13 18:00:00	NVDA	Stock	10.0812	10.2	10.0812	10.15	927400.0
2020-07-13 19:00:00	NVDA	Stock	10.165	10.1875	10.1625	10.18	466320.0
2020-07-13 04:00:00	AMZN	Stock	161.75	161.75	161.05	161.2105	34380.0
2020-07-13 05:00:00	AMZN	Stock	161.4075	161.55	161.3	161.55	15260.0

> showing 50 of 58,498 rows — these rows as CSV

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