PREVIEW / stock_1hour / 2023-01-11

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-11.parquet
  size:    1.4 MB
  rows:    62,140
  symbols: 1,959

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-01-11 04:00:00	AAPL	Stock	130.95	131.3	130.8	131.05	23416.0
2023-01-11 05:00:00	AAPL	Stock	131.21	131.32	130.96	130.96	15582.0
2023-01-11 06:00:00	AAPL	Stock	130.96	131.18	130.8	130.8	27441.0
2023-01-11 07:00:00	AAPL	Stock	130.88	130.94	130.46	130.7	54275.0
2023-01-11 08:00:00	AAPL	Stock	130.85	131.68	130.404	131.5	391961.0
2023-01-11 09:00:00	AAPL	Stock	131.5	131.59	130.46	130.8781	7719760.0
2023-01-11 10:00:00	AAPL	Stock	130.895	132.1084	130.49	131.475	10499657.0
2023-01-11 11:00:00	AAPL	Stock	131.48	132.37	131.375	132.29	6142489.0
2023-01-11 12:00:00	AAPL	Stock	132.3	132.93	132.2296	132.75	6243078.0
2023-01-11 13:00:00	AAPL	Stock	132.76	133.24	132.21	132.4001	5468874.0
2023-01-11 14:00:00	AAPL	Stock	132.41	132.87	132.165	132.5299	4810998.0
2023-01-11 15:00:00	AAPL	Stock	132.53	133.51	132.495	133.48	10768576.0
2023-01-11 16:00:00	AAPL	Stock	133.48	133.5	133.14	133.43	9339811.0
2023-01-11 17:00:00	AAPL	Stock	133.42	133.47	133.35	133.44	91635.0
2023-01-11 18:00:00	AAPL	Stock	133.44	133.47	133.36	133.44	31104.0
2023-01-11 19:00:00	AAPL	Stock	133.45	133.49	133.39	133.49	51764.0
2023-01-11 04:00:00	MSFT	Stock	229.2	229.73	228.74	229.68	4324.0
2023-01-11 05:00:00	MSFT	Stock	229.6	229.6	229.3	229.3	1329.0
2023-01-11 06:00:00	MSFT	Stock	229.37	229.8	228.93	229.61	12532.0
2023-01-11 07:00:00	MSFT	Stock	229.51	230.1	229.0	229.66	29281.0
2023-01-11 08:00:00	MSFT	Stock	229.4	230.88	227.5	230.75	87540.0
2023-01-11 09:00:00	MSFT	Stock	230.56	233.8699	230.16	231.9828	3266753.0
2023-01-11 10:00:00	MSFT	Stock	231.97	233.6799	231.45	232.555	2522528.0
2023-01-11 11:00:00	MSFT	Stock	232.54	233.99	232.52	233.785	1664759.0
2023-01-11 12:00:00	MSFT	Stock	233.8	234.29	233.47	233.79	1676680.0
2023-01-11 13:00:00	MSFT	Stock	233.8	234.53	233.07	234.01	1317074.0
2023-01-11 14:00:00	MSFT	Stock	234.02	234.45	233.67	234.41	1885021.0
2023-01-11 15:00:00	MSFT	Stock	234.41	235.95	234.05	235.79	3862612.0
2023-01-11 16:00:00	MSFT	Stock	235.79	235.85	234.4466	235.55	5110019.0
2023-01-11 17:00:00	MSFT	Stock	235.56	235.65	235.29	235.55	11106.0
2023-01-11 18:00:00	MSFT	Stock	235.66	235.77	235.12	235.5	12811.0
2023-01-11 19:00:00	MSFT	Stock	235.54	235.54	235.15	235.5	8174.0
2023-01-11 04:00:00	NVDA	Stock	15.948	15.981	15.939	15.953	23290.0
2023-01-11 05:00:00	NVDA	Stock	15.975	15.982	15.94	15.965	43840.0
2023-01-11 06:00:00	NVDA	Stock	15.96	15.998	15.95	15.963	64330.0
2023-01-11 07:00:00	NVDA	Stock	15.983	15.983	15.845	15.854	492460.0
2023-01-11 08:00:00	NVDA	Stock	15.965	16.041	15.82	15.844	1331580.0
2023-01-11 09:00:00	NVDA	Stock	15.845	15.891	15.563	15.7147	53144490.0
2023-01-11 10:00:00	NVDA	Stock	15.715	15.874	15.613	15.6235	47656020.0
2023-01-11 11:00:00	NVDA	Stock	15.6235	15.776	15.618	15.757	29613760.0
2023-01-11 12:00:00	NVDA	Stock	15.758	15.894	15.742	15.808	30826560.0
2023-01-11 13:00:00	NVDA	Stock	15.808	15.91	15.801	15.844	29122260.0
2023-01-11 14:00:00	NVDA	Stock	15.845	15.911	15.8202	15.8671	25960040.0
2023-01-11 15:00:00	NVDA	Stock	15.867	16.028	15.845	16.002	52187990.0
2023-01-11 16:00:00	NVDA	Stock	16.002	16.033	15.975	16.028	26582100.0
2023-01-11 17:00:00	NVDA	Stock	16.024	16.041	16.018	16.023	145910.0
2023-01-11 18:00:00	NVDA	Stock	16.025	16.032	16.001	16.02	172060.0
2023-01-11 19:00:00	NVDA	Stock	16.021	16.04	16.011	16.035	134650.0
2023-01-11 04:00:00	AMZN	Stock	90.02	90.4	89.88	90.27	26389.0
2023-01-11 05:00:00	AMZN	Stock	90.39	90.42	90.26	90.35	14054.0

> showing 50 of 62,140 rows — these rows as CSV

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