PREVIEW / stock_1hour / 2023-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-09.parquet
  size:    1.3 MB
  rows:    59,443
  symbols: 1,617

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-06-09 04:00:00	AAPL	Stock	180.19	180.42	180.0	180.4	32399.0
2023-06-09 05:00:00	AAPL	Stock	180.39	180.5	180.24	180.24	28881.0
2023-06-09 06:00:00	AAPL	Stock	180.25	180.38	180.13	180.38	20016.0
2023-06-09 07:00:00	AAPL	Stock	180.39	180.7	180.07	180.55	32457.0
2023-06-09 08:00:00	AAPL	Stock	180.45	180.85	180.05	180.77	130102.0
2023-06-09 09:00:00	AAPL	Stock	180.77	182.19	180.66	181.58	5842106.0
2023-06-09 10:00:00	AAPL	Stock	181.59	182.11	180.98	181.4	6523459.0
2023-06-09 11:00:00	AAPL	Stock	181.3988	182.07	180.86	180.92	5309842.0
2023-06-09 12:00:00	AAPL	Stock	180.9	181.58	180.63	181.39	3557339.0
2023-06-09 13:00:00	AAPL	Stock	181.4099	182.03	181.28	182.025	2871346.0
2023-06-09 14:00:00	AAPL	Stock	182.03	182.23	181.755	182.035	3163624.0
2023-06-09 15:00:00	AAPL	Stock	182.0397	182.09	180.73	181.05	6911597.0
2023-06-09 16:00:00	AAPL	Stock	181.05	181.1	180.8	180.8488	6527351.0
2023-06-09 17:00:00	AAPL	Stock	180.87	180.88	180.75	180.78	25767.0
2023-06-09 18:00:00	AAPL	Stock	180.7536	180.85	180.72	180.84	13361.0
2023-06-09 19:00:00	AAPL	Stock	180.78	180.86	180.72	180.81	7438.0
2023-06-09 04:00:00	MSFT	Stock	324.11	324.24	323.2	323.8	5695.0
2023-06-09 05:00:00	MSFT	Stock	323.8	324.27	323.5	323.7	3448.0
2023-06-09 06:00:00	MSFT	Stock	323.98	324.96	323.98	324.86	12408.0
2023-06-09 07:00:00	MSFT	Stock	324.6	324.7	324.12	324.4	9362.0
2023-06-09 08:00:00	MSFT	Stock	324.75	324.94	323.7351	324.73	38062.0
2023-06-09 09:00:00	MSFT	Stock	324.62	329.99	324.41	329.55	2904552.0
2023-06-09 10:00:00	MSFT	Stock	329.58	329.79	326.8	327.43	2703523.0
2023-06-09 11:00:00	MSFT	Stock	327.4	328.63	325.29	325.51	1980975.0
2023-06-09 12:00:00	MSFT	Stock	325.51	326.88	325.02	326.81	1274330.0
2023-06-09 13:00:00	MSFT	Stock	326.83	328.45	326.6642	328.44	969704.0
2023-06-09 14:00:00	MSFT	Stock	328.45	328.48	327.34	327.96	894298.0
2023-06-09 15:00:00	MSFT	Stock	328.0	328.09	326.24	326.81	2250872.0
2023-06-09 16:00:00	MSFT	Stock	326.86	327.43	326.7	327.36	3712518.0
2023-06-09 17:00:00	MSFT	Stock	327.16	327.49	326.79	327.25	28580.0
2023-06-09 18:00:00	MSFT	Stock	327.47	327.6676	327.25	327.33	6473.0
2023-06-09 19:00:00	MSFT	Stock	327.32	327.5	327.15	327.3	2469.0
2023-06-09 04:00:00	NVDA	Stock	38.5	38.935	38.5	38.888	361800.0
2023-06-09 05:00:00	NVDA	Stock	38.878	39.1	38.878	38.95	391960.0
2023-06-09 06:00:00	NVDA	Stock	38.95	38.986	38.881	38.935	202030.0
2023-06-09 07:00:00	NVDA	Stock	38.921	39.011	38.861	38.92	767430.0
2023-06-09 08:00:00	NVDA	Stock	38.932	39.045	38.56	38.9716	2134500.0
2023-06-09 09:00:00	NVDA	Stock	38.97	39.617	38.92	39.502	64059860.0
2023-06-09 10:00:00	NVDA	Stock	39.506	39.711	39.069	39.203	61413820.0
2023-06-09 11:00:00	NVDA	Stock	39.197	39.449	38.826	38.8335	45474780.0
2023-06-09 12:00:00	NVDA	Stock	38.834	38.9425	38.588	38.942	39722530.0
2023-06-09 13:00:00	NVDA	Stock	38.945	39.184	38.914	39.096	30618330.0
2023-06-09 14:00:00	NVDA	Stock	39.096	39.155	38.782	38.8599	25254690.0
2023-06-09 15:00:00	NVDA	Stock	38.852	38.886	38.567	38.764	36067070.0
2023-06-09 16:00:00	NVDA	Stock	38.763	38.86	38.74	38.775	19127750.0
2023-06-09 17:00:00	NVDA	Stock	38.765	38.765	38.735	38.735	262490.0
2023-06-09 18:00:00	NVDA	Stock	38.733	38.75	38.725	38.745	165280.0
2023-06-09 19:00:00	NVDA	Stock	38.749	38.77	38.71	38.71	250350.0
2023-06-09 04:00:00	AMZN	Stock	124.16	124.18	123.86	124.0	12615.0
2023-06-09 05:00:00	AMZN	Stock	123.99	124.1	123.87	123.88	7238.0

> showing 50 of 59,443 rows — these rows as CSV

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