PREVIEW / stock_1hour / 2023-04-10

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-10.parquet
  size:    1.3 MB
  rows:    59,633
  symbols: 1,695

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-10 04:00:00	AAPL	Stock	164.49	164.49	163.56	163.75	14288.0
2023-04-10 05:00:00	AAPL	Stock	163.77	163.97	163.57	163.8	12675.0
2023-04-10 06:00:00	AAPL	Stock	163.8	163.98	163.23	163.32	17467.0
2023-04-10 07:00:00	AAPL	Stock	163.6	163.64	162.5	162.75	63326.0
2023-04-10 08:00:00	AAPL	Stock	163.35	163.75	162.33	162.55	223953.0
2023-04-10 09:00:00	AAPL	Stock	162.55	162.61	160.08	160.4712	8549264.0
2023-04-10 10:00:00	AAPL	Stock	160.47	160.82	160.09	160.545	6342356.0
2023-04-10 11:00:00	AAPL	Stock	160.545	161.61	160.53	161.1008	4731829.0
2023-04-10 12:00:00	AAPL	Stock	161.1	161.6131	160.6	161.4	3763875.0
2023-04-10 13:00:00	AAPL	Stock	161.41	161.63	161.1701	161.435	3072975.0
2023-04-10 14:00:00	AAPL	Stock	161.44	161.84	161.34	161.72	2928131.0
2023-04-10 15:00:00	AAPL	Stock	161.73	162.03	161.5	162.025	5934755.0
2023-04-10 16:00:00	AAPL	Stock	162.02	162.19	161.93	162.06	4259161.0
2023-04-10 17:00:00	AAPL	Stock	162.0428	162.1	161.91	161.93	29374.0
2023-04-10 18:00:00	AAPL	Stock	161.91	162.099	161.91	162.01	21133.0
2023-04-10 19:00:00	AAPL	Stock	162.01	162.2	162.01	162.2	16007.0
2023-04-10 04:00:00	MSFT	Stock	291.06	291.3	290.7	291.0	7018.0
2023-04-10 05:00:00	MSFT	Stock	291.23	291.32	291.16	291.32	965.0
2023-04-10 06:00:00	MSFT	Stock	291.4	291.85	291.3	291.43	10069.0
2023-04-10 07:00:00	MSFT	Stock	291.46	291.46	290.0	290.65	14216.0
2023-04-10 08:00:00	MSFT	Stock	291.2	291.5	289.01	289.72	94907.0
2023-04-10 09:00:00	MSFT	Stock	289.69	290.0	285.11	285.49	3296836.0
2023-04-10 10:00:00	MSFT	Stock	285.51	287.13	284.71	286.3	3307368.0
2023-04-10 11:00:00	MSFT	Stock	286.32	287.94	286.29	286.9329	1993528.0
2023-04-10 12:00:00	MSFT	Stock	286.95	288.59	285.93	288.285	1642674.0
2023-04-10 13:00:00	MSFT	Stock	288.2772	288.9178	288.075	288.345	1337814.0
2023-04-10 14:00:00	MSFT	Stock	288.35	289.49	288.19	289.45	1672325.0
2023-04-10 15:00:00	MSFT	Stock	289.47	289.6	288.44	289.39	2576223.0
2023-04-10 16:00:00	MSFT	Stock	289.39	289.49	288.45	288.69	2556829.0
2023-04-10 17:00:00	MSFT	Stock	288.65	288.6999	288.3119	288.65	9641.0
2023-04-10 18:00:00	MSFT	Stock	288.6	288.88	288.52	288.75	8099.0
2023-04-10 19:00:00	MSFT	Stock	288.7	289.01	288.69	288.69	9045.0
2023-04-10 04:00:00	NVDA	Stock	26.979	27.031	26.93	26.98	81160.0
2023-04-10 05:00:00	NVDA	Stock	26.99	27.0	26.975	26.98	23230.0
2023-04-10 06:00:00	NVDA	Stock	26.983	27.0	26.95	26.96	37370.0
2023-04-10 07:00:00	NVDA	Stock	26.978	27.015	26.811	26.845	455740.0
2023-04-10 08:00:00	NVDA	Stock	26.9563	27.004	26.65	26.68	1319900.0
2023-04-10 09:00:00	NVDA	Stock	26.679	26.92	26.669	26.8448	33739680.0
2023-04-10 10:00:00	NVDA	Stock	26.841	27.255	26.785	27.165	68166860.0
2023-04-10 11:00:00	NVDA	Stock	27.165	27.433	27.158	27.379	45619360.0
2023-04-10 12:00:00	NVDA	Stock	27.3814	27.5505	27.262	27.496	41808030.0
2023-04-10 13:00:00	NVDA	Stock	27.496	27.59	27.407	27.454	31546020.0
2023-04-10 14:00:00	NVDA	Stock	27.456	27.5879	27.425	27.5705	23260980.0
2023-04-10 15:00:00	NVDA	Stock	27.571	27.621	27.518	27.589	35275950.0
2023-04-10 16:00:00	NVDA	Stock	27.579	27.591	27.55	27.575	20382850.0
2023-04-10 17:00:00	NVDA	Stock	27.573	27.598	27.57	27.584	167290.0
2023-04-10 18:00:00	NVDA	Stock	27.58	27.64	27.5731	27.638	323360.0
2023-04-10 19:00:00	NVDA	Stock	27.64	27.675	27.627	27.662	460980.0
2023-04-10 04:00:00	AMZN	Stock	101.7	101.83	101.69	101.8	6996.0
2023-04-10 05:00:00	AMZN	Stock	101.71	101.87	101.71	101.85	2979.0

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

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