PREVIEW / stock_1hour / 2022-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-27.parquet
  size:    1.4 MB
  rows:    62,361
  symbols: 2,277

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-09-27 04:00:00	AAPL	Stock	152.52	153.33	152.52	152.67	31254.0
2022-09-27 05:00:00	AAPL	Stock	152.68	152.68	152.12	152.22	19997.0
2022-09-27 06:00:00	AAPL	Stock	152.34	153.0	152.22	152.79	27061.0
2022-09-27 07:00:00	AAPL	Stock	152.66	153.2	152.62	153.0	174248.0
2022-09-27 08:00:00	AAPL	Stock	152.7001	153.35	152.5	152.92	275543.0
2022-09-27 09:00:00	AAPL	Stock	152.91	154.72	152.6	153.92	10243754.0
2022-09-27 10:00:00	AAPL	Stock	153.92	154.04	152.5	153.4762	10473966.0
2022-09-27 11:00:00	AAPL	Stock	153.46	153.57	151.53	151.575	9089880.0
2022-09-27 12:00:00	AAPL	Stock	151.58	151.82	149.945	151.7	10536766.0
2022-09-27 13:00:00	AAPL	Stock	151.69	151.7	150.72	151.08	6417735.0
2022-09-27 14:00:00	AAPL	Stock	151.09	152.45	150.86	152.02	7091575.0
2022-09-27 15:00:00	AAPL	Stock	152.03	152.19	151.03	151.75	11375398.0
2022-09-27 16:00:00	AAPL	Stock	151.76	151.91	151.51	151.81	7328153.0
2022-09-27 17:00:00	AAPL	Stock	151.82	151.88	151.66	151.78	59679.0
2022-09-27 18:00:00	AAPL	Stock	151.82	151.99	151.78	151.95	40289.0
2022-09-27 19:00:00	AAPL	Stock	151.98	152.2	151.8	151.9	65403.0
2022-09-27 04:00:00	MSFT	Stock	237.6	240.97	237.6	240.61	6600.0
2022-09-27 05:00:00	MSFT	Stock	240.13	240.13	239.29	239.31	3003.0
2022-09-27 06:00:00	MSFT	Stock	239.6	240.37	239.55	240.0	17023.0
2022-09-27 07:00:00	MSFT	Stock	239.93	240.66	239.9	240.66	49756.0
2022-09-27 08:00:00	MSFT	Stock	240.2	240.9	236.857	240.0	116866.0
2022-09-27 09:00:00	MSFT	Stock	239.83	241.8	239.31	240.06	2372822.0
2022-09-27 10:00:00	MSFT	Stock	240.07	240.14	238.42	239.565	2288341.0
2022-09-27 11:00:00	MSFT	Stock	239.57	239.86	236.6882	236.7612	1949318.0
2022-09-27 12:00:00	MSFT	Stock	236.74	236.87	234.5	235.67	2664510.0
2022-09-27 13:00:00	MSFT	Stock	235.65	235.9	234.68	235.19	2108145.0
2022-09-27 14:00:00	MSFT	Stock	235.2	237.0	234.81	236.44	2488703.0
2022-09-27 15:00:00	MSFT	Stock	236.435	236.96	235.2	236.41	3669656.0
2022-09-27 16:00:00	MSFT	Stock	236.41	236.79	236.06	236.24	3572288.0
2022-09-27 17:00:00	MSFT	Stock	236.32	236.56	236.32	236.39	5756.0
2022-09-27 18:00:00	MSFT	Stock	236.49	237.0	236.32	236.41	12360.0
2022-09-27 19:00:00	MSFT	Stock	236.44	237.0	236.32	236.33	12436.0
2022-09-27 04:00:00	NVDA	Stock	12.45	12.5	12.4	12.404	233530.0
2022-09-27 05:00:00	NVDA	Stock	12.405	12.405	12.361	12.375	112900.0
2022-09-27 06:00:00	NVDA	Stock	12.38	12.431	12.38	12.42	99450.0
2022-09-27 07:00:00	NVDA	Stock	12.403	12.473	12.39	12.453	721870.0
2022-09-27 08:00:00	NVDA	Stock	12.3911	12.527	12.1975	12.488	3168290.0
2022-09-27 09:00:00	NVDA	Stock	12.482	12.736	12.452	12.6	81391530.0
2022-09-27 10:00:00	NVDA	Stock	12.605	12.699	12.486	12.679	85496010.0
2022-09-27 11:00:00	NVDA	Stock	12.681	12.704	12.467	12.475	59485070.0
2022-09-27 12:00:00	NVDA	Stock	12.474	12.474	12.258	12.352	55956670.0
2022-09-27 13:00:00	NVDA	Stock	12.352	12.375	12.273	12.33	42618140.0
2022-09-27 14:00:00	NVDA	Stock	12.33	12.465	12.298	12.419	50323620.0
2022-09-27 15:00:00	NVDA	Stock	12.422	12.464	12.353	12.41	68711200.0
2022-09-27 16:00:00	NVDA	Stock	12.413	12.4479	12.39	12.4479	19824870.0
2022-09-27 17:00:00	NVDA	Stock	12.44	12.4599	12.43	12.45	380080.0
2022-09-27 18:00:00	NVDA	Stock	12.459	12.476	12.43	12.451	227980.0
2022-09-27 19:00:00	NVDA	Stock	12.47	12.53	12.45	12.529	793670.0
2022-09-27 04:00:00	AMZN	Stock	116.52	117.66	116.02	116.84	18536.0
2022-09-27 05:00:00	AMZN	Stock	116.68	116.97	116.44	116.44	7647.0

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

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