PREVIEW / stock_1hour / 2021-02-25

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-25.parquet
  size:    1.5 MB
  rows:    71,272
  symbols: 2,842

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-25 04:00:00	AAPL	Stock	124.8	125.0	123.92	124.35	55785.0
2021-02-25 05:00:00	AAPL	Stock	124.34	124.78	124.2	124.78	17960.0
2021-02-25 06:00:00	AAPL	Stock	124.82	125.0	123.62	124.22	68468.0
2021-02-25 07:00:00	AAPL	Stock	124.2	124.78	124.01	124.34	450019.0
2021-02-25 08:00:00	AAPL	Stock	124.166	125.663	124.021	124.88	536546.0
2021-02-25 09:00:00	AAPL	Stock	124.85	126.458	124.21	124.63	12619007.0
2021-02-25 10:00:00	AAPL	Stock	124.63	124.66	123.13	124.0	17833003.0
2021-02-25 11:00:00	AAPL	Stock	123.99	124.23	122.45	122.59	13206335.0
2021-02-25 12:00:00	AAPL	Stock	122.59	122.89	121.26	121.28	16927151.0
2021-02-25 13:00:00	AAPL	Stock	121.28	122.65	120.75	122.185	16379186.0
2021-02-25 14:00:00	AAPL	Stock	122.175	123.43	121.99	122.06	12321280.0
2021-02-25 15:00:00	AAPL	Stock	122.05	122.29	120.54	121.0	24925248.0
2021-02-25 16:00:00	AAPL	Stock	120.99	125.35	120.56	120.67	10014236.0
2021-02-25 17:00:00	AAPL	Stock	120.67	120.74	120.4	120.45	258263.0
2021-02-25 18:00:00	AAPL	Stock	120.5	120.99	120.35	120.42	302760.0
2021-02-25 19:00:00	AAPL	Stock	120.45	121.0	119.82	120.8	559259.0
2021-02-25 04:00:00	MSFT	Stock	233.54	233.54	231.97	232.5	15244.0
2021-02-25 05:00:00	MSFT	Stock	232.51	233.68	232.5	233.68	3305.0
2021-02-25 06:00:00	MSFT	Stock	233.59	233.61	231.21	232.05	7961.0
2021-02-25 07:00:00	MSFT	Stock	232.05	232.85	232.0	232.25	25382.0
2021-02-25 08:00:00	MSFT	Stock	232.329	233.964	231.65	232.71	39294.0
2021-02-25 09:00:00	MSFT	Stock	232.7	234.585	231.71	234.2	2080340.0
2021-02-25 10:00:00	MSFT	Stock	234.2	234.23	231.59	233.11	3433835.0
2021-02-25 11:00:00	MSFT	Stock	233.08	234.1	230.48	230.62	3007082.0
2021-02-25 12:00:00	MSFT	Stock	230.63	231.25	229.29	229.44	4519566.0
2021-02-25 13:00:00	MSFT	Stock	229.44	230.91	228.5	230.65	3047232.0
2021-02-25 14:00:00	MSFT	Stock	230.63	232.29	230.15	230.17	1949894.0
2021-02-25 15:00:00	MSFT	Stock	230.15	230.67	227.88	228.83	6855464.0
2021-02-25 16:00:00	MSFT	Stock	228.83	234.55	228.16	228.32	5271404.0
2021-02-25 17:00:00	MSFT	Stock	228.22	228.99	228.11	228.3	14607.0
2021-02-25 18:00:00	MSFT	Stock	228.5	229.81	228.25	228.35	29393.0
2021-02-25 19:00:00	MSFT	Stock	228.53	229.6	227.2	228.7	19257.0
2021-02-25 04:00:00	NVDA	Stock	14.2	14.225	14.1475	14.15	158520.0
2021-02-25 05:00:00	NVDA	Stock	14.1948	14.225	14.1948	14.2125	118800.0
2021-02-25 06:00:00	NVDA	Stock	14.2125	14.2125	14.1062	14.1248	144360.0
2021-02-25 07:00:00	NVDA	Stock	14.1248	14.1875	14.05	14.108	2435120.0
2021-02-25 08:00:00	NVDA	Stock	14.125	14.1932	13.954	14.093	5141560.0
2021-02-25 09:00:00	NVDA	Stock	14.0752	14.3748	14.0062	14.1078	103797360.0
2021-02-25 10:00:00	NVDA	Stock	14.1102	14.1385	13.8555	13.9426	87691320.0
2021-02-25 11:00:00	NVDA	Stock	13.9426	13.9682	13.6775	13.7188	67847760.0
2021-02-25 12:00:00	NVDA	Stock	13.7238	13.7238	13.3752	13.401	78902680.0
2021-02-25 13:00:00	NVDA	Stock	13.4084	13.4885	13.268	13.4081	90049000.0
2021-02-25 14:00:00	NVDA	Stock	13.4032	13.5845	13.359	13.3955	56416240.0
2021-02-25 15:00:00	NVDA	Stock	13.395	13.4252	13.2162	13.3075	120038160.0
2021-02-25 16:00:00	NVDA	Stock	13.3095	13.4625	13.2625	13.2865	32582320.0
2021-02-25 17:00:00	NVDA	Stock	13.2762	13.305	13.2578	13.2985	833560.0
2021-02-25 18:00:00	NVDA	Stock	13.3072	13.575	13.275	13.4812	6373280.0
2021-02-25 19:00:00	NVDA	Stock	13.4828	13.5125	13.3875	13.42	2016440.0
2021-02-25 04:00:00	AMZN	Stock	157.255	157.255	157.254	157.254	5280.0
2021-02-25 06:00:00	AMZN	Stock	156.9995	156.9995	156.5	156.5155	9980.0

> showing 50 of 71,272 rows — these rows as CSV

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