PREVIEW / stock_1hour / 2021-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-08.parquet
  size:    1.4 MB
  rows:    64,123
  symbols: 2,696

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-09-08 04:00:00	AAPL	Stock	156.45	156.72	156.0	156.27	23942.0
2021-09-08 05:00:00	AAPL	Stock	156.3	156.69	156.24	156.69	9616.0
2021-09-08 06:00:00	AAPL	Stock	156.69	156.75	156.63	156.75	9040.0
2021-09-08 07:00:00	AAPL	Stock	156.71	157.07	156.61	156.97	128017.0
2021-09-08 08:00:00	AAPL	Stock	156.7499	157.09	156.66	157.06	394230.0
2021-09-08 09:00:00	AAPL	Stock	157.06	157.19	155.49	155.96	12261196.0
2021-09-08 10:00:00	AAPL	Stock	155.96	156.07	153.975	154.12	13150081.0
2021-09-08 11:00:00	AAPL	Stock	154.1108	155.14	154.08	154.3201	9962845.0
2021-09-08 12:00:00	AAPL	Stock	154.32	154.8814	154.11	154.3301	6324649.0
2021-09-08 13:00:00	AAPL	Stock	154.33	155.04	154.27	154.705	5205397.0
2021-09-08 14:00:00	AAPL	Stock	154.7083	155.1	154.62	154.7401	4838735.0
2021-09-08 15:00:00	AAPL	Stock	154.745	155.13	154.6	155.1199	7343768.0
2021-09-08 16:00:00	AAPL	Stock	155.12	155.12	154.93	155.06	6048767.0
2021-09-08 17:00:00	AAPL	Stock	155.08	155.14	155.04	155.1	35838.0
2021-09-08 18:00:00	AAPL	Stock	155.1	155.11	154.9701	154.9701	32712.0
2021-09-08 19:00:00	AAPL	Stock	154.97	155.04	154.94	155.0	41014.0
2021-09-08 04:00:00	MSFT	Stock	299.5	299.8	299.22	299.8	646.0
2021-09-08 05:00:00	MSFT	Stock	299.74	300.0	299.69	300.0	754.0
2021-09-08 06:00:00	MSFT	Stock	300.0	300.0	299.8	299.87	1169.0
2021-09-08 07:00:00	MSFT	Stock	299.95	300.12	299.61	299.85	6287.0
2021-09-08 08:00:00	MSFT	Stock	299.95	300.08	299.6	299.75	12522.0
2021-09-08 09:00:00	MSFT	Stock	299.75	300.61	298.55	299.02	1438480.0
2021-09-08 10:00:00	MSFT	Stock	299.02	299.56	297.4651	297.786	1792934.0
2021-09-08 11:00:00	MSFT	Stock	297.77	298.89	297.75	298.18	1125260.0
2021-09-08 12:00:00	MSFT	Stock	298.18	299.18	297.96	298.6801	875042.0
2021-09-08 13:00:00	MSFT	Stock	298.67	299.2177	298.55	298.71	714124.0
2021-09-08 14:00:00	MSFT	Stock	298.73	299.25	298.6	298.82	696245.0
2021-09-08 15:00:00	MSFT	Stock	298.82	300.23	298.69	300.23	1666591.0
2021-09-08 16:00:00	MSFT	Stock	300.21	300.49	299.95	300.05	2302744.0
2021-09-08 17:00:00	MSFT	Stock	300.07	300.07	299.96	299.98	1592.0
2021-09-08 18:00:00	MSFT	Stock	300.21	300.21	299.71	299.71	1404.0
2021-09-08 19:00:00	MSFT	Stock	299.71	299.75	299.35	299.64	2680.0
2021-09-08 04:00:00	NVDA	Stock	22.483	22.483	22.35	22.382	85720.0
2021-09-08 05:00:00	NVDA	Stock	22.411	22.5	22.411	22.5	59720.0
2021-09-08 06:00:00	NVDA	Stock	22.545	22.589	22.5	22.589	34440.0
2021-09-08 07:00:00	NVDA	Stock	22.57	22.607	22.54	22.55	107540.0
2021-09-08 08:00:00	NVDA	Stock	22.5538	22.6	22.5	22.51	383580.0
2021-09-08 09:00:00	NVDA	Stock	22.527	22.656	22.23	22.3201	31805860.0
2021-09-08 10:00:00	NVDA	Stock	22.324	22.405	21.977	22.011	42444950.0
2021-09-08 11:00:00	NVDA	Stock	22.006	22.191	22.005	22.085	29082010.0
2021-09-08 12:00:00	NVDA	Stock	22.0836	22.418	22.02	22.269	36606670.0
2021-09-08 13:00:00	NVDA	Stock	22.271	22.3775	22.243	22.307	17784820.0
2021-09-08 14:00:00	NVDA	Stock	22.3075	22.391	22.281	22.331	11356160.0
2021-09-08 15:00:00	NVDA	Stock	22.332	22.381	22.293	22.338	17337490.0
2021-09-08 16:00:00	NVDA	Stock	22.339	22.345	22.2591	22.339	9039480.0
2021-09-08 17:00:00	NVDA	Stock	22.326	22.326	22.308	22.309	65700.0
2021-09-08 18:00:00	NVDA	Stock	22.329	22.339	22.307	22.31	107050.0
2021-09-08 19:00:00	NVDA	Stock	22.318	22.318	22.255	22.28	163480.0
2021-09-08 06:00:00	AMZN	Stock	175.4	175.45	175.4	175.45	8680.0
2021-09-08 07:00:00	AMZN	Stock	175.475	175.6205	175.4	175.6	38020.0

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

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