PREVIEW / stock_1hour / 2022-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-07.parquet
  size:    1.4 MB
  rows:    63,648
  symbols: 2,602

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-07 04:00:00	AAPL	Stock	171.5	172.46	171.31	172.22	22305.0
2022-01-07 05:00:00	AAPL	Stock	172.3	172.83	172.16	172.71	12384.0
2022-01-07 06:00:00	AAPL	Stock	172.72	173.3	172.57	172.82	16585.0
2022-01-07 07:00:00	AAPL	Stock	172.85	173.09	172.4	172.42	79120.0
2022-01-07 08:00:00	AAPL	Stock	172.75	173.72	171.31	171.61	857198.0
2022-01-07 09:00:00	AAPL	Stock	171.61	174.14	171.47	173.72	10535535.0
2022-01-07 10:00:00	AAPL	Stock	173.72	173.78	171.03	171.4312	11474528.0
2022-01-07 11:00:00	AAPL	Stock	171.44	172.72	171.05	172.52	8163116.0
2022-01-07 12:00:00	AAPL	Stock	172.52	172.63	171.76	172.2808	5234808.0
2022-01-07 13:00:00	AAPL	Stock	172.285	172.6	172.05	172.29	4638709.0
2022-01-07 14:00:00	AAPL	Stock	172.2982	173.1	171.87	173.095	5838989.0
2022-01-07 15:00:00	AAPL	Stock	173.09	173.6881	171.9	172.22	12603362.0
2022-01-07 16:00:00	AAPL	Stock	172.19	172.19	171.74	172.0	9228052.0
2022-01-07 17:00:00	AAPL	Stock	172.01	172.04	171.76	171.87	44374.0
2022-01-07 18:00:00	AAPL	Stock	171.86	172.1	171.82	172.01	33113.0
2022-01-07 19:00:00	AAPL	Stock	172.01	172.15	171.96	172.07	39886.0
2022-01-07 04:00:00	MSFT	Stock	313.5	314.73	312.89	314.51	11758.0
2022-01-07 05:00:00	MSFT	Stock	314.95	315.48	314.95	315.46	1069.0
2022-01-07 06:00:00	MSFT	Stock	315.33	315.88	315.0	315.0	7585.0
2022-01-07 07:00:00	MSFT	Stock	315.02	315.8	314.75	314.75	26130.0
2022-01-07 08:00:00	MSFT	Stock	315.7999	317.0188	312.0	313.1999	201764.0
2022-01-07 09:00:00	MSFT	Stock	313.18	316.5	312.31	315.6733	3072484.0
2022-01-07 10:00:00	MSFT	Stock	315.715	316.14	310.09	310.91	3666224.0
2022-01-07 11:00:00	MSFT	Stock	310.93	314.45	310.82	313.5543	2554912.0
2022-01-07 12:00:00	MSFT	Stock	313.58	313.85	312.33	313.7882	1623692.0
2022-01-07 13:00:00	MSFT	Stock	313.83	314.51	313.44	313.79	1494024.0
2022-01-07 14:00:00	MSFT	Stock	313.79	315.26	313.33	314.96	1987604.0
2022-01-07 15:00:00	MSFT	Stock	314.97	315.6897	313.88	314.11	3595898.0
2022-01-07 16:00:00	MSFT	Stock	314.04	314.46	313.13	313.65	4504329.0
2022-01-07 17:00:00	MSFT	Stock	313.65	313.8	313.25	313.8	10757.0
2022-01-07 18:00:00	MSFT	Stock	313.5	313.99	313.5	313.99	9241.0
2022-01-07 19:00:00	MSFT	Stock	313.9699	314.0	313.75	313.82	8871.0
2022-01-07 04:00:00	NVDA	Stock	28.162	28.337	28.012	28.292	125340.0
2022-01-07 05:00:00	NVDA	Stock	28.25	28.45	28.25	28.37	98330.0
2022-01-07 06:00:00	NVDA	Stock	28.397	28.447	28.294	28.39	132280.0
2022-01-07 07:00:00	NVDA	Stock	28.38	28.52	28.332	28.35	581280.0
2022-01-07 08:00:00	NVDA	Stock	28.43	28.525	28.0	28.089	2042050.0
2022-01-07 09:00:00	NVDA	Stock	28.088	28.422	27.784	28.151	38599950.0
2022-01-07 10:00:00	NVDA	Stock	28.158	28.169	27.057	27.182	66423450.0
2022-01-07 11:00:00	NVDA	Stock	27.187	27.644	27.166	27.4849	47004500.0
2022-01-07 12:00:00	NVDA	Stock	27.487	27.598	27.294	27.537	28344340.0
2022-01-07 13:00:00	NVDA	Stock	27.545	27.57	27.363	27.422	21961360.0
2022-01-07 14:00:00	NVDA	Stock	27.422	27.56	27.255	27.498	29493860.0
2022-01-07 15:00:00	NVDA	Stock	27.499	27.549	27.215	27.24	40835020.0
2022-01-07 16:00:00	NVDA	Stock	27.247	27.294	27.2	27.244	26283520.0
2022-01-07 17:00:00	NVDA	Stock	27.221	27.252	27.208	27.241	296890.0
2022-01-07 18:00:00	NVDA	Stock	27.24	27.242	27.192	27.214	270120.0
2022-01-07 19:00:00	NVDA	Stock	27.207	27.22	27.198	27.22	308000.0
2022-01-07 04:00:00	AMZN	Stock	163.49	163.49	163.49	163.49	2000.0
2022-01-07 07:00:00	AMZN	Stock	164.235	164.235	163.9	163.9	9780.0

> showing 50 of 63,648 rows — these rows as CSV

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