PREVIEW / stock_1hour / 2023-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-06.parquet
  size:    1.3 MB
  rows:    59,899
  symbols: 1,555

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
2023-07-06 04:00:00	AAPL	Stock	190.53	190.55	190.02	190.34	18398.0
2023-07-06 05:00:00	AAPL	Stock	190.35	190.4	190.18	190.23	8227.0
2023-07-06 06:00:00	AAPL	Stock	190.25	190.25	190.04	190.1	21916.0
2023-07-06 07:00:00	AAPL	Stock	190.07	190.3	190.05	190.11	59965.0
2023-07-06 08:00:00	AAPL	Stock	190.18	191.11	189.26	189.61	403527.0
2023-07-06 09:00:00	AAPL	Stock	189.64	190.46	189.2	189.93	5763137.0
2023-07-06 10:00:00	AAPL	Stock	189.94	190.18	189.5	189.544	4779686.0
2023-07-06 11:00:00	AAPL	Stock	189.55	190.61	189.53	190.495	4171144.0
2023-07-06 12:00:00	AAPL	Stock	190.5	191.17	190.49	190.9722	3176322.0
2023-07-06 13:00:00	AAPL	Stock	190.975	191.41	190.74	191.408	2838448.0
2023-07-06 14:00:00	AAPL	Stock	191.41	191.53	190.914	191.425	2769961.0
2023-07-06 15:00:00	AAPL	Stock	191.425	192.02	191.3222	191.78	5971900.0
2023-07-06 16:00:00	AAPL	Stock	191.71	192.0491	191.71	191.86	5403060.0
2023-07-06 17:00:00	AAPL	Stock	191.86	191.87	191.69	191.765	24866.0
2023-07-06 18:00:00	AAPL	Stock	191.76	191.8	191.65	191.7599	31487.0
2023-07-06 19:00:00	AAPL	Stock	191.75	191.97	191.75	191.83	29245.0
2023-07-06 04:00:00	MSFT	Stock	338.2	340.65	337.49	340.29	33652.0
2023-07-06 05:00:00	MSFT	Stock	340.18	341.08	339.99	340.99	7531.0
2023-07-06 06:00:00	MSFT	Stock	340.75	341.69	340.22	340.35	14067.0
2023-07-06 07:00:00	MSFT	Stock	340.3	341.3	340.3	340.65	41090.0
2023-07-06 08:00:00	MSFT	Stock	340.31	341.33	336.0	338.52	190751.0
2023-07-06 09:00:00	MSFT	Stock	338.65	340.39	335.5	338.73	4055395.0
2023-07-06 10:00:00	MSFT	Stock	338.735	341.12	336.65	338.72	3781806.0
2023-07-06 11:00:00	MSFT	Stock	338.76	340.0	338.09	339.66	1746340.0
2023-07-06 12:00:00	MSFT	Stock	339.69	342.465	339.65	341.63	2409421.0
2023-07-06 13:00:00	MSFT	Stock	341.625	342.99	341.4778	342.37	1803509.0
2023-07-06 14:00:00	MSFT	Stock	342.39	342.41	340.82	341.34	1379913.0
2023-07-06 15:00:00	MSFT	Stock	341.33	341.65	340.485	341.27	2081395.0
2023-07-06 16:00:00	MSFT	Stock	341.27	341.6975	341.19	341.33	2826854.0
2023-07-06 17:00:00	MSFT	Stock	341.3426	341.48	341.1101	341.35	11074.0
2023-07-06 18:00:00	MSFT	Stock	341.12	341.25	340.89	341.0	9311.0
2023-07-06 19:00:00	MSFT	Stock	341.0	341.7	340.8	341.35	13290.0
2023-07-06 04:00:00	NVDA	Stock	42.09	42.12	41.9	42.07	383520.0
2023-07-06 05:00:00	NVDA	Stock	42.088	42.175	42.03	42.145	239900.0
2023-07-06 06:00:00	NVDA	Stock	42.15	42.165	42.056	42.075	118020.0
2023-07-06 07:00:00	NVDA	Stock	42.1	42.35	42.1	42.325	574410.0
2023-07-06 08:00:00	NVDA	Stock	42.135	42.372	41.91	41.95	2253770.0
2023-07-06 09:00:00	NVDA	Stock	41.95	42.01	41.346	41.535	44353090.0
2023-07-06 10:00:00	NVDA	Stock	41.532	41.813	41.397	41.526	41513230.0
2023-07-06 11:00:00	NVDA	Stock	41.5216	41.794	41.457	41.649	25624640.0
2023-07-06 12:00:00	NVDA	Stock	41.654	41.8839	41.617	41.856	18690180.0
2023-07-06 13:00:00	NVDA	Stock	41.865	42.01	41.732	42.0075	20976210.0
2023-07-06 14:00:00	NVDA	Stock	42.009	42.179	41.934	42.1393	24983470.0
2023-07-06 15:00:00	NVDA	Stock	42.135	42.148	41.88	42.096	28985020.0
2023-07-06 16:00:00	NVDA	Stock	42.097	42.141	42.07	42.12	16253870.0
2023-07-06 17:00:00	NVDA	Stock	42.115	42.115	42.082	42.101	144580.0
2023-07-06 18:00:00	NVDA	Stock	42.099	42.099	42.025	42.06	203570.0
2023-07-06 19:00:00	NVDA	Stock	42.06	42.13	42.05	42.12	221450.0
2023-07-06 04:00:00	AMZN	Stock	129.94	129.94	129.6	129.7	19110.0
2023-07-06 05:00:00	AMZN	Stock	129.67	129.75	129.55	129.75	3059.0

> showing 50 of 59,899 rows — these rows as CSV

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