PREVIEW / stock_1hour / 2022-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-19.parquet
  size:    1.4 MB
  rows:    62,167
  symbols: 2,306

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-07-19 04:00:00	AAPL	Stock	147.24	147.4	146.85	147.4	26058.0
2022-07-19 05:00:00	AAPL	Stock	147.35	148.0	147.26	147.61	42968.0
2022-07-19 06:00:00	AAPL	Stock	147.58	147.98	147.47	147.67	47454.0
2022-07-19 07:00:00	AAPL	Stock	147.68	147.68	147.31	147.53	121455.0
2022-07-19 08:00:00	AAPL	Stock	147.63	147.8	146.703	147.581	834988.0
2022-07-19 09:00:00	AAPL	Stock	147.61	148.49	146.91	147.98	8990213.0
2022-07-19 10:00:00	AAPL	Stock	147.99	149.4099	147.31	149.4	9960672.0
2022-07-19 11:00:00	AAPL	Stock	149.41	150.22	149.4075	149.81	9494184.0
2022-07-19 12:00:00	AAPL	Stock	149.805	150.21	149.3586	150.08	5955645.0
2022-07-19 13:00:00	AAPL	Stock	150.0898	150.85	149.68	150.8168	6577760.0
2022-07-19 14:00:00	AAPL	Stock	150.815	150.94	150.28	150.68	5729725.0
2022-07-19 15:00:00	AAPL	Stock	150.68	151.23	150.37	150.97	12752319.0
2022-07-19 16:00:00	AAPL	Stock	150.97	151.87	150.93	151.72	11980122.0
2022-07-19 17:00:00	AAPL	Stock	151.75	152.11	151.7	152.04	171686.0
2022-07-19 18:00:00	AAPL	Stock	151.92	151.93	151.56	151.75	69215.0
2022-07-19 19:00:00	AAPL	Stock	151.75	151.97	151.5	151.8	96809.0
2022-07-19 04:00:00	MSFT	Stock	254.99	255.2	254.85	255.2	1477.0
2022-07-19 05:00:00	MSFT	Stock	256.0	256.12	255.8	256.06	4069.0
2022-07-19 06:00:00	MSFT	Stock	256.0	256.95	256.0	256.78	2994.0
2022-07-19 07:00:00	MSFT	Stock	256.6	256.66	256.0	256.6	22445.0
2022-07-19 08:00:00	MSFT	Stock	256.5997	256.75	253.615	256.5	25602.0
2022-07-19 09:00:00	MSFT	Stock	256.4999	258.45	253.68	255.515	2361175.0
2022-07-19 10:00:00	MSFT	Stock	255.54	257.21	254.08	257.04	2242405.0
2022-07-19 11:00:00	MSFT	Stock	257.07	258.04	256.86	257.53	1192955.0
2022-07-19 12:00:00	MSFT	Stock	257.52	258.04	256.7334	257.9533	1009945.0
2022-07-19 13:00:00	MSFT	Stock	257.95	258.91	257.52	258.81	1043738.0
2022-07-19 14:00:00	MSFT	Stock	258.81	259.24	257.75	258.64	1220066.0
2022-07-19 15:00:00	MSFT	Stock	258.65	259.72	258.3	259.49	3489470.0
2022-07-19 16:00:00	MSFT	Stock	259.489	259.95	259.3	259.76	5997977.0
2022-07-19 17:00:00	MSFT	Stock	259.87	260.48	259.8	260.0578	18372.0
2022-07-19 18:00:00	MSFT	Stock	260.04	260.04	259.65	259.89	18618.0
2022-07-19 19:00:00	MSFT	Stock	259.89	260.04	259.5	259.54	35708.0
2022-07-19 04:00:00	NVDA	Stock	16.142	16.218	16.098	16.218	97980.0
2022-07-19 05:00:00	NVDA	Stock	16.211	16.272	16.194	16.24	91200.0
2022-07-19 06:00:00	NVDA	Stock	16.232	16.301	16.221	16.284	81720.0
2022-07-19 07:00:00	NVDA	Stock	16.28	16.299	16.251	16.292	369780.0
2022-07-19 08:00:00	NVDA	Stock	16.258	16.425	16.25	16.409	2487960.0
2022-07-19 09:00:00	NVDA	Stock	16.409	16.568	16.172	16.3791	74414920.0
2022-07-19 10:00:00	NVDA	Stock	16.381	16.5769	16.223	16.5671	78548380.0
2022-07-19 11:00:00	NVDA	Stock	16.567	16.746	16.532	16.6915	71791300.0
2022-07-19 12:00:00	NVDA	Stock	16.692	16.822	16.613	16.8195	53610210.0
2022-07-19 13:00:00	NVDA	Stock	16.819	17.068	16.809	17.028	89833890.0
2022-07-19 14:00:00	NVDA	Stock	17.028	17.11	16.843	16.924	84956540.0
2022-07-19 15:00:00	NVDA	Stock	16.924	17.018	16.856	16.99	76755000.0
2022-07-19 16:00:00	NVDA	Stock	16.991	17.189	16.971	17.183	34925080.0
2022-07-19 17:00:00	NVDA	Stock	17.188	17.239	17.179	17.233	932040.0
2022-07-19 18:00:00	NVDA	Stock	17.231	17.231	17.125	17.19	727070.0
2022-07-19 19:00:00	NVDA	Stock	17.192	17.277	17.189	17.24	952650.0
2022-07-19 04:00:00	AMZN	Stock	114.15	114.27	113.7	114.27	10033.0
2022-07-19 05:00:00	AMZN	Stock	114.04	114.74	114.03	114.55	10648.0

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

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