PREVIEW / stock_1hour / 2023-02-16

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-16.parquet
  size:    1.4 MB
  rows:    61,676
  symbols: 1,882

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-02-16 04:00:00	AAPL	Stock	155.41	155.41	155.02	155.03	21691.0
2023-02-16 05:00:00	AAPL	Stock	155.02	155.2	155.0	155.1	5171.0
2023-02-16 06:00:00	AAPL	Stock	155.06	155.33	155.06	155.3	25007.0
2023-02-16 07:00:00	AAPL	Stock	155.29	155.42	154.85	154.94	33016.0
2023-02-16 08:00:00	AAPL	Stock	154.93	155.7	153.1	153.49	388190.0
2023-02-16 09:00:00	AAPL	Stock	153.46	154.6571	153.02	154.08	7333758.0
2023-02-16 10:00:00	AAPL	Stock	154.075	155.22	153.8	155.15	7672293.0
2023-02-16 11:00:00	AAPL	Stock	155.16	155.5	154.8889	155.07	5743114.0
2023-02-16 12:00:00	AAPL	Stock	155.065	156.17	154.75	155.93	5964238.0
2023-02-16 13:00:00	AAPL	Stock	155.94	156.19	155.535	155.95	4794988.0
2023-02-16 14:00:00	AAPL	Stock	155.95	156.33	155.72	156.19	4903219.0
2023-02-16 15:00:00	AAPL	Stock	156.2	156.2499	153.59	153.69	10947003.0
2023-02-16 16:00:00	AAPL	Stock	153.71	153.73	153.06	153.27	8792079.0
2023-02-16 17:00:00	AAPL	Stock	153.29	153.32	153.2	153.27	45255.0
2023-02-16 18:00:00	AAPL	Stock	153.3	153.38	152.75	152.98	103242.0
2023-02-16 19:00:00	AAPL	Stock	152.97	153.08	152.81	152.81	39386.0
2023-02-16 04:00:00	MSFT	Stock	270.08	270.39	269.95	270.0	4694.0
2023-02-16 05:00:00	MSFT	Stock	269.83	270.0	269.69	270.0	1823.0
2023-02-16 06:00:00	MSFT	Stock	270.0	270.0	268.41	268.41	12423.0
2023-02-16 07:00:00	MSFT	Stock	268.75	269.19	268.1	268.52	14306.0
2023-02-16 08:00:00	MSFT	Stock	269.12	270.91	264.51	265.031	126505.0
2023-02-16 09:00:00	MSFT	Stock	265.03	265.5	263.1	264.37	3603127.0
2023-02-16 10:00:00	MSFT	Stock	264.35	266.74	264.07	265.74	2704050.0
2023-02-16 11:00:00	MSFT	Stock	265.8	266.29	264.72	264.83	1962157.0
2023-02-16 12:00:00	MSFT	Stock	264.825	266.41	264.43	265.9608	1480552.0
2023-02-16 13:00:00	MSFT	Stock	266.0	266.26	264.89	265.375	1342798.0
2023-02-16 14:00:00	MSFT	Stock	265.38	265.74	264.9574	265.0999	1600128.0
2023-02-16 15:00:00	MSFT	Stock	265.08	265.25	261.9	262.14	4499509.0
2023-02-16 16:00:00	MSFT	Stock	262.15	262.4076	261.33	261.79	5187519.0
2023-02-16 17:00:00	MSFT	Stock	261.82	262.0	261.11	261.15	31449.0
2023-02-16 18:00:00	MSFT	Stock	261.15	261.2	260.48	260.75	23587.0
2023-02-16 19:00:00	MSFT	Stock	260.75	261.25	260.4	260.75	24361.0
2023-02-16 04:00:00	NVDA	Stock	22.7	22.7	22.55	22.6	275050.0
2023-02-16 05:00:00	NVDA	Stock	22.59	22.594	22.4	22.427	267860.0
2023-02-16 06:00:00	NVDA	Stock	22.428	22.5	22.423	22.477	175360.0
2023-02-16 07:00:00	NVDA	Stock	22.487	22.61	22.478	22.525	416580.0
2023-02-16 08:00:00	NVDA	Stock	22.53	22.98	22.151	22.19	2935190.0
2023-02-16 09:00:00	NVDA	Stock	22.184	22.3677	22.022	22.218	60043300.0
2023-02-16 10:00:00	NVDA	Stock	22.219	22.423	21.983	22.282	62728940.0
2023-02-16 11:00:00	NVDA	Stock	22.286	22.391	22.166	22.3175	35268440.0
2023-02-16 12:00:00	NVDA	Stock	22.312	22.514	22.211	22.405	34247340.0
2023-02-16 13:00:00	NVDA	Stock	22.405	22.54	22.343	22.5146	27327460.0
2023-02-16 14:00:00	NVDA	Stock	22.5138	22.55	22.3807	22.424	21838850.0
2023-02-16 15:00:00	NVDA	Stock	22.424	22.434	21.9268	21.996	61110480.0
2023-02-16 16:00:00	NVDA	Stock	22.002	22.01	21.85	21.866	29902140.0
2023-02-16 17:00:00	NVDA	Stock	21.867	21.9208	21.825	21.841	319850.0
2023-02-16 18:00:00	NVDA	Stock	21.84	21.84	21.675	21.68	679500.0
2023-02-16 19:00:00	NVDA	Stock	21.683	21.736	21.668	21.72	492190.0
2023-02-16 04:00:00	AMZN	Stock	101.05	101.27	100.97	100.97	15538.0
2023-02-16 05:00:00	AMZN	Stock	100.97	101.06	100.88	100.96	5624.0

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

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