PREVIEW / stock_1hour / 2023-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-29.parquet
  size:    1.3 MB
  rows:    58,209
  symbols: 1,458

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-08-29 04:00:00	AAPL	Stock	180.25	180.38	180.01	180.1	13869.0
2023-08-29 05:00:00	AAPL	Stock	180.08	180.38	180.05	180.38	7880.0
2023-08-29 06:00:00	AAPL	Stock	180.43	180.55	180.26	180.29	13971.0
2023-08-29 07:00:00	AAPL	Stock	180.3	180.4	180.1	180.23	19891.0
2023-08-29 08:00:00	AAPL	Stock	180.39	180.4	179.91	180.07	82578.0
2023-08-29 09:00:00	AAPL	Stock	180.08	181.15	179.35	180.91	4152714.0
2023-08-29 10:00:00	AAPL	Stock	180.91	182.67	180.86	182.295	7570944.0
2023-08-29 11:00:00	AAPL	Stock	182.2999	183.53	182.28	183.185	4610109.0
2023-08-29 12:00:00	AAPL	Stock	183.185	183.75	183.125	183.59	4216872.0
2023-08-29 13:00:00	AAPL	Stock	183.6	184.0	183.4562	183.705	3559835.0
2023-08-29 14:00:00	AAPL	Stock	183.7	184.54	183.661	184.51	4467548.0
2023-08-29 15:00:00	AAPL	Stock	184.509	184.9	183.86	184.12	8720199.0
2023-08-29 16:00:00	AAPL	Stock	184.12	184.49	184.1	184.38	7692391.0
2023-08-29 17:00:00	AAPL	Stock	184.37	184.48	184.33	184.38	38858.0
2023-08-29 18:00:00	AAPL	Stock	184.38	184.7	184.38	184.57	39186.0
2023-08-29 19:00:00	AAPL	Stock	184.52	184.6	184.4	184.57	31394.0
2023-08-29 04:00:00	MSFT	Stock	323.77	324.1	323.77	323.9	891.0
2023-08-29 05:00:00	MSFT	Stock	324.0	324.1	323.6	324.1	1673.0
2023-08-29 06:00:00	MSFT	Stock	324.2	324.2	323.7	323.7	400.0
2023-08-29 07:00:00	MSFT	Stock	323.67	324.1	322.57	322.97	5739.0
2023-08-29 08:00:00	MSFT	Stock	323.6101	324.1	322.1	322.55	12800.0
2023-08-29 09:00:00	MSFT	Stock	322.5	323.6979	321.55	323.05	1436812.0
2023-08-29 10:00:00	MSFT	Stock	323.035	328.0	323.035	327.22	2480273.0
2023-08-29 11:00:00	MSFT	Stock	327.26	328.9835	327.16	328.015	1147766.0
2023-08-29 12:00:00	MSFT	Stock	328.03	328.35	327.25	327.84	1007961.0
2023-08-29 13:00:00	MSFT	Stock	327.87	328.43	326.98	327.3899	694684.0
2023-08-29 14:00:00	MSFT	Stock	327.36	327.85	327.03	327.275	958505.0
2023-08-29 15:00:00	MSFT	Stock	327.28	328.55	326.85	328.4	2165411.0
2023-08-29 16:00:00	MSFT	Stock	328.41	328.85	327.88	328.51	3896944.0
2023-08-29 17:00:00	MSFT	Stock	328.58	328.63	328.57	328.59	7696.0
2023-08-29 18:00:00	MSFT	Stock	328.73	329.3	328.7	329.3	9500.0
2023-08-29 19:00:00	MSFT	Stock	329.3	329.3	328.88	329.09	6613.0
2023-08-29 04:00:00	NVDA	Stock	46.89	46.901	46.65	46.732	121970.0
2023-08-29 05:00:00	NVDA	Stock	46.704	46.85	46.67	46.84	58730.0
2023-08-29 06:00:00	NVDA	Stock	46.832	46.832	46.666	46.7	71070.0
2023-08-29 07:00:00	NVDA	Stock	46.733	46.733	46.53	46.55	353110.0
2023-08-29 08:00:00	NVDA	Stock	46.735	46.735	46.38	46.542	2078460.0
2023-08-29 09:00:00	NVDA	Stock	46.52	47.389	46.391	47.3715	74848020.0
2023-08-29 10:00:00	NVDA	Stock	47.3786	48.542	47.3786	48.2351	137471160.0
2023-08-29 11:00:00	NVDA	Stock	48.232	48.712	48.133	48.587	71783960.0
2023-08-29 12:00:00	NVDA	Stock	48.596	49.081	48.461	48.825	70441060.0
2023-08-29 13:00:00	NVDA	Stock	48.8268	49.05	48.7167	48.903	54045760.0
2023-08-29 14:00:00	NVDA	Stock	48.9	49.058	48.806	48.92	47734540.0
2023-08-29 15:00:00	NVDA	Stock	48.918	48.985	48.523	48.784	72805980.0
2023-08-29 16:00:00	NVDA	Stock	48.784	48.85	48.611	48.717	21570690.0
2023-08-29 17:00:00	NVDA	Stock	48.72	48.743	48.6463	48.715	498530.0
2023-08-29 18:00:00	NVDA	Stock	48.705	48.732	48.618	48.678	363090.0
2023-08-29 19:00:00	NVDA	Stock	48.675	48.935	48.651	48.911	1089640.0
2023-08-29 04:00:00	AMZN	Stock	133.25	133.26	133.03	133.2	5779.0
2023-08-29 05:00:00	AMZN	Stock	133.2	133.4	133.2	133.4	1922.0

> showing 50 of 58,209 rows — these rows as CSV

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