PREVIEW / stock_1hour / 2021-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-16.parquet
  size:    1.4 MB
  rows:    65,529
  symbols: 2,812

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-16 04:00:00	AAPL	Stock	148.99	148.99	148.6	148.74	11925.0
2021-08-16 05:00:00	AAPL	Stock	148.67	148.72	148.51	148.69	3380.0
2021-08-16 06:00:00	AAPL	Stock	148.6	148.65	148.31	148.48	12253.0
2021-08-16 07:00:00	AAPL	Stock	148.52	148.66	148.32	148.48	55051.0
2021-08-16 08:00:00	AAPL	Stock	148.55	148.728	148.21	148.5	206349.0
2021-08-16 09:00:00	AAPL	Stock	148.49	150.59	148.07	148.64	19370035.0
2021-08-16 10:00:00	AAPL	Stock	148.64	148.8989	146.47	147.085	16420666.0
2021-08-16 11:00:00	AAPL	Stock	147.085	148.55	147.03	148.325	8364796.0
2021-08-16 12:00:00	AAPL	Stock	148.3293	149.73	148.274	149.495	8367122.0
2021-08-16 13:00:00	AAPL	Stock	149.5	150.68	149.19	150.5057	10850371.0
2021-08-16 14:00:00	AAPL	Stock	150.502	150.81	150.12	150.5	8374093.0
2021-08-16 15:00:00	AAPL	Stock	150.49	151.13	150.43	151.125	12885415.0
2021-08-16 16:00:00	AAPL	Stock	151.19	151.68	151.06	151.44	5824286.0
2021-08-16 17:00:00	AAPL	Stock	151.41	151.41	151.27	151.35	65977.0
2021-08-16 18:00:00	AAPL	Stock	151.36	151.36	151.25	151.29	62523.0
2021-08-16 19:00:00	AAPL	Stock	151.29	151.7	151.29	151.67	120709.0
2021-08-16 04:00:00	MSFT	Stock	292.9	292.9	292.25	292.25	2145.0
2021-08-16 05:00:00	MSFT	Stock	292.46	292.46	292.39	292.46	332.0
2021-08-16 06:00:00	MSFT	Stock	292.38	292.41	291.79	292.38	10347.0
2021-08-16 07:00:00	MSFT	Stock	292.25	292.6	292.08	292.15	16347.0
2021-08-16 08:00:00	MSFT	Stock	292.51	292.64	291.93	292.1	30932.0
2021-08-16 09:00:00	MSFT	Stock	292.2	294.59	292.13	293.15	2751876.0
2021-08-16 10:00:00	MSFT	Stock	293.15	293.29	290.02	290.57	3203001.0
2021-08-16 11:00:00	MSFT	Stock	290.5251	292.08	290.48	291.71	1542329.0
2021-08-16 12:00:00	MSFT	Stock	291.72	292.94	291.6301	292.765	1011711.0
2021-08-16 13:00:00	MSFT	Stock	292.8	293.7	292.44	293.32	1155985.0
2021-08-16 14:00:00	MSFT	Stock	293.33	293.615	293.08	293.25	1188293.0
2021-08-16 15:00:00	MSFT	Stock	293.26	294.82	293.23	294.66	2616648.0
2021-08-16 16:00:00	MSFT	Stock	294.6	294.8	294.5	294.65	3287110.0
2021-08-16 17:00:00	MSFT	Stock	294.65	294.65	294.45	294.45	4760.0
2021-08-16 18:00:00	MSFT	Stock	294.6	294.6	294.4	294.5	3451.0
2021-08-16 19:00:00	MSFT	Stock	294.41	294.6	294.4	294.59	2431.0
2021-08-16 04:00:00	NVDA	Stock	20.159	20.159	20.101	20.12	38000.0
2021-08-16 05:00:00	NVDA	Stock	20.101	20.12	20.1	20.103	11730.0
2021-08-16 06:00:00	NVDA	Stock	20.114	20.114	20.05	20.1	58350.0
2021-08-16 07:00:00	NVDA	Stock	20.081	20.125	20.057	20.075	207610.0
2021-08-16 08:00:00	NVDA	Stock	20.0892	20.13	20.055	20.104	394770.0
2021-08-16 09:00:00	NVDA	Stock	20.102	20.287	19.78	19.789	31921440.0
2021-08-16 10:00:00	NVDA	Stock	19.786	19.873	19.453	19.515	35803370.0
2021-08-16 11:00:00	NVDA	Stock	19.515	19.719	19.484	19.662	17915350.0
2021-08-16 12:00:00	NVDA	Stock	19.662	19.73	19.606	19.662	10726710.0
2021-08-16 13:00:00	NVDA	Stock	19.665	19.8522	19.66	19.813	15781470.0
2021-08-16 14:00:00	NVDA	Stock	19.814	19.918	19.81	19.887	11460860.0
2021-08-16 15:00:00	NVDA	Stock	19.886	19.96	19.861	19.956	22402380.0
2021-08-16 16:00:00	NVDA	Stock	19.956	19.961	19.916	19.935	20378550.0
2021-08-16 17:00:00	NVDA	Stock	19.93	19.969	19.925	19.95	141160.0
2021-08-16 18:00:00	NVDA	Stock	19.951	19.951	19.9	19.919	102470.0
2021-08-16 19:00:00	NVDA	Stock	19.905	19.935	19.883	19.915	101530.0
2021-08-16 05:00:00	AMZN	Stock	164.95	164.95	164.95	164.95	2000.0
2021-08-16 06:00:00	AMZN	Stock	164.5	164.5	164.25	164.325	17520.0

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

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