PREVIEW / stock_1hour / 2023-12-18

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-18.parquet
  size:    1.4 MB
  rows:    61,336
  symbols: 1,266

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-12-18 04:00:00	AAPL	Stock	196.32	196.49	195.5	195.77	19410.0
2023-12-18 05:00:00	AAPL	Stock	195.8	196.2	195.8	196.05	6534.0
2023-12-18 06:00:00	AAPL	Stock	196.07	196.31	195.95	196.21	9712.0
2023-12-18 07:00:00	AAPL	Stock	196.32	196.5	196.12	196.48	24086.0
2023-12-18 08:00:00	AAPL	Stock	196.44	196.5	193.5	196.22	151859.0
2023-12-18 09:00:00	AAPL	Stock	196.22	196.63	194.39	194.925	8174196.0
2023-12-18 10:00:00	AAPL	Stock	194.95	195.59	194.62	194.96	7132086.0
2023-12-18 11:00:00	AAPL	Stock	194.95	195.29	194.65	194.835	4252171.0
2023-12-18 12:00:00	AAPL	Stock	194.835	195.4688	194.81	195.46	2843523.0
2023-12-18 13:00:00	AAPL	Stock	195.465	196.23	195.46	196.205	3062154.0
2023-12-18 14:00:00	AAPL	Stock	196.21	196.48	196.01	196.26	3455367.0
2023-12-18 15:00:00	AAPL	Stock	196.27	196.45	195.78	195.8623	5416756.0
2023-12-18 16:00:00	AAPL	Stock	195.89	195.9207	195.0	195.8	7414868.0
2023-12-18 17:00:00	AAPL	Stock	195.78	195.86	195.72	195.75	29158.0
2023-12-18 18:00:00	AAPL	Stock	195.75	195.89	195.69	195.7802	53801.0
2023-12-18 19:00:00	AAPL	Stock	195.86	195.89	195.74	195.85	19830.0
2023-12-18 04:00:00	MSFT	Stock	370.3	370.31	369.81	369.81	3739.0
2023-12-18 05:00:00	MSFT	Stock	369.8	370.0	369.7	369.7	7975.0
2023-12-18 06:00:00	MSFT	Stock	369.25	369.25	368.69	368.69	1956.0
2023-12-18 07:00:00	MSFT	Stock	368.9	369.75	368.9	369.7	5015.0
2023-12-18 08:00:00	MSFT	Stock	368.89	370.44	368.89	370.0	32971.0
2023-12-18 09:00:00	MSFT	Stock	370.08	371.24	368.27	369.76	2202057.0
2023-12-18 10:00:00	MSFT	Stock	369.79	372.71	369.63	370.63	2382321.0
2023-12-18 11:00:00	MSFT	Stock	370.595	371.39	370.3245	371.11	1163463.0
2023-12-18 12:00:00	MSFT	Stock	371.12	371.89	370.6301	371.04	1189504.0
2023-12-18 13:00:00	MSFT	Stock	371.046	372.55	370.98	372.4888	932314.0
2023-12-18 14:00:00	MSFT	Stock	372.49	373.0	372.25	372.7	1052910.0
2023-12-18 15:00:00	MSFT	Stock	372.71	372.93	372.26	372.59	1912225.0
2023-12-18 16:00:00	MSFT	Stock	372.65	372.76	371.9	372.25	4606853.0
2023-12-18 17:00:00	MSFT	Stock	372.29	372.3636	372.2659	372.32	3868.0
2023-12-18 18:00:00	MSFT	Stock	372.31	372.38	372.01	372.23	3989.0
2023-12-18 19:00:00	MSFT	Stock	372.3	372.38	372.1	372.38	3222.0
2023-12-18 04:00:00	NVDA	Stock	49.163	49.163	48.958	49.064	43030.0
2023-12-18 05:00:00	NVDA	Stock	49.05	49.099	49.043	49.043	30230.0
2023-12-18 06:00:00	NVDA	Stock	49.021	49.029	48.911	48.95	43780.0
2023-12-18 07:00:00	NVDA	Stock	48.928	49.16	48.928	49.155	327210.0
2023-12-18 08:00:00	NVDA	Stock	49.0	49.25	48.93	49.249	1026400.0
2023-12-18 09:00:00	NVDA	Stock	49.248	49.608	49.15	49.5935	54630500.0
2023-12-18 10:00:00	NVDA	Stock	49.5935	50.0	49.519	49.683	60390380.0
2023-12-18 11:00:00	NVDA	Stock	49.683	50.0	49.638	49.759	32956010.0
2023-12-18 12:00:00	NVDA	Stock	49.7636	49.942	49.755	49.8775	20473330.0
2023-12-18 13:00:00	NVDA	Stock	49.876	50.115	49.81	50.0869	34450120.0
2023-12-18 14:00:00	NVDA	Stock	50.085	50.345	50.081	50.216	42945750.0
2023-12-18 15:00:00	NVDA	Stock	50.22	50.433	50.063	50.081	51524560.0
2023-12-18 16:00:00	NVDA	Stock	50.077	50.128	49.923	50.031	20147100.0
2023-12-18 17:00:00	NVDA	Stock	50.06	50.106	50.031	50.061	196480.0
2023-12-18 18:00:00	NVDA	Stock	50.058	50.07	50.007	50.02	256340.0
2023-12-18 19:00:00	NVDA	Stock	50.02	50.038	49.94	49.945	433360.0
2023-12-18 04:00:00	AMZN	Stock	149.74	150.07	149.74	149.87	9416.0
2023-12-18 05:00:00	AMZN	Stock	149.82	149.96	149.81	149.91	6077.0

> showing 50 of 61,336 rows — these rows as CSV

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