PREVIEW / stock_1hour / 2019-02-26

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-26.parquet
  size:    1.1 MB
  rows:    50,176
  symbols: 2,674

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-02-26 04:00:00	AAPL	Stock	43.4	43.4	43.305	43.305	8368.0
2019-02-26 05:00:00	AAPL	Stock	43.33	43.385	43.325	43.385	6444.0
2019-02-26 06:00:00	AAPL	Stock	43.39	43.4125	43.33	43.4125	10656.0
2019-02-26 07:00:00	AAPL	Stock	43.4075	43.425	43.4	43.4	23032.0
2019-02-26 08:00:00	AAPL	Stock	43.4125	43.425	43.325	43.325	168772.0
2019-02-26 09:00:00	AAPL	Stock	43.3375	43.75	43.2932	43.71	10970468.0
2019-02-26 10:00:00	AAPL	Stock	43.715	43.825	43.4425	43.445	11247672.0
2019-02-26 11:00:00	AAPL	Stock	43.445	43.6475	43.415	43.5575	7771976.0
2019-02-26 12:00:00	AAPL	Stock	43.5575	43.5925	43.485	43.5543	5064320.0
2019-02-26 13:00:00	AAPL	Stock	43.5525	43.64	43.535	43.5588	4900980.0
2019-02-26 14:00:00	AAPL	Stock	43.56	43.6462	43.55	43.638	4375576.0
2019-02-26 15:00:00	AAPL	Stock	43.6375	43.72	43.54	43.5875	8680360.0
2019-02-26 16:00:00	AAPL	Stock	43.585	43.585	43.515	43.515	8401692.0
2019-02-26 17:00:00	AAPL	Stock	43.5	43.54	43.5	43.5275	65976.0
2019-02-26 18:00:00	AAPL	Stock	43.5275	43.55	43.4775	43.525	111056.0
2019-02-26 19:00:00	AAPL	Stock	43.545	43.5625	43.5375	43.5525	20056.0
2019-02-26 04:00:00	MSFT	Stock	111.34	111.34	111.3	111.3	1274.0
2019-02-26 05:00:00	MSFT	Stock	111.1	111.1	111.06	111.06	200.0
2019-02-26 07:00:00	MSFT	Stock	111.15	111.37	111.15	111.26	2632.0
2019-02-26 08:00:00	MSFT	Stock	111.25	111.3	111.05	111.05	6973.0
2019-02-26 09:00:00	MSFT	Stock	111.11	112.35	111.012	112.045	2442924.0
2019-02-26 10:00:00	MSFT	Stock	112.045	112.785	112.005	112.53	3366567.0
2019-02-26 11:00:00	MSFT	Stock	112.52	113.24	112.475	112.973	2829517.0
2019-02-26 12:00:00	MSFT	Stock	112.97	113.01	112.51	112.633	1640325.0
2019-02-26 13:00:00	MSFT	Stock	112.645	112.9	112.57	112.675	1448783.0
2019-02-26 14:00:00	MSFT	Stock	112.685	112.77	112.52	112.61	1458514.0
2019-02-26 15:00:00	MSFT	Stock	112.61	112.79	112.3	112.36	3196236.0
2019-02-26 16:00:00	MSFT	Stock	112.36	112.617	112.18	112.18	2963868.0
2019-02-26 17:00:00	MSFT	Stock	112.15	112.2	112.15	112.17	1546.0
2019-02-26 18:00:00	MSFT	Stock	112.15	112.2	112.12	112.15	17458.0
2019-02-26 19:00:00	MSFT	Stock	112.12	112.29	112.12	112.23	3964.0
2019-02-26 04:00:00	NVDA	Stock	3.95	3.9502	3.95	3.9502	13160.0
2019-02-26 05:00:00	NVDA	Stock	3.9498	3.9498	3.9498	3.9498	4000.0
2019-02-26 06:00:00	NVDA	Stock	3.951	3.951	3.95	3.95	28000.0
2019-02-26 07:00:00	NVDA	Stock	3.9518	3.99	3.9518	3.971	282800.0
2019-02-26 08:00:00	NVDA	Stock	3.9525	3.9888	3.95	3.9532	1387880.0
2019-02-26 09:00:00	NVDA	Stock	3.9534	4.0175	3.9312	3.9864	80044960.0
2019-02-26 10:00:00	NVDA	Stock	3.987	4.019	3.9175	3.9205	89992960.0
2019-02-26 11:00:00	NVDA	Stock	3.9205	3.9698	3.9145	3.9485	59594840.0
2019-02-26 12:00:00	NVDA	Stock	3.9485	3.952	3.9135	3.9138	35592680.0
2019-02-26 13:00:00	NVDA	Stock	3.9139	3.9275	3.8938	3.9162	55169760.0
2019-02-26 14:00:00	NVDA	Stock	3.9169	3.936	3.9	3.9048	43138680.0
2019-02-26 15:00:00	NVDA	Stock	3.9048	3.9292	3.9048	3.9285	77188720.0
2019-02-26 16:00:00	NVDA	Stock	3.9275	3.9275	3.9205	3.9255	3483360.0
2019-02-26 17:00:00	NVDA	Stock	3.9255	3.9255	3.9212	3.9238	411160.0
2019-02-26 18:00:00	NVDA	Stock	3.9225	3.9245	3.9188	3.92	310200.0
2019-02-26 19:00:00	NVDA	Stock	3.923	3.9235	3.919	3.9225	151840.0
2019-02-26 04:00:00	AMZN	Stock	81.45	81.45	81.25	81.25	15760.0
2019-02-26 05:00:00	AMZN	Stock	81.375	81.375	81.375	81.375	2000.0
2019-02-26 07:00:00	AMZN	Stock	81.335	81.434	81.335	81.434	20000.0

> showing 50 of 50,176 rows — these rows as CSV

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