PREVIEW / stock_1hour / 2021-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-04.parquet
  size:    1.4 MB
  rows:    65,351
  symbols: 2,762

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-10-04 04:00:00	AAPL	Stock	141.46	141.83	141.35	141.62	17459.0
2021-10-04 05:00:00	AAPL	Stock	141.63	141.84	141.4	141.5	22051.0
2021-10-04 06:00:00	AAPL	Stock	141.46	141.7	141.21	141.6	18391.0
2021-10-04 07:00:00	AAPL	Stock	141.59	141.84	141.23	141.53	154882.0
2021-10-04 08:00:00	AAPL	Stock	141.5499	142.2	141.24	141.99	434353.0
2021-10-04 09:00:00	AAPL	Stock	141.9551	142.21	140.24	140.73	9461530.0
2021-10-04 10:00:00	AAPL	Stock	140.72	140.8844	138.837	139.11	14583485.0
2021-10-04 11:00:00	AAPL	Stock	139.11	139.5	138.63	139.239	10799303.0
2021-10-04 12:00:00	AAPL	Stock	139.23	139.25	138.31	138.5199	9018534.0
2021-10-04 13:00:00	AAPL	Stock	138.515	138.98	138.27	138.56	7468678.0
2021-10-04 14:00:00	AAPL	Stock	138.56	139.22	138.53	138.945	8822865.0
2021-10-04 15:00:00	AAPL	Stock	138.95	139.32	138.47	139.19	15366601.0
2021-10-04 16:00:00	AAPL	Stock	139.14	139.35	139.14	139.21	9796905.0
2021-10-04 17:00:00	AAPL	Stock	139.24	139.24	139.15	139.21	47471.0
2021-10-04 18:00:00	AAPL	Stock	139.22	139.5	139.21	139.41	75465.0
2021-10-04 19:00:00	AAPL	Stock	139.42	139.48	139.14	139.14	75525.0
2021-10-04 04:00:00	MSFT	Stock	287.05	287.29	286.57	286.57	1735.0
2021-10-04 05:00:00	MSFT	Stock	287.11	287.38	287.01	287.01	1248.0
2021-10-04 06:00:00	MSFT	Stock	287.29	287.38	286.7	287.38	11550.0
2021-10-04 07:00:00	MSFT	Stock	287.35	287.47	286.7	287.1	88484.0
2021-10-04 08:00:00	MSFT	Stock	287.29	288.45	286.7	288.2061	35656.0
2021-10-04 09:00:00	MSFT	Stock	288.12	288.1259	283.55	284.1	2632363.0
2021-10-04 10:00:00	MSFT	Stock	284.09	284.32	280.4	281.25	3565869.0
2021-10-04 11:00:00	MSFT	Stock	281.22	282.77	280.7601	282.3	2974484.0
2021-10-04 12:00:00	MSFT	Stock	282.27	282.72	280.47	280.915	1815171.0
2021-10-04 13:00:00	MSFT	Stock	280.9	281.7217	280.25	281.08	1586518.0
2021-10-04 14:00:00	MSFT	Stock	281.1	282.9	281.075	282.635	1776003.0
2021-10-04 15:00:00	MSFT	Stock	282.66	283.54	281.7	283.14	3786791.0
2021-10-04 16:00:00	MSFT	Stock	283.11	283.9807	283.11	283.75	4597925.0
2021-10-04 17:00:00	MSFT	Stock	283.68	283.74	283.3	283.3	7655.0
2021-10-04 18:00:00	MSFT	Stock	283.6	284.1	283.6	284.0	13363.0
2021-10-04 19:00:00	MSFT	Stock	283.99	284.0	283.11	283.51	12781.0
2021-10-04 04:00:00	NVDA	Stock	20.553	20.632	20.47	20.502	32820.0
2021-10-04 05:00:00	NVDA	Stock	20.53	20.572	20.53	20.539	8970.0
2021-10-04 06:00:00	NVDA	Stock	20.534	20.573	20.47	20.47	23410.0
2021-10-04 07:00:00	NVDA	Stock	20.52	20.552	20.43	20.49	351170.0
2021-10-04 08:00:00	NVDA	Stock	20.4401	20.6902	20.43	20.56	686700.0
2021-10-04 09:00:00	NVDA	Stock	20.56	20.577	19.92	20.07	41269190.0
2021-10-04 10:00:00	NVDA	Stock	20.068	20.0802	19.733	19.8595	44624490.0
2021-10-04 11:00:00	NVDA	Stock	19.858	19.974	19.693	19.8	30121950.0
2021-10-04 12:00:00	NVDA	Stock	19.799	19.8669	19.669	19.686	26616070.0
2021-10-04 13:00:00	NVDA	Stock	19.685	19.8	19.628	19.635	25100640.0
2021-10-04 14:00:00	NVDA	Stock	19.638	19.744	19.6321	19.731	22069610.0
2021-10-04 15:00:00	NVDA	Stock	19.737	19.822	19.555	19.736	47602630.0
2021-10-04 16:00:00	NVDA	Stock	19.732	19.773	19.732	19.76	24802580.0
2021-10-04 17:00:00	NVDA	Stock	19.765	19.773	19.744	19.756	155180.0
2021-10-04 18:00:00	NVDA	Stock	19.756	19.814	19.756	19.795	583560.0
2021-10-04 19:00:00	NVDA	Stock	19.798	19.798	19.705	19.75	417250.0
2021-10-04 05:00:00	AMZN	Stock	163.066	163.066	163.066	163.066	2000.0
2021-10-04 06:00:00	AMZN	Stock	163.25	163.25	163.25	163.25	2000.0

> showing 50 of 65,351 rows — these rows as CSV

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