PREVIEW / stock_1hour / 2023-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-07.parquet
  size:    1.4 MB
  rows:    61,583
  symbols: 1,861

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-07 04:00:00	AAPL	Stock	151.79	152.09	151.67	151.96	31311.0
2023-02-07 05:00:00	AAPL	Stock	152.01	152.01	151.7	151.7	8116.0
2023-02-07 06:00:00	AAPL	Stock	151.71	151.77	151.6	151.64	9850.0
2023-02-07 07:00:00	AAPL	Stock	151.78	152.1	151.68	151.95	59638.0
2023-02-07 08:00:00	AAPL	Stock	151.7	152.39	151.19	151.37	229456.0
2023-02-07 09:00:00	AAPL	Stock	151.39	152.925	150.33	152.3156	8552250.0
2023-02-07 10:00:00	AAPL	Stock	152.31	153.19	151.84	152.6	7913831.0
2023-02-07 11:00:00	AAPL	Stock	152.6	153.5999	152.561	153.014	5538127.0
2023-02-07 12:00:00	AAPL	Stock	153.015	155.23	152.38	154.8101	7438475.0
2023-02-07 13:00:00	AAPL	Stock	154.83	155.15	151.36	152.1299	10476063.0
2023-02-07 14:00:00	AAPL	Stock	152.1162	154.47	152.048	154.22	7233403.0
2023-02-07 15:00:00	AAPL	Stock	154.22	155.22	153.43	154.64	12740588.0
2023-02-07 16:00:00	AAPL	Stock	154.64	154.66	153.87	153.99	11302399.0
2023-02-07 17:00:00	AAPL	Stock	154.0	154.2	153.99	154.19	43419.0
2023-02-07 18:00:00	AAPL	Stock	154.15	154.6	154.12	154.1999	84457.0
2023-02-07 19:00:00	AAPL	Stock	154.19	154.25	153.91	154.15	47025.0
2023-02-07 04:00:00	MSFT	Stock	257.27	260.0	257.27	259.3	47253.0
2023-02-07 05:00:00	MSFT	Stock	259.43	259.52	258.65	258.65	11603.0
2023-02-07 06:00:00	MSFT	Stock	258.51	258.9	258.3	258.87	8584.0
2023-02-07 07:00:00	MSFT	Stock	258.88	259.96	258.75	259.95	35000.0
2023-02-07 08:00:00	MSFT	Stock	259.03	261.0	256.129	260.16	168638.0
2023-02-07 09:00:00	MSFT	Stock	260.16	263.45	259.75	260.8	5175734.0
2023-02-07 10:00:00	MSFT	Stock	260.7801	263.6699	260.5689	262.56	4721240.0
2023-02-07 11:00:00	MSFT	Stock	262.55	264.62	261.97	264.14	3580132.0
2023-02-07 12:00:00	MSFT	Stock	264.13	268.32	262.88	267.31	4291821.0
2023-02-07 13:00:00	MSFT	Stock	267.33	267.92	261.44	262.495	5127678.0
2023-02-07 14:00:00	MSFT	Stock	262.4858	267.335	262.41	266.6	4633634.0
2023-02-07 15:00:00	MSFT	Stock	266.61	268.775	266.11	267.56	6728755.0
2023-02-07 16:00:00	MSFT	Stock	267.56	267.9184	266.58	267.1	4513068.0
2023-02-07 17:00:00	MSFT	Stock	267.2	268.2	267.05	268.1399	57107.0
2023-02-07 18:00:00	MSFT	Stock	268.14	270.15	268.14	269.35	122974.0
2023-02-07 19:00:00	MSFT	Stock	269.35	270.02	269.0	269.82	66602.0
2023-02-07 04:00:00	NVDA	Stock	21.193	21.529	21.112	21.504	514450.0
2023-02-07 05:00:00	NVDA	Stock	21.528	21.57	21.361	21.361	374690.0
2023-02-07 06:00:00	NVDA	Stock	21.387	21.452	21.368	21.427	166410.0
2023-02-07 07:00:00	NVDA	Stock	21.42	21.478	21.376	21.424	426200.0
2023-02-07 08:00:00	NVDA	Stock	21.437	21.4849	21.0363	21.3291	2012750.0
2023-02-07 09:00:00	NVDA	Stock	21.32	21.438	21.15	21.3161	54282240.0
2023-02-07 10:00:00	NVDA	Stock	21.3218	21.42	21.192	21.3805	60253140.0
2023-02-07 11:00:00	NVDA	Stock	21.3825	21.7069	21.3825	21.6625	74884880.0
2023-02-07 12:00:00	NVDA	Stock	21.662	22.172	21.487	22.068	82003050.0
2023-02-07 13:00:00	NVDA	Stock	22.068	22.123	21.277	21.437	82666440.0
2023-02-07 14:00:00	NVDA	Stock	21.4375	21.985	21.423	21.9188	74386280.0
2023-02-07 15:00:00	NVDA	Stock	21.922	22.259	21.791	22.172	89532670.0
2023-02-07 16:00:00	NVDA	Stock	22.173	22.189	22.0924	22.129	26413820.0
2023-02-07 17:00:00	NVDA	Stock	22.12	22.173	22.1151	22.1661	502340.0
2023-02-07 18:00:00	NVDA	Stock	22.175	22.35	22.17	22.25	733420.0
2023-02-07 19:00:00	NVDA	Stock	22.25	22.35	22.25	22.331	642630.0
2023-02-07 04:00:00	AMZN	Stock	102.2	102.6	102.12	102.5	18018.0
2023-02-07 05:00:00	AMZN	Stock	102.43	102.47	102.23	102.23	23355.0

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

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