PREVIEW / stock_1hour / 2020-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-17.parquet
  size:    1.2 MB
  rows:    54,918
  symbols: 2,403

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-04-17 04:00:00	AAPL	Stock	72.1975	72.625	71.75	71.875	250424.0
2020-04-17 05:00:00	AAPL	Stock	71.85	72.335	71.85	72.25	97616.0
2020-04-17 06:00:00	AAPL	Stock	72.25	72.5	72.2125	72.4825	133456.0
2020-04-17 07:00:00	AAPL	Stock	72.4425	72.8325	71.7025	71.7125	1503492.0
2020-04-17 08:00:00	AAPL	Stock	72.6575	72.8325	71.3625	71.4585	2559320.0
2020-04-17 09:00:00	AAPL	Stock	71.435	71.7362	70.695	71.01	30279832.0
2020-04-17 10:00:00	AAPL	Stock	71.0025	71.0625	69.83	70.445	27917980.0
2020-04-17 11:00:00	AAPL	Stock	70.4412	70.6475	69.8525	70.155	18382936.0
2020-04-17 12:00:00	AAPL	Stock	70.1625	70.385	69.9475	70.3012	13895236.0
2020-04-17 13:00:00	AAPL	Stock	70.3	70.345	69.9	69.9275	10491500.0
2020-04-17 14:00:00	AAPL	Stock	69.92	69.9208	69.215	69.5725	19569444.0
2020-04-17 15:00:00	AAPL	Stock	69.5775	70.74	69.5325	70.7	34946764.0
2020-04-17 16:00:00	AAPL	Stock	70.635	70.8375	70.2005	70.6325	15356736.0
2020-04-17 17:00:00	AAPL	Stock	70.6272	70.6425	70.5075	70.5075	232108.0
2020-04-17 18:00:00	AAPL	Stock	70.5075	70.5875	70.4	70.5875	159444.0
2020-04-17 19:00:00	AAPL	Stock	70.6	70.6	70.445	70.555	57944.0
2020-04-17 04:00:00	MSFT	Stock	181.32	181.32	180.05	180.96	12620.0
2020-04-17 05:00:00	MSFT	Stock	180.85	181.15	180.44	181.15	29637.0
2020-04-17 06:00:00	MSFT	Stock	181.25	181.73	180.6	181.35	16497.0
2020-04-17 07:00:00	MSFT	Stock	181.35	181.98	180.6	180.8	133056.0
2020-04-17 08:00:00	MSFT	Stock	181.886	181.97	180.0	180.262	197293.0
2020-04-17 09:00:00	MSFT	Stock	180.1	180.7	177.0	178.433	8773211.0
2020-04-17 10:00:00	MSFT	Stock	178.42	179.827	177.68	177.915	6481649.0
2020-04-17 11:00:00	MSFT	Stock	177.92	178.53	176.16	176.688	5244439.0
2020-04-17 12:00:00	MSFT	Stock	176.72	177.29	175.91	177.07	3970871.0
2020-04-17 13:00:00	MSFT	Stock	177.05	177.37	176.44	176.72	2972795.0
2020-04-17 14:00:00	MSFT	Stock	176.72	176.93	175.87	176.5	2951514.0
2020-04-17 15:00:00	MSFT	Stock	176.51	178.75	176.39	178.6	8553024.0
2020-04-17 16:00:00	MSFT	Stock	178.44	178.68	177.703	178.21	6772299.0
2020-04-17 17:00:00	MSFT	Stock	178.22	178.22	177.81	177.81	19214.0
2020-04-17 18:00:00	MSFT	Stock	177.9	177.9	177.5	177.6	16436.0
2020-04-17 19:00:00	MSFT	Stock	177.6	177.89	177.57	177.71	16888.0
2020-04-17 04:00:00	NVDA	Stock	7.645	7.645	7.5412	7.5562	159760.0
2020-04-17 05:00:00	NVDA	Stock	7.549	7.571	7.5012	7.571	133440.0
2020-04-17 06:00:00	NVDA	Stock	7.55	7.5843	7.55	7.57	73720.0
2020-04-17 07:00:00	NVDA	Stock	7.575	7.595	7.5268	7.535	1393240.0
2020-04-17 08:00:00	NVDA	Stock	7.5752	7.5975	7.4902	7.4946	3614400.0
2020-04-17 09:00:00	NVDA	Stock	7.5	7.5065	7.3312	7.3965	101626040.0
2020-04-17 10:00:00	NVDA	Stock	7.3985	7.4205	7.2946	7.3228	80884160.0
2020-04-17 11:00:00	NVDA	Stock	7.3213	7.3488	7.192	7.2329	83852400.0
2020-04-17 12:00:00	NVDA	Stock	7.2345	7.2653	7.2103	7.2372	38000320.0
2020-04-17 13:00:00	NVDA	Stock	7.2352	7.2464	7.2025	7.2087	29673240.0
2020-04-17 14:00:00	NVDA	Stock	7.2095	7.2268	7.1735	7.2225	38675600.0
2020-04-17 15:00:00	NVDA	Stock	7.223	7.3379	7.216	7.308	85781280.0
2020-04-17 16:00:00	NVDA	Stock	7.308	7.3185	7.275	7.3162	28733880.0
2020-04-17 17:00:00	NVDA	Stock	7.3088	7.3215	7.3088	7.3125	398200.0
2020-04-17 18:00:00	NVDA	Stock	7.31	7.31	7.275	7.28	362360.0
2020-04-17 19:00:00	NVDA	Stock	7.284	7.2875	7.28	7.28	482320.0
2020-04-17 04:00:00	AMZN	Stock	121.0	121.0	119.555	119.555	75140.0
2020-04-17 05:00:00	AMZN	Stock	119.8495	119.8495	119.8495	119.8495	2000.0

> showing 50 of 54,918 rows — these rows as CSV

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