PREVIEW / stock_1hour / 2023-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-15.parquet
  size:    1.4 MB
  rows:    61,572
  symbols: 1,598

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-15 04:00:00	AAPL	Stock	183.84	183.88	183.3	183.35	11130.0
2023-06-15 05:00:00	AAPL	Stock	183.36	183.39	183.01	183.1	9205.0
2023-06-15 06:00:00	AAPL	Stock	183.1	183.26	183.01	183.25	15792.0
2023-06-15 07:00:00	AAPL	Stock	183.14	183.45	183.04	183.19	43461.0
2023-06-15 08:00:00	AAPL	Stock	183.25	183.89	183.02	183.68	181027.0
2023-06-15 09:00:00	AAPL	Stock	183.68	185.2	183.45	185.196	8003933.0
2023-06-15 10:00:00	AAPL	Stock	185.195	185.85	185.0	185.42	7821182.0
2023-06-15 11:00:00	AAPL	Stock	185.425	185.9585	185.23	185.5484	5173214.0
2023-06-15 12:00:00	AAPL	Stock	185.55	185.56	185.03	185.1079	3701186.0
2023-06-15 13:00:00	AAPL	Stock	185.11	185.75	184.55	185.6735	3963829.0
2023-06-15 14:00:00	AAPL	Stock	185.69	186.52	185.46	186.34	6089393.0
2023-06-15 15:00:00	AAPL	Stock	186.34	186.45	185.69	186.03	9778252.0
2023-06-15 16:00:00	AAPL	Stock	186.01	186.04	185.55	185.72	9246225.0
2023-06-15 17:00:00	AAPL	Stock	185.72	185.85	185.62	185.8	37306.0
2023-06-15 18:00:00	AAPL	Stock	185.81	185.81	185.53	185.64	19254.0
2023-06-15 19:00:00	AAPL	Stock	185.66	185.76	185.65	185.73	16197.0
2023-06-15 04:00:00	MSFT	Stock	337.35	337.35	336.0	336.0	1712.0
2023-06-15 05:00:00	MSFT	Stock	335.82	336.18	334.82	335.1	5534.0
2023-06-15 06:00:00	MSFT	Stock	335.1	335.66	334.84	335.33	4150.0
2023-06-15 07:00:00	MSFT	Stock	335.49	335.94	335.2	335.6	17560.0
2023-06-15 08:00:00	MSFT	Stock	335.83	337.58	335.05	336.68	41693.0
2023-06-15 09:00:00	MSFT	Stock	336.68	341.9289	336.33	341.06	3862141.0
2023-06-15 10:00:00	MSFT	Stock	341.1	345.81	340.4	345.1953	5289126.0
2023-06-15 11:00:00	MSFT	Stock	345.19	346.16	344.01	345.39	2345049.0
2023-06-15 12:00:00	MSFT	Stock	345.41	346.78	345.16	345.8159	1817934.0
2023-06-15 13:00:00	MSFT	Stock	345.845	346.99	344.3914	346.71	2259505.0
2023-06-15 14:00:00	MSFT	Stock	346.72	349.23	346.1436	348.7484	2456009.0
2023-06-15 15:00:00	MSFT	Stock	348.75	349.84	347.4	348.13	4207873.0
2023-06-15 16:00:00	MSFT	Stock	348.17	349.1585	347.64	349.1585	4872512.0
2023-06-15 17:00:00	MSFT	Stock	349.0002	349.905	348.87	349.74	41947.0
2023-06-15 18:00:00	MSFT	Stock	349.51	349.53	348.395	348.45	16508.0
2023-06-15 19:00:00	MSFT	Stock	348.35	349.07	348.35	349.0	9931.0
2023-06-15 04:00:00	NVDA	Stock	43.188	43.188	42.432	42.436	524460.0
2023-06-15 05:00:00	NVDA	Stock	42.436	42.6	42.331	42.4	241730.0
2023-06-15 06:00:00	NVDA	Stock	42.374	42.43	42.068	42.286	457600.0
2023-06-15 07:00:00	NVDA	Stock	42.32	42.46	42.219	42.38	1752040.0
2023-06-15 08:00:00	NVDA	Stock	42.349	43.034	42.2115	42.464	4908660.0
2023-06-15 09:00:00	NVDA	Stock	42.4689	42.898	42.19	42.222	78648230.0
2023-06-15 10:00:00	NVDA	Stock	42.2128	42.933	42.147	42.7909	83415260.0
2023-06-15 11:00:00	NVDA	Stock	42.794	43.078	42.669	42.877	58386240.0
2023-06-15 12:00:00	NVDA	Stock	42.877	43.022	42.707	42.939	37471940.0
2023-06-15 13:00:00	NVDA	Stock	42.939	43.19	42.782	43.151	38448600.0
2023-06-15 14:00:00	NVDA	Stock	43.151	43.289	42.9	43.222	42149890.0
2023-06-15 15:00:00	NVDA	Stock	43.234	43.269	42.5	42.646	63272130.0
2023-06-15 16:00:00	NVDA	Stock	42.645	42.85	42.5787	42.666	26419260.0
2023-06-15 17:00:00	NVDA	Stock	42.67	42.731	42.65	42.71	118830.0
2023-06-15 18:00:00	NVDA	Stock	42.69	42.748	42.65	42.669	325460.0
2023-06-15 19:00:00	NVDA	Stock	42.67	42.716	42.64	42.64	420890.0
2023-06-15 04:00:00	AMZN	Stock	125.93	125.93	125.0	125.06	11017.0
2023-06-15 05:00:00	AMZN	Stock	125.2	125.38	124.96	125.0	11020.0

> showing 50 of 61,572 rows — these rows as CSV

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