PREVIEW / stock_1hour / 2021-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-04.parquet
  size:    1.4 MB
  rows:    64,999
  symbols: 2,832

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
2021-08-04 04:00:00	AAPL	Stock	147.0	147.4	147.0	147.3	3710.0
2021-08-04 05:00:00	AAPL	Stock	147.34	147.53	147.22	147.4	4837.0
2021-08-04 06:00:00	AAPL	Stock	147.49	147.68	147.4	147.43	4589.0
2021-08-04 07:00:00	AAPL	Stock	147.4	147.54	147.09	147.09	58448.0
2021-08-04 08:00:00	AAPL	Stock	147.36	147.55	146.905	147.22	1663119.0
2021-08-04 09:00:00	AAPL	Stock	147.2136	147.79	146.79	147.693	8799860.0
2021-08-04 10:00:00	AAPL	Stock	147.7	147.756	146.58	146.63	9036781.0
2021-08-04 11:00:00	AAPL	Stock	146.635	146.99	146.28	146.97	6358351.0
2021-08-04 12:00:00	AAPL	Stock	146.96	147.31	146.81	147.145	4214402.0
2021-08-04 13:00:00	AAPL	Stock	147.15	147.52	147.0	147.075	3748190.0
2021-08-04 14:00:00	AAPL	Stock	147.07	147.26	146.77	146.82	3557712.0
2021-08-04 15:00:00	AAPL	Stock	146.815	147.33	146.66	146.94	5955447.0
2021-08-04 16:00:00	AAPL	Stock	146.95	146.95	146.75	146.83	5172844.0
2021-08-04 17:00:00	AAPL	Stock	146.83	146.95	146.81	146.9	488585.0
2021-08-04 18:00:00	AAPL	Stock	146.89	146.95	146.87	146.9	17260.0
2021-08-04 19:00:00	AAPL	Stock	146.91	147.01	146.87	147.01	25987.0
2021-08-04 04:00:00	MSFT	Stock	287.19	287.19	286.9	286.9	911.0
2021-08-04 05:00:00	MSFT	Stock	287.12	287.31	286.92	287.2	2163.0
2021-08-04 06:00:00	MSFT	Stock	287.25	287.3	287.17	287.17	1358.0
2021-08-04 07:00:00	MSFT	Stock	287.2	287.2	286.6	286.6	6798.0
2021-08-04 08:00:00	MSFT	Stock	287.12	287.4799	286.2	286.33	14738.0
2021-08-04 09:00:00	MSFT	Stock	286.25	287.2126	285.54	286.795	1797504.0
2021-08-04 10:00:00	MSFT	Stock	286.805	286.88	284.65	285.02	2148959.0
2021-08-04 11:00:00	MSFT	Stock	285.03	286.48	284.97	286.45	1203350.0
2021-08-04 12:00:00	MSFT	Stock	286.44	286.725	286.12	286.48	871037.0
2021-08-04 13:00:00	MSFT	Stock	286.49	287.03	286.33	286.41	1025139.0
2021-08-04 14:00:00	MSFT	Stock	286.45	287.5883	286.4	286.96	1426726.0
2021-08-04 15:00:00	MSFT	Stock	286.98	287.22	286.39	286.46	1573699.0
2021-08-04 16:00:00	MSFT	Stock	286.51	286.75	286.23	286.48	2444774.0
2021-08-04 17:00:00	MSFT	Stock	286.42	286.51	286.37	286.4	216964.0
2021-08-04 18:00:00	MSFT	Stock	286.51	286.51	286.4	286.5099	1829.0
2021-08-04 19:00:00	MSFT	Stock	286.5099	286.78	286.45	286.78	3543.0
2021-08-04 04:00:00	NVDA	Stock	19.725	19.772	19.725	19.768	56890.0
2021-08-04 05:00:00	NVDA	Stock	19.805	19.83	19.805	19.83	2990.0
2021-08-04 06:00:00	NVDA	Stock	19.84	19.88	19.82	19.821	82550.0
2021-08-04 07:00:00	NVDA	Stock	19.817	19.823	19.658	19.7	201450.0
2021-08-04 08:00:00	NVDA	Stock	19.77	19.83	19.625	19.734	572820.0
2021-08-04 09:00:00	NVDA	Stock	19.734	20.149	19.71	20.0139	30593270.0
2021-08-04 10:00:00	NVDA	Stock	20.009	20.1772	19.843	20.1285	32599750.0
2021-08-04 11:00:00	NVDA	Stock	20.13	20.259	20.001	20.073	26573800.0
2021-08-04 12:00:00	NVDA	Stock	20.0782	20.2235	20.035	20.197	14030220.0
2021-08-04 13:00:00	NVDA	Stock	20.202	20.274	20.143	20.206	16628940.0
2021-08-04 14:00:00	NVDA	Stock	20.206	20.278	20.145	20.217	14808850.0
2021-08-04 15:00:00	NVDA	Stock	20.217	20.318	20.163	20.274	24226800.0
2021-08-04 16:00:00	NVDA	Stock	20.273	20.276	20.22	20.272	12351960.0
2021-08-04 17:00:00	NVDA	Stock	20.268	20.292	20.257	20.267	246150.0
2021-08-04 18:00:00	NVDA	Stock	20.267	20.295	20.26	20.295	200280.0
2021-08-04 19:00:00	NVDA	Stock	20.288	20.314	20.285	20.302	105770.0
2021-08-04 04:00:00	AMZN	Stock	168.75	168.9	168.7	168.75	10640.0
2021-08-04 06:00:00	AMZN	Stock	168.65	168.65	168.65	168.65	2600.0

> showing 50 of 64,999 rows — these rows as CSV

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