PREVIEW / stock_1hour / 2023-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-07.parquet
  size:    1.4 MB
  rows:    60,867
  symbols: 1,617

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-06-07 04:00:00	AAPL	Stock	179.07	179.07	178.69	178.75	9328.0
2023-06-07 05:00:00	AAPL	Stock	178.75	178.98	178.75	178.98	4032.0
2023-06-07 06:00:00	AAPL	Stock	179.0	179.2	178.2	178.81	22499.0
2023-06-07 07:00:00	AAPL	Stock	178.81	179.15	178.58	179.06	74140.0
2023-06-07 08:00:00	AAPL	Stock	178.87	179.1999	178.5801	178.85	195011.0
2023-06-07 09:00:00	AAPL	Stock	178.93	181.21	178.15	180.425	7955135.0
2023-06-07 10:00:00	AAPL	Stock	180.42	180.64	178.49	178.73	8003531.0
2023-06-07 11:00:00	AAPL	Stock	178.71	179.61	178.57	178.88	5099675.0
2023-06-07 12:00:00	AAPL	Stock	178.909	179.05	178.0	178.1182	3950258.0
2023-06-07 13:00:00	AAPL	Stock	178.12	178.47	177.32	177.8	4589875.0
2023-06-07 14:00:00	AAPL	Stock	177.795	178.285	177.6	178.245	3469207.0
2023-06-07 15:00:00	AAPL	Stock	178.24	178.5	177.4239	177.83	8976431.0
2023-06-07 16:00:00	AAPL	Stock	177.83	177.92	177.68	177.78	8043084.0
2023-06-07 17:00:00	AAPL	Stock	177.77	177.82	177.64	177.75	67526.0
2023-06-07 18:00:00	AAPL	Stock	177.75	177.87	177.69	177.73	20257.0
2023-06-07 19:00:00	AAPL	Stock	177.76	177.92	177.7	177.92	20888.0
2023-06-07 04:00:00	MSFT	Stock	333.17	333.17	331.62	332.05	1318.0
2023-06-07 05:00:00	MSFT	Stock	332.05	333.1	331.75	332.2	9168.0
2023-06-07 06:00:00	MSFT	Stock	332.5	333.0	332.5	332.75	6335.0
2023-06-07 07:00:00	MSFT	Stock	332.89	333.2	332.42	333.19	11596.0
2023-06-07 08:00:00	MSFT	Stock	332.84	333.26	332.42	332.62	35487.0
2023-06-07 09:00:00	MSFT	Stock	332.95	334.49	330.46	330.655	2909346.0
2023-06-07 10:00:00	MSFT	Stock	330.67	330.69	325.745	326.8	5669309.0
2023-06-07 11:00:00	MSFT	Stock	326.8	327.57	325.03	325.08	3308240.0
2023-06-07 12:00:00	MSFT	Stock	325.09	325.74	323.89	324.19	3133591.0
2023-06-07 13:00:00	MSFT	Stock	324.16	324.67	323.5	323.87	2503715.0
2023-06-07 14:00:00	MSFT	Stock	323.88	324.82	323.5	324.475	1965078.0
2023-06-07 15:00:00	MSFT	Stock	324.47	324.55	322.5	323.46	4708631.0
2023-06-07 16:00:00	MSFT	Stock	323.38	323.7999	322.01	322.1	5132721.0
2023-06-07 17:00:00	MSFT	Stock	322.12	323.38	322.1	322.3	29419.0
2023-06-07 18:00:00	MSFT	Stock	322.5	322.85	322.3101	322.576	9771.0
2023-06-07 19:00:00	MSFT	Stock	322.46	322.78	322.4	322.58	11372.0
2023-06-07 04:00:00	NVDA	Stock	38.6	38.693	38.4	38.522	115460.0
2023-06-07 05:00:00	NVDA	Stock	38.482	38.53	38.47	38.518	25550.0
2023-06-07 06:00:00	NVDA	Stock	38.53	38.66	38.528	38.66	109580.0
2023-06-07 07:00:00	NVDA	Stock	38.65	39.025	38.65	38.967	705920.0
2023-06-07 08:00:00	NVDA	Stock	38.649	39.024	38.587	38.84	2083830.0
2023-06-07 09:00:00	NVDA	Stock	38.8392	39.499	38.762	39.2065	58340600.0
2023-06-07 10:00:00	NVDA	Stock	39.2065	39.408	38.365	38.465	73341780.0
2023-06-07 11:00:00	NVDA	Stock	38.4677	38.752	38.398	38.421	46274550.0
2023-06-07 12:00:00	NVDA	Stock	38.4215	38.64	38.1778	38.2123	40269400.0
2023-06-07 13:00:00	NVDA	Stock	38.213	38.321	38.06	38.1163	34510280.0
2023-06-07 14:00:00	NVDA	Stock	38.113	38.319	37.8331	37.9767	41162230.0
2023-06-07 15:00:00	NVDA	Stock	37.97	38.049	37.356	37.483	73319130.0
2023-06-07 16:00:00	NVDA	Stock	37.475	37.55	37.4	37.441	22187610.0
2023-06-07 17:00:00	NVDA	Stock	37.43	37.51	37.43	37.5	345900.0
2023-06-07 18:00:00	NVDA	Stock	37.505	37.595	37.485	37.54	548960.0
2023-06-07 19:00:00	NVDA	Stock	37.515	37.9	37.515	37.78	1462430.0
2023-06-07 04:00:00	AMZN	Stock	126.75	126.75	126.14	126.48	18565.0
2023-06-07 05:00:00	AMZN	Stock	126.45	126.47	125.81	126.13	66573.0

> showing 50 of 60,867 rows — these rows as CSV

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