PREVIEW / stock_1hour / 2023-03-13

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-13.parquet
  size:    1.4 MB
  rows:    63,859
  symbols: 1,763

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-03-13 04:00:00	AAPL	Stock	150.55	150.73	149.16	149.16	62027.0
2023-03-13 05:00:00	AAPL	Stock	149.11	149.9	148.35	149.03	52533.0
2023-03-13 06:00:00	AAPL	Stock	149.0	150.0	148.81	149.79	34828.0
2023-03-13 07:00:00	AAPL	Stock	149.52	150.1	148.94	149.3	91097.0
2023-03-13 08:00:00	AAPL	Stock	149.8	150.95	146.28	147.63	422964.0
2023-03-13 09:00:00	AAPL	Stock	147.622	151.14	146.8	150.74	9233766.0
2023-03-13 10:00:00	AAPL	Stock	150.74	151.87	150.19	151.5611	12704165.0
2023-03-13 11:00:00	AAPL	Stock	151.565	153.14	151.3401	152.61	11148372.0
2023-03-13 12:00:00	AAPL	Stock	152.61	153.1	151.47	151.8	7435553.0
2023-03-13 13:00:00	AAPL	Stock	151.8	152.04	150.88	151.9044	6305605.0
2023-03-13 14:00:00	AAPL	Stock	151.92	152.7	151.73	152.1144	6464441.0
2023-03-13 15:00:00	AAPL	Stock	152.11	152.35	150.35	150.46	10595335.0
2023-03-13 16:00:00	AAPL	Stock	150.45	150.7	150.13	150.64	8528169.0
2023-03-13 17:00:00	AAPL	Stock	150.52	150.67	150.44	150.61	24163.0
2023-03-13 18:00:00	AAPL	Stock	150.64	150.94	150.47	150.94	40012.0
2023-03-13 19:00:00	AAPL	Stock	150.94	150.96	150.65	150.9	24122.0
2023-03-13 04:00:00	MSFT	Stock	251.5	252.5	250.1	250.1	33217.0
2023-03-13 05:00:00	MSFT	Stock	250.39	251.43	248.67	249.84	17079.0
2023-03-13 06:00:00	MSFT	Stock	250.32	252.81	248.5	252.46	27800.0
2023-03-13 07:00:00	MSFT	Stock	251.83	252.99	250.41	251.74	29806.0
2023-03-13 08:00:00	MSFT	Stock	252.12	253.56	245.0	247.99	69659.0
2023-03-13 09:00:00	MSFT	Stock	248.06	251.13	245.73	250.4	2857717.0
2023-03-13 10:00:00	MSFT	Stock	250.39	254.34	249.81	254.03	3678400.0
2023-03-13 11:00:00	MSFT	Stock	254.06	256.46	253.71	255.85	3351132.0
2023-03-13 12:00:00	MSFT	Stock	255.88	256.79	254.72	255.255	2249950.0
2023-03-13 13:00:00	MSFT	Stock	255.22	256.06	254.28	255.915	1673926.0
2023-03-13 14:00:00	MSFT	Stock	255.9	257.91	255.78	256.71	2276428.0
2023-03-13 15:00:00	MSFT	Stock	256.7031	257.12	253.78	253.92	4304474.0
2023-03-13 16:00:00	MSFT	Stock	253.92	255.69	253.92	254.31	4372975.0
2023-03-13 17:00:00	MSFT	Stock	254.1733	254.21	253.9	254.2	18566.0
2023-03-13 18:00:00	MSFT	Stock	254.2	254.97	253.92	254.97	15670.0
2023-03-13 19:00:00	MSFT	Stock	254.98	255.2	254.25	255.19	23367.0
2023-03-13 04:00:00	NVDA	Stock	23.208	23.539	23.208	23.3	469010.0
2023-03-13 05:00:00	NVDA	Stock	23.27	23.297	22.997	23.01	735700.0
2023-03-13 06:00:00	NVDA	Stock	23.01	23.114	22.861	23.111	406350.0
2023-03-13 07:00:00	NVDA	Stock	23.059	23.241	23.059	23.16	835630.0
2023-03-13 08:00:00	NVDA	Stock	23.0962	23.673	22.375	22.63	2914640.0
2023-03-13 09:00:00	NVDA	Stock	22.64	22.961	22.297	22.813	61026310.0
2023-03-13 10:00:00	NVDA	Stock	22.791	23.012	22.605	22.909	57944110.0
2023-03-13 11:00:00	NVDA	Stock	22.913	23.218	22.847	23.169	42879610.0
2023-03-13 12:00:00	NVDA	Stock	23.168	23.28	22.883	22.9049	36329370.0
2023-03-13 13:00:00	NVDA	Stock	22.9038	23.077	22.79	23.0165	29082740.0
2023-03-13 14:00:00	NVDA	Stock	23.019	23.279	23.01	23.1745	30243830.0
2023-03-13 15:00:00	NVDA	Stock	23.1745	23.298	22.958	22.958	39173850.0
2023-03-13 16:00:00	NVDA	Stock	22.957	23.01	22.956	23.01	28315210.0
2023-03-13 17:00:00	NVDA	Stock	23.0089	23.1277	22.99	22.994	138970.0
2023-03-13 18:00:00	NVDA	Stock	22.999	23.04	22.99	23.04	95720.0
2023-03-13 19:00:00	NVDA	Stock	23.04	23.06	22.992	23.06	199380.0
2023-03-13 04:00:00	AMZN	Stock	92.3	92.5	91.06	91.3	27822.0
2023-03-13 05:00:00	AMZN	Stock	91.3	91.97	90.78	91.01	45812.0

> showing 50 of 63,859 rows — these rows as CSV

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