PREVIEW / stock_1hour / 2022-02-16

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-16.parquet
  size:    1.4 MB
  rows:    62,785
  symbols: 2,538

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
2022-02-16 04:00:00	AAPL	Stock	173.05	173.2	171.99	172.7	16087.0
2022-02-16 05:00:00	AAPL	Stock	172.5	172.54	172.0	172.54	7575.0
2022-02-16 06:00:00	AAPL	Stock	172.5	172.7	172.35	172.7	3801.0
2022-02-16 07:00:00	AAPL	Stock	172.71	172.74	171.95	172.0	69840.0
2022-02-16 08:00:00	AAPL	Stock	172.6899	173.221	171.88	172.06	433550.0
2022-02-16 09:00:00	AAPL	Stock	172.05	172.8612	170.05	170.575	7670533.0
2022-02-16 10:00:00	AAPL	Stock	170.575	171.22	170.265	171.04	6616063.0
2022-02-16 11:00:00	AAPL	Stock	171.05	171.19	170.35	171.105	4187875.0
2022-02-16 12:00:00	AAPL	Stock	171.1	171.41	170.18	170.675	4173012.0
2022-02-16 13:00:00	AAPL	Stock	170.67	170.895	170.545	170.78	2544579.0
2022-02-16 14:00:00	AAPL	Stock	170.7691	172.88	170.54	172.88	8638772.0
2022-02-16 15:00:00	AAPL	Stock	172.8721	173.34	172.31	172.55	9442208.0
2022-02-16 16:00:00	AAPL	Stock	172.55	172.63	172.0	172.13	5622800.0
2022-02-16 17:00:00	AAPL	Stock	172.16	172.45	172.16	172.3	26071.0
2022-02-16 18:00:00	AAPL	Stock	172.35	172.55	172.09	172.12	28921.0
2022-02-16 19:00:00	AAPL	Stock	172.11	172.3	172.0	172.17	30490.0
2022-02-16 04:00:00	MSFT	Stock	300.7	300.95	300.4	300.4	1729.0
2022-02-16 05:00:00	MSFT	Stock	299.86	300.84	299.81	299.81	3439.0
2022-02-16 06:00:00	MSFT	Stock	300.29	300.29	299.91	299.91	360.0
2022-02-16 07:00:00	MSFT	Stock	300.3	300.45	299.0	299.2	18661.0
2022-02-16 08:00:00	MSFT	Stock	300.1014	300.5	298.41	298.775	37816.0
2022-02-16 09:00:00	MSFT	Stock	298.51	298.9	293.73	294.0687	2381390.0
2022-02-16 10:00:00	MSFT	Stock	294.03	295.135	293.68	294.77	2509787.0
2022-02-16 11:00:00	MSFT	Stock	294.81	296.74	294.6	296.7	1916350.0
2022-02-16 12:00:00	MSFT	Stock	296.7	297.31	295.51	296.31	1563967.0
2022-02-16 13:00:00	MSFT	Stock	296.29	297.03	295.845	296.6641	1147256.0
2022-02-16 14:00:00	MSFT	Stock	296.77	299.85	295.8	299.62	2991002.0
2022-02-16 15:00:00	MSFT	Stock	299.61	300.87	298.62	299.5	3463090.0
2022-02-16 16:00:00	MSFT	Stock	299.5	299.9	299.0	299.18	4371723.0
2022-02-16 17:00:00	MSFT	Stock	299.17	299.4	299.17	299.4	6442.0
2022-02-16 18:00:00	MSFT	Stock	299.22	299.8	298.57	298.78	9906.0
2022-02-16 19:00:00	MSFT	Stock	298.78	299.2	298.34	299.2	12125.0
2022-02-16 04:00:00	NVDA	Stock	26.628	26.742	26.549	26.62	334690.0
2022-02-16 05:00:00	NVDA	Stock	26.57	26.575	26.418	26.525	95520.0
2022-02-16 06:00:00	NVDA	Stock	26.55	26.599	26.498	26.588	153540.0
2022-02-16 07:00:00	NVDA	Stock	26.57	26.695	26.51	26.56	1325180.0
2022-02-16 08:00:00	NVDA	Stock	26.6	26.7	26.405	26.423	2343690.0
2022-02-16 09:00:00	NVDA	Stock	26.43	26.45	25.552	25.773	64470880.0
2022-02-16 10:00:00	NVDA	Stock	25.764	26.365	25.6813	26.2665	80778410.0
2022-02-16 11:00:00	NVDA	Stock	26.27	26.295	26.058	26.0935	45222710.0
2022-02-16 12:00:00	NVDA	Stock	26.0939	26.117	25.693	25.705	45941410.0
2022-02-16 13:00:00	NVDA	Stock	25.704	25.9	25.589	25.843	44602830.0
2022-02-16 14:00:00	NVDA	Stock	25.846	26.425	25.738	26.324	77650870.0
2022-02-16 15:00:00	NVDA	Stock	26.323	26.582	26.312	26.511	99547940.0
2022-02-16 16:00:00	NVDA	Stock	26.511	27.597	25.1	26.249	40392410.0
2022-02-16 17:00:00	NVDA	Stock	26.249	26.633	25.84	26.111	12950400.0
2022-02-16 18:00:00	NVDA	Stock	26.102	26.195	25.861	25.863	4148830.0
2022-02-16 19:00:00	NVDA	Stock	25.863	25.9	25.682	25.801	3657140.0
2022-02-16 04:00:00	AMZN	Stock	157.0	157.0	157.0	157.0	2000.0
2022-02-16 05:00:00	AMZN	Stock	156.9	156.9	156.9	156.9	2000.0

> showing 50 of 62,785 rows — these rows as CSV

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