PREVIEW / stock_1hour / 2021-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-19.parquet
  size:    1.5 MB
  rows:    68,836
  symbols: 2,902

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-07-19 04:00:00	AAPL	Stock	145.85	145.85	144.95	145.12	83256.0
2021-07-19 05:00:00	AAPL	Stock	145.1	145.45	144.95	145.24	59321.0
2021-07-19 06:00:00	AAPL	Stock	145.34	145.35	145.05	145.22	37587.0
2021-07-19 07:00:00	AAPL	Stock	145.17	145.29	143.3	143.69	812991.0
2021-07-19 08:00:00	AAPL	Stock	143.68	146.025	143.35	144.01	1222748.0
2021-07-19 09:00:00	AAPL	Stock	144.0	144.07	142.02	142.045	18923017.0
2021-07-19 10:00:00	AAPL	Stock	142.05	143.05	141.67	143.0314	19962436.0
2021-07-19 11:00:00	AAPL	Stock	143.04	143.95	142.85	143.3557	10899534.0
2021-07-19 12:00:00	AAPL	Stock	143.34	143.4069	142.015	142.0818	9876133.0
2021-07-19 13:00:00	AAPL	Stock	142.08	142.29	141.7	141.9	9232636.0
2021-07-19 14:00:00	AAPL	Stock	141.9	142.58	141.88	142.135	7633513.0
2021-07-19 15:00:00	AAPL	Stock	142.13	142.58	141.76	142.53	15415304.0
2021-07-19 16:00:00	AAPL	Stock	142.45	143.1899	142.27	143.11	9382483.0
2021-07-19 17:00:00	AAPL	Stock	143.05	143.2	143.01	143.17	102122.0
2021-07-19 18:00:00	AAPL	Stock	143.15	143.17	143.05	143.07	81766.0
2021-07-19 19:00:00	AAPL	Stock	143.06	143.18	143.05	143.18	59504.0
2021-07-19 04:00:00	MSFT	Stock	280.57	281.5	280.21	280.23	18919.0
2021-07-19 05:00:00	MSFT	Stock	280.09	280.84	280.0	280.6	8977.0
2021-07-19 06:00:00	MSFT	Stock	280.8	280.8	280.12	280.4	7982.0
2021-07-19 07:00:00	MSFT	Stock	280.33	280.7	278.41	279.43	65040.0
2021-07-19 08:00:00	MSFT	Stock	278.6199	280.5	278.2771	279.52	82599.0
2021-07-19 09:00:00	MSFT	Stock	279.36	280.37	277.84	278.6	3833560.0
2021-07-19 10:00:00	MSFT	Stock	278.6	279.18	274.45	276.2	4369708.0
2021-07-19 11:00:00	MSFT	Stock	276.2	277.48	275.86	276.57	2762900.0
2021-07-19 12:00:00	MSFT	Stock	276.55	276.95	275.825	276.41	1891652.0
2021-07-19 13:00:00	MSFT	Stock	276.42	276.81	275.41	275.88	1752254.0
2021-07-19 14:00:00	MSFT	Stock	275.88	276.92	275.79	276.18	1660186.0
2021-07-19 15:00:00	MSFT	Stock	276.15	277.21	275.88	277.05	3546176.0
2021-07-19 16:00:00	MSFT	Stock	277.01	277.99	276.9	277.82	5316877.0
2021-07-19 17:00:00	MSFT	Stock	277.7901	277.99	277.65	277.82	5006.0
2021-07-19 18:00:00	MSFT	Stock	277.9	277.93	277.31	277.31	16986.0
2021-07-19 19:00:00	MSFT	Stock	277.35	278.0	277.35	277.99	6118.0
2021-07-19 04:00:00	NVDA	Stock	18.15	18.161	18.0062	18.015	274600.0
2021-07-19 05:00:00	NVDA	Stock	18.0232	18.1005	18.0125	18.075	182600.0
2021-07-19 06:00:00	NVDA	Stock	18.0525	18.1002	18.045	18.0875	191720.0
2021-07-19 07:00:00	NVDA	Stock	18.1	18.1062	17.825	17.8985	2630600.0
2021-07-19 08:00:00	NVDA	Stock	18.07	18.2064	17.775	17.875	2855120.0
2021-07-19 09:00:00	NVDA	Stock	17.8688	18.5744	17.8525	18.4018	102593280.0
2021-07-19 10:00:00	NVDA	Stock	18.402	18.997	18.3138	18.9884	134493920.0
2021-07-19 11:00:00	NVDA	Stock	18.9918	19.042	18.78	18.8023	46880840.0
2021-07-19 12:00:00	NVDA	Stock	18.8074	18.841	18.6073	18.7054	37947480.0
2021-07-19 13:00:00	NVDA	Stock	18.704	18.8	18.6603	18.7092	25287600.0
2021-07-19 14:00:00	NVDA	Stock	18.7058	18.8357	18.6566	18.6853	27006360.0
2021-07-19 15:00:00	NVDA	Stock	18.6828	18.7825	18.55	18.7798	59855680.0
2021-07-19 16:00:00	NVDA	Stock	18.7798	18.95	18.7625	18.95	38384040.0
2021-07-19 17:00:00	NVDA	Stock	18.9525	19.025	18.9138	18.9702	1270840.0
2021-07-19 18:00:00	NVDA	Stock	18.9645	18.9812	18.945	18.9735	434480.0
2021-07-19 19:00:00	NVDA	Stock	18.9735	19.003	18.9538	19.0	564760.0
2021-07-19 04:00:00	AMZN	Stock	178.1	178.2575	177.75	177.9	14020.0
2021-07-19 05:00:00	AMZN	Stock	177.9	178.0	177.9	178.0	23480.0

> showing 50 of 68,836 rows — these rows as CSV

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