PREVIEW / stock_1hour / 2021-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-03.parquet
  size:    1.4 MB
  rows:    64,702
  symbols: 2,801

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-08-03 04:00:00	AAPL	Stock	146.1	146.35	145.79	145.9	12873.0
2021-08-03 05:00:00	AAPL	Stock	145.9	145.9	145.43	145.75	10663.0
2021-08-03 06:00:00	AAPL	Stock	145.83	145.87	145.66	145.79	11622.0
2021-08-03 07:00:00	AAPL	Stock	145.74	145.8	145.39	145.69	81114.0
2021-08-03 08:00:00	AAPL	Stock	145.6001	145.89	145.49	145.85	632080.0
2021-08-03 09:00:00	AAPL	Stock	145.86	146.6	145.18	145.5232	9279119.0
2021-08-03 10:00:00	AAPL	Stock	145.53	146.15	145.33	145.94	8524353.0
2021-08-03 11:00:00	AAPL	Stock	145.93	147.06	145.435	147.0101	8086228.0
2021-08-03 12:00:00	AAPL	Stock	147.0201	147.75	146.9492	147.73	6885694.0
2021-08-03 13:00:00	AAPL	Stock	147.73	148.045	147.71	147.825	5272709.0
2021-08-03 14:00:00	AAPL	Stock	147.83	147.96	147.13	147.44	4906971.0
2021-08-03 15:00:00	AAPL	Stock	147.44	147.74	147.14	147.34	7983796.0
2021-08-03 16:00:00	AAPL	Stock	147.36	147.42	147.31	147.36	4497048.0
2021-08-03 17:00:00	AAPL	Stock	147.36	147.48	147.35	147.42	33281.0
2021-08-03 18:00:00	AAPL	Stock	147.42	147.48	147.1	147.2	53633.0
2021-08-03 19:00:00	AAPL	Stock	147.15	147.2	147.01	147.1	66073.0
2021-08-03 04:00:00	MSFT	Stock	284.97	285.44	284.97	285.44	557.0
2021-08-03 05:00:00	MSFT	Stock	285.54	285.6	285.1	285.4	1220.0
2021-08-03 06:00:00	MSFT	Stock	285.27	285.4	285.25	285.35	1160.0
2021-08-03 07:00:00	MSFT	Stock	285.33	285.37	284.76	284.76	3242.0
2021-08-03 08:00:00	MSFT	Stock	285.0	285.3895	284.75	285.3	113315.0
2021-08-03 09:00:00	MSFT	Stock	285.4	286.89	284.54	284.93	1704930.0
2021-08-03 10:00:00	MSFT	Stock	284.915	285.82	284.21	285.1	2023066.0
2021-08-03 11:00:00	MSFT	Stock	285.09	286.84	284.25	286.68	1841233.0
2021-08-03 12:00:00	MSFT	Stock	286.68	287.05	286.37	286.952	1204355.0
2021-08-03 13:00:00	MSFT	Stock	286.96	287.1	286.17	286.31	974227.0
2021-08-03 14:00:00	MSFT	Stock	286.325	287.07	286.065	286.71	1051884.0
2021-08-03 15:00:00	MSFT	Stock	286.72	287.23	286.315	287.12	1975307.0
2021-08-03 16:00:00	MSFT	Stock	287.12	287.2	286.81	287.05	2220143.0
2021-08-03 17:00:00	MSFT	Stock	287.1	287.1	286.9	286.9	2112.0
2021-08-03 18:00:00	MSFT	Stock	286.9	287.03	286.56	286.79	4607.0
2021-08-03 19:00:00	MSFT	Stock	286.65	286.7	286.3	286.3	7902.0
2021-08-03 04:00:00	NVDA	Stock	19.758	19.758	19.687	19.753	35120.0
2021-08-03 05:00:00	NVDA	Stock	19.774	19.775	19.735	19.735	78780.0
2021-08-03 06:00:00	NVDA	Stock	19.745	19.75	19.6	19.6	100580.0
2021-08-03 07:00:00	NVDA	Stock	19.648	19.69	19.54	19.66	286060.0
2021-08-03 08:00:00	NVDA	Stock	19.5893	19.69	19.567	19.66	525560.0
2021-08-03 09:00:00	NVDA	Stock	19.655	20.222	19.646	19.8149	46151510.0
2021-08-03 10:00:00	NVDA	Stock	19.815	19.98	19.63	19.907	33553730.0
2021-08-03 11:00:00	NVDA	Stock	19.907	19.97	19.22	19.722	72462590.0
2021-08-03 12:00:00	NVDA	Stock	19.728	19.804	19.644	19.8	19670560.0
2021-08-03 13:00:00	NVDA	Stock	19.8025	19.862	19.66	19.7016	20991210.0
2021-08-03 14:00:00	NVDA	Stock	19.706	19.79	19.621	19.754	16030300.0
2021-08-03 15:00:00	NVDA	Stock	19.755	19.834	19.727	19.815	21478950.0
2021-08-03 16:00:00	NVDA	Stock	19.815	19.825	19.778	19.785	9203970.0
2021-08-03 17:00:00	NVDA	Stock	19.785	19.815	19.785	19.79	167660.0
2021-08-03 18:00:00	NVDA	Stock	19.792	19.792	19.74	19.74	262920.0
2021-08-03 19:00:00	NVDA	Stock	19.739	19.749	19.686	19.715	243810.0
2021-08-03 04:00:00	AMZN	Stock	166.7835	166.7835	166.7695	166.7695	4000.0
2021-08-03 05:00:00	AMZN	Stock	167.0	167.0	167.0	167.0	2780.0

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

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