PREVIEW / stock_1hour / 2022-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-31.parquet
  size:    1.4 MB
  rows:    62,110
  symbols: 2,133

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-31 04:00:00	AAPL	Stock	155.0	155.66	154.45	154.68	81173.0
2022-10-31 05:00:00	AAPL	Stock	154.72	155.1	154.67	154.78	29975.0
2022-10-31 06:00:00	AAPL	Stock	154.78	154.93	154.58	154.8	31131.0
2022-10-31 07:00:00	AAPL	Stock	154.89	155.02	154.57	154.61	121730.0
2022-10-31 08:00:00	AAPL	Stock	154.9778	155.0526	153.46	153.79	761029.0
2022-10-31 09:00:00	AAPL	Stock	153.79	154.07	152.33	153.01	13510645.0
2022-10-31 10:00:00	AAPL	Stock	153.005	153.4	151.92	152.69	12659610.0
2022-10-31 11:00:00	AAPL	Stock	152.68	154.01	152.5737	153.28	9560344.0
2022-10-31 12:00:00	AAPL	Stock	153.26	154.1499	153.01	153.59	7226906.0
2022-10-31 13:00:00	AAPL	Stock	153.595	154.12	153.37	153.73	5807902.0
2022-10-31 14:00:00	AAPL	Stock	153.72	154.24	153.29	153.6	6533394.0
2022-10-31 15:00:00	AAPL	Stock	153.61	153.65	152.62	153.45	12523937.0
2022-10-31 16:00:00	AAPL	Stock	153.34	153.65	153.15	153.4	14046052.0
2022-10-31 17:00:00	AAPL	Stock	153.4	153.49	153.21	153.2399	90924.0
2022-10-31 18:00:00	AAPL	Stock	153.25	153.38	152.91	153.3	45328.0
2022-10-31 19:00:00	AAPL	Stock	153.31	153.5	153.31	153.46	49293.0
2022-10-31 04:00:00	MSFT	Stock	234.7	234.7	233.31	233.52	5826.0
2022-10-31 05:00:00	MSFT	Stock	233.79	234.15	233.61	234.0	2311.0
2022-10-31 06:00:00	MSFT	Stock	233.99	233.99	233.1	233.2	6263.0
2022-10-31 07:00:00	MSFT	Stock	233.79	234.64	233.76	234.24	15408.0
2022-10-31 08:00:00	MSFT	Stock	233.7817	236.459	232.1	233.75	46625.0
2022-10-31 09:00:00	MSFT	Stock	233.8423	234.92	231.67	232.18	2697732.0
2022-10-31 10:00:00	MSFT	Stock	232.16	233.26	231.15	231.97	2413985.0
2022-10-31 11:00:00	MSFT	Stock	231.95	234.19	231.95	233.32	2353389.0
2022-10-31 12:00:00	MSFT	Stock	233.35	234.41	232.5	232.77	1408447.0
2022-10-31 13:00:00	MSFT	Stock	232.78	233.84	232.33	233.44	1345605.0
2022-10-31 14:00:00	MSFT	Stock	233.43	233.84	232.905	233.18	1399663.0
2022-10-31 15:00:00	MSFT	Stock	233.18	233.27	231.49	232.13	4210071.0
2022-10-31 16:00:00	MSFT	Stock	232.13	232.59	232.02	232.27	5872168.0
2022-10-31 17:00:00	MSFT	Stock	232.32	232.35	232.13	232.13	4371.0
2022-10-31 18:00:00	MSFT	Stock	232.27	232.39	231.76	232.15	7197.0
2022-10-31 19:00:00	MSFT	Stock	232.26	232.88	232.26	232.6	5825.0
2022-10-31 04:00:00	NVDA	Stock	13.74	13.76	13.668	13.673	289600.0
2022-10-31 05:00:00	NVDA	Stock	13.675	13.738	13.675	13.701	124960.0
2022-10-31 06:00:00	NVDA	Stock	13.703	13.72	13.695	13.71	62890.0
2022-10-31 07:00:00	NVDA	Stock	13.737	13.82	13.703	13.799	338000.0
2022-10-31 08:00:00	NVDA	Stock	13.7551	13.8298	13.701	13.738	1689780.0
2022-10-31 09:00:00	NVDA	Stock	13.738	13.838	13.428	13.5154	50945320.0
2022-10-31 10:00:00	NVDA	Stock	13.513	13.609	13.297	13.367	75158180.0
2022-10-31 11:00:00	NVDA	Stock	13.366	13.582	13.326	13.512	59496080.0
2022-10-31 12:00:00	NVDA	Stock	13.515	13.584	13.407	13.4845	47537600.0
2022-10-31 13:00:00	NVDA	Stock	13.486	13.643	13.454	13.583	45905590.0
2022-10-31 14:00:00	NVDA	Stock	13.582	13.624	13.52	13.558	42888140.0
2022-10-31 15:00:00	NVDA	Stock	13.5575	13.567	13.473	13.5	56151560.0
2022-10-31 16:00:00	NVDA	Stock	13.497	13.535	13.482	13.517	27377250.0
2022-10-31 17:00:00	NVDA	Stock	13.517	13.529	13.491	13.5	122060.0
2022-10-31 18:00:00	NVDA	Stock	13.495	13.51	13.491	13.497	101260.0
2022-10-31 19:00:00	NVDA	Stock	13.498	13.505	13.453	13.47	429570.0
2022-10-31 04:00:00	AMZN	Stock	104.0	104.0	102.28	102.54	75581.0
2022-10-31 05:00:00	AMZN	Stock	102.51	102.9	102.32	102.7	30896.0

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

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