PREVIEW / stock_1hour / 2022-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-09.parquet
  size:    1.4 MB
  rows:    63,200
  symbols: 2,309

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-08-09 04:00:00	AAPL	Stock	165.0	165.15	164.31	164.8	20356.0
2022-08-09 05:00:00	AAPL	Stock	164.95	164.95	164.6	164.65	3560.0
2022-08-09 06:00:00	AAPL	Stock	164.68	164.68	163.88	164.01	36102.0
2022-08-09 07:00:00	AAPL	Stock	164.09	164.3	163.61	163.75	76544.0
2022-08-09 08:00:00	AAPL	Stock	164.2751	165.0	163.5	163.82	343434.0
2022-08-09 09:00:00	AAPL	Stock	163.8	164.87	163.25	163.9001	6100649.0
2022-08-09 10:00:00	AAPL	Stock	163.9	164.99	163.77	164.5101	6765262.0
2022-08-09 11:00:00	AAPL	Stock	164.52	165.82	164.01	165.1001	8888843.0
2022-08-09 12:00:00	AAPL	Stock	165.11	165.32	164.46	164.99	4602766.0
2022-08-09 13:00:00	AAPL	Stock	165.0	165.55	164.845	165.39	4216342.0
2022-08-09 14:00:00	AAPL	Stock	165.385	165.6	164.865	165.135	4727143.0
2022-08-09 15:00:00	AAPL	Stock	165.14	165.4446	164.51	164.93	7678580.0
2022-08-09 16:00:00	AAPL	Stock	164.92	165.05	164.82	165.05	7829257.0
2022-08-09 17:00:00	AAPL	Stock	165.05	165.11	164.88	164.93	25322.0
2022-08-09 18:00:00	AAPL	Stock	165.0	165.1	164.95	164.96	17179.0
2022-08-09 19:00:00	AAPL	Stock	164.96	165.06	164.96	165.01	22229.0
2022-08-09 04:00:00	MSFT	Stock	280.64	280.8	280.3	280.8	1115.0
2022-08-09 05:00:00	MSFT	Stock	280.61	280.61	280.3	280.3	2158.0
2022-08-09 06:00:00	MSFT	Stock	280.25	280.25	278.35	278.5	5977.0
2022-08-09 07:00:00	MSFT	Stock	279.0	279.5	278.65	278.93	17150.0
2022-08-09 08:00:00	MSFT	Stock	279.49	280.34	278.55	278.9	36362.0
2022-08-09 09:00:00	MSFT	Stock	278.8	280.33	277.61	277.88	1613596.0
2022-08-09 10:00:00	MSFT	Stock	277.9	281.36	277.88	280.64	2135243.0
2022-08-09 11:00:00	MSFT	Stock	280.67	281.9336	279.6001	280.9971	1306798.0
2022-08-09 12:00:00	MSFT	Stock	280.97	281.16	279.89	280.26	1023001.0
2022-08-09 13:00:00	MSFT	Stock	280.235	282.62	279.82	282.22	1392754.0
2022-08-09 14:00:00	MSFT	Stock	282.215	282.63	280.93	282.2769	1849398.0
2022-08-09 15:00:00	MSFT	Stock	282.287	283.08	281.69	282.31	2780972.0
2022-08-09 16:00:00	MSFT	Stock	282.29	283.11	282.29	283.11	3913633.0
2022-08-09 17:00:00	MSFT	Stock	283.16	283.2	283.0	283.05	10923.0
2022-08-09 18:00:00	MSFT	Stock	283.0	283.13	282.83	283.01	3730.0
2022-08-09 19:00:00	MSFT	Stock	283.17	283.49	282.98	283.3	12525.0
2022-08-09 04:00:00	NVDA	Stock	17.629	17.629	17.481	17.481	171250.0
2022-08-09 05:00:00	NVDA	Stock	17.507	17.516	17.388	17.388	79710.0
2022-08-09 06:00:00	NVDA	Stock	17.395	17.395	17.149	17.18	560810.0
2022-08-09 07:00:00	NVDA	Stock	17.22	17.375	17.2	17.32	1259130.0
2022-08-09 08:00:00	NVDA	Stock	17.3	17.68	17.229	17.33	2144000.0
2022-08-09 09:00:00	NVDA	Stock	17.325	17.793	17.076	17.092	92512470.0
2022-08-09 10:00:00	NVDA	Stock	17.09	17.2	17.03	17.138	80403000.0
2022-08-09 11:00:00	NVDA	Stock	17.139	17.16	16.841	16.857	76689410.0
2022-08-09 12:00:00	NVDA	Stock	16.857	16.882	16.724	16.821	71168140.0
2022-08-09 13:00:00	NVDA	Stock	16.818	17.032	16.818	17.024	65329520.0
2022-08-09 14:00:00	NVDA	Stock	17.025	17.123	16.958	17.077	60795430.0
2022-08-09 15:00:00	NVDA	Stock	17.076	17.172	17.062	17.085	72852480.0
2022-08-09 16:00:00	NVDA	Stock	17.086	17.097	17.057	17.083	18687410.0
2022-08-09 17:00:00	NVDA	Stock	17.0836	17.0836	17.015	17.039	438160.0
2022-08-09 18:00:00	NVDA	Stock	17.033	17.035	17.0	17.015	385810.0
2022-08-09 19:00:00	NVDA	Stock	17.012	17.02	16.995	16.995	309820.0
2022-08-09 04:00:00	AMZN	Stock	139.22	140.15	139.22	139.85	23846.0
2022-08-09 05:00:00	AMZN	Stock	139.86	139.91	139.41	139.47	6606.0

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

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