PREVIEW / stock_1hour / 2021-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-24.parquet
  size:    1.4 MB
  rows:    63,387
  symbols: 2,673

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-24 04:00:00	AAPL	Stock	146.4	146.4	145.65	146.0	20877.0
2021-09-24 05:00:00	AAPL	Stock	146.01	146.01	145.71	145.79	11791.0
2021-09-24 06:00:00	AAPL	Stock	145.73	146.0	145.66	145.74	10877.0
2021-09-24 07:00:00	AAPL	Stock	145.79	146.07	145.75	145.83	110580.0
2021-09-24 08:00:00	AAPL	Stock	145.8001	146.03	145.49	145.7	510088.0
2021-09-24 09:00:00	AAPL	Stock	145.71	146.28	145.56	146.17	7575551.0
2021-09-24 10:00:00	AAPL	Stock	146.17	146.39	145.73	145.9099	7745397.0
2021-09-24 11:00:00	AAPL	Stock	145.9023	146.44	145.85	146.425	5062151.0
2021-09-24 12:00:00	AAPL	Stock	146.425	146.8	146.29	146.615	4665697.0
2021-09-24 13:00:00	AAPL	Stock	146.6169	146.8999	146.5	146.705	3985384.0
2021-09-24 14:00:00	AAPL	Stock	146.705	147.03	146.69	147.0025	3498418.0
2021-09-24 15:00:00	AAPL	Stock	147.0099	147.4701	146.82	146.91	9629922.0
2021-09-24 16:00:00	AAPL	Stock	146.92	147.0	146.92	146.99	4508530.0
2021-09-24 17:00:00	AAPL	Stock	146.98	147.0	146.93	146.95	32237.0
2021-09-24 18:00:00	AAPL	Stock	146.95	146.96	146.92	146.93	15905.0
2021-09-24 19:00:00	AAPL	Stock	146.93	147.01	146.93	146.97	25479.0
2021-09-24 04:00:00	MSFT	Stock	298.02	298.3	298.0	298.3	1118.0
2021-09-24 05:00:00	MSFT	Stock	298.3	298.33	298.2	298.22	808.0
2021-09-24 06:00:00	MSFT	Stock	298.0	298.6	298.0	298.25	5297.0
2021-09-24 07:00:00	MSFT	Stock	298.5	298.59	298.09	298.17	16371.0
2021-09-24 08:00:00	MSFT	Stock	298.1001	298.58	297.75	297.9401	44679.0
2021-09-24 09:00:00	MSFT	Stock	297.93	299.466	297.61	298.52	1540384.0
2021-09-24 10:00:00	MSFT	Stock	298.51	298.97	297.13	297.44	1739575.0
2021-09-24 11:00:00	MSFT	Stock	297.435	298.12	296.93	297.64	1082085.0
2021-09-24 12:00:00	MSFT	Stock	297.64	298.62	297.29	298.4541	955480.0
2021-09-24 13:00:00	MSFT	Stock	298.46	298.7999	298.19	298.21	833958.0
2021-09-24 14:00:00	MSFT	Stock	298.2	298.82	298.1	298.78	752097.0
2021-09-24 15:00:00	MSFT	Stock	298.78	299.8	298.42	299.35	1924017.0
2021-09-24 16:00:00	MSFT	Stock	299.35	299.81	299.27	299.48	1828179.0
2021-09-24 17:00:00	MSFT	Stock	299.41	299.5	299.39	299.5	2042.0
2021-09-24 18:00:00	MSFT	Stock	299.42	299.5	299.4	299.4	2712.0
2021-09-24 19:00:00	MSFT	Stock	299.5	299.5	299.35	299.5	790.0
2021-09-24 04:00:00	NVDA	Stock	22.237	22.363	22.237	22.35	60960.0
2021-09-24 05:00:00	NVDA	Stock	22.306	22.306	22.203	22.203	55810.0
2021-09-24 06:00:00	NVDA	Stock	22.207	22.232	22.198	22.2	241510.0
2021-09-24 07:00:00	NVDA	Stock	22.197	22.225	22.14	22.17	497270.0
2021-09-24 08:00:00	NVDA	Stock	22.18	22.225	22.1154	22.154	908010.0
2021-09-24 09:00:00	NVDA	Stock	22.175	22.195	21.868	22.012	42264200.0
2021-09-24 10:00:00	NVDA	Stock	22.014	22.0669	21.862	21.8692	26717510.0
2021-09-24 11:00:00	NVDA	Stock	21.867	21.97	21.861	21.9559	15252840.0
2021-09-24 12:00:00	NVDA	Stock	21.958	22.1315	21.938	22.0913	19845770.0
2021-09-24 13:00:00	NVDA	Stock	22.09	22.149	21.965	21.989	14026460.0
2021-09-24 14:00:00	NVDA	Stock	21.9888	22.06	21.971	22.0565	9963150.0
2021-09-24 15:00:00	NVDA	Stock	22.059	22.139	22.001	22.083	18613430.0
2021-09-24 16:00:00	NVDA	Stock	22.081	22.125	22.031	22.074	16039730.0
2021-09-24 17:00:00	NVDA	Stock	22.069	22.09	22.058	22.089	62500.0
2021-09-24 18:00:00	NVDA	Stock	22.075	22.075	22.055	22.056	133590.0
2021-09-24 19:00:00	NVDA	Stock	22.055	22.069	22.03	22.04	131750.0
2021-09-24 06:00:00	AMZN	Stock	170.0	170.0	170.0	170.0	2000.0
2021-09-24 07:00:00	AMZN	Stock	170.05	170.05	169.95	169.95	32940.0

> showing 50 of 63,387 rows — these rows as CSV

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