PREVIEW / stock_1hour / 2022-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-12.parquet
  size:    1.3 MB
  rows:    60,479
  symbols: 2,283

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
2022-07-12 04:00:00	AAPL	Stock	143.98	144.2	143.42	144.06	20208.0
2022-07-12 05:00:00	AAPL	Stock	144.01	144.15	143.88	144.0	9162.0
2022-07-12 06:00:00	AAPL	Stock	144.03	144.7	144.03	144.44	70307.0
2022-07-12 07:00:00	AAPL	Stock	144.45	145.59	144.34	144.95	58273.0
2022-07-12 08:00:00	AAPL	Stock	144.61	145.56	143.52	145.33	232224.0
2022-07-12 09:00:00	AAPL	Stock	145.32	147.99	145.11	146.17	10775790.0
2022-07-12 10:00:00	AAPL	Stock	146.18	147.66	145.5601	146.985	11251818.0
2022-07-12 11:00:00	AAPL	Stock	146.99	148.175	146.8406	147.8001	7307292.0
2022-07-12 12:00:00	AAPL	Stock	147.8	148.45	147.33	148.0432	5739682.0
2022-07-12 13:00:00	AAPL	Stock	148.04	148.34	147.3576	148.15	5197172.0
2022-07-12 14:00:00	AAPL	Stock	148.15	148.22	146.72	146.77	5009461.0
2022-07-12 15:00:00	AAPL	Stock	146.765	146.77	145.05	145.86	13593812.0
2022-07-12 16:00:00	AAPL	Stock	145.88	146.0	145.7	145.85	7772216.0
2022-07-12 17:00:00	AAPL	Stock	145.82	145.86	145.7	145.72	30849.0
2022-07-12 18:00:00	AAPL	Stock	145.75	145.85	145.72	145.79	39854.0
2022-07-12 19:00:00	AAPL	Stock	145.78	145.85	145.62	145.8	33162.0
2022-07-12 04:00:00	MSFT	Stock	262.3	262.83	261.9	262.78	1974.0
2022-07-12 05:00:00	MSFT	Stock	262.9	263.3	262.9	263.09	1535.0
2022-07-12 06:00:00	MSFT	Stock	263.24	264.24	263.21	263.36	4071.0
2022-07-12 07:00:00	MSFT	Stock	263.21	266.03	263.13	264.51	18197.0
2022-07-12 08:00:00	MSFT	Stock	264.7468	265.48	263.14	265.0	23140.0
2022-07-12 09:00:00	MSFT	Stock	265.0	266.15	258.75	258.76	3006730.0
2022-07-12 10:00:00	MSFT	Stock	258.75	258.75	255.93	257.29	4826029.0
2022-07-12 11:00:00	MSFT	Stock	257.3	258.08	256.58	257.02	2382627.0
2022-07-12 12:00:00	MSFT	Stock	257.01	257.98	256.81	257.7099	1700102.0
2022-07-12 13:00:00	MSFT	Stock	257.7	258.28	256.42	256.59	1596169.0
2022-07-12 14:00:00	MSFT	Stock	256.6	256.63	254.71	254.7501	2828104.0
2022-07-12 15:00:00	MSFT	Stock	254.765	254.765	252.04	253.67	6767178.0
2022-07-12 16:00:00	MSFT	Stock	253.675	254.48	253.65	254.03	4086578.0
2022-07-12 17:00:00	MSFT	Stock	254.0	254.25	253.91	253.91	15639.0
2022-07-12 18:00:00	MSFT	Stock	254.02	254.14	253.81	253.95	8587.0
2022-07-12 19:00:00	MSFT	Stock	253.86	254.02	253.67	254.0	8007.0
2022-07-12 04:00:00	NVDA	Stock	15.009	15.009	14.9	14.989	64810.0
2022-07-12 05:00:00	NVDA	Stock	14.962	14.98	14.906	14.92	96200.0
2022-07-12 06:00:00	NVDA	Stock	14.936	15.011	14.926	14.981	206400.0
2022-07-12 07:00:00	NVDA	Stock	14.974	15.139	14.969	15.095	364780.0
2022-07-12 08:00:00	NVDA	Stock	15.017	15.2117	14.88	15.18	1067850.0
2022-07-12 09:00:00	NVDA	Stock	15.18	15.431	15.021	15.021	59055080.0
2022-07-12 10:00:00	NVDA	Stock	15.0215	15.1545	14.877	15.1	71691000.0
2022-07-12 11:00:00	NVDA	Stock	15.103	15.332	15.065	15.314	51674630.0
2022-07-12 12:00:00	NVDA	Stock	15.313	15.355	15.207	15.2389	31290430.0
2022-07-12 13:00:00	NVDA	Stock	15.2373	15.3	15.148	15.247	29102600.0
2022-07-12 14:00:00	NVDA	Stock	15.247	15.282	15.15	15.1552	27822930.0
2022-07-12 15:00:00	NVDA	Stock	15.155	15.155	14.982	15.0825	62289040.0
2022-07-12 16:00:00	NVDA	Stock	15.082	15.121	15.082	15.086	18755280.0
2022-07-12 17:00:00	NVDA	Stock	15.088	15.113	15.086	15.086	323130.0
2022-07-12 18:00:00	NVDA	Stock	15.09	15.109	15.077	15.098	223850.0
2022-07-12 19:00:00	NVDA	Stock	15.1	15.109	15.082	15.1	216110.0
2022-07-12 04:00:00	AMZN	Stock	111.39	111.79	110.54	111.0	24994.0
2022-07-12 05:00:00	AMZN	Stock	110.92	111.11	110.76	110.84	8752.0

> showing 50 of 60,479 rows — these rows as CSV

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