PREVIEW / stock_1hour / 2020-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-03.parquet
  size:    1.2 MB
  rows:    52,158
  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-01-03 04:00:00	AAPL	Stock	74.3375	74.3375	73.9	74.05	179444.0
2020-01-03 05:00:00	AAPL	Stock	74.045	74.15	73.595	73.71	144204.0
2020-01-03 06:00:00	AAPL	Stock	73.71	73.975	73.7075	73.9175	178084.0
2020-01-03 07:00:00	AAPL	Stock	73.9475	74.55	73.9	74.5125	1021100.0
2020-01-03 08:00:00	AAPL	Stock	74.5025	74.65	73.9125	74.3975	1667388.0
2020-01-03 09:00:00	AAPL	Stock	74.38	75.1425	74.125	74.8005	28283772.0
2020-01-03 10:00:00	AAPL	Stock	74.795	74.9	74.4	74.66	18880596.0
2020-01-03 11:00:00	AAPL	Stock	74.6675	74.96	74.485	74.8375	12812748.0
2020-01-03 12:00:00	AAPL	Stock	74.8375	75.145	74.8275	75.0475	12042592.0
2020-01-03 13:00:00	AAPL	Stock	75.055	75.0975	74.6925	74.8465	10350364.0
2020-01-03 14:00:00	AAPL	Stock	74.844	74.985	74.7075	74.9562	7432488.0
2020-01-03 15:00:00	AAPL	Stock	74.9525	75.01	74.3375	74.345	19772896.0
2020-01-03 16:00:00	AAPL	Stock	74.3575	74.47	74.3575	74.38	14115480.0
2020-01-03 17:00:00	AAPL	Stock	74.4125	74.415	74.3675	74.4	108012.0
2020-01-03 18:00:00	AAPL	Stock	74.4075	74.45	74.4075	74.425	58552.0
2020-01-03 19:00:00	AAPL	Stock	74.4125	74.4125	74.3275	74.33	122120.0
2020-01-03 04:00:00	MSFT	Stock	159.06	159.06	158.5	158.74	12924.0
2020-01-03 05:00:00	MSFT	Stock	158.74	158.97	157.6	157.88	9354.0
2020-01-03 06:00:00	MSFT	Stock	157.97	158.7	157.9	158.42	28268.0
2020-01-03 07:00:00	MSFT	Stock	158.53	158.82	158.37	158.5	67267.0
2020-01-03 08:00:00	MSFT	Stock	158.55	159.04	158.4	158.89	84509.0
2020-01-03 09:00:00	MSFT	Stock	158.9	159.93	158.06	159.673	3194119.0
2020-01-03 10:00:00	MSFT	Stock	159.67	159.71	159.175	159.31	2402914.0
2020-01-03 11:00:00	MSFT	Stock	159.31	159.595	159.07	159.595	1447846.0
2020-01-03 12:00:00	MSFT	Stock	159.59	159.945	159.45	159.71	1299972.0
2020-01-03 13:00:00	MSFT	Stock	159.71	159.78	159.16	159.39	1372268.0
2020-01-03 14:00:00	MSFT	Stock	159.384	159.6	159.11	159.55	1188092.0
2020-01-03 15:00:00	MSFT	Stock	159.555	159.69	158.58	158.59	3466083.0
2020-01-03 16:00:00	MSFT	Stock	158.59	158.95	158.49	158.6	3617259.0
2020-01-03 17:00:00	MSFT	Stock	158.6	158.74	158.6	158.74	7725.0
2020-01-03 18:00:00	MSFT	Stock	158.74	158.75	158.7	158.7	1201.0
2020-01-03 19:00:00	MSFT	Stock	158.74	158.74	158.64	158.64	1927.0
2020-01-03 04:00:00	NVDA	Stock	5.9125	5.9142	5.825	5.8502	151800.0
2020-01-03 05:00:00	NVDA	Stock	5.8695	5.8738	5.804	5.804	152720.0
2020-01-03 06:00:00	NVDA	Stock	5.811	5.835	5.8055	5.827	376440.0
2020-01-03 07:00:00	NVDA	Stock	5.8275	5.8885	5.8253	5.8763	880520.0
2020-01-03 08:00:00	NVDA	Stock	5.8425	5.935	5.83	5.8925	1874480.0
2020-01-03 09:00:00	NVDA	Stock	5.893	5.9375	5.8525	5.9157	39957800.0
2020-01-03 10:00:00	NVDA	Stock	5.9133	5.9213	5.8875	5.8998	27009760.0
2020-01-03 11:00:00	NVDA	Stock	5.9008	5.9187	5.8875	5.9163	18306320.0
2020-01-03 12:00:00	NVDA	Stock	5.9158	5.9458	5.9158	5.9364	18918200.0
2020-01-03 13:00:00	NVDA	Stock	5.9371	5.9407	5.9025	5.9222	13652040.0
2020-01-03 14:00:00	NVDA	Stock	5.9218	5.9252	5.8983	5.9145	13429200.0
2020-01-03 15:00:00	NVDA	Stock	5.9145	5.9273	5.901	5.901	30189840.0
2020-01-03 16:00:00	NVDA	Stock	5.9018	5.9048	5.8968	5.8968	5063000.0
2020-01-03 17:00:00	NVDA	Stock	5.897	5.9035	5.897	5.8988	96800.0
2020-01-03 18:00:00	NVDA	Stock	5.9	5.906	5.9	5.902	101960.0
2020-01-03 19:00:00	NVDA	Stock	5.9018	5.905	5.8888	5.9018	214560.0
2020-01-03 04:00:00	AMZN	Stock	93.5	93.5	93.375	93.4	26860.0
2020-01-03 05:00:00	AMZN	Stock	93.5875	93.5875	93.01	93.01	59160.0

> showing 50 of 52,158 rows — these rows as CSV

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