PREVIEW / stock_1hour / 2022-02-22

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-22.parquet
  size:    1.4 MB
  rows:    66,293
  symbols: 2,546

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-02-22 04:00:00	AAPL	Stock	166.0	166.0	162.24	163.84	110169.0
2022-02-22 05:00:00	AAPL	Stock	163.84	166.6	163.71	165.99	64313.0
2022-02-22 06:00:00	AAPL	Stock	166.0	166.15	165.5	165.9	15066.0
2022-02-22 07:00:00	AAPL	Stock	165.92	166.48	165.3	166.18	187546.0
2022-02-22 08:00:00	AAPL	Stock	165.5109	167.718	160.0	165.9	308226.0
2022-02-22 09:00:00	AAPL	Stock	165.9023	166.5	163.85	165.71	12585771.0
2022-02-22 10:00:00	AAPL	Stock	165.72	166.69	164.5703	164.66	9850818.0
2022-02-22 11:00:00	AAPL	Stock	164.67	165.32	164.41	164.695	7720853.0
2022-02-22 12:00:00	AAPL	Stock	164.68	165.045	163.9	164.1	5944678.0
2022-02-22 13:00:00	AAPL	Stock	164.12	164.365	162.73	162.935	6437192.0
2022-02-22 14:00:00	AAPL	Stock	162.93	164.47	162.15	164.2	11232675.0
2022-02-22 15:00:00	AAPL	Stock	164.21	165.3586	163.45	164.3	12713836.0
2022-02-22 16:00:00	AAPL	Stock	164.32	165.47	164.32	164.6	8130436.0
2022-02-22 17:00:00	AAPL	Stock	164.65	165.04	164.57	165.02	41859.0
2022-02-22 18:00:00	AAPL	Stock	164.98	165.47	164.82	165.26	50098.0
2022-02-22 19:00:00	AAPL	Stock	165.43	165.47	165.13	165.45	38569.0
2022-02-22 04:00:00	MSFT	Stock	281.97	285.0	280.78	281.15	57815.0
2022-02-22 05:00:00	MSFT	Stock	280.82	286.45	280.82	285.2	23867.0
2022-02-22 06:00:00	MSFT	Stock	285.09	285.5	284.5	285.19	14475.0
2022-02-22 07:00:00	MSFT	Stock	285.04	286.2	284.1	285.55	59196.0
2022-02-22 08:00:00	MSFT	Stock	284.65	286.2	279.0	286.0	82232.0
2022-02-22 09:00:00	MSFT	Stock	285.89	291.54	284.1	289.41	3729435.0
2022-02-22 10:00:00	MSFT	Stock	289.35	290.54	288.09	288.28	3200435.0
2022-02-22 11:00:00	MSFT	Stock	288.27	288.52	286.2	286.855	2146984.0
2022-02-22 12:00:00	MSFT	Stock	286.815	287.5001	286.45	286.6725	1636067.0
2022-02-22 13:00:00	MSFT	Stock	286.705	287.05	285.5301	285.8405	1858380.0
2022-02-22 14:00:00	MSFT	Stock	285.79	289.2	285.1	288.29	3017586.0
2022-02-22 15:00:00	MSFT	Stock	288.32	290.25	286.08	287.72	4043234.0
2022-02-22 16:00:00	MSFT	Stock	287.8	289.83	287.4	288.62	5903312.0
2022-02-22 17:00:00	MSFT	Stock	288.69	289.25	288.62	289.2	8342.0
2022-02-22 18:00:00	MSFT	Stock	289.2	290.0	289.1	290.0	15365.0
2022-02-22 19:00:00	MSFT	Stock	290.0	290.4	289.56	290.0	15167.0
2022-02-22 04:00:00	NVDA	Stock	23.0	23.0	22.5	22.65	890520.0
2022-02-22 05:00:00	NVDA	Stock	22.65	23.33	22.65	23.14	520370.0
2022-02-22 06:00:00	NVDA	Stock	23.15	23.2	22.961	23.14	299700.0
2022-02-22 07:00:00	NVDA	Stock	23.12	23.22	22.89	23.11	1592800.0
2022-02-22 08:00:00	NVDA	Stock	23.0001	23.325	22.292	23.12	3719000.0
2022-02-22 09:00:00	NVDA	Stock	23.11	23.907	22.988	23.6147	72659930.0
2022-02-22 10:00:00	NVDA	Stock	23.607	24.064	23.437	23.4541	77273860.0
2022-02-22 11:00:00	NVDA	Stock	23.461	23.5525	23.085	23.169	54177890.0
2022-02-22 12:00:00	NVDA	Stock	23.168	23.341	23.067	23.23	41344730.0
2022-02-22 13:00:00	NVDA	Stock	23.2367	23.398	23.143	23.238	38105540.0
2022-02-22 14:00:00	NVDA	Stock	23.233	23.756	23.0	23.621	70335280.0
2022-02-22 15:00:00	NVDA	Stock	23.63	23.883	23.237	23.413	81966010.0
2022-02-22 16:00:00	NVDA	Stock	23.41	23.59	23.39	23.535	18797790.0
2022-02-22 17:00:00	NVDA	Stock	23.511	23.566	23.45	23.535	256870.0
2022-02-22 18:00:00	NVDA	Stock	23.53	23.695	23.49	23.677	448570.0
2022-02-22 19:00:00	NVDA	Stock	23.681	23.687	23.59	23.641	301510.0
2022-02-22 04:00:00	AMZN	Stock	149.0	149.0	148.0	148.95	28500.0
2022-02-22 05:00:00	AMZN	Stock	148.95	151.25	148.95	151.25	49980.0

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

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