PREVIEW / stock_1hour / 2021-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-31.parquet
  size:    1.4 MB
  rows:    65,159
  symbols: 2,773

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-31 04:00:00	AAPL	Stock	153.28	153.7	153.15	153.44	37491.0
2021-08-31 05:00:00	AAPL	Stock	153.5	153.52	153.07	153.07	22174.0
2021-08-31 06:00:00	AAPL	Stock	153.06	153.14	152.57	152.65	47530.0
2021-08-31 07:00:00	AAPL	Stock	152.71	152.9	152.56	152.71	235369.0
2021-08-31 08:00:00	AAPL	Stock	152.8	152.89	152.25	152.64	362720.0
2021-08-31 09:00:00	AAPL	Stock	152.63	152.93	151.492	151.525	11676232.0
2021-08-31 10:00:00	AAPL	Stock	151.52	152.01	151.29	151.58	10761830.0
2021-08-31 11:00:00	AAPL	Stock	151.59	152.31	151.56	152.115	7278815.0
2021-08-31 12:00:00	AAPL	Stock	152.12	152.8	151.9824	152.665	6705365.0
2021-08-31 13:00:00	AAPL	Stock	152.6684	152.74	152.06	152.355	4702936.0
2021-08-31 14:00:00	AAPL	Stock	152.36	152.57	152.19	152.365	4363329.0
2021-08-31 15:00:00	AAPL	Stock	152.365	152.46	151.55	151.83	12492400.0
2021-08-31 16:00:00	AAPL	Stock	152.02	152.02	151.76	151.86	16168561.0
2021-08-31 17:00:00	AAPL	Stock	151.85	151.92	151.85	151.92	33929.0
2021-08-31 18:00:00	AAPL	Stock	151.92	151.92	151.86	151.87	28233.0
2021-08-31 19:00:00	AAPL	Stock	151.87	151.91	151.8	151.91	51604.0
2021-08-31 04:00:00	MSFT	Stock	304.72	305.2	304.72	304.9	6895.0
2021-08-31 05:00:00	MSFT	Stock	304.89	304.89	304.39	304.39	3544.0
2021-08-31 06:00:00	MSFT	Stock	304.34	304.43	303.2	303.59	11486.0
2021-08-31 07:00:00	MSFT	Stock	303.55	304.4	303.45	303.82	21093.0
2021-08-31 08:00:00	MSFT	Stock	304.0	304.348	303.1	303.8	21355.0
2021-08-31 09:00:00	MSFT	Stock	303.8	304.94	302.3345	302.73	1866000.0
2021-08-31 10:00:00	MSFT	Stock	302.705	303.7668	302.445	303.06	1439194.0
2021-08-31 11:00:00	MSFT	Stock	303.07	304.37	302.76	303.77	1187851.0
2021-08-31 12:00:00	MSFT	Stock	303.77	304.05	303.46	303.61	906594.0
2021-08-31 13:00:00	MSFT	Stock	303.61	303.67	302.8099	303.1899	994629.0
2021-08-31 14:00:00	MSFT	Stock	303.185	303.425	302.91	303.225	1071373.0
2021-08-31 15:00:00	MSFT	Stock	303.22	303.48	301.5	301.92	4058401.0
2021-08-31 16:00:00	MSFT	Stock	301.88	302.19	301.8422	302.05	7155100.0
2021-08-31 17:00:00	MSFT	Stock	301.88	302.1	301.88	302.06	18441.0
2021-08-31 18:00:00	MSFT	Stock	302.15	302.15	302.02	302.0201	25213.0
2021-08-31 19:00:00	MSFT	Stock	302.07	302.18	301.99	302.0	3026.0
2021-08-31 04:00:00	NVDA	Stock	22.88	22.88	22.764	22.834	70230.0
2021-08-31 05:00:00	NVDA	Stock	22.833	22.834	22.74	22.74	28480.0
2021-08-31 06:00:00	NVDA	Stock	22.735	22.76	22.648	22.666	66470.0
2021-08-31 07:00:00	NVDA	Stock	22.64	22.689	22.585	22.594	279120.0
2021-08-31 08:00:00	NVDA	Stock	22.65	22.7	22.526	22.567	532790.0
2021-08-31 09:00:00	NVDA	Stock	22.5839	22.695	22.201	22.254	32298110.0
2021-08-31 10:00:00	NVDA	Stock	22.2535	22.319	22.12	22.284	36015290.0
2021-08-31 11:00:00	NVDA	Stock	22.2835	22.535	22.257	22.5	30629020.0
2021-08-31 12:00:00	NVDA	Stock	22.5	22.502	22.37	22.4575	19675540.0
2021-08-31 13:00:00	NVDA	Stock	22.458	22.504	22.408	22.481	10507640.0
2021-08-31 14:00:00	NVDA	Stock	22.483	22.529	22.45	22.51	8660630.0
2021-08-31 15:00:00	NVDA	Stock	22.507	22.526	22.371	22.378	25719140.0
2021-08-31 16:00:00	NVDA	Stock	22.385	22.43	22.355	22.398	29388860.0
2021-08-31 17:00:00	NVDA	Stock	22.4	22.4	22.38	22.398	61200.0
2021-08-31 18:00:00	NVDA	Stock	22.398	22.398	22.38	22.386	83340.0
2021-08-31 19:00:00	NVDA	Stock	22.385	22.397	22.38	22.395	78810.0
2021-08-31 07:00:00	AMZN	Stock	170.6	170.95	170.6	170.75	39360.0
2021-08-31 08:00:00	AMZN	Stock	170.9	170.9	170.401	170.525	61040.0

> showing 50 of 65,159 rows — these rows as CSV

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