PREVIEW / stock_1hour / 2022-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-27.parquet
  size:    1.4 MB
  rows:    61,650
  symbols: 1,950

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-12-27 04:00:00	AAPL	Stock	132.52	133.24	132.33	132.61	18705.0
2022-12-27 05:00:00	AAPL	Stock	132.68	132.82	132.54	132.55	14370.0
2022-12-27 06:00:00	AAPL	Stock	132.54	132.56	132.2	132.38	28711.0
2022-12-27 07:00:00	AAPL	Stock	132.34	132.4	131.62	131.62	90285.0
2022-12-27 08:00:00	AAPL	Stock	132.37	132.6985	131.11	131.24	296097.0
2022-12-27 09:00:00	AAPL	Stock	131.21	131.66	129.18	129.3399	8796734.0
2022-12-27 10:00:00	AAPL	Stock	129.33	130.42	128.72	129.8428	12644061.0
2022-12-27 11:00:00	AAPL	Stock	129.85	130.14	129.18	129.95	7684175.0
2022-12-27 12:00:00	AAPL	Stock	129.9457	130.5299	129.68	130.13	5464584.0
2022-12-27 13:00:00	AAPL	Stock	130.135	130.37	129.62	129.675	5187806.0
2022-12-27 14:00:00	AAPL	Stock	129.68	130.31	129.65	130.1884	4763678.0
2022-12-27 15:00:00	AAPL	Stock	130.185	130.59	129.94	130.05	8288514.0
2022-12-27 16:00:00	AAPL	Stock	130.05	130.15	129.98	130.02	6033021.0
2022-12-27 17:00:00	AAPL	Stock	129.96	130.08	129.89	129.96	72080.0
2022-12-27 18:00:00	AAPL	Stock	130.0	130.14	129.9	129.97	32184.0
2022-12-27 19:00:00	AAPL	Stock	130.0	130.1	129.5	129.5	32693.0
2022-12-27 04:00:00	MSFT	Stock	240.8	240.8	239.62	240.29	7340.0
2022-12-27 05:00:00	MSFT	Stock	240.0	240.17	239.8	239.8	3031.0
2022-12-27 06:00:00	MSFT	Stock	239.76	240.16	239.7	240.16	11198.0
2022-12-27 07:00:00	MSFT	Stock	239.97	239.99	239.43	239.43	41686.0
2022-12-27 08:00:00	MSFT	Stock	240.0199	240.02	238.134	238.79	35493.0
2022-12-27 09:00:00	MSFT	Stock	238.85	239.79	235.83	236.83	1553114.0
2022-12-27 10:00:00	MSFT	Stock	236.8	238.53	235.86	237.51	1883490.0
2022-12-27 11:00:00	MSFT	Stock	237.52	238.17	237.2	237.54	1465336.0
2022-12-27 12:00:00	MSFT	Stock	237.54	238.4287	236.86	237.28	1036552.0
2022-12-27 13:00:00	MSFT	Stock	237.27	237.83	236.44	236.66	821761.0
2022-12-27 14:00:00	MSFT	Stock	236.65	237.22	235.98	236.6088	1039742.0
2022-12-27 15:00:00	MSFT	Stock	236.63	237.73	236.44	236.96	2408776.0
2022-12-27 16:00:00	MSFT	Stock	236.99	237.35	236.71	236.95	2680196.0
2022-12-27 17:00:00	MSFT	Stock	236.9993	237.0	236.9	236.97	2600.0
2022-12-27 18:00:00	MSFT	Stock	237.0	237.5	236.86	236.96	4597.0
2022-12-27 19:00:00	MSFT	Stock	237.29	237.34	236.4	236.6	6264.0
2022-12-27 04:00:00	NVDA	Stock	15.372	15.4	15.221	15.36	143260.0
2022-12-27 05:00:00	NVDA	Stock	15.388	15.41	15.357	15.361	81660.0
2022-12-27 06:00:00	NVDA	Stock	15.343	15.389	15.298	15.301	168730.0
2022-12-27 07:00:00	NVDA	Stock	15.317	15.317	15.101	15.13	295600.0
2022-12-27 08:00:00	NVDA	Stock	15.28	15.428	15.05	15.085	873590.0
2022-12-27 09:00:00	NVDA	Stock	15.084	15.116	14.4672	14.573	55026380.0
2022-12-27 10:00:00	NVDA	Stock	14.5745	14.813	14.528	14.5857	68269100.0
2022-12-27 11:00:00	NVDA	Stock	14.585	14.6	14.416	14.4172	45647500.0
2022-12-27 12:00:00	NVDA	Stock	14.4175	14.497	14.292	14.327	41522190.0
2022-12-27 13:00:00	NVDA	Stock	14.329	14.4	14.233	14.2585	34708450.0
2022-12-27 14:00:00	NVDA	Stock	14.259	14.284	14.133	14.141	48048150.0
2022-12-27 15:00:00	NVDA	Stock	14.141	14.206	14.056	14.119	77939760.0
2022-12-27 16:00:00	NVDA	Stock	14.121	14.13	14.026	14.03	21317190.0
2022-12-27 17:00:00	NVDA	Stock	14.03	14.121	14.013	14.035	761690.0
2022-12-27 18:00:00	NVDA	Stock	14.035	14.048	14.026	14.027	189630.0
2022-12-27 19:00:00	NVDA	Stock	14.027	14.04	13.995	13.999	492510.0
2022-12-27 04:00:00	AMZN	Stock	86.3	86.3	85.68	85.73	35315.0
2022-12-27 05:00:00	AMZN	Stock	85.75	85.77	85.7	85.76	12188.0

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

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