PREVIEW / stock_1hour / 2021-02-26

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-26.parquet
  size:    1.5 MB
  rows:    69,905
  symbols: 2,844

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
2021-02-26 04:00:00	AAPL	Stock	121.68	121.95	120.93	121.7	88533.0
2021-02-26 05:00:00	AAPL	Stock	121.6	121.64	120.56	120.77	54901.0
2021-02-26 06:00:00	AAPL	Stock	120.69	121.06	119.75	120.28	78251.0
2021-02-26 07:00:00	AAPL	Stock	120.29	121.83	120.0	121.13	538254.0
2021-02-26 08:00:00	AAPL	Stock	121.1	122.54	120.1	122.54	1115084.0
2021-02-26 09:00:00	AAPL	Stock	122.52	123.95	122.0	122.315	16251417.0
2021-02-26 10:00:00	AAPL	Stock	122.32	124.12	121.29	123.847	24172309.0
2021-02-26 11:00:00	AAPL	Stock	123.847	124.48	123.0	124.36	14975676.0
2021-02-26 12:00:00	AAPL	Stock	124.35	124.76	123.585	123.68	10987523.0
2021-02-26 13:00:00	AAPL	Stock	123.685	124.35	122.76	123.07	10295861.0
2021-02-26 14:00:00	AAPL	Stock	123.07	123.685	122.78	123.59	11273257.0
2021-02-26 15:00:00	AAPL	Stock	123.59	124.85	121.2	121.2	25880395.0
2021-02-26 16:00:00	AAPL	Stock	121.28	122.19	120.85	121.89	22546588.0
2021-02-26 17:00:00	AAPL	Stock	121.85	122.1	121.7	122.03	266726.0
2021-02-26 18:00:00	AAPL	Stock	122.0	122.09	121.7	121.85	143609.0
2021-02-26 19:00:00	AAPL	Stock	121.82	121.95	121.69	121.76	138646.0
2021-02-26 04:00:00	MSFT	Stock	229.86	230.0	228.9	229.8	2520.0
2021-02-26 05:00:00	MSFT	Stock	229.1	229.37	228.53	228.83	4708.0
2021-02-26 06:00:00	MSFT	Stock	228.51	228.9	227.13	227.41	4633.0
2021-02-26 07:00:00	MSFT	Stock	227.77	230.95	227.7	229.2	45050.0
2021-02-26 08:00:00	MSFT	Stock	228.06	231.98	228.06	231.27	61704.0
2021-02-26 09:00:00	MSFT	Stock	231.68	233.16	230.1	231.175	3078760.0
2021-02-26 10:00:00	MSFT	Stock	231.21	233.31	229.54	232.94	3519520.0
2021-02-26 11:00:00	MSFT	Stock	232.95	233.81	231.41	233.36	2242435.0
2021-02-26 12:00:00	MSFT	Stock	233.45	235.183	232.63	233.97	2173393.0
2021-02-26 13:00:00	MSFT	Stock	234.02	235.21	232.92	233.24	1713889.0
2021-02-26 14:00:00	MSFT	Stock	233.25	234.45	232.74	233.915	1729755.0
2021-02-26 15:00:00	MSFT	Stock	233.9	235.37	232.18	232.19	4745862.0
2021-02-26 16:00:00	MSFT	Stock	232.38	233.5	231.81	232.41	7556914.0
2021-02-26 17:00:00	MSFT	Stock	232.49	232.55	232.0	232.22	26373.0
2021-02-26 18:00:00	MSFT	Stock	232.3	232.5	232.22	232.5	4546.0
2021-02-26 19:00:00	MSFT	Stock	232.4	232.4	232.0	232.0	4989.0
2021-02-26 04:00:00	NVDA	Stock	13.54	13.55	13.4993	13.515	117440.0
2021-02-26 05:00:00	NVDA	Stock	13.515	13.515	13.465	13.465	85800.0
2021-02-26 06:00:00	NVDA	Stock	13.465	13.465	13.35	13.35	53760.0
2021-02-26 07:00:00	NVDA	Stock	13.4975	13.6228	13.435	13.56	1607320.0
2021-02-26 08:00:00	NVDA	Stock	13.45	13.725	13.3408	13.6981	4272800.0
2021-02-26 09:00:00	NVDA	Stock	13.7005	13.8538	13.5168	13.6074	66245320.0
2021-02-26 10:00:00	NVDA	Stock	13.6099	13.67	13.361	13.625	77776040.0
2021-02-26 11:00:00	NVDA	Stock	13.6375	13.7625	13.5505	13.6862	42163720.0
2021-02-26 12:00:00	NVDA	Stock	13.6815	13.8305	13.6062	13.7382	38888600.0
2021-02-26 13:00:00	NVDA	Stock	13.7312	13.8312	13.6882	13.7325	37433560.0
2021-02-26 14:00:00	NVDA	Stock	13.7334	13.7508	13.6278	13.7281	34781360.0
2021-02-26 15:00:00	NVDA	Stock	13.728	13.8545	13.7031	13.705	62306480.0
2021-02-26 16:00:00	NVDA	Stock	13.7145	13.7262	13.6493	13.688	15114080.0
2021-02-26 17:00:00	NVDA	Stock	13.685	13.685	13.6275	13.6812	483080.0
2021-02-26 18:00:00	NVDA	Stock	13.6812	13.6812	13.65	13.6688	185880.0
2021-02-26 19:00:00	NVDA	Stock	13.6688	13.6795	13.6625	13.6625	79440.0
2021-02-26 04:00:00	AMZN	Stock	153.4	153.4	152.55	152.95	15360.0
2021-02-26 05:00:00	AMZN	Stock	152.8	152.925	152.8	152.925	15260.0

> showing 50 of 69,905 rows — these rows as CSV

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