PREVIEW / stock_1hour / 2023-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-27.parquet
  size:    1.4 MB
  rows:    61,061
  symbols: 1,885

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-27 04:00:00	AAPL	Stock	143.48	143.57	143.1	143.4	18021.0
2023-01-27 05:00:00	AAPL	Stock	143.48	143.49	143.29	143.39	2815.0
2023-01-27 06:00:00	AAPL	Stock	143.48	143.5	143.27	143.45	10815.0
2023-01-27 07:00:00	AAPL	Stock	143.45	143.69	143.3	143.57	51360.0
2023-01-27 08:00:00	AAPL	Stock	143.65	143.99	143.0	143.64	209311.0
2023-01-27 09:00:00	AAPL	Stock	143.64	145.21	143.0	144.6999	7303590.0
2023-01-27 10:00:00	AAPL	Stock	144.71	145.525	144.38	144.68	8711535.0
2023-01-27 11:00:00	AAPL	Stock	144.7	146.19	144.61	146.05	7145607.0
2023-01-27 12:00:00	AAPL	Stock	146.05	146.89	145.92	146.37	6575314.0
2023-01-27 13:00:00	AAPL	Stock	146.3601	146.56	145.99	146.35	4330645.0
2023-01-27 14:00:00	AAPL	Stock	146.35	147.02	146.25	146.9	5913433.0
2023-01-27 15:00:00	AAPL	Stock	146.895	147.23	145.8	145.97	10919332.0
2023-01-27 16:00:00	AAPL	Stock	145.93	146.04	145.855	145.98	8440273.0
2023-01-27 17:00:00	AAPL	Stock	145.96	145.96	145.81	145.86	69476.0
2023-01-27 18:00:00	AAPL	Stock	145.85	145.9	145.83	145.89	14573.0
2023-01-27 19:00:00	AAPL	Stock	145.88	145.98	145.84	145.9	26827.0
2023-01-27 04:00:00	MSFT	Stock	246.87	247.01	246.28	247.01	3866.0
2023-01-27 05:00:00	MSFT	Stock	247.35	247.5	247.28	247.28	2150.0
2023-01-27 06:00:00	MSFT	Stock	247.31	247.31	247.15	247.2	2430.0
2023-01-27 07:00:00	MSFT	Stock	247.15	247.68	247.14	247.2	17054.0
2023-01-27 08:00:00	MSFT	Stock	247.61	248.23	247.0	247.63	70013.0
2023-01-27 09:00:00	MSFT	Stock	247.79	249.36	247.33	247.8701	3268441.0
2023-01-27 10:00:00	MSFT	Stock	247.9	249.0	246.83	247.51	2733368.0
2023-01-27 11:00:00	MSFT	Stock	247.52	248.88	247.151	248.32	1770727.0
2023-01-27 12:00:00	MSFT	Stock	248.33	248.84	247.9605	248.57	1582973.0
2023-01-27 13:00:00	MSFT	Stock	248.58	248.7	247.78	248.47	1239444.0
2023-01-27 14:00:00	MSFT	Stock	248.47	248.78	248.22	248.6	1594287.0
2023-01-27 15:00:00	MSFT	Stock	248.61	249.83	247.79	248.14	4070151.0
2023-01-27 16:00:00	MSFT	Stock	248.165	248.165	247.7	247.99	4111076.0
2023-01-27 17:00:00	MSFT	Stock	247.98	248.16	247.94	248.0	15143.0
2023-01-27 18:00:00	MSFT	Stock	247.99	248.11	247.96	248.11	3788.0
2023-01-27 19:00:00	MSFT	Stock	248.11	248.15	248.0	248.13	7977.0
2023-01-27 04:00:00	NVDA	Stock	19.299	19.389	19.299	19.385	114740.0
2023-01-27 05:00:00	NVDA	Stock	19.376	19.43	19.376	19.415	32970.0
2023-01-27 06:00:00	NVDA	Stock	19.412	19.412	19.384	19.398	49350.0
2023-01-27 07:00:00	NVDA	Stock	19.399	19.52	19.375	19.389	938720.0
2023-01-27 08:00:00	NVDA	Stock	19.415	19.563	19.3	19.5	1745030.0
2023-01-27 09:00:00	NVDA	Stock	19.492	19.979	19.405	19.895	70698530.0
2023-01-27 10:00:00	NVDA	Stock	19.9	20.222	19.864	19.997	113350580.0
2023-01-27 11:00:00	NVDA	Stock	19.9982	20.2	19.88	20.0792	58959200.0
2023-01-27 12:00:00	NVDA	Stock	20.083	20.359	20.07	20.351	40074910.0
2023-01-27 13:00:00	NVDA	Stock	20.35	20.594	20.299	20.538	51777640.0
2023-01-27 14:00:00	NVDA	Stock	20.539	20.628	20.4707	20.5008	39259700.0
2023-01-27 15:00:00	NVDA	Stock	20.502	20.5483	20.3401	20.361	54100710.0
2023-01-27 16:00:00	NVDA	Stock	20.361	20.365	20.312	20.334	24859300.0
2023-01-27 17:00:00	NVDA	Stock	20.3446	20.365	20.33	20.34	155860.0
2023-01-27 18:00:00	NVDA	Stock	20.336	20.342	20.325	20.327	146300.0
2023-01-27 19:00:00	NVDA	Stock	20.33	20.34	20.256	20.256	262840.0
2023-01-27 04:00:00	AMZN	Stock	98.59	98.7	98.0	98.6	9504.0
2023-01-27 05:00:00	AMZN	Stock	98.62	98.79	98.62	98.7	4365.0

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

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