PREVIEW / stock_1hour / 2022-04-08

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-08.parquet
  size:    1.4 MB
  rows:    62,421
  symbols: 2,468

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-04-08 04:00:00	AAPL	Stock	173.17	173.18	172.5	172.69	9222.0
2022-04-08 05:00:00	AAPL	Stock	172.37	172.55	172.25	172.4	9923.0
2022-04-08 06:00:00	AAPL	Stock	172.36	172.51	172.13	172.51	9943.0
2022-04-08 07:00:00	AAPL	Stock	172.5	172.69	172.22	172.57	85733.0
2022-04-08 08:00:00	AAPL	Stock	172.47	173.46	172.21	172.4	517138.0
2022-04-08 09:00:00	AAPL	Stock	172.4	172.45	169.2	169.245	10488166.0
2022-04-08 10:00:00	AAPL	Stock	169.25	170.96	169.25	170.94	11034833.0
2022-04-08 11:00:00	AAPL	Stock	170.94	171.37	170.336	171.32	8520052.0
2022-04-08 12:00:00	AAPL	Stock	171.31	171.77	171.0	171.6206	5806921.0
2022-04-08 13:00:00	AAPL	Stock	171.63	171.64	170.115	170.17	4933060.0
2022-04-08 14:00:00	AAPL	Stock	170.1698	170.755	169.78	170.49	6458130.0
2022-04-08 15:00:00	AAPL	Stock	170.49	170.97	169.82	170.14	11520919.0
2022-04-08 16:00:00	AAPL	Stock	170.14	170.25	169.93	169.99	7794186.0
2022-04-08 17:00:00	AAPL	Stock	169.98	170.02	169.9	169.9109	50598.0
2022-04-08 18:00:00	AAPL	Stock	169.93	169.9399	169.71	169.76	27635.0
2022-04-08 19:00:00	AAPL	Stock	169.74	169.8	169.74	169.76	22805.0
2022-04-08 04:00:00	MSFT	Stock	302.62	303.03	302.48	302.48	3251.0
2022-04-08 05:00:00	MSFT	Stock	301.51	302.28	301.37	301.72	1770.0
2022-04-08 06:00:00	MSFT	Stock	301.55	302.27	301.41	302.27	2186.0
2022-04-08 07:00:00	MSFT	Stock	302.3	302.7	301.63	302.2	14747.0
2022-04-08 08:00:00	MSFT	Stock	302.4	302.6	300.5342	300.5342	15782.0
2022-04-08 09:00:00	MSFT	Stock	300.17	300.79	296.76	296.8601	2100165.0
2022-04-08 10:00:00	MSFT	Stock	296.86	300.19	296.78	300.164	2119164.0
2022-04-08 11:00:00	MSFT	Stock	300.13	300.7	299.11	300.35	1581586.0
2022-04-08 12:00:00	MSFT	Stock	300.35	301.12	299.76	300.57	1526097.0
2022-04-08 13:00:00	MSFT	Stock	300.6	300.6025	298.83	298.84	1105639.0
2022-04-08 14:00:00	MSFT	Stock	298.8	299.13	296.78	298.295	2025170.0
2022-04-08 15:00:00	MSFT	Stock	298.28	298.59	296.28	297.0	3610172.0
2022-04-08 16:00:00	MSFT	Stock	297.0	297.08	296.5501	296.69	3731393.0
2022-04-08 17:00:00	MSFT	Stock	296.6892	296.79	296.6113	296.7	13747.0
2022-04-08 18:00:00	MSFT	Stock	296.64	296.65	296.5	296.5	5323.0
2022-04-08 19:00:00	MSFT	Stock	296.5	296.63	296.41	296.4201	3750.0
2022-04-08 04:00:00	NVDA	Stock	24.499	24.56	24.364	24.39	135490.0
2022-04-08 05:00:00	NVDA	Stock	24.303	24.4	24.303	24.342	85780.0
2022-04-08 06:00:00	NVDA	Stock	24.341	24.363	24.25	24.363	113040.0
2022-04-08 07:00:00	NVDA	Stock	24.335	24.389	24.28	24.34	288370.0
2022-04-08 08:00:00	NVDA	Stock	24.335	24.526	24.1	24.106	938780.0
2022-04-08 09:00:00	NVDA	Stock	24.106	24.106	23.225	23.238	57884470.0
2022-04-08 10:00:00	NVDA	Stock	23.237	23.511	23.11	23.5069	84957010.0
2022-04-08 11:00:00	NVDA	Stock	23.508	23.594	23.1904	23.355	55532250.0
2022-04-08 12:00:00	NVDA	Stock	23.353	23.53	23.295	23.512	45257240.0
2022-04-08 13:00:00	NVDA	Stock	23.514	23.514	23.168	23.229	35606240.0
2022-04-08 14:00:00	NVDA	Stock	23.227	23.325	23.062	23.205	43182140.0
2022-04-08 15:00:00	NVDA	Stock	23.205	23.328	23.097	23.111	59486580.0
2022-04-08 16:00:00	NVDA	Stock	23.111	23.145	23.018	23.05	22568100.0
2022-04-08 17:00:00	NVDA	Stock	23.05	23.277	23.035	23.1579	1276980.0
2022-04-08 18:00:00	NVDA	Stock	23.155	23.155	23.062	23.081	271840.0
2022-04-08 19:00:00	NVDA	Stock	23.089	23.11	23.05	23.05	271130.0
2022-04-08 04:00:00	AMZN	Stock	158.7625	158.7625	158.5	158.5	8240.0
2022-04-08 07:00:00	AMZN	Stock	158.4	158.6	158.4	158.4	41460.0

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

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