PREVIEW / stock_1hour / 2022-12-13

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-13.parquet
  size:    1.4 MB
  rows:    62,976
  symbols: 2,039

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-13 04:00:00	AAPL	Stock	144.74	144.92	144.4	144.69	26947.0
2022-12-13 05:00:00	AAPL	Stock	144.73	144.99	144.67	144.89	23365.0
2022-12-13 06:00:00	AAPL	Stock	144.89	145.14	144.89	145.08	42181.0
2022-12-13 07:00:00	AAPL	Stock	145.08	145.73	144.96	145.71	67429.0
2022-12-13 08:00:00	AAPL	Stock	145.0379	151.0	144.0	149.45	1395776.0
2022-12-13 09:00:00	AAPL	Stock	149.53	150.01	148.785	149.29	10845390.0
2022-12-13 10:00:00	AAPL	Stock	149.29	149.37	146.91	147.86	12428498.0
2022-12-13 11:00:00	AAPL	Stock	147.87	148.3496	145.668	146.2	8903021.0
2022-12-13 12:00:00	AAPL	Stock	146.2008	146.37	144.24	145.065	8848086.0
2022-12-13 13:00:00	AAPL	Stock	145.08	145.77	144.53	145.3	6124214.0
2022-12-13 14:00:00	AAPL	Stock	145.3	146.14	144.28	145.14	8967372.0
2022-12-13 15:00:00	AAPL	Stock	145.1336	145.97	144.32	145.49	10187756.0
2022-12-13 16:00:00	AAPL	Stock	145.48	145.48	145.21	145.3416	12597934.0
2022-12-13 17:00:00	AAPL	Stock	145.34	145.47	145.31	145.45	24143.0
2022-12-13 18:00:00	AAPL	Stock	145.45	145.5	145.4	145.41	14144.0
2022-12-13 19:00:00	AAPL	Stock	145.41	145.6	145.4	145.49	33571.0
2022-12-13 04:00:00	MSFT	Stock	252.52	253.25	252.52	252.82	2587.0
2022-12-13 05:00:00	MSFT	Stock	252.92	254.0	252.9	254.0	3593.0
2022-12-13 06:00:00	MSFT	Stock	254.1	255.02	254.1	254.71	10488.0
2022-12-13 07:00:00	MSFT	Stock	254.5	255.97	254.3	255.5	59541.0
2022-12-13 08:00:00	MSFT	Stock	254.8729	265.0	251.879	262.5	289427.0
2022-12-13 09:00:00	MSFT	Stock	262.6	263.915	260.87	262.32	4579416.0
2022-12-13 10:00:00	MSFT	Stock	262.34	262.52	258.4	259.91	4419316.0
2022-12-13 11:00:00	MSFT	Stock	259.95	261.28	257.32	257.95	3603247.0
2022-12-13 12:00:00	MSFT	Stock	257.95	258.37	253.07	254.67	2979557.0
2022-12-13 13:00:00	MSFT	Stock	254.63	256.0	253.51	255.63	1967442.0
2022-12-13 14:00:00	MSFT	Stock	255.6	257.4689	255.04	255.94	1902378.0
2022-12-13 15:00:00	MSFT	Stock	255.94	258.0	254.56	256.95	3990611.0
2022-12-13 16:00:00	MSFT	Stock	256.93	257.1882	256.4	256.91	8115625.0
2022-12-13 17:00:00	MSFT	Stock	257.081	257.4	257.0	257.12	3163.0
2022-12-13 18:00:00	MSFT	Stock	257.0	257.4	257.0	257.33	6353.0
2022-12-13 19:00:00	MSFT	Stock	257.3	257.76	257.3	257.76	5963.0
2022-12-13 04:00:00	NVDA	Stock	17.697	17.697	17.58	17.69	135630.0
2022-12-13 05:00:00	NVDA	Stock	17.672	17.74	17.665	17.73	158790.0
2022-12-13 06:00:00	NVDA	Stock	17.719	17.74	17.703	17.723	149340.0
2022-12-13 07:00:00	NVDA	Stock	17.728	17.923	17.719	17.85	1530320.0
2022-12-13 08:00:00	NVDA	Stock	17.76	18.888	17.541	18.605	9466720.0
2022-12-13 09:00:00	NVDA	Stock	18.612	18.79	18.301	18.617	94973160.0
2022-12-13 10:00:00	NVDA	Stock	18.627	18.639	18.0621	18.241	99301730.0
2022-12-13 11:00:00	NVDA	Stock	18.245	18.339	17.968	18.0644	65154150.0
2022-12-13 12:00:00	NVDA	Stock	18.067	18.102	17.711	17.847	60584940.0
2022-12-13 13:00:00	NVDA	Stock	17.849	18.118	17.803	17.952	48874100.0
2022-12-13 14:00:00	NVDA	Stock	17.953	18.144	17.911	17.9696	38229470.0
2022-12-13 15:00:00	NVDA	Stock	17.965	18.132	17.846	18.069	61687650.0
2022-12-13 16:00:00	NVDA	Stock	18.068	18.1	18.06	18.07	31654500.0
2022-12-13 17:00:00	NVDA	Stock	18.068	18.092	18.045	18.09	88650.0
2022-12-13 18:00:00	NVDA	Stock	18.094	18.095	18.075	18.083	123820.0
2022-12-13 19:00:00	NVDA	Stock	18.072	18.089	18.07	18.081	178610.0
2022-12-13 04:00:00	AMZN	Stock	90.64	90.96	90.6	90.79	11305.0
2022-12-13 05:00:00	AMZN	Stock	90.79	90.95	90.73	90.94	16240.0

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

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