PREVIEW / stock_1hour / 2022-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-27.parquet
  size:    1.4 MB
  rows:    61,114
  symbols: 2,121

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-10-27 04:00:00	AAPL	Stock	148.94	149.1	148.65	148.8	34898.0
2022-10-27 05:00:00	AAPL	Stock	148.75	148.76	148.32	148.32	28111.0
2022-10-27 06:00:00	AAPL	Stock	148.32	148.47	148.0	148.17	52574.0
2022-10-27 07:00:00	AAPL	Stock	148.15	148.39	147.92	147.97	99171.0
2022-10-27 08:00:00	AAPL	Stock	148.0535	149.5	147.5	148.61	449710.0
2022-10-27 09:00:00	AAPL	Stock	148.61	149.046	145.54	146.31	10395095.0
2022-10-27 10:00:00	AAPL	Stock	146.32	148.3	146.17	146.53	10827080.0
2022-10-27 11:00:00	AAPL	Stock	146.525	147.27	145.8	146.1465	7455741.0
2022-10-27 12:00:00	AAPL	Stock	146.15	146.69	145.18	145.29	7039460.0
2022-10-27 13:00:00	AAPL	Stock	145.295	145.8042	144.56	144.6637	8446648.0
2022-10-27 14:00:00	AAPL	Stock	144.66	144.755	144.13	144.5182	7902565.0
2022-10-27 15:00:00	AAPL	Stock	144.51	145.38	144.28	145.0	15147161.0
2022-10-27 16:00:00	AAPL	Stock	144.97	145.9	136.0	143.17	18769287.0
2022-10-27 17:00:00	AAPL	Stock	143.2999	148.25	139.4	145.85	5252744.0
2022-10-27 18:00:00	AAPL	Stock	145.9799	147.34	144.72	145.2	856252.0
2022-10-27 19:00:00	AAPL	Stock	145.3	145.99	145.1	145.3499	258396.0
2022-10-27 04:00:00	MSFT	Stock	232.44	232.72	231.6	232.0	18248.0
2022-10-27 05:00:00	MSFT	Stock	231.75	231.75	231.0	231.05	14900.0
2022-10-27 06:00:00	MSFT	Stock	231.04	231.04	230.0	230.12	13147.0
2022-10-27 07:00:00	MSFT	Stock	230.34	230.95	230.0	230.3	30037.0
2022-10-27 08:00:00	MSFT	Stock	230.05	232.21	230.01	232.2	138589.0
2022-10-27 09:00:00	MSFT	Stock	232.0	233.69	226.81	227.29	5494831.0
2022-10-27 10:00:00	MSFT	Stock	227.275	230.73	226.87	227.941	4976382.0
2022-10-27 11:00:00	MSFT	Stock	227.91	229.06	227.05	227.28	2937587.0
2022-10-27 12:00:00	MSFT	Stock	227.29	227.57	225.78	226.61	3044020.0
2022-10-27 13:00:00	MSFT	Stock	226.61	227.67	226.17	226.67	2499922.0
2022-10-27 14:00:00	MSFT	Stock	226.675	227.22	226.11	226.35	2080484.0
2022-10-27 15:00:00	MSFT	Stock	226.35	227.99	226.1	226.81	4741027.0
2022-10-27 16:00:00	MSFT	Stock	226.75	227.46	220.33	223.8	5403720.0
2022-10-27 17:00:00	MSFT	Stock	223.8	225.89	223.4001	224.94	131956.0
2022-10-27 18:00:00	MSFT	Stock	224.6936	225.5	224.26	225.02	67932.0
2022-10-27 19:00:00	MSFT	Stock	224.9	225.0	224.6	224.7	27555.0
2022-10-27 04:00:00	NVDA	Stock	13.394	13.394	13.283	13.308	224080.0
2022-10-27 05:00:00	NVDA	Stock	13.302	13.31	13.278	13.28	149940.0
2022-10-27 06:00:00	NVDA	Stock	13.281	13.312	13.239	13.26	159620.0
2022-10-27 07:00:00	NVDA	Stock	13.275	13.412	13.275	13.412	793730.0
2022-10-27 08:00:00	NVDA	Stock	13.311	13.62	12.8638	13.6	3185040.0
2022-10-27 09:00:00	NVDA	Stock	13.6	13.838	13.122	13.191	107140450.0
2022-10-27 10:00:00	NVDA	Stock	13.193	13.668	13.135	13.425	107453190.0
2022-10-27 11:00:00	NVDA	Stock	13.4212	13.518	13.22	13.228	53259180.0
2022-10-27 12:00:00	NVDA	Stock	13.231	13.292	13.1669	13.252	40701850.0
2022-10-27 13:00:00	NVDA	Stock	13.254	13.372	13.213	13.2845	41578130.0
2022-10-27 14:00:00	NVDA	Stock	13.2845	13.316	13.204	13.23	32232900.0
2022-10-27 15:00:00	NVDA	Stock	13.229	13.301	13.155	13.169	57040260.0
2022-10-27 16:00:00	NVDA	Stock	13.176	13.198	12.755	13.029	34457740.0
2022-10-27 17:00:00	NVDA	Stock	13.017	13.112	12.982	13.075	1125240.0
2022-10-27 18:00:00	NVDA	Stock	13.076	13.096	13.026	13.04	173720.0
2022-10-27 19:00:00	NVDA	Stock	13.033	13.07	13.026	13.056	139490.0
2022-10-27 04:00:00	AMZN	Stock	115.62	115.69	115.1	115.24	9271.0
2022-10-27 05:00:00	AMZN	Stock	115.13	115.13	114.31	114.31	32743.0

> showing 50 of 61,114 rows — these rows as CSV

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