PREVIEW / stock_1hour / 2021-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-24.parquet
  size:    1.5 MB
  rows:    67,597
  symbols: 2,934

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-03-24 04:00:00	AAPL	Stock	122.64	123.43	122.5	123.43	17101.0
2021-03-24 05:00:00	AAPL	Stock	123.47	123.52	123.2	123.39	21495.0
2021-03-24 06:00:00	AAPL	Stock	123.38	123.38	123.07	123.15	6152.0
2021-03-24 07:00:00	AAPL	Stock	123.06	123.18	122.91	123.039	117230.0
2021-03-24 08:00:00	AAPL	Stock	123.05	123.2	122.82	122.83	270633.0
2021-03-24 09:00:00	AAPL	Stock	122.82	123.01	121.605	121.63	8956640.0
2021-03-24 10:00:00	AAPL	Stock	121.635	122.02	121.11	121.71	11918958.0
2021-03-24 11:00:00	AAPL	Stock	121.71	122.44	121.44	121.56	8483911.0
2021-03-24 12:00:00	AAPL	Stock	121.56	121.72	121.11	121.13	7325898.0
2021-03-24 13:00:00	AAPL	Stock	121.13	121.49	120.65	121.435	10179725.0
2021-03-24 14:00:00	AAPL	Stock	121.43	121.55	120.522	120.56	7691560.0
2021-03-24 15:00:00	AAPL	Stock	120.565	120.8455	120.065	120.0776	14578690.0
2021-03-24 16:00:00	AAPL	Stock	120.09	120.199	119.99	120.12	6422403.0
2021-03-24 17:00:00	AAPL	Stock	120.12	120.15	120.06	120.11	61187.0
2021-03-24 18:00:00	AAPL	Stock	120.14	120.29	120.06	120.21	66581.0
2021-03-24 19:00:00	AAPL	Stock	120.22	120.3	120.01	120.13	135299.0
2021-03-24 04:00:00	MSFT	Stock	238.66	239.97	238.66	239.9	2123.0
2021-03-24 05:00:00	MSFT	Stock	240.0	240.02	239.95	239.96	3251.0
2021-03-24 06:00:00	MSFT	Stock	239.47	239.47	238.73	238.88	885.0
2021-03-24 07:00:00	MSFT	Stock	238.81	239.29	238.81	238.94	17308.0
2021-03-24 08:00:00	MSFT	Stock	238.73	239.29	236.987	238.67	31512.0
2021-03-24 09:00:00	MSFT	Stock	238.7	238.75	235.7199	236.0	2435717.0
2021-03-24 10:00:00	MSFT	Stock	236.0	236.9	235.32	236.725	2987430.0
2021-03-24 11:00:00	MSFT	Stock	236.73	237.905	236.29	236.49	2121928.0
2021-03-24 12:00:00	MSFT	Stock	236.49	236.9	236.11	236.157	1403719.0
2021-03-24 13:00:00	MSFT	Stock	236.15	237.43	235.8	237.375	1606456.0
2021-03-24 14:00:00	MSFT	Stock	237.36	237.62	236.32	236.38	1271496.0
2021-03-24 15:00:00	MSFT	Stock	236.38	236.84	235.34	235.46	3651370.0
2021-03-24 16:00:00	MSFT	Stock	235.46	235.8	234.99	235.1	2949509.0
2021-03-24 17:00:00	MSFT	Stock	235.17	235.25	235.17	235.24	3885.0
2021-03-24 18:00:00	MSFT	Stock	235.25	235.94	235.2	235.59	15380.0
2021-03-24 19:00:00	MSFT	Stock	235.74	235.79	235.34	235.34	5883.0
2021-03-24 04:00:00	NVDA	Stock	13.1675	13.2162	13.1675	13.2162	16960.0
2021-03-24 06:00:00	NVDA	Stock	13.25	13.25	13.2025	13.2025	8000.0
2021-03-24 07:00:00	NVDA	Stock	13.1955	13.225	13.1818	13.2062	189680.0
2021-03-24 08:00:00	NVDA	Stock	13.1955	13.2155	13.175	13.1875	213760.0
2021-03-24 09:00:00	NVDA	Stock	13.2	13.2	12.917	12.9518	20137000.0
2021-03-24 10:00:00	NVDA	Stock	12.9518	13.0325	12.8488	12.9935	21072920.0
2021-03-24 11:00:00	NVDA	Stock	12.9948	13.1158	12.926	12.965	15939000.0
2021-03-24 12:00:00	NVDA	Stock	12.9625	12.9731	12.8433	12.85	12053560.0
2021-03-24 13:00:00	NVDA	Stock	12.844	12.8968	12.805	12.8894	14319000.0
2021-03-24 14:00:00	NVDA	Stock	12.892	12.9	12.7832	12.8028	11415400.0
2021-03-24 15:00:00	NVDA	Stock	12.8075	12.8373	12.6368	12.6373	31360240.0
2021-03-24 16:00:00	NVDA	Stock	12.643	12.7236	12.625	12.6598	18826240.0
2021-03-24 17:00:00	NVDA	Stock	12.65	12.6598	12.6463	12.6598	163800.0
2021-03-24 18:00:00	NVDA	Stock	12.655	12.667	12.65	12.6502	237040.0
2021-03-24 19:00:00	NVDA	Stock	12.6518	12.6625	12.65	12.6562	133320.0
2021-03-24 04:00:00	AMZN	Stock	158.0005	158.0005	158.0005	158.0005	2000.0
2021-03-24 05:00:00	AMZN	Stock	158.35	158.35	158.35	158.35	4000.0
2021-03-24 06:00:00	AMZN	Stock	158.2	158.2	158.0	158.0	8180.0

> showing 50 of 67,597 rows — these rows as CSV

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