PREVIEW / stock_1hour / 2022-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-04.parquet
  size:    1.4 MB
  rows:    60,857
  symbols: 2,099

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-11-04 04:00:00	AAPL	Stock	138.01	139.0	138.01	139.0	51407.0
2022-11-04 05:00:00	AAPL	Stock	138.98	139.8	138.98	139.47	62942.0
2022-11-04 06:00:00	AAPL	Stock	139.52	139.95	139.4	139.87	61415.0
2022-11-04 07:00:00	AAPL	Stock	139.84	140.43	139.7	140.27	163925.0
2022-11-04 08:00:00	AAPL	Stock	139.77	141.74	138.53	141.67	1368601.0
2022-11-04 09:00:00	AAPL	Stock	141.72	142.67	136.56	138.9159	19465893.0
2022-11-04 10:00:00	AAPL	Stock	138.92	140.18	137.77	138.19	19028605.0
2022-11-04 11:00:00	AAPL	Stock	138.2	138.3	134.9	135.03	19289896.0
2022-11-04 12:00:00	AAPL	Stock	135.04	136.5599	134.49	134.8004	14933460.0
2022-11-04 13:00:00	AAPL	Stock	134.81	135.65	134.45	134.88	8705089.0
2022-11-04 14:00:00	AAPL	Stock	134.87	136.88	134.38	136.76	11193464.0
2022-11-04 15:00:00	AAPL	Stock	136.77	138.5	136.62	138.39	18571158.0
2022-11-04 16:00:00	AAPL	Stock	138.39	138.62	138.12	138.24	10771364.0
2022-11-04 17:00:00	AAPL	Stock	138.2	138.3	138.07	138.2138	96100.0
2022-11-04 18:00:00	AAPL	Stock	138.19	138.24	138.13	138.23	30285.0
2022-11-04 19:00:00	AAPL	Stock	138.22	138.22	138.07	138.12	51007.0
2022-11-04 04:00:00	MSFT	Stock	214.81	215.3	214.7	215.3	4475.0
2022-11-04 05:00:00	MSFT	Stock	215.31	215.99	215.31	215.57	5232.0
2022-11-04 06:00:00	MSFT	Stock	215.72	216.05	215.23	215.76	7291.0
2022-11-04 07:00:00	MSFT	Stock	215.71	215.95	215.12	215.35	21610.0
2022-11-04 08:00:00	MSFT	Stock	215.385	216.25	212.25	216.25	208112.0
2022-11-04 09:00:00	MSFT	Stock	216.25	218.48	213.431	216.39	3982167.0
2022-11-04 10:00:00	MSFT	Stock	216.42	219.98	215.56	218.56	4073588.0
2022-11-04 11:00:00	MSFT	Stock	218.57	218.9	215.475	215.73	3031109.0
2022-11-04 12:00:00	MSFT	Stock	215.69	218.61	215.105	217.58	2703051.0
2022-11-04 13:00:00	MSFT	Stock	217.59	217.83	216.11	216.97	1918291.0
2022-11-04 14:00:00	MSFT	Stock	216.96	219.13	216.34	218.93	2160271.0
2022-11-04 15:00:00	MSFT	Stock	218.94	221.59	218.53	221.54	4742246.0
2022-11-04 16:00:00	MSFT	Stock	221.5	221.74	221.0	221.0	4992611.0
2022-11-04 17:00:00	MSFT	Stock	220.9007	221.3512	220.9001	221.3	7591.0
2022-11-04 18:00:00	MSFT	Stock	221.25	221.33	220.92	221.3	6602.0
2022-11-04 19:00:00	MSFT	Stock	221.25	221.34	221.11	221.24	7030.0
2022-11-04 04:00:00	NVDA	Stock	13.505	13.63	13.473	13.57	92920.0
2022-11-04 05:00:00	NVDA	Stock	13.573	13.621	13.559	13.6	76350.0
2022-11-04 06:00:00	NVDA	Stock	13.6	13.68	13.6	13.68	108450.0
2022-11-04 07:00:00	NVDA	Stock	13.636	13.67	13.6	13.64	175930.0
2022-11-04 08:00:00	NVDA	Stock	13.6468	13.89	13.435	13.88	4547180.0
2022-11-04 09:00:00	NVDA	Stock	13.88	14.063	13.697	13.964	66770740.0
2022-11-04 10:00:00	NVDA	Stock	13.966	14.229	13.866	14.091	98666400.0
2022-11-04 11:00:00	NVDA	Stock	14.092	14.146	13.807	13.811	67192610.0
2022-11-04 12:00:00	NVDA	Stock	13.811	13.994	13.759	13.834	60191930.0
2022-11-04 13:00:00	NVDA	Stock	13.829	13.923	13.711	13.731	43570830.0
2022-11-04 14:00:00	NVDA	Stock	13.729	14.039	13.7	14.0145	48370000.0
2022-11-04 15:00:00	NVDA	Stock	14.018	14.181	13.985	14.18	81185310.0
2022-11-04 16:00:00	NVDA	Stock	14.156	14.18	14.115	14.129	35777860.0
2022-11-04 17:00:00	NVDA	Stock	14.132	14.164	14.131	14.164	199740.0
2022-11-04 18:00:00	NVDA	Stock	14.162	14.165	14.149	14.16	165420.0
2022-11-04 19:00:00	NVDA	Stock	14.161	14.18	14.16	14.175	253820.0
2022-11-04 04:00:00	AMZN	Stock	91.53	91.53	89.59	90.28	77102.0
2022-11-04 05:00:00	AMZN	Stock	90.28	90.72	90.2	90.43	35273.0

> showing 50 of 60,857 rows — these rows as CSV

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