PREVIEW / stock_1hour / 2021-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-05.parquet
  size:    1.4 MB
  rows:    64,771
  symbols: 2,677

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-01-05 04:00:00	AAPL	Stock	130.07	130.2	129.68	130.02	45710.0
2021-01-05 05:00:00	AAPL	Stock	130.18	130.26	129.97	130.2	29163.0
2021-01-05 06:00:00	AAPL	Stock	130.2	130.3	129.5	129.56	55396.0
2021-01-05 07:00:00	AAPL	Stock	129.69	129.8	128.85	129.45	388250.0
2021-01-05 08:00:00	AAPL	Stock	129.53	129.83	128.35	128.4	665408.0
2021-01-05 09:00:00	AAPL	Stock	128.4	131.48	128.31	131.31	13903790.0
2021-01-05 10:00:00	AAPL	Stock	131.32	131.74	130.431	130.52	14480604.0
2021-01-05 11:00:00	AAPL	Stock	130.535	130.69	129.93	130.29	10408356.0
2021-01-05 12:00:00	AAPL	Stock	130.29	130.34	129.84	130.145	7643264.0
2021-01-05 13:00:00	AAPL	Stock	130.15	130.63	129.94	130.625	5809738.0
2021-01-05 14:00:00	AAPL	Stock	130.63	131.405	130.595	130.95	8810381.0
2021-01-05 15:00:00	AAPL	Stock	130.96	131.45	130.76	130.95	11537779.0
2021-01-05 16:00:00	AAPL	Stock	131.01	131.32	130.81	130.93	10316022.0
2021-01-05 17:00:00	AAPL	Stock	130.93	130.93	130.85	130.9	72236.0
2021-01-05 18:00:00	AAPL	Stock	130.9	131.0	130.7	130.75	116428.0
2021-01-05 19:00:00	AAPL	Stock	130.75	131.4	130.6	130.65	230640.0
2021-01-05 04:00:00	MSFT	Stock	218.5	218.5	217.76	218.0	17384.0
2021-01-05 05:00:00	MSFT	Stock	218.0	218.1	217.72	217.9	4639.0
2021-01-05 06:00:00	MSFT	Stock	218.0	218.19	217.05	217.41	11850.0
2021-01-05 07:00:00	MSFT	Stock	217.67	217.67	217.1	217.65	14911.0
2021-01-05 08:00:00	MSFT	Stock	217.304	217.7	216.15	216.26	39762.0
2021-01-05 09:00:00	MSFT	Stock	216.26	218.52	215.7	217.74	2747023.0
2021-01-05 10:00:00	MSFT	Stock	217.74	218.1	216.2	216.78	2222077.0
2021-01-05 11:00:00	MSFT	Stock	216.78	217.74	215.98	217.384	2035759.0
2021-01-05 12:00:00	MSFT	Stock	217.36	217.49	216.09	216.445	1389690.0
2021-01-05 13:00:00	MSFT	Stock	216.45	216.92	216.1	216.815	1082134.0
2021-01-05 14:00:00	MSFT	Stock	216.81	218.07	216.81	217.64	1610137.0
2021-01-05 15:00:00	MSFT	Stock	217.65	218.39	216.98	218.01	2506719.0
2021-01-05 16:00:00	MSFT	Stock	218.0	218.01	217.81	217.9	5133277.0
2021-01-05 17:00:00	MSFT	Stock	218.0	218.23	217.7	217.7	5199.0
2021-01-05 18:00:00	MSFT	Stock	217.74	217.88	217.7	217.7	3312.0
2021-01-05 19:00:00	MSFT	Stock	217.51	218.37	217.1	217.57	13039.0
2021-01-05 04:00:00	NVDA	Stock	13.1475	13.1738	13.1475	13.1738	12720.0
2021-01-05 05:00:00	NVDA	Stock	13.1628	13.1628	13.1625	13.1625	39800.0
2021-01-05 06:00:00	NVDA	Stock	13.165	13.165	13.1498	13.1498	70480.0
2021-01-05 07:00:00	NVDA	Stock	13.1262	13.1393	13.086	13.1125	291360.0
2021-01-05 08:00:00	NVDA	Stock	13.1325	13.175	13.025	13.025	1298720.0
2021-01-05 09:00:00	NVDA	Stock	13.0128	13.3963	13.009	13.3542	50356480.0
2021-01-05 10:00:00	NVDA	Stock	13.3565	13.4435	13.2955	13.3155	50663320.0
2021-01-05 11:00:00	NVDA	Stock	13.3218	13.3665	13.254	13.3084	28218760.0
2021-01-05 12:00:00	NVDA	Stock	13.3112	13.315	13.1938	13.2439	19460120.0
2021-01-05 13:00:00	NVDA	Stock	13.2448	13.3455	13.2405	13.338	16828680.0
2021-01-05 14:00:00	NVDA	Stock	13.3408	13.3866	13.333	13.3432	19391360.0
2021-01-05 15:00:00	NVDA	Stock	13.3512	13.4238	13.3295	13.406	36051120.0
2021-01-05 16:00:00	NVDA	Stock	13.4115	13.425	13.4021	13.4105	44833160.0
2021-01-05 17:00:00	NVDA	Stock	13.4102	13.425	13.4048	13.4162	2585280.0
2021-01-05 18:00:00	NVDA	Stock	13.4202	13.4202	13.404	13.404	39880.0
2021-01-05 19:00:00	NVDA	Stock	13.4188	13.4315	13.3812	13.3812	990760.0
2021-01-05 04:00:00	AMZN	Stock	159.4775	159.4775	159.4775	159.4775	3360.0
2021-01-05 06:00:00	AMZN	Stock	159.5245	159.5245	159.208	159.208	4680.0

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

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