PREVIEW / stock_1hour / 2020-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-08.parquet
  size:    1.2 MB
  rows:    56,248
  symbols: 2,421

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-08 04:00:00	AAPL	Stock	93.715	94.05	93.67	93.975	7600.0
2020-07-08 05:00:00	AAPL	Stock	93.95	93.9525	93.3875	93.44	12520.0
2020-07-08 06:00:00	AAPL	Stock	93.375	93.8425	93.375	93.75	12968.0
2020-07-08 07:00:00	AAPL	Stock	93.82	94.075	93.82	94.0	221820.0
2020-07-08 08:00:00	AAPL	Stock	93.75	94.1875	93.405	94.1	396184.0
2020-07-08 09:00:00	AAPL	Stock	94.09	95.22	93.1725	95.03	18563884.0
2020-07-08 10:00:00	AAPL	Stock	95.0342	95.1618	94.5162	95.1025	13944056.0
2020-07-08 11:00:00	AAPL	Stock	95.1125	95.1425	94.1675	94.9375	14508480.0
2020-07-08 12:00:00	AAPL	Stock	94.9475	95.0925	94.675	95.0725	7972360.0
2020-07-08 13:00:00	AAPL	Stock	95.075	95.0925	94.4775	94.6552	6692504.0
2020-07-08 14:00:00	AAPL	Stock	94.665	95.0325	94.525	95.0075	7536776.0
2020-07-08 15:00:00	AAPL	Stock	95.0112	95.375	94.8775	95.36	13703188.0
2020-07-08 16:00:00	AAPL	Stock	95.333	95.4525	95.2625	95.4525	10821724.0
2020-07-08 17:00:00	AAPL	Stock	95.465	95.75	95.465	95.6625	175184.0
2020-07-08 18:00:00	AAPL	Stock	95.7	95.7725	95.425	95.5	234196.0
2020-07-08 19:00:00	AAPL	Stock	95.5	95.725	95.415	95.55	140792.0
2020-07-08 04:00:00	MSFT	Stock	209.53	210.0	209.29	209.75	5496.0
2020-07-08 05:00:00	MSFT	Stock	209.5	209.55	208.78	209.14	5537.0
2020-07-08 06:00:00	MSFT	Stock	209.05	209.75	209.05	209.62	5499.0
2020-07-08 07:00:00	MSFT	Stock	209.9	210.28	209.55	210.27	27141.0
2020-07-08 08:00:00	MSFT	Stock	209.83	210.33	209.35	210.07	58352.0
2020-07-08 09:00:00	MSFT	Stock	209.9	212.67	209.3	212.46	4241535.0
2020-07-08 10:00:00	MSFT	Stock	212.45	212.52	210.21	211.1	3172730.0
2020-07-08 11:00:00	MSFT	Stock	211.125	211.155	208.69	210.905	3635592.0
2020-07-08 12:00:00	MSFT	Stock	210.97	211.7	210.65	211.655	2663676.0
2020-07-08 13:00:00	MSFT	Stock	211.69	211.879	210.48	210.78	2354052.0
2020-07-08 14:00:00	MSFT	Stock	210.8	212.55	210.39	212.47	3157559.0
2020-07-08 15:00:00	MSFT	Stock	212.45	213.26	211.934	212.84	4381552.0
2020-07-08 16:00:00	MSFT	Stock	212.83	213.39	212.61	213.36	4916766.0
2020-07-08 17:00:00	MSFT	Stock	213.36	213.49	213.3	213.46	6981.0
2020-07-08 18:00:00	MSFT	Stock	213.48	213.59	213.29	213.45	17354.0
2020-07-08 19:00:00	MSFT	Stock	213.44	213.61	213.31	213.56	18800.0
2020-07-08 05:00:00	NVDA	Stock	9.9	9.946	9.9	9.946	22400.0
2020-07-08 07:00:00	NVDA	Stock	9.9548	9.9938	9.9508	9.985	476600.0
2020-07-08 08:00:00	NVDA	Stock	9.9688	9.999	9.96	9.999	1172080.0
2020-07-08 09:00:00	NVDA	Stock	9.995	10.08	9.975	10.0655	48115640.0
2020-07-08 10:00:00	NVDA	Stock	10.0638	10.1082	10.0608	10.093	45632320.0
2020-07-08 11:00:00	NVDA	Stock	10.094	10.096	9.9655	10.0775	48128600.0
2020-07-08 12:00:00	NVDA	Stock	10.0768	10.1725	10.0678	10.1528	39961600.0
2020-07-08 13:00:00	NVDA	Stock	10.1545	10.1585	10.1	10.117	22299040.0
2020-07-08 14:00:00	NVDA	Stock	10.1195	10.1409	10.0787	10.132	23971720.0
2020-07-08 15:00:00	NVDA	Stock	10.1354	10.225	10.1298	10.2225	42477640.0
2020-07-08 16:00:00	NVDA	Stock	10.216	10.2475	10.2088	10.2473	16888800.0
2020-07-08 17:00:00	NVDA	Stock	10.2473	10.3	10.245	10.275	432120.0
2020-07-08 18:00:00	NVDA	Stock	10.2875	10.295	10.2575	10.2668	396360.0
2020-07-08 19:00:00	NVDA	Stock	10.2668	10.2925	10.2632	10.28	345600.0
2020-07-08 04:00:00	AMZN	Stock	151.0	151.25	150.95	151.25	10000.0
2020-07-08 05:00:00	AMZN	Stock	151.0	151.0	151.0	151.0	2000.0
2020-07-08 06:00:00	AMZN	Stock	150.6665	150.8995	150.6665	150.8995	4240.0
2020-07-08 07:00:00	AMZN	Stock	151.1	151.403	151.05	151.375	90500.0

> showing 50 of 56,248 rows — these rows as CSV

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