PREVIEW / stock_1hour / 2021-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-16.parquet
  size:    1.4 MB
  rows:    64,555
  symbols: 2,881

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-16 04:00:00	AAPL	Stock	148.34	148.35	148.1	148.35	10955.0
2021-07-16 05:00:00	AAPL	Stock	148.38	148.43	148.3	148.34	19011.0
2021-07-16 06:00:00	AAPL	Stock	148.35	148.78	148.2	148.7	30873.0
2021-07-16 07:00:00	AAPL	Stock	148.65	148.89	148.61	148.78	126221.0
2021-07-16 08:00:00	AAPL	Stock	148.6999	149.02	148.109	148.86	488736.0
2021-07-16 09:00:00	AAPL	Stock	148.87	149.76	148.38	149.0	13589488.0
2021-07-16 10:00:00	AAPL	Stock	149.0	149.32	148.18	148.602	12889385.0
2021-07-16 11:00:00	AAPL	Stock	148.61	148.705	147.06	147.335	10794988.0
2021-07-16 12:00:00	AAPL	Stock	147.34	147.8769	147.325	147.7	6109303.0
2021-07-16 13:00:00	AAPL	Stock	147.7	148.18	147.63	147.68	5327818.0
2021-07-16 14:00:00	AAPL	Stock	147.68	147.685	146.46	146.535	7783898.0
2021-07-16 15:00:00	AAPL	Stock	146.535	146.63	145.88	146.39	16208675.0
2021-07-16 16:00:00	AAPL	Stock	146.39	147.377	146.05	146.19	5685287.0
2021-07-16 17:00:00	AAPL	Stock	146.15	146.17	146.0	146.01	64488.0
2021-07-16 18:00:00	AAPL	Stock	146.02	146.04	145.92	145.94	52520.0
2021-07-16 19:00:00	AAPL	Stock	145.91	145.94	145.81	145.92	93162.0
2021-07-16 04:00:00	MSFT	Stock	281.06	281.06	281.01	281.01	295.0
2021-07-16 05:00:00	MSFT	Stock	281.0	281.21	280.9	281.0	7408.0
2021-07-16 06:00:00	MSFT	Stock	280.98	281.21	280.91	281.21	4309.0
2021-07-16 07:00:00	MSFT	Stock	281.33	281.65	281.33	281.56	4785.0
2021-07-16 08:00:00	MSFT	Stock	281.3299	282.2499	281.18	282.0	32568.0
2021-07-16 09:00:00	MSFT	Stock	281.96	284.1	281.8	282.78	3866747.0
2021-07-16 10:00:00	MSFT	Stock	282.79	283.08	281.02	281.13	2751714.0
2021-07-16 11:00:00	MSFT	Stock	281.13	281.22	279.46	280.37	2488926.0
2021-07-16 12:00:00	MSFT	Stock	280.36	281.93	280.33	281.4917	2046511.0
2021-07-16 13:00:00	MSFT	Stock	281.5	282.69	281.42	282.2441	1716411.0
2021-07-16 14:00:00	MSFT	Stock	282.26	282.3	281.54	281.8	1625517.0
2021-07-16 15:00:00	MSFT	Stock	281.8	281.94	280.58	280.76	3256382.0
2021-07-16 16:00:00	MSFT	Stock	280.75	281.0	280.47	280.6	2785235.0
2021-07-16 17:00:00	MSFT	Stock	280.75	280.78	280.51	280.7	3471.0
2021-07-16 18:00:00	MSFT	Stock	280.8	281.0	280.55	280.5601	2675.0
2021-07-16 19:00:00	MSFT	Stock	280.8	280.8	280.26	280.3	6549.0
2021-07-16 04:00:00	NVDA	Stock	18.8825	18.8873	18.8505	18.8873	39200.0
2021-07-16 05:00:00	NVDA	Stock	18.8922	18.8922	18.8903	18.8903	8000.0
2021-07-16 06:00:00	NVDA	Stock	18.8995	18.8995	18.8772	18.886	18000.0
2021-07-16 07:00:00	NVDA	Stock	18.9	18.9425	18.8555	18.9325	566320.0
2021-07-16 08:00:00	NVDA	Stock	18.9151	19.1343	18.87	19.125	2253440.0
2021-07-16 09:00:00	NVDA	Stock	19.125	19.1802	18.653	18.71	70732920.0
2021-07-16 10:00:00	NVDA	Stock	18.7048	18.7398	18.4352	18.5962	106456800.0
2021-07-16 11:00:00	NVDA	Stock	18.5962	18.62	18.4713	18.555	59194200.0
2021-07-16 12:00:00	NVDA	Stock	18.557	18.5974	18.4445	18.4852	30528160.0
2021-07-16 13:00:00	NVDA	Stock	18.4938	18.5397	18.3625	18.3752	32366400.0
2021-07-16 14:00:00	NVDA	Stock	18.375	18.3848	18.1898	18.2032	41555240.0
2021-07-16 15:00:00	NVDA	Stock	18.1982	18.225	18.073	18.1613	69790760.0
2021-07-16 16:00:00	NVDA	Stock	18.161	18.4172	18.1575	18.1575	15247360.0
2021-07-16 17:00:00	NVDA	Stock	18.1528	18.17	18.125	18.1477	446920.0
2021-07-16 18:00:00	NVDA	Stock	18.1477	18.1525	18.0863	18.1125	359000.0
2021-07-16 19:00:00	NVDA	Stock	18.1113	18.1188	18.0775	18.1	265320.0
2021-07-16 05:00:00	AMZN	Stock	181.56	181.56	181.56	181.56	2000.0
2021-07-16 07:00:00	AMZN	Stock	181.825	181.8925	181.825	181.8925	11580.0

> showing 50 of 64,555 rows — these rows as CSV

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