PREVIEW / stock_1hour / 2021-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-02.parquet
  size:    1.4 MB
  rows:    64,939
  symbols: 2,828

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-02 04:00:00	AAPL	Stock	146.46	146.75	146.15	146.67	21334.0
2021-08-02 05:00:00	AAPL	Stock	146.62	146.71	146.6	146.65	19022.0
2021-08-02 06:00:00	AAPL	Stock	146.6	146.72	146.5	146.5	74583.0
2021-08-02 07:00:00	AAPL	Stock	146.45	146.99	146.27	146.8	150257.0
2021-08-02 08:00:00	AAPL	Stock	146.44	146.95	146.27	146.575	264076.0
2021-08-02 09:00:00	AAPL	Stock	146.58	146.95	145.25	145.95	10665600.0
2021-08-02 10:00:00	AAPL	Stock	145.93	146.25	145.41	146.0201	9483026.0
2021-08-02 11:00:00	AAPL	Stock	146.03	146.55	145.71	146.0244	6512558.0
2021-08-02 12:00:00	AAPL	Stock	146.0257	146.035	145.5589	145.75	5333032.0
2021-08-02 13:00:00	AAPL	Stock	145.75	146.2154	145.74	146.045	4643786.0
2021-08-02 14:00:00	AAPL	Stock	146.04	146.18	145.86	145.935	3246019.0
2021-08-02 15:00:00	AAPL	Stock	145.935	146.01	145.37	145.52	7641910.0
2021-08-02 16:00:00	AAPL	Stock	145.52	145.52	145.26	145.34	3759548.0
2021-08-02 17:00:00	AAPL	Stock	145.31	145.52	145.27	145.3	65583.0
2021-08-02 18:00:00	AAPL	Stock	145.31	145.41	145.3	145.4	27544.0
2021-08-02 19:00:00	AAPL	Stock	145.35	145.39	145.25	145.25	40340.0
2021-08-02 04:00:00	MSFT	Stock	286.7	286.98	286.5	286.53	1227.0
2021-08-02 05:00:00	MSFT	Stock	286.84	286.85	286.5	286.7	2314.0
2021-08-02 06:00:00	MSFT	Stock	286.55	286.55	286.28	286.28	1692.0
2021-08-02 07:00:00	MSFT	Stock	285.75	286.14	285.75	286.05	12851.0
2021-08-02 08:00:00	MSFT	Stock	286.0	286.12	285.51	285.83	18367.0
2021-08-02 09:00:00	MSFT	Stock	285.83	286.775	283.74	284.795	2164521.0
2021-08-02 10:00:00	MSFT	Stock	284.79	285.79	284.095	285.149	1733637.0
2021-08-02 11:00:00	MSFT	Stock	285.16	286.43	284.74	285.73	1455495.0
2021-08-02 12:00:00	MSFT	Stock	285.73	285.95	285.14	285.52	1171775.0
2021-08-02 13:00:00	MSFT	Stock	285.52	286.1399	285.45	285.74	898655.0
2021-08-02 14:00:00	MSFT	Stock	285.7425	285.91	285.46	285.79	658332.0
2021-08-02 15:00:00	MSFT	Stock	285.81	285.89	284.63	284.83	1790498.0
2021-08-02 16:00:00	MSFT	Stock	284.82	284.88	284.52	284.62	2091741.0
2021-08-02 17:00:00	MSFT	Stock	284.61	284.63	284.53	284.55	2273.0
2021-08-02 18:00:00	MSFT	Stock	284.6	284.8	284.6	284.65	3681.0
2021-08-02 19:00:00	MSFT	Stock	284.7399	284.7399	284.5	284.69	1935.0
2021-08-02 04:00:00	NVDA	Stock	19.551	19.619	19.498	19.584	89600.0
2021-08-02 05:00:00	NVDA	Stock	19.585	19.6	19.575	19.575	25580.0
2021-08-02 06:00:00	NVDA	Stock	19.572	19.63	19.562	19.562	204560.0
2021-08-02 07:00:00	NVDA	Stock	19.579	19.65	19.562	19.643	347390.0
2021-08-02 08:00:00	NVDA	Stock	19.5865	19.65	19.574	19.63	359510.0
2021-08-02 09:00:00	NVDA	Stock	19.629	19.75	19.361	19.56	26916340.0
2021-08-02 10:00:00	NVDA	Stock	19.558	19.8	19.421	19.784	27660280.0
2021-08-02 11:00:00	NVDA	Stock	19.788	19.961	19.716	19.7985	34017420.0
2021-08-02 12:00:00	NVDA	Stock	19.799	19.891	19.677	19.825	17986820.0
2021-08-02 13:00:00	NVDA	Stock	19.8253	19.917	19.821	19.853	12474220.0
2021-08-02 14:00:00	NVDA	Stock	19.854	19.957	19.8385	19.866	12831950.0
2021-08-02 15:00:00	NVDA	Stock	19.866	19.899	19.675	19.75	24259870.0
2021-08-02 16:00:00	NVDA	Stock	19.75	19.75	19.676	19.69	13113860.0
2021-08-02 17:00:00	NVDA	Stock	19.69	19.695	19.68	19.681	83970.0
2021-08-02 18:00:00	NVDA	Stock	19.689	19.691	19.682	19.684	429310.0
2021-08-02 19:00:00	NVDA	Stock	19.688	19.69	19.68	19.685	126840.0
2021-08-02 04:00:00	AMZN	Stock	167.91	167.91	167.6	167.85	10140.0
2021-08-02 05:00:00	AMZN	Stock	167.6	167.7625	167.6	167.6	19980.0

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

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