PREVIEW / stock_1hour / 2023-02-15

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-15.parquet
  size:    1.4 MB
  rows:    61,044
  symbols: 1,868

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-02-15 04:00:00	AAPL	Stock	152.8	152.91	152.36	152.51	21170.0
2023-02-15 05:00:00	AAPL	Stock	152.51	152.66	152.44	152.65	3820.0
2023-02-15 06:00:00	AAPL	Stock	152.66	152.76	152.54	152.72	9829.0
2023-02-15 07:00:00	AAPL	Stock	152.7	153.15	152.69	152.87	63779.0
2023-02-15 08:00:00	AAPL	Stock	152.75	153.4	151.7	152.96	304331.0
2023-02-15 09:00:00	AAPL	Stock	152.99	154.52	152.34	153.5663	7518214.0
2023-02-15 10:00:00	AAPL	Stock	153.57	154.4	153.05	153.8299	8212137.0
2023-02-15 11:00:00	AAPL	Stock	153.82	155.5	153.81	155.25	8173008.0
2023-02-15 12:00:00	AAPL	Stock	155.26	155.3975	153.5	154.07	7227274.0
2023-02-15 13:00:00	AAPL	Stock	154.09	155.05	153.715	155.01	5018434.0
2023-02-15 14:00:00	AAPL	Stock	155.01	155.47	154.9	155.02	4328029.0
2023-02-15 15:00:00	AAPL	Stock	155.02	155.38	154.67	155.36	6657279.0
2023-02-15 16:00:00	AAPL	Stock	155.36	155.45	155.08	155.3	5614698.0
2023-02-15 17:00:00	AAPL	Stock	155.29	155.33	155.2404	155.29	36671.0
2023-02-15 18:00:00	AAPL	Stock	155.26	155.39	155.26	155.33	27584.0
2023-02-15 19:00:00	AAPL	Stock	155.31	155.51	155.3	155.48	50865.0
2023-02-15 04:00:00	MSFT	Stock	271.21	271.52	270.5	270.8	17059.0
2023-02-15 05:00:00	MSFT	Stock	270.53	271.3	270.4	271.2	2690.0
2023-02-15 06:00:00	MSFT	Stock	271.1	271.24	270.66	270.67	2082.0
2023-02-15 07:00:00	MSFT	Stock	271.0	271.96	270.84	271.21	22866.0
2023-02-15 08:00:00	MSFT	Stock	270.98	272.17	269.8	270.9104	118318.0
2023-02-15 09:00:00	MSFT	Stock	271.11	271.11	268.18	269.285	2861720.0
2023-02-15 10:00:00	MSFT	Stock	269.3	269.8899	266.53	266.7033	3357104.0
2023-02-15 11:00:00	MSFT	Stock	266.67	268.24	266.64	266.745	2170111.0
2023-02-15 12:00:00	MSFT	Stock	266.745	268.14	266.18	267.515	1812958.0
2023-02-15 13:00:00	MSFT	Stock	267.56	268.98	267.1687	268.47	1498853.0
2023-02-15 14:00:00	MSFT	Stock	268.47	269.28	267.56	267.73	1489508.0
2023-02-15 15:00:00	MSFT	Stock	267.74	269.33	267.74	269.33	3039346.0
2023-02-15 16:00:00	MSFT	Stock	269.33	269.7	269.11	269.59	2944585.0
2023-02-15 17:00:00	MSFT	Stock	269.68	269.74	269.2	269.22	111959.0
2023-02-15 18:00:00	MSFT	Stock	269.4	269.5	269.11	269.33	8631.0
2023-02-15 19:00:00	MSFT	Stock	269.39	270.34	269.39	269.79	13513.0
2023-02-15 04:00:00	NVDA	Stock	22.79	22.833	22.667	22.751	488390.0
2023-02-15 05:00:00	NVDA	Stock	22.751	22.751	22.7	22.731	61320.0
2023-02-15 06:00:00	NVDA	Stock	22.716	22.74	22.671	22.725	113840.0
2023-02-15 07:00:00	NVDA	Stock	22.705	22.915	22.702	22.82	1425040.0
2023-02-15 08:00:00	NVDA	Stock	22.7838	22.91	22.701	22.745	2834210.0
2023-02-15 09:00:00	NVDA	Stock	22.74	22.855	22.225	22.2965	77094000.0
2023-02-15 10:00:00	NVDA	Stock	22.2945	22.489	22.106	22.2561	71331320.0
2023-02-15 11:00:00	NVDA	Stock	22.256	22.672	22.243	22.562	49259940.0
2023-02-15 12:00:00	NVDA	Stock	22.5656	22.6224	22.463	22.5904	26766140.0
2023-02-15 13:00:00	NVDA	Stock	22.6	22.667	22.496	22.645	23459150.0
2023-02-15 14:00:00	NVDA	Stock	22.644	22.7909	22.63	22.649	29865190.0
2023-02-15 15:00:00	NVDA	Stock	22.6495	22.775	22.554	22.764	42899830.0
2023-02-15 16:00:00	NVDA	Stock	22.764	22.8	22.728	22.7369	20294190.0
2023-02-15 17:00:00	NVDA	Stock	22.739	22.7612	22.729	22.739	154910.0
2023-02-15 18:00:00	NVDA	Stock	22.74	22.775	22.717	22.763	131700.0
2023-02-15 19:00:00	NVDA	Stock	22.785	22.825	22.77	22.814	310510.0
2023-02-15 04:00:00	AMZN	Stock	99.14	99.45	99.01	99.23	8879.0
2023-02-15 05:00:00	AMZN	Stock	99.25	99.26	99.02	99.11	10148.0

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

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