PREVIEW / stock_1hour / 2022-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-06.parquet
  size:    1.4 MB
  rows:    65,062
  symbols: 2,607

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-01-06 04:00:00	AAPL	Stock	174.78	175.08	173.76	174.0	63886.0
2022-01-06 05:00:00	AAPL	Stock	174.11	174.64	173.88	173.89	56956.0
2022-01-06 06:00:00	AAPL	Stock	173.99	174.25	173.16	173.55	40360.0
2022-01-06 07:00:00	AAPL	Stock	173.6	173.84	172.87	173.13	231084.0
2022-01-06 08:00:00	AAPL	Stock	173.5901	173.82	172.81	173.5599	707375.0
2022-01-06 09:00:00	AAPL	Stock	173.53	175.3	172.1	173.979	12870685.0
2022-01-06 10:00:00	AAPL	Stock	173.95	174.3	172.17	173.5399	14414436.0
2022-01-06 11:00:00	AAPL	Stock	173.55	174.24	172.74	172.985	8842798.0
2022-01-06 12:00:00	AAPL	Stock	172.98	173.66	172.58	172.89	6848846.0
2022-01-06 13:00:00	AAPL	Stock	172.8981	173.42	172.6932	173.38	5266570.0
2022-01-06 14:00:00	AAPL	Stock	173.37	173.71	172.76	172.8985	5947224.0
2022-01-06 15:00:00	AAPL	Stock	172.89	173.38	171.64	172.01	12496801.0
2022-01-06 16:00:00	AAPL	Stock	172.0	172.32	171.93	172.17	9797068.0
2022-01-06 17:00:00	AAPL	Stock	172.23	172.42	172.12	172.35	36057.0
2022-01-06 18:00:00	AAPL	Stock	172.35	172.69	172.28	172.6	80901.0
2022-01-06 19:00:00	AAPL	Stock	172.6	172.93	172.58	172.9	55626.0
2022-01-06 04:00:00	MSFT	Stock	316.06	317.08	315.03	315.6	7350.0
2022-01-06 05:00:00	MSFT	Stock	315.76	316.39	315.56	315.79	6233.0
2022-01-06 06:00:00	MSFT	Stock	315.75	315.75	314.53	315.0	9103.0
2022-01-06 07:00:00	MSFT	Stock	315.17	316.25	314.61	314.78	41826.0
2022-01-06 08:00:00	MSFT	Stock	314.7601	317.17	314.55	315.0	85684.0
2022-01-06 09:00:00	MSFT	Stock	314.9999	317.46	311.49	314.5501	5233629.0
2022-01-06 10:00:00	MSFT	Stock	314.56	318.7	312.62	318.05	5272577.0
2022-01-06 11:00:00	MSFT	Stock	318.03	318.48	314.65	316.16	3045958.0
2022-01-06 12:00:00	MSFT	Stock	316.16	317.8462	314.88	315.9702	2576197.0
2022-01-06 13:00:00	MSFT	Stock	316.0	316.52	314.55	315.4	1896750.0
2022-01-06 14:00:00	MSFT	Stock	315.36	316.21	314.37	314.925	1812416.0
2022-01-06 15:00:00	MSFT	Stock	314.92	316.22	313.04	313.84	4177770.0
2022-01-06 16:00:00	MSFT	Stock	313.88	314.75	313.88	314.66	4288825.0
2022-01-06 17:00:00	MSFT	Stock	314.66	315.2	314.65	314.9	35854.0
2022-01-06 18:00:00	MSFT	Stock	314.9	315.75	314.9	315.5	19918.0
2022-01-06 19:00:00	MSFT	Stock	315.6	316.16	315.51	316.06	23320.0
2022-01-06 04:00:00	NVDA	Stock	27.605	27.749	27.236	27.68	476780.0
2022-01-06 05:00:00	NVDA	Stock	27.697	27.878	27.606	27.606	162320.0
2022-01-06 06:00:00	NVDA	Stock	27.735	27.735	27.505	27.615	119240.0
2022-01-06 07:00:00	NVDA	Stock	27.588	27.69	27.475	27.65	553530.0
2022-01-06 08:00:00	NVDA	Stock	27.65	27.79	27.482	27.702	1378790.0
2022-01-06 09:00:00	NVDA	Stock	27.692	28.211	27.5	27.6144	60227650.0
2022-01-06 10:00:00	NVDA	Stock	27.6	28.32	27.065	28.216	87785480.0
2022-01-06 11:00:00	NVDA	Stock	28.227	28.398	27.841	28.139	41300540.0
2022-01-06 12:00:00	NVDA	Stock	28.154	28.188	27.912	27.964	21986040.0
2022-01-06 13:00:00	NVDA	Stock	27.967	28.069	27.7542	28.03	21587470.0
2022-01-06 14:00:00	NVDA	Stock	28.027	28.388	27.905	28.303	31144130.0
2022-01-06 15:00:00	NVDA	Stock	28.302	28.438	28.01	28.18	41249080.0
2022-01-06 16:00:00	NVDA	Stock	28.178	28.28	28.167	28.269	16467930.0
2022-01-06 17:00:00	NVDA	Stock	28.26	28.295	28.251	28.287	79680.0
2022-01-06 18:00:00	NVDA	Stock	28.294	28.34	28.285	28.339	367810.0
2022-01-06 19:00:00	NVDA	Stock	28.343	28.45	28.343	28.45	365540.0
2022-01-06 04:00:00	AMZN	Stock	164.357	164.357	164.25	164.25	6000.0
2022-01-06 05:00:00	AMZN	Stock	164.049	164.049	164.049	164.049	15380.0

> showing 50 of 65,062 rows — these rows as CSV

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