PREVIEW / stock_1hour / 2023-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-23.parquet
  size:    1.3 MB
  rows:    59,938
  symbols: 1,728

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-03-23 04:00:00	AAPL	Stock	159.02	159.78	158.52	159.71	31411.0
2023-03-23 05:00:00	AAPL	Stock	159.72	159.82	159.44	159.7	40404.0
2023-03-23 06:00:00	AAPL	Stock	159.75	159.82	159.33	159.6	15613.0
2023-03-23 07:00:00	AAPL	Stock	159.61	159.8	159.43	159.45	58617.0
2023-03-23 08:00:00	AAPL	Stock	159.7	159.85	158.44	159.51	221139.0
2023-03-23 09:00:00	AAPL	Stock	159.51	159.78	158.61	159.67	6403541.0
2023-03-23 10:00:00	AAPL	Stock	159.67	161.2999	159.54	161.24	8071398.0
2023-03-23 11:00:00	AAPL	Stock	161.24	161.5501	160.36	160.6402	6138353.0
2023-03-23 12:00:00	AAPL	Stock	160.645	161.02	160.31	160.41	4239392.0
2023-03-23 13:00:00	AAPL	Stock	160.41	160.64	159.52	159.61	5131276.0
2023-03-23 14:00:00	AAPL	Stock	159.6024	159.83	157.7	158.6005	7775399.0
2023-03-23 15:00:00	AAPL	Stock	158.61	159.64	157.68	158.89	12495756.0
2023-03-23 16:00:00	AAPL	Stock	158.89	159.97	158.64	159.2	8082966.0
2023-03-23 17:00:00	AAPL	Stock	159.2	159.37	158.93	159.2228	193550.0
2023-03-23 18:00:00	AAPL	Stock	159.22	159.22	158.8	158.93	29680.0
2023-03-23 19:00:00	AAPL	Stock	158.94	159.32	158.9	159.05	18897.0
2023-03-23 04:00:00	MSFT	Stock	274.1	277.0	273.98	276.67	19780.0
2023-03-23 05:00:00	MSFT	Stock	276.4	276.6	275.87	276.31	7668.0
2023-03-23 06:00:00	MSFT	Stock	276.49	276.49	275.51	276.0	10994.0
2023-03-23 07:00:00	MSFT	Stock	276.02	276.67	275.33	275.98	18615.0
2023-03-23 08:00:00	MSFT	Stock	276.2115	276.6	271.61	276.1995	63763.0
2023-03-23 09:00:00	MSFT	Stock	276.25	278.61	275.3	276.98	2897056.0
2023-03-23 10:00:00	MSFT	Stock	276.99	280.13	276.39	280.09	3655931.0
2023-03-23 11:00:00	MSFT	Stock	280.1	281.06	279.59	280.31	3060885.0
2023-03-23 12:00:00	MSFT	Stock	280.29	280.68	279.69	280.01	2143958.0
2023-03-23 13:00:00	MSFT	Stock	280.04	280.4099	278.65	278.84	2564248.0
2023-03-23 14:00:00	MSFT	Stock	278.84	279.2299	275.3813	277.28	3905801.0
2023-03-23 15:00:00	MSFT	Stock	277.3	279.05	275.2	277.63	5443504.0
2023-03-23 16:00:00	MSFT	Stock	277.59	278.38	276.8	277.81	4235894.0
2023-03-23 17:00:00	MSFT	Stock	277.81	277.92	277.66	277.75	142364.0
2023-03-23 18:00:00	MSFT	Stock	277.75	277.75	276.76	277.0	13114.0
2023-03-23 19:00:00	MSFT	Stock	277.17	277.58	276.9	277.06	3596.0
2023-03-23 04:00:00	NVDA	Stock	26.684	27.189	26.68	27.02	861370.0
2023-03-23 05:00:00	NVDA	Stock	27.03	27.048	26.982	27.048	222860.0
2023-03-23 06:00:00	NVDA	Stock	27.06	27.06	26.911	26.994	182920.0
2023-03-23 07:00:00	NVDA	Stock	26.996	27.08	26.958	27.025	1606770.0
2023-03-23 08:00:00	NVDA	Stock	26.735	27.14	26.735	27.087	3637200.0
2023-03-23 09:00:00	NVDA	Stock	27.09	27.388	27.0162	27.322	68320910.0
2023-03-23 10:00:00	NVDA	Stock	27.33	27.48	27.147	27.3014	73982510.0
2023-03-23 11:00:00	NVDA	Stock	27.301	27.499	27.3005	27.3275	54253380.0
2023-03-23 12:00:00	NVDA	Stock	27.3235	27.446	27.2	27.301	35520190.0
2023-03-23 13:00:00	NVDA	Stock	27.303	27.402	27.037	27.052	40541630.0
2023-03-23 14:00:00	NVDA	Stock	27.056	27.1316	26.69	26.969	58699710.0
2023-03-23 15:00:00	NVDA	Stock	26.9744	27.303	26.778	27.182	78313770.0
2023-03-23 16:00:00	NVDA	Stock	27.191	27.261	27.164	27.237	23789970.0
2023-03-23 17:00:00	NVDA	Stock	27.223	27.3061	27.202	27.255	516890.0
2023-03-23 18:00:00	NVDA	Stock	27.252	27.27	27.201	27.235	219290.0
2023-03-23 19:00:00	NVDA	Stock	27.225	27.329	27.225	27.315	688750.0
2023-03-23 04:00:00	AMZN	Stock	99.55	100.05	98.75	100.01	22366.0
2023-03-23 05:00:00	AMZN	Stock	99.96	100.29	99.8	100.07	16707.0

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

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