PREVIEW / stock_1hour / 2023-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-20.parquet
  size:    1.3 MB
  rows:    59,330
  symbols: 1,691

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
2023-04-20 04:00:00	AAPL	Stock	167.0	167.0	165.86	166.11	30754.0
2023-04-20 05:00:00	AAPL	Stock	166.1	166.1	165.7	165.72	29234.0
2023-04-20 06:00:00	AAPL	Stock	165.72	166.1	165.7	166.0	14456.0
2023-04-20 07:00:00	AAPL	Stock	166.15	166.28	165.88	166.0	105523.0
2023-04-20 08:00:00	AAPL	Stock	166.11	167.211	165.5622	166.01	254036.0
2023-04-20 09:00:00	AAPL	Stock	166.01	167.33	165.7	166.815	6182650.0
2023-04-20 10:00:00	AAPL	Stock	166.81	167.4	166.66	166.86	5820595.0
2023-04-20 11:00:00	AAPL	Stock	166.87	167.54	166.51	167.28	4517580.0
2023-04-20 12:00:00	AAPL	Stock	167.28	167.87	166.96	167.7	3712578.0
2023-04-20 13:00:00	AAPL	Stock	167.695	167.86	167.44	167.47	3044452.0
2023-04-20 14:00:00	AAPL	Stock	167.47	167.5	166.2301	166.56	4922823.0
2023-04-20 15:00:00	AAPL	Stock	166.56	166.67	165.56	166.65	8342324.0
2023-04-20 16:00:00	AAPL	Stock	166.65	166.78	166.55	166.63	6374443.0
2023-04-20 17:00:00	AAPL	Stock	166.611	166.69	166.61	166.66	43449.0
2023-04-20 18:00:00	AAPL	Stock	166.66	166.77	166.61	166.72	62617.0
2023-04-20 19:00:00	AAPL	Stock	166.74	166.98	166.7	166.98	45360.0
2023-04-20 04:00:00	MSFT	Stock	286.15	286.15	284.57	285.01	6081.0
2023-04-20 05:00:00	MSFT	Stock	285.03	285.65	284.76	285.65	1857.0
2023-04-20 06:00:00	MSFT	Stock	285.65	285.7	285.34	285.7	823.0
2023-04-20 07:00:00	MSFT	Stock	286.2	286.39	285.65	285.65	10948.0
2023-04-20 08:00:00	MSFT	Stock	288.2	288.2	285.09	286.75	49040.0
2023-04-20 09:00:00	MSFT	Stock	286.55	287.24	285.1	287.005	2226344.0
2023-04-20 10:00:00	MSFT	Stock	286.99	287.71	286.3	286.74	2063728.0
2023-04-20 11:00:00	MSFT	Stock	286.76	287.5	286.27	287.29	1441619.0
2023-04-20 12:00:00	MSFT	Stock	287.29	288.4271	286.62	288.4143	1412719.0
2023-04-20 13:00:00	MSFT	Stock	288.43	289.03	288.2	288.3201	1217271.0
2023-04-20 14:00:00	MSFT	Stock	288.3	288.45	285.91	286.43	2071146.0
2023-04-20 15:00:00	MSFT	Stock	286.44	286.63	285.08	286.11	2939271.0
2023-04-20 16:00:00	MSFT	Stock	286.11	286.6	285.95	286.33	3712092.0
2023-04-20 17:00:00	MSFT	Stock	286.33	286.45	286.11	286.39	8662.0
2023-04-20 18:00:00	MSFT	Stock	286.29	286.5	286.2	286.5	7309.0
2023-04-20 19:00:00	MSFT	Stock	286.6	286.63	285.94	285.95	15162.0
2023-04-20 04:00:00	NVDA	Stock	27.681	27.686	27.52	27.555	200060.0
2023-04-20 05:00:00	NVDA	Stock	27.555	27.58	27.55	27.58	59810.0
2023-04-20 06:00:00	NVDA	Stock	27.58	27.643	27.54	27.609	155080.0
2023-04-20 07:00:00	NVDA	Stock	27.616	27.765	27.616	27.679	654070.0
2023-04-20 08:00:00	NVDA	Stock	27.595	27.8612	27.595	27.761	1502100.0
2023-04-20 09:00:00	NVDA	Stock	27.769	27.935	27.63	27.874	40909700.0
2023-04-20 10:00:00	NVDA	Stock	27.8755	28.03	27.7	27.726	55032240.0
2023-04-20 11:00:00	NVDA	Stock	27.729	27.732	27.491	27.6565	41007950.0
2023-04-20 12:00:00	NVDA	Stock	27.658	27.681	27.45	27.673	32369440.0
2023-04-20 13:00:00	NVDA	Stock	27.678	27.7639	27.614	27.655	27371820.0
2023-04-20 14:00:00	NVDA	Stock	27.653	27.676	27.279	27.397	43213000.0
2023-04-20 15:00:00	NVDA	Stock	27.401	27.405	27.0	27.105	72033560.0
2023-04-20 16:00:00	NVDA	Stock	27.104	27.145	27.086	27.119	20364820.0
2023-04-20 17:00:00	NVDA	Stock	27.11	27.118	27.055	27.099	218880.0
2023-04-20 18:00:00	NVDA	Stock	27.085	27.105	27.075	27.083	169650.0
2023-04-20 19:00:00	NVDA	Stock	27.109	27.211	27.09	27.198	373660.0
2023-04-20 04:00:00	AMZN	Stock	103.65	103.65	103.07	103.07	27776.0
2023-04-20 05:00:00	AMZN	Stock	103.13	103.29	103.05	103.11	6100.0

> showing 50 of 59,330 rows — these rows as CSV

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