PREVIEW / stock_1hour / 2022-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-25.parquet
  size:    1.4 MB
  rows:    65,517
  symbols: 2,645

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-01-25 04:00:00	AAPL	Stock	159.75	160.37	158.2	160.0	59259.0
2022-01-25 05:00:00	AAPL	Stock	159.98	160.0	158.6	158.99	32408.0
2022-01-25 06:00:00	AAPL	Stock	158.83	159.46	157.84	158.6	47835.0
2022-01-25 07:00:00	AAPL	Stock	158.59	158.8	157.72	158.27	156893.0
2022-01-25 08:00:00	AAPL	Stock	158.35	158.86	157.25	158.61	607038.0
2022-01-25 09:00:00	AAPL	Stock	158.57	161.6976	157.27	157.62	10014776.0
2022-01-25 10:00:00	AAPL	Stock	157.64	159.79	157.02	158.41	13052823.0
2022-01-25 11:00:00	AAPL	Stock	158.41	158.95	157.22	157.34	9776940.0
2022-01-25 12:00:00	AAPL	Stock	157.35	158.96	157.135	158.35	8364890.0
2022-01-25 13:00:00	AAPL	Stock	158.36	160.531	157.92	160.4927	8249449.0
2022-01-25 14:00:00	AAPL	Stock	160.49	162.76	159.83	162.475	13048696.0
2022-01-25 15:00:00	AAPL	Stock	162.47	162.555	159.39	159.88	16212035.0
2022-01-25 16:00:00	AAPL	Stock	159.89	160.37	157.01	157.42	10921014.0
2022-01-25 17:00:00	AAPL	Stock	157.49	157.95	157.3	157.95	125155.0
2022-01-25 18:00:00	AAPL	Stock	157.98	160.72	157.98	159.98	484615.0
2022-01-25 19:00:00	AAPL	Stock	160.0	160.36	159.51	160.03	146279.0
2022-01-25 04:00:00	MSFT	Stock	292.6	295.12	291.89	295.0	42842.0
2022-01-25 05:00:00	MSFT	Stock	295.1	295.82	293.15	293.62	21033.0
2022-01-25 06:00:00	MSFT	Stock	293.6	294.2	292.11	293.34	18093.0
2022-01-25 07:00:00	MSFT	Stock	293.51	294.45	291.65	292.78	38357.0
2022-01-25 08:00:00	MSFT	Stock	292.72	293.9699	290.39	292.5	110319.0
2022-01-25 09:00:00	MSFT	Stock	292.4	293.73	286.8905	288.13	4851001.0
2022-01-25 10:00:00	MSFT	Stock	288.12	290.655	287.05	288.01	5451345.0
2022-01-25 11:00:00	MSFT	Stock	288.01	288.51	285.17	285.74	5484382.0
2022-01-25 12:00:00	MSFT	Stock	285.75	288.72	285.4	288.32	4025966.0
2022-01-25 13:00:00	MSFT	Stock	288.35	292.3299	287.24	292.26	4846476.0
2022-01-25 14:00:00	MSFT	Stock	292.268	294.99	291.22	294.78	4989071.0
2022-01-25 15:00:00	MSFT	Stock	294.7872	294.85	287.76	288.41	8790799.0
2022-01-25 16:00:00	MSFT	Stock	288.49	295.07	269.0	274.41	9676465.0
2022-01-25 17:00:00	MSFT	Stock	274.41	288.49	273.08	276.1	989403.0
2022-01-25 18:00:00	MSFT	Stock	276.25	299.75	274.0	293.75	2900981.0
2022-01-25 19:00:00	MSFT	Stock	293.6	294.11	290.5	292.0	573909.0
2022-01-25 04:00:00	NVDA	Stock	22.5	23.072	22.451	22.904	340470.0
2022-01-25 05:00:00	NVDA	Stock	22.94	22.971	22.569	22.6	226960.0
2022-01-25 06:00:00	NVDA	Stock	22.61	22.82	22.501	22.705	232190.0
2022-01-25 07:00:00	NVDA	Stock	22.64	22.72	22.382	22.47	1221960.0
2022-01-25 08:00:00	NVDA	Stock	22.7	22.74	22.305	22.5	1973800.0
2022-01-25 09:00:00	NVDA	Stock	22.5	22.803	22.1115	22.389	78155620.0
2022-01-25 10:00:00	NVDA	Stock	22.4	22.88	22.07	22.497	94582100.0
2022-01-25 11:00:00	NVDA	Stock	22.492	22.656	22.085	22.165	47752800.0
2022-01-25 12:00:00	NVDA	Stock	22.168	22.39	22.0	22.1655	49139320.0
2022-01-25 13:00:00	NVDA	Stock	22.164	22.69	22.04	22.667	49673550.0
2022-01-25 14:00:00	NVDA	Stock	22.671	22.943	22.469	22.887	53430520.0
2022-01-25 15:00:00	NVDA	Stock	22.886	22.892	22.225	22.324	67914610.0
2022-01-25 16:00:00	NVDA	Stock	22.324	22.404	21.502	21.572	31638730.0
2022-01-25 17:00:00	NVDA	Stock	21.572	21.75	21.55	21.697	1060260.0
2022-01-25 18:00:00	NVDA	Stock	21.725	22.701	21.717	22.44	3206970.0
2022-01-25 19:00:00	NVDA	Stock	22.46	22.488	22.214	22.351	835740.0
2022-01-25 04:00:00	AMZN	Stock	141.9	141.9	141.9	141.9	4000.0
2022-01-25 06:00:00	AMZN	Stock	141.9035	141.9035	141.9035	141.9035	15600.0

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

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