PREVIEW / stock_1hour / 2024-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-11-07.parquet
  size:    1.4 MB
  rows:    62,717
  symbols: 716

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
2024-11-07 04:00:00	AAPL	Stock	223.14	223.51	222.82	223.32	10562.0
2024-11-07 05:00:00	AAPL	Stock	223.34	223.34	223.1	223.15	6633.0
2024-11-07 06:00:00	AAPL	Stock	223.1	223.13	222.87	223.0	8623.0
2024-11-07 07:00:00	AAPL	Stock	222.94	223.55	222.94	223.42	31791.0
2024-11-07 08:00:00	AAPL	Stock	223.08	223.9392	222.7814	223.78	132208.0
2024-11-07 09:00:00	AAPL	Stock	223.75	226.55	223.72	226.3	5108111.0
2024-11-07 10:00:00	AAPL	Stock	226.3	226.35	225.35	226.23	3539716.0
2024-11-07 11:00:00	AAPL	Stock	226.23	227.1	225.78	227.07	2516285.0
2024-11-07 12:00:00	AAPL	Stock	227.062	227.49	226.76	227.2	1931603.0
2024-11-07 13:00:00	AAPL	Stock	227.205	227.26	226.745	227.0989	1637235.0
2024-11-07 14:00:00	AAPL	Stock	227.0999	227.51	226.79	227.505	1869798.0
2024-11-07 15:00:00	AAPL	Stock	227.5	227.875	226.75	227.69	5309453.0
2024-11-07 16:00:00	AAPL	Stock	227.4917	227.95	227.39	227.77	8381196.0
2024-11-07 17:00:00	AAPL	Stock	227.71	227.75	227.48	227.6	388381.0
2024-11-07 18:00:00	AAPL	Stock	227.5	227.72	227.45	227.4801	12827.0
2024-11-07 19:00:00	AAPL	Stock	227.52	227.7198	227.5	227.6	13143.0
2024-11-07 04:00:00	MSFT	Stock	420.06	420.95	420.06	420.65	5485.0
2024-11-07 05:00:00	MSFT	Stock	420.75	421.3	420.7	421.3	5894.0
2024-11-07 06:00:00	MSFT	Stock	421.25	421.25	420.75	421.0	2434.0
2024-11-07 07:00:00	MSFT	Stock	421.0	421.24	420.76	421.22	13085.0
2024-11-07 08:00:00	MSFT	Stock	420.89	421.75	419.55	421.52	39529.0
2024-11-07 09:00:00	MSFT	Stock	421.51	422.45	419.88	421.895	1868806.0
2024-11-07 10:00:00	MSFT	Stock	421.99	424.43	421.64	423.73	1506565.0
2024-11-07 11:00:00	MSFT	Stock	423.74	426.42	423.67	425.54	1290629.0
2024-11-07 12:00:00	MSFT	Stock	425.5799	425.59	423.77	424.355	723043.0
2024-11-07 13:00:00	MSFT	Stock	424.37	424.9	423.81	424.5	600026.0
2024-11-07 14:00:00	MSFT	Stock	424.45	426.38	424.2033	426.31	823903.0
2024-11-07 15:00:00	MSFT	Stock	426.305	426.85	424.6	425.51	1868260.0
2024-11-07 16:00:00	MSFT	Stock	425.43	426.77	425.1	425.6	4261542.0
2024-11-07 17:00:00	MSFT	Stock	425.6	425.79	425.0018	425.75	208299.0
2024-11-07 18:00:00	MSFT	Stock	425.43	425.79	425.12	425.33	8078.0
2024-11-07 19:00:00	MSFT	Stock	425.43	425.8	425.43	425.6501	9214.0
2024-11-07 04:00:00	NVDA	Stock	145.14	145.82	145.01	145.63	381009.0
2024-11-07 05:00:00	NVDA	Stock	145.64	145.65	144.82	144.98	267722.0
2024-11-07 06:00:00	NVDA	Stock	144.95	145.4	144.6	145.31	370289.0
2024-11-07 07:00:00	NVDA	Stock	145.33	145.75	145.28	145.73	644156.0
2024-11-07 08:00:00	NVDA	Stock	145.28	146.29	144.6336	146.06	2199356.0
2024-11-07 09:00:00	NVDA	Stock	146.0501	148.205	146.0	148.155	31472477.0
2024-11-07 10:00:00	NVDA	Stock	148.155	148.75	147.75	147.985	29943531.0
2024-11-07 11:00:00	NVDA	Stock	147.99	148.3	147.29	148.2218	17907861.0
2024-11-07 12:00:00	NVDA	Stock	148.23	148.24	147.71	148.225	10351991.0
2024-11-07 13:00:00	NVDA	Stock	148.22	148.25	147.45	148.02	11802970.0
2024-11-07 14:00:00	NVDA	Stock	148.02	148.5	147.56	148.4646	18158375.0
2024-11-07 15:00:00	NVDA	Stock	148.47	148.93	148.06	148.89	21783222.0
2024-11-07 16:00:00	NVDA	Stock	148.89	149.23	148.55	148.72	23301110.0
2024-11-07 17:00:00	NVDA	Stock	148.729	148.88	148.69	148.8	985595.0
2024-11-07 18:00:00	NVDA	Stock	148.8	149.1	148.7	149.02	607888.0
2024-11-07 19:00:00	NVDA	Stock	149.0	149.5	148.98	149.45	585294.0
2024-11-07 04:00:00	AMZN	Stock	206.0	206.2	205.59	205.94	31617.0
2024-11-07 05:00:00	AMZN	Stock	205.96	206.33	205.94	206.07	10533.0

> showing 50 of 62,717 rows — these rows as CSV

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