PREVIEW / stock_1hour / 2022-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-01.parquet
  size:    1.4 MB
  rows:    64,028
  symbols: 2,494

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-04-01 04:00:00	AAPL	Stock	175.25	175.88	175.1	175.26	24417.0
2022-04-01 05:00:00	AAPL	Stock	175.32	175.38	175.04	175.31	13692.0
2022-04-01 06:00:00	AAPL	Stock	175.43	175.72	175.33	175.5	90057.0
2022-04-01 07:00:00	AAPL	Stock	175.54	175.6	174.69	174.82	162983.0
2022-04-01 08:00:00	AAPL	Stock	175.49	175.52	173.35	173.6	736016.0
2022-04-01 09:00:00	AAPL	Stock	173.65	174.88	172.6	172.84	10190215.0
2022-04-01 10:00:00	AAPL	Stock	172.83	174.17	172.51	173.9	10215837.0
2022-04-01 11:00:00	AAPL	Stock	173.9	174.0199	171.94	172.2	8070211.0
2022-04-01 12:00:00	AAPL	Stock	172.19	172.88	172.07	172.2721	5530501.0
2022-04-01 13:00:00	AAPL	Stock	172.27	172.8	172.1	172.5399	5075391.0
2022-04-01 14:00:00	AAPL	Stock	172.53	173.74	172.46	173.2	6775532.0
2022-04-01 15:00:00	AAPL	Stock	173.2	174.645	172.77	174.26	12424095.0
2022-04-01 16:00:00	AAPL	Stock	174.31	174.41	173.92	174.1	7563247.0
2022-04-01 17:00:00	AAPL	Stock	174.1	174.31	173.9	174.04	53056.0
2022-04-01 18:00:00	AAPL	Stock	174.1	174.11	174.0	174.1	8929.0
2022-04-01 19:00:00	AAPL	Stock	174.14	174.15	173.92	174.0	32074.0
2022-04-01 04:00:00	MSFT	Stock	310.37	310.5	309.8	309.92	2250.0
2022-04-01 05:00:00	MSFT	Stock	309.66	310.1	309.2	310.01	3507.0
2022-04-01 06:00:00	MSFT	Stock	310.03	310.28	310.03	310.11	2047.0
2022-04-01 07:00:00	MSFT	Stock	310.3	310.6	310.2	310.6	6618.0
2022-04-01 08:00:00	MSFT	Stock	310.2	310.6	307.54	309.7	85560.0
2022-04-01 09:00:00	MSFT	Stock	309.64	310.13	306.82	306.945	2494848.0
2022-04-01 10:00:00	MSFT	Stock	306.94	309.45	306.272	308.75	2474099.0
2022-04-01 11:00:00	MSFT	Stock	308.73	308.99	305.61	305.8615	2041667.0
2022-04-01 12:00:00	MSFT	Stock	305.83	306.82	305.54	306.0406	1435915.0
2022-04-01 13:00:00	MSFT	Stock	306.06	307.34	306.03	306.92	1376608.0
2022-04-01 14:00:00	MSFT	Stock	306.915	308.48	306.64	307.5	1543402.0
2022-04-01 15:00:00	MSFT	Stock	307.44	309.62	305.851	309.42	4159818.0
2022-04-01 16:00:00	MSFT	Stock	309.42	309.75	309.08	309.4	3950777.0
2022-04-01 17:00:00	MSFT	Stock	309.48	309.6	309.3409	309.51	12483.0
2022-04-01 18:00:00	MSFT	Stock	309.55	309.69	309.51	309.55	8176.0
2022-04-01 19:00:00	MSFT	Stock	309.51	309.65	309.4	309.46	13531.0
2022-04-01 04:00:00	NVDA	Stock	27.518	27.565	27.45	27.485	113110.0
2022-04-01 05:00:00	NVDA	Stock	27.452	27.599	27.452	27.599	53410.0
2022-04-01 06:00:00	NVDA	Stock	27.6	27.66	27.51	27.51	69670.0
2022-04-01 07:00:00	NVDA	Stock	27.5	27.57	27.455	27.559	268410.0
2022-04-01 08:00:00	NVDA	Stock	27.522	27.595	27.304	27.41	1112050.0
2022-04-01 09:00:00	NVDA	Stock	27.42	27.496	26.627	26.819	52576160.0
2022-04-01 10:00:00	NVDA	Stock	26.8125	27.0084	26.58	26.925	71582230.0
2022-04-01 11:00:00	NVDA	Stock	26.93	27.035	26.501	26.532	51398650.0
2022-04-01 12:00:00	NVDA	Stock	26.533	26.65	26.377	26.388	42575880.0
2022-04-01 13:00:00	NVDA	Stock	26.386	26.52	26.267	26.355	37925900.0
2022-04-01 14:00:00	NVDA	Stock	26.351	26.597	26.285	26.5115	42940910.0
2022-04-01 15:00:00	NVDA	Stock	26.507	26.725	26.295	26.715	62522650.0
2022-04-01 16:00:00	NVDA	Stock	26.712	26.732	26.615	26.653	23731030.0
2022-04-01 17:00:00	NVDA	Stock	26.651	26.675	26.631	26.661	391140.0
2022-04-01 18:00:00	NVDA	Stock	26.665	26.665	26.618	26.62	376480.0
2022-04-01 19:00:00	NVDA	Stock	26.621	26.669	26.6	26.669	188660.0
2022-04-01 07:00:00	AMZN	Stock	164.05	164.05	163.95	164.05	14000.0
2022-04-01 08:00:00	AMZN	Stock	164.05	164.245	163.6122	163.751	63540.0

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

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