PREVIEW / stock_1hour / 2022-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-10.parquet
  size:    1.4 MB
  rows:    64,031
  symbols: 2,289

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-10 04:00:00	AAPL	Stock	165.0	165.49	164.57	165.36	14098.0
2022-08-10 05:00:00	AAPL	Stock	165.41	165.48	165.12	165.23	3868.0
2022-08-10 06:00:00	AAPL	Stock	165.13	165.24	164.85	165.08	7382.0
2022-08-10 07:00:00	AAPL	Stock	165.04	165.45	164.91	165.28	65988.0
2022-08-10 08:00:00	AAPL	Stock	165.0	168.18	164.12	167.4	1198968.0
2022-08-10 09:00:00	AAPL	Stock	167.4	168.65	167.12	168.44	10421045.0
2022-08-10 10:00:00	AAPL	Stock	168.46	168.48	166.9	167.75	8386021.0
2022-08-10 11:00:00	AAPL	Stock	167.75	168.245	167.5406	168.1519	5613755.0
2022-08-10 12:00:00	AAPL	Stock	168.1615	168.3	167.65	168.07	4839270.0
2022-08-10 13:00:00	AAPL	Stock	168.0809	168.5	167.87	168.29	3971374.0
2022-08-10 14:00:00	AAPL	Stock	168.28	168.74	168.19	168.46	4516313.0
2022-08-10 15:00:00	AAPL	Stock	168.46	169.34	168.36	169.24	11949273.0
2022-08-10 16:00:00	AAPL	Stock	169.1838	169.25	168.85	168.93	8594932.0
2022-08-10 17:00:00	AAPL	Stock	168.93	169.0	168.85	168.96	61257.0
2022-08-10 18:00:00	AAPL	Stock	168.98	168.98	168.83	168.88	24570.0
2022-08-10 19:00:00	AAPL	Stock	168.86	169.24	168.86	169.1	47855.0
2022-08-10 04:00:00	MSFT	Stock	282.83	283.03	282.0	282.0	1055.0
2022-08-10 05:00:00	MSFT	Stock	283.69	283.76	283.01	283.01	925.0
2022-08-10 06:00:00	MSFT	Stock	283.0	283.0	282.53	282.53	934.0
2022-08-10 07:00:00	MSFT	Stock	282.7	283.8	282.7	283.8	8660.0
2022-08-10 08:00:00	MSFT	Stock	282.748	290.0	282.1	289.43	227260.0
2022-08-10 09:00:00	MSFT	Stock	289.13	289.3	286.94	288.5813	3035261.0
2022-08-10 10:00:00	MSFT	Stock	288.64	289.2698	287.02	288.39	2473705.0
2022-08-10 11:00:00	MSFT	Stock	288.41	289.66	288.33	288.63	1931312.0
2022-08-10 12:00:00	MSFT	Stock	288.65	288.8	287.64	288.175	1263531.0
2022-08-10 13:00:00	MSFT	Stock	288.19	289.0	287.815	288.46	988917.0
2022-08-10 14:00:00	MSFT	Stock	288.475	288.925	288.1	288.17	1070069.0
2022-08-10 15:00:00	MSFT	Stock	288.16	289.81	287.94	289.13	3254295.0
2022-08-10 16:00:00	MSFT	Stock	289.13	289.2	288.12	289.16	4355766.0
2022-08-10 17:00:00	MSFT	Stock	288.51	288.55	288.463	288.54	4508.0
2022-08-10 18:00:00	MSFT	Stock	288.53	288.55	288.4	288.5	7370.0
2022-08-10 19:00:00	MSFT	Stock	288.49	289.13	288.4	289.0	9659.0
2022-08-10 04:00:00	NVDA	Stock	16.965	17.185	16.965	17.15	145510.0
2022-08-10 05:00:00	NVDA	Stock	17.157	17.186	17.11	17.13	34570.0
2022-08-10 06:00:00	NVDA	Stock	17.115	17.115	17.052	17.095	38060.0
2022-08-10 07:00:00	NVDA	Stock	17.083	17.089	17.044	17.08	170790.0
2022-08-10 08:00:00	NVDA	Stock	16.965	17.748	16.911	17.662	8587960.0
2022-08-10 09:00:00	NVDA	Stock	17.659	17.734	17.393	17.5146	67102510.0
2022-08-10 10:00:00	NVDA	Stock	17.515	17.637	17.317	17.619	71660220.0
2022-08-10 11:00:00	NVDA	Stock	17.6195	17.973	17.6195	17.954	77230510.0
2022-08-10 12:00:00	NVDA	Stock	17.953	18.023	17.772	17.813	63242190.0
2022-08-10 13:00:00	NVDA	Stock	17.814	17.99	17.751	17.9625	43632650.0
2022-08-10 14:00:00	NVDA	Stock	17.9625	18.083	17.9215	18.0062	48148830.0
2022-08-10 15:00:00	NVDA	Stock	18.006	18.118	17.9662	18.096	74149040.0
2022-08-10 16:00:00	NVDA	Stock	18.096	18.1	18.036	18.075	29717100.0
2022-08-10 17:00:00	NVDA	Stock	18.068	18.0724	18.051	18.053	146680.0
2022-08-10 18:00:00	NVDA	Stock	18.052	18.065	18.045	18.061	236910.0
2022-08-10 19:00:00	NVDA	Stock	18.058	18.105	18.051	18.095	210470.0
2022-08-10 04:00:00	AMZN	Stock	137.83	138.42	137.4	138.3	8591.0
2022-08-10 05:00:00	AMZN	Stock	138.29	138.32	138.06	138.1	7536.0

> showing 50 of 64,031 rows — these rows as CSV

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