PREVIEW / stock_1hour / 2022-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-04.parquet
  size:    1.4 MB
  rows:    63,780
  symbols: 2,234

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
2022-08-04 04:00:00	AAPL	Stock	165.63	166.04	165.63	165.81	17081.0
2022-08-04 05:00:00	AAPL	Stock	165.76	166.11	165.62	166.1	12104.0
2022-08-04 06:00:00	AAPL	Stock	166.1	166.65	166.1	166.47	21527.0
2022-08-04 07:00:00	AAPL	Stock	166.43	166.46	165.92	165.93	88708.0
2022-08-04 08:00:00	AAPL	Stock	166.4745	166.58	165.33	166.49	466153.0
2022-08-04 09:00:00	AAPL	Stock	166.48	167.19	165.7092	166.22	8683147.0
2022-08-04 10:00:00	AAPL	Stock	166.225	166.59	164.5612	165.3103	7807369.0
2022-08-04 11:00:00	AAPL	Stock	165.31	165.49	164.43	165.3838	5405988.0
2022-08-04 12:00:00	AAPL	Stock	165.39	165.735	164.791	164.96	4481280.0
2022-08-04 13:00:00	AAPL	Stock	164.96	165.57	164.95	165.26	3356607.0
2022-08-04 14:00:00	AAPL	Stock	165.26	165.61	165.01	165.55	3308808.0
2022-08-04 15:00:00	AAPL	Stock	165.55	166.06	165.27	165.82	7749115.0
2022-08-04 16:00:00	AAPL	Stock	165.82	165.85	165.6	165.69	4316518.0
2022-08-04 17:00:00	AAPL	Stock	165.64	165.6962	165.61	165.66	11058.0
2022-08-04 18:00:00	AAPL	Stock	165.63	165.77	165.61	165.71	15269.0
2022-08-04 19:00:00	AAPL	Stock	165.7	165.86	165.69	165.86	33252.0
2022-08-04 04:00:00	MSFT	Stock	281.85	282.0	281.15	281.19	4113.0
2022-08-04 05:00:00	MSFT	Stock	281.4	281.8	281.4	281.8	5719.0
2022-08-04 06:00:00	MSFT	Stock	282.4	283.3	282.4	283.16	5001.0
2022-08-04 07:00:00	MSFT	Stock	283.0	283.01	281.67	281.72	23688.0
2022-08-04 08:00:00	MSFT	Stock	283.1983	283.1983	281.21	282.71	28199.0
2022-08-04 09:00:00	MSFT	Stock	282.68	283.4	281.11	282.78	1891059.0
2022-08-04 10:00:00	MSFT	Stock	282.745	283.36	280.1677	281.73	2189233.0
2022-08-04 11:00:00	MSFT	Stock	281.73	282.94	280.54	282.77	1212695.0
2022-08-04 12:00:00	MSFT	Stock	282.78	283.75	281.35	281.36	1396141.0
2022-08-04 13:00:00	MSFT	Stock	281.36	283.04	281.35	282.64	760356.0
2022-08-04 14:00:00	MSFT	Stock	282.64	283.29	282.1	283.07	1116086.0
2022-08-04 15:00:00	MSFT	Stock	283.07	283.8	282.665	283.65	2039906.0
2022-08-04 16:00:00	MSFT	Stock	283.65	283.83	283.3454	283.65	2429293.0
2022-08-04 17:00:00	MSFT	Stock	283.52	283.88	283.51	283.5325	3625.0
2022-08-04 18:00:00	MSFT	Stock	283.51	283.8	283.51	283.72	4347.0
2022-08-04 19:00:00	MSFT	Stock	283.7	284.08	283.7	284.0	11270.0
2022-08-04 04:00:00	NVDA	Stock	18.842	18.886	18.825	18.868	53310.0
2022-08-04 05:00:00	NVDA	Stock	18.87	18.946	18.848	18.943	34390.0
2022-08-04 06:00:00	NVDA	Stock	18.948	19.082	18.948	19.025	126820.0
2022-08-04 07:00:00	NVDA	Stock	19.029	19.058	18.869	18.869	291730.0
2022-08-04 08:00:00	NVDA	Stock	19.017	19.0323	18.802	18.933	1282260.0
2022-08-04 09:00:00	NVDA	Stock	18.941	19.165	18.76	19.0746	58464970.0
2022-08-04 10:00:00	NVDA	Stock	19.0755	19.239	18.766	18.929	69931220.0
2022-08-04 11:00:00	NVDA	Stock	18.925	19.0585	18.803	19.031	48414450.0
2022-08-04 12:00:00	NVDA	Stock	19.0325	19.167	18.957	19.011	34894350.0
2022-08-04 13:00:00	NVDA	Stock	19.01	19.206	19.006	19.1599	33532520.0
2022-08-04 14:00:00	NVDA	Stock	19.1585	19.229	19.0786	19.198	28433880.0
2022-08-04 15:00:00	NVDA	Stock	19.199	19.274	19.134	19.215	42216850.0
2022-08-04 16:00:00	NVDA	Stock	19.215	19.224	19.184	19.195	12098500.0
2022-08-04 17:00:00	NVDA	Stock	19.196	19.1994	19.182	19.184	101050.0
2022-08-04 18:00:00	NVDA	Stock	19.185	19.2	19.182	19.199	137520.0
2022-08-04 19:00:00	NVDA	Stock	19.2	19.24	19.199	19.24	228300.0
2022-08-04 04:00:00	AMZN	Stock	139.41	139.52	139.29	139.4	5584.0
2022-08-04 05:00:00	AMZN	Stock	139.34	139.99	139.22	139.99	6378.0

> showing 50 of 63,780 rows — these rows as CSV

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