PREVIEW / stock_1hour / 2023-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-27.parquet
  size:    1.4 MB
  rows:    60,791
  symbols: 1,537

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
2023-07-27 04:00:00	AAPL	Stock	195.42	196.34	195.42	196.12	34135.0
2023-07-27 05:00:00	AAPL	Stock	196.19	196.25	196.01	196.24	19524.0
2023-07-27 06:00:00	AAPL	Stock	196.22	196.36	196.01	196.25	23852.0
2023-07-27 07:00:00	AAPL	Stock	196.19	196.44	196.0	196.2	74121.0
2023-07-27 08:00:00	AAPL	Stock	196.09	196.4201	194.5	196.08	223908.0
2023-07-27 09:00:00	AAPL	Stock	196.08	197.2	195.82	196.9118	5371859.0
2023-07-27 10:00:00	AAPL	Stock	196.92	197.035	195.45	195.5434	5132843.0
2023-07-27 11:00:00	AAPL	Stock	195.545	196.44	195.49	195.83	4215410.0
2023-07-27 12:00:00	AAPL	Stock	195.8471	196.43	195.83	196.075	2648124.0
2023-07-27 13:00:00	AAPL	Stock	196.08	196.26	194.47	194.676	4095678.0
2023-07-27 14:00:00	AAPL	Stock	194.67	194.87	192.92	192.96	5367481.0
2023-07-27 15:00:00	AAPL	Stock	192.94	193.66	192.55	193.23	6857731.0
2023-07-27 16:00:00	AAPL	Stock	193.24	193.43	193.1	193.3	3860474.0
2023-07-27 17:00:00	AAPL	Stock	193.33	193.38	193.27	193.375	24563.0
2023-07-27 18:00:00	AAPL	Stock	193.31	193.39	193.06	193.39	38519.0
2023-07-27 19:00:00	AAPL	Stock	193.4	193.55	193.33	193.4	18424.0
2023-07-27 04:00:00	MSFT	Stock	338.5	340.87	338.5	340.6	37340.0
2023-07-27 05:00:00	MSFT	Stock	340.7	341.0	340.33	340.33	20856.0
2023-07-27 06:00:00	MSFT	Stock	340.39	340.95	340.1	340.77	7249.0
2023-07-27 07:00:00	MSFT	Stock	340.6	340.81	339.89	340.25	79735.0
2023-07-27 08:00:00	MSFT	Stock	340.25	341.42	337.77	340.15	186760.0
2023-07-27 09:00:00	MSFT	Stock	340.19	341.33	338.0	338.035	4755098.0
2023-07-27 10:00:00	MSFT	Stock	338.045	338.25	334.28	335.3998	5089353.0
2023-07-27 11:00:00	MSFT	Stock	335.43	337.25	334.82	335.31	2629325.0
2023-07-27 12:00:00	MSFT	Stock	335.2995	336.5	335.1105	335.585	1775343.0
2023-07-27 13:00:00	MSFT	Stock	335.61	335.95	332.52	334.35	3238860.0
2023-07-27 14:00:00	MSFT	Stock	334.36	334.6	331.15	331.15	3053768.0
2023-07-27 15:00:00	MSFT	Stock	331.15	331.87	329.05	330.72	5130027.0
2023-07-27 16:00:00	MSFT	Stock	330.72	330.9	330.5	330.58	2902608.0
2023-07-27 17:00:00	MSFT	Stock	330.5399	330.56	330.26	330.5	21756.0
2023-07-27 18:00:00	MSFT	Stock	330.4	330.45	330.22	330.45	24842.0
2023-07-27 19:00:00	MSFT	Stock	330.5	330.5	330.0	330.2	27567.0
2023-07-27 04:00:00	NVDA	Stock	45.8	46.574	45.8	46.526	215550.0
2023-07-27 05:00:00	NVDA	Stock	46.514	46.547	46.48	46.501	82040.0
2023-07-27 06:00:00	NVDA	Stock	46.479	46.57	46.451	46.475	129860.0
2023-07-27 07:00:00	NVDA	Stock	46.48	46.5	46.21	46.45	885860.0
2023-07-27 08:00:00	NVDA	Stock	46.476	46.588	45.452	46.403	2879910.0
2023-07-27 09:00:00	NVDA	Stock	46.4	46.95	46.388	46.776	45975150.0
2023-07-27 10:00:00	NVDA	Stock	46.779	46.982	46.359	46.589	50404770.0
2023-07-27 11:00:00	NVDA	Stock	46.599	46.97	46.599	46.75	34764000.0
2023-07-27 12:00:00	NVDA	Stock	46.764	47.395	46.746	47.266	50182430.0
2023-07-27 13:00:00	NVDA	Stock	47.266	47.33	46.847	47.045	42646510.0
2023-07-27 14:00:00	NVDA	Stock	47.045	47.12	46.041	46.093	55162620.0
2023-07-27 15:00:00	NVDA	Stock	46.08	46.454	45.75	45.9	55184220.0
2023-07-27 16:00:00	NVDA	Stock	45.9	46.23	45.85	46.068	12014770.0
2023-07-27 17:00:00	NVDA	Stock	46.08	46.115	45.95	46.026	456020.0
2023-07-27 18:00:00	NVDA	Stock	46.03	46.168	46.011	46.165	337910.0
2023-07-27 19:00:00	NVDA	Stock	46.17	46.325	46.15	46.3	748260.0
2023-07-27 04:00:00	AMZN	Stock	129.32	130.19	129.18	130.13	32606.0
2023-07-27 05:00:00	AMZN	Stock	130.1	130.1	129.81	129.98	9691.0

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

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