PREVIEW / stock_1hour / 2023-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-04.parquet
  size:    1.4 MB
  rows:    60,971
  symbols: 1,657

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-05-04 04:00:00	AAPL	Stock	166.02	166.44	165.15	165.4	64297.0
2023-05-04 05:00:00	AAPL	Stock	165.5	165.64	165.2	165.41	18811.0
2023-05-04 06:00:00	AAPL	Stock	165.5	166.16	165.32	165.5	38542.0
2023-05-04 07:00:00	AAPL	Stock	165.52	165.57	164.8	165.15	122223.0
2023-05-04 08:00:00	AAPL	Stock	165.399	166.62	164.48	164.9	374975.0
2023-05-04 09:00:00	AAPL	Stock	164.92	165.5	164.22	165.165	8307969.0
2023-05-04 10:00:00	AAPL	Stock	165.16	166.23	165.0	165.95	7913628.0
2023-05-04 11:00:00	AAPL	Stock	165.93	166.88	165.5184	165.7766	6055246.0
2023-05-04 12:00:00	AAPL	Stock	165.76	166.64	165.43	166.58	4158999.0
2023-05-04 13:00:00	AAPL	Stock	166.585	167.04	166.01	166.37	4660444.0
2023-05-04 14:00:00	AAPL	Stock	166.38	166.4	165.3	165.615	4679581.0
2023-05-04 15:00:00	AAPL	Stock	165.61	166.34	165.08	165.78	11728018.0
2023-05-04 16:00:00	AAPL	Stock	165.78	171.47	165.3	167.39	9715542.0
2023-05-04 17:00:00	AAPL	Stock	167.3	170.26	166.69	169.2	4212342.0
2023-05-04 18:00:00	AAPL	Stock	169.2	169.66	168.8	169.35	560662.0
2023-05-04 19:00:00	AAPL	Stock	169.39	169.92	169.35	169.92	333718.0
2023-05-04 04:00:00	MSFT	Stock	306.0	306.59	305.77	306.56	7592.0
2023-05-04 05:00:00	MSFT	Stock	306.58	306.8	306.01	306.01	2991.0
2023-05-04 06:00:00	MSFT	Stock	306.18	306.21	305.98	306.21	1297.0
2023-05-04 07:00:00	MSFT	Stock	305.9	305.91	305.64	305.77	6119.0
2023-05-04 08:00:00	MSFT	Stock	305.65	306.87	305.0	305.35	43107.0
2023-05-04 09:00:00	MSFT	Stock	305.63	306.5	303.81	303.95	1999653.0
2023-05-04 10:00:00	MSFT	Stock	303.93	305.8144	303.4	305.3905	2520813.0
2023-05-04 11:00:00	MSFT	Stock	305.43	306.92	305.03	305.6	1779845.0
2023-05-04 12:00:00	MSFT	Stock	305.59	306.94	305.01	306.87	1445107.0
2023-05-04 13:00:00	MSFT	Stock	306.89	307.7626	306.55	306.98	1906827.0
2023-05-04 14:00:00	MSFT	Stock	306.99	307.11	305.71	306.14	1840064.0
2023-05-04 15:00:00	MSFT	Stock	306.13	307.21	305.14	305.535	2412934.0
2023-05-04 16:00:00	MSFT	Stock	305.56	306.6	305.19	305.32	2168993.0
2023-05-04 17:00:00	MSFT	Stock	305.32	305.8299	305.32	305.4	23223.0
2023-05-04 18:00:00	MSFT	Stock	305.4	305.76	305.27	305.76	11545.0
2023-05-04 19:00:00	MSFT	Stock	305.61	306.41	305.61	306.2	25970.0
2023-05-04 04:00:00	NVDA	Stock	27.794	27.875	27.794	27.811	59920.0
2023-05-04 05:00:00	NVDA	Stock	27.84	27.84	27.754	27.754	21050.0
2023-05-04 06:00:00	NVDA	Stock	27.728	27.745	27.702	27.714	39270.0
2023-05-04 07:00:00	NVDA	Stock	27.701	27.74	27.653	27.74	103570.0
2023-05-04 08:00:00	NVDA	Stock	27.735	27.96	27.6412	27.6609	675330.0
2023-05-04 09:00:00	NVDA	Stock	27.65	27.792	27.481	27.73	33064130.0
2023-05-04 10:00:00	NVDA	Stock	27.728	27.859	27.384	27.5495	48537190.0
2023-05-04 11:00:00	NVDA	Stock	27.547	27.7178	27.533	27.663	23449700.0
2023-05-04 12:00:00	NVDA	Stock	27.6625	27.717	27.509	27.712	19915610.0
2023-05-04 13:00:00	NVDA	Stock	27.714	27.835	27.24	27.647	58334960.0
2023-05-04 14:00:00	NVDA	Stock	27.647	27.66	27.38	27.468	23067300.0
2023-05-04 15:00:00	NVDA	Stock	27.464	27.638	27.445	27.562	25588340.0
2023-05-04 16:00:00	NVDA	Stock	27.562	27.63	27.475	27.51	14052130.0
2023-05-04 17:00:00	NVDA	Stock	27.508	27.544	27.5	27.535	226510.0
2023-05-04 18:00:00	NVDA	Stock	27.543	27.575	27.54	27.575	105580.0
2023-05-04 19:00:00	NVDA	Stock	27.572	27.687	27.572	27.68	179530.0
2023-05-04 04:00:00	AMZN	Stock	104.03	104.36	103.9	104.29	13212.0
2023-05-04 05:00:00	AMZN	Stock	104.22	104.22	104.03	104.2	9660.0

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

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