PREVIEW / stock_1hour / 2021-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-15.parquet
  size:    1.5 MB
  rows:    66,186
  symbols: 2,663

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
2021-12-15 04:00:00	AAPL	Stock	174.7	174.97	173.34	173.99	28865.0
2021-12-15 05:00:00	AAPL	Stock	174.0	174.3	173.95	174.3	10797.0
2021-12-15 06:00:00	AAPL	Stock	174.16	174.24	173.81	174.11	34879.0
2021-12-15 07:00:00	AAPL	Stock	174.12	175.19	174.0	174.57	220313.0
2021-12-15 08:00:00	AAPL	Stock	175.14	175.33	173.895	174.51	483490.0
2021-12-15 09:00:00	AAPL	Stock	174.53	175.8494	172.96	173.74	13375367.0
2021-12-15 10:00:00	AAPL	Stock	173.73	174.41	172.91	173.89	10861661.0
2021-12-15 11:00:00	AAPL	Stock	173.88	173.91	172.42	172.44	8020357.0
2021-12-15 12:00:00	AAPL	Stock	172.43	173.44	172.3108	173.43	7946530.0
2021-12-15 13:00:00	AAPL	Stock	173.43	173.82	172.86	173.48	6754781.0
2021-12-15 14:00:00	AAPL	Stock	173.46	178.27	172.4	177.84	29049668.0
2021-12-15 15:00:00	AAPL	Stock	177.8301	179.5	177.76	179.3	22685812.0
2021-12-15 16:00:00	AAPL	Stock	179.3	179.79	179.24	179.56	11621367.0
2021-12-15 17:00:00	AAPL	Stock	179.56	179.95	179.54	179.88	145790.0
2021-12-15 18:00:00	AAPL	Stock	179.88	180.3	179.75	180.0	185298.0
2021-12-15 19:00:00	AAPL	Stock	180.0	180.08	179.7	179.72	171490.0
2021-12-15 04:00:00	MSFT	Stock	328.73	329.4	326.46	328.27	5296.0
2021-12-15 05:00:00	MSFT	Stock	327.49	328.41	327.49	328.3	1463.0
2021-12-15 06:00:00	MSFT	Stock	328.06	328.3	327.21	327.84	7669.0
2021-12-15 07:00:00	MSFT	Stock	327.86	328.35	327.82	327.98	13679.0
2021-12-15 08:00:00	MSFT	Stock	327.89	329.36	327.71	327.9	947669.0
2021-12-15 09:00:00	MSFT	Stock	327.82	329.8	327.72	329.215	2180872.0
2021-12-15 10:00:00	MSFT	Stock	329.25	330.6	328.51	329.71	2257247.0
2021-12-15 11:00:00	MSFT	Stock	329.6902	329.931	325.64	325.77	2239099.0
2021-12-15 12:00:00	MSFT	Stock	325.76	326.57	325.2801	325.785	1258482.0
2021-12-15 13:00:00	MSFT	Stock	325.78	326.56	325.33	326.33	1317340.0
2021-12-15 14:00:00	MSFT	Stock	326.27	329.98	324.5	329.03	4041622.0
2021-12-15 15:00:00	MSFT	Stock	329.0	335.19	328.8	334.66	6068197.0
2021-12-15 16:00:00	MSFT	Stock	334.66	334.99	334.09	334.94	6606827.0
2021-12-15 17:00:00	MSFT	Stock	334.85	335.19	334.62	335.15	24536.0
2021-12-15 18:00:00	MSFT	Stock	335.02	335.65	334.65	335.11	23900.0
2021-12-15 19:00:00	MSFT	Stock	335.3	335.3	334.35	334.85	30177.0
2021-12-15 04:00:00	NVDA	Stock	28.404	28.429	27.97	28.12	237790.0
2021-12-15 05:00:00	NVDA	Stock	28.086	28.25	28.07	28.22	34950.0
2021-12-15 06:00:00	NVDA	Stock	28.22	28.289	28.11	28.236	89880.0
2021-12-15 07:00:00	NVDA	Stock	28.205	28.374	28.166	28.29	455700.0
2021-12-15 08:00:00	NVDA	Stock	28.299	28.495	28.152	28.25	650470.0
2021-12-15 09:00:00	NVDA	Stock	28.25	29.015	28.05	28.4	56271460.0
2021-12-15 10:00:00	NVDA	Stock	28.4065	29.004	28.153	28.666	74449670.0
2021-12-15 11:00:00	NVDA	Stock	28.67	28.84	28.056	28.41	53551730.0
2021-12-15 12:00:00	NVDA	Stock	28.405	28.47	28.086	28.287	36750090.0
2021-12-15 13:00:00	NVDA	Stock	28.291	28.55	28.24	28.459	28504020.0
2021-12-15 14:00:00	NVDA	Stock	28.459	29.345	27.838	29.178	122244880.0
2021-12-15 15:00:00	NVDA	Stock	29.185	30.5	29.163	30.482	138183660.0
2021-12-15 16:00:00	NVDA	Stock	30.481	30.55	30.402	30.52	32386850.0
2021-12-15 17:00:00	NVDA	Stock	30.54	30.685	30.525	30.677	895870.0
2021-12-15 18:00:00	NVDA	Stock	30.672	30.797	30.625	30.78	1140040.0
2021-12-15 19:00:00	NVDA	Stock	30.775	30.775	30.68	30.75	762800.0
2021-12-15 04:00:00	AMZN	Stock	168.5025	168.5025	168.5025	168.5025	4000.0
2021-12-15 05:00:00	AMZN	Stock	168.5	168.5	168.5	168.5	2000.0

> showing 50 of 66,186 rows — these rows as CSV

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