PREVIEW / stock_1hour / 2023-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-31.parquet
  size:    1.4 MB
  rows:    62,363
  symbols: 1,935

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-01-31 04:00:00	AAPL	Stock	142.67	142.67	142.05	142.2	24876.0
2023-01-31 05:00:00	AAPL	Stock	142.08	142.12	141.58	141.61	26800.0
2023-01-31 06:00:00	AAPL	Stock	141.56	141.94	141.45	141.93	25601.0
2023-01-31 07:00:00	AAPL	Stock	141.95	142.58	141.95	142.48	61106.0
2023-01-31 08:00:00	AAPL	Stock	142.32	143.6398	141.6515	143.26	338945.0
2023-01-31 09:00:00	AAPL	Stock	143.3	143.75	142.28	142.6456	7348984.0
2023-01-31 10:00:00	AAPL	Stock	142.65	143.35	142.41	143.16	6590933.0
2023-01-31 11:00:00	AAPL	Stock	143.17	143.64	142.99	143.2583	4110011.0
2023-01-31 12:00:00	AAPL	Stock	143.26	143.66	142.98	143.535	3125410.0
2023-01-31 13:00:00	AAPL	Stock	143.54	143.74	143.16	143.63	3182900.0
2023-01-31 14:00:00	AAPL	Stock	143.625	144.0	143.53	143.86	3365289.0
2023-01-31 15:00:00	AAPL	Stock	143.87	144.34	143.12	144.3	10193341.0
2023-01-31 16:00:00	AAPL	Stock	144.3	144.43	143.69	143.73	18914803.0
2023-01-31 17:00:00	AAPL	Stock	143.73	144.08	143.72	143.8801	49288.0
2023-01-31 18:00:00	AAPL	Stock	143.91	143.91	143.77	143.81	26447.0
2023-01-31 19:00:00	AAPL	Stock	143.81	143.94	143.64	143.8	38961.0
2023-01-31 04:00:00	MSFT	Stock	242.05	242.39	241.52	241.89	6581.0
2023-01-31 05:00:00	MSFT	Stock	241.7	241.75	241.0	241.33	5500.0
2023-01-31 06:00:00	MSFT	Stock	241.36	241.84	241.23	241.84	2397.0
2023-01-31 07:00:00	MSFT	Stock	241.76	242.36	241.64	242.36	28963.0
2023-01-31 08:00:00	MSFT	Stock	242.14	244.52	241.63	243.9	68803.0
2023-01-31 09:00:00	MSFT	Stock	243.96	244.75	242.945	243.77	1890362.0
2023-01-31 10:00:00	MSFT	Stock	243.85	245.555	243.62	244.71	2002691.0
2023-01-31 11:00:00	MSFT	Stock	244.7	246.38	244.69	245.88	1441850.0
2023-01-31 12:00:00	MSFT	Stock	245.89	246.47	245.28	246.18	959739.0
2023-01-31 13:00:00	MSFT	Stock	246.2	246.76	245.6504	246.6872	935801.0
2023-01-31 14:00:00	MSFT	Stock	246.68	247.0399	246.5434	246.62	1342276.0
2023-01-31 15:00:00	MSFT	Stock	246.61	247.95	245.99	247.84	3511371.0
2023-01-31 16:00:00	MSFT	Stock	247.81	247.91	247.01	247.05	7352557.0
2023-01-31 17:00:00	MSFT	Stock	247.05	247.81	247.05	247.33	12487.0
2023-01-31 18:00:00	MSFT	Stock	247.32	247.33	246.9	246.9	3772.0
2023-01-31 19:00:00	MSFT	Stock	247.0	247.32	246.75	246.85	5879.0
2023-01-31 04:00:00	NVDA	Stock	19.05	19.075	18.901	18.962	114550.0
2023-01-31 05:00:00	NVDA	Stock	18.914	18.932	18.819	18.82	102670.0
2023-01-31 06:00:00	NVDA	Stock	18.837	18.855	18.765	18.855	111980.0
2023-01-31 07:00:00	NVDA	Stock	18.878	18.95	18.85	18.933	347040.0
2023-01-31 08:00:00	NVDA	Stock	18.8679	19.156	18.8538	19.116	1838980.0
2023-01-31 09:00:00	NVDA	Stock	19.101	19.447	19.03	19.051	66815090.0
2023-01-31 10:00:00	NVDA	Stock	19.062	19.63	18.95	19.616	98186000.0
2023-01-31 11:00:00	NVDA	Stock	19.618	19.687	19.336	19.403	62070130.0
2023-01-31 12:00:00	NVDA	Stock	19.406	19.517	19.3522	19.513	34854880.0
2023-01-31 13:00:00	NVDA	Stock	19.513	19.589	19.4068	19.4935	31137430.0
2023-01-31 14:00:00	NVDA	Stock	19.4955	19.534	19.442	19.487	25160480.0
2023-01-31 15:00:00	NVDA	Stock	19.485	19.544	19.366	19.542	58297520.0
2023-01-31 16:00:00	NVDA	Stock	19.537	19.778	19.2596	19.38	37187190.0
2023-01-31 17:00:00	NVDA	Stock	19.379	19.4943	19.31	19.337	1236100.0
2023-01-31 18:00:00	NVDA	Stock	19.36	19.36	19.286	19.29	628620.0
2023-01-31 19:00:00	NVDA	Stock	19.29	19.319	19.26	19.268	314840.0
2023-01-31 04:00:00	AMZN	Stock	100.15	100.15	99.88	100.01	12072.0
2023-01-31 05:00:00	AMZN	Stock	99.92	99.92	99.53	99.53	15608.0

> showing 50 of 62,363 rows — these rows as CSV

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