PREVIEW / stock_1hour / 2019-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-27.parquet
  size:    1.1 MB
  rows:    49,886
  symbols: 2,642

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-03-27 04:00:00	AAPL	Stock	46.9625	47.22	46.9625	47.065	12320.0
2019-03-27 05:00:00	AAPL	Stock	47.1	47.1	46.9625	46.9625	10340.0
2019-03-27 06:00:00	AAPL	Stock	46.915	46.95	46.8375	46.9375	13868.0
2019-03-27 07:00:00	AAPL	Stock	46.9425	47.0975	46.875	47.09	193580.0
2019-03-27 08:00:00	AAPL	Stock	46.95	47.2	46.8125	47.0925	458164.0
2019-03-27 09:00:00	AAPL	Stock	47.1125	47.41	47.065	47.13	19321324.0
2019-03-27 10:00:00	AAPL	Stock	47.13	47.44	47.0475	47.24	20741504.0
2019-03-27 11:00:00	AAPL	Stock	47.24	47.2712	46.6375	46.83	16135976.0
2019-03-27 12:00:00	AAPL	Stock	46.8275	47.145	46.8112	46.995	10946344.0
2019-03-27 13:00:00	AAPL	Stock	47.0025	47.3162	46.9075	47.2125	8890164.0
2019-03-27 14:00:00	AAPL	Stock	47.2175	47.3375	47.05	47.065	8618340.0
2019-03-27 15:00:00	AAPL	Stock	47.065	47.2175	47.0225	47.1175	13116352.0
2019-03-27 16:00:00	AAPL	Stock	47.1175	47.205	47.1175	47.1375	9604920.0
2019-03-27 17:00:00	AAPL	Stock	47.1175	47.1375	47.1	47.1125	31896.0
2019-03-27 18:00:00	AAPL	Stock	47.1125	47.125	47.0	47.0125	84840.0
2019-03-27 19:00:00	AAPL	Stock	47.0375	47.055	47.0	47.045	54344.0
2019-03-27 04:00:00	MSFT	Stock	118.15	118.32	118.0	118.32	1230.0
2019-03-27 05:00:00	MSFT	Stock	118.25	118.25	118.16	118.16	400.0
2019-03-27 06:00:00	MSFT	Stock	117.71	117.86	117.71	117.86	400.0
2019-03-27 07:00:00	MSFT	Stock	117.41	117.83	117.41	117.83	1558.0
2019-03-27 08:00:00	MSFT	Stock	117.49	117.95	117.49	117.8	5862.0
2019-03-27 09:00:00	MSFT	Stock	117.9	118.21	117.4	117.47	2046935.0
2019-03-27 10:00:00	MSFT	Stock	117.46	117.605	116.67	116.88	2948188.0
2019-03-27 11:00:00	MSFT	Stock	116.88	117.025	115.522	115.755	3740696.0
2019-03-27 12:00:00	MSFT	Stock	115.74	116.33	115.65	116.04	1911179.0
2019-03-27 13:00:00	MSFT	Stock	116.04	116.892	115.94	116.69	1516793.0
2019-03-27 14:00:00	MSFT	Stock	116.69	116.94	116.52	116.77	1603866.0
2019-03-27 15:00:00	MSFT	Stock	116.77	117.008	116.45	116.77	2958824.0
2019-03-27 16:00:00	MSFT	Stock	116.77	116.83	116.72	116.72	3248976.0
2019-03-27 17:00:00	MSFT	Stock	116.54	116.54	116.54	116.54	717.0
2019-03-27 18:00:00	MSFT	Stock	116.52	116.65	116.4	116.65	4958.0
2019-03-27 19:00:00	MSFT	Stock	116.63	116.63	116.4	116.4	5363.0
2019-03-27 04:00:00	NVDA	Stock	4.445	4.4502	4.445	4.45	20000.0
2019-03-27 05:00:00	NVDA	Stock	4.458	4.458	4.4218	4.4218	68160.0
2019-03-27 06:00:00	NVDA	Stock	4.422	4.422	4.422	4.422	8000.0
2019-03-27 07:00:00	NVDA	Stock	4.425	4.436	4.4062	4.435	575160.0
2019-03-27 08:00:00	NVDA	Stock	4.4027	4.4425	4.4008	4.4305	1900160.0
2019-03-27 09:00:00	NVDA	Stock	4.43	4.4942	4.35	4.3875	97850320.0
2019-03-27 10:00:00	NVDA	Stock	4.388	4.4525	4.3868	4.4135	84694000.0
2019-03-27 11:00:00	NVDA	Stock	4.4128	4.4181	4.3425	4.3553	64700960.0
2019-03-27 12:00:00	NVDA	Stock	4.3555	4.3868	4.3485	4.374	35387440.0
2019-03-27 13:00:00	NVDA	Stock	4.3738	4.3975	4.357	4.3844	36172440.0
2019-03-27 14:00:00	NVDA	Stock	4.385	4.408	4.3782	4.389	30937760.0
2019-03-27 15:00:00	NVDA	Stock	4.3898	4.4185	4.3755	4.4148	65297240.0
2019-03-27 16:00:00	NVDA	Stock	4.4125	4.4175	4.4075	4.4075	3197000.0
2019-03-27 17:00:00	NVDA	Stock	4.4098	4.4125	4.4018	4.4028	1041040.0
2019-03-27 18:00:00	NVDA	Stock	4.405	4.4075	4.3912	4.3978	242880.0
2019-03-27 19:00:00	NVDA	Stock	4.4025	4.405	4.3962	4.3962	338720.0
2019-03-27 04:00:00	AMZN	Stock	89.5	89.5	89.5	89.5	2000.0
2019-03-27 05:00:00	AMZN	Stock	89.45	89.59	89.25	89.25	12000.0

> showing 50 of 49,886 rows — these rows as CSV

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