PREVIEW / stock_1hour / 2023-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-12.parquet
  size:    1.4 MB
  rows:    61,978
  symbols: 1,923

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-12 04:00:00	AAPL	Stock	134.0	134.0	133.32	133.8	21813.0
2023-01-12 05:00:00	AAPL	Stock	133.75	133.75	133.41	133.64	13025.0
2023-01-12 06:00:00	AAPL	Stock	133.63	133.69	133.42	133.64	12621.0
2023-01-12 07:00:00	AAPL	Stock	133.64	134.16	133.5	134.16	67737.0
2023-01-12 08:00:00	AAPL	Stock	133.6302	134.61	131.5	134.33	1419587.0
2023-01-12 09:00:00	AAPL	Stock	134.35	134.66	131.44	132.3	10108087.0
2023-01-12 10:00:00	AAPL	Stock	132.3	133.795	132.15	132.445	10239533.0
2023-01-12 11:00:00	AAPL	Stock	132.45	133.1705	131.99	133.08	5797476.0
2023-01-12 12:00:00	AAPL	Stock	133.08	134.22	132.815	133.72	5992532.0
2023-01-12 13:00:00	AAPL	Stock	133.715	134.19	132.42	134.025	6956865.0
2023-01-12 14:00:00	AAPL	Stock	134.02	134.11	133.01	133.3501	5450724.0
2023-01-12 15:00:00	AAPL	Stock	133.355	133.56	132.77	133.385	7949079.0
2023-01-12 16:00:00	AAPL	Stock	133.385	133.45	133.1501	133.22	7179935.0
2023-01-12 17:00:00	AAPL	Stock	133.2	133.5	133.18	133.201	25701.0
2023-01-12 18:00:00	AAPL	Stock	133.2	133.27	133.13	133.2	22570.0
2023-01-12 19:00:00	AAPL	Stock	133.19	133.25	133.12	133.12	24791.0
2023-01-12 04:00:00	MSFT	Stock	235.78	235.78	235.33	235.65	3583.0
2023-01-12 05:00:00	MSFT	Stock	235.5	235.55	235.02	235.26	2705.0
2023-01-12 06:00:00	MSFT	Stock	235.32	235.32	235.25	235.27	635.0
2023-01-12 07:00:00	MSFT	Stock	235.37	235.69	235.15	235.52	16737.0
2023-01-12 08:00:00	MSFT	Stock	235.54	236.77	231.0	236.7	307641.0
2023-01-12 09:00:00	MSFT	Stock	236.66	237.28	233.56	234.6736	2677728.0
2023-01-12 10:00:00	MSFT	Stock	234.7	239.1386	234.63	237.31	4026482.0
2023-01-12 11:00:00	MSFT	Stock	237.31	238.95	236.72	238.77	2020664.0
2023-01-12 12:00:00	MSFT	Stock	238.76	239.64	237.9974	239.27	1835999.0
2023-01-12 13:00:00	MSFT	Stock	239.27	239.9	237.63	239.68	1934675.0
2023-01-12 14:00:00	MSFT	Stock	239.69	239.86	237.9328	238.34	1422903.0
2023-01-12 15:00:00	MSFT	Stock	238.33	238.75	237.41	238.47	2482415.0
2023-01-12 16:00:00	MSFT	Stock	238.51	238.63	238.27	238.323	3856906.0
2023-01-12 17:00:00	MSFT	Stock	238.33	238.88	238.32	238.37	24677.0
2023-01-12 18:00:00	MSFT	Stock	238.37	239.29	238.0	239.29	8340.0
2023-01-12 19:00:00	MSFT	Stock	238.41	238.7	238.41	238.6	8569.0
2023-01-12 04:00:00	NVDA	Stock	16.0	16.117	15.993	16.11	107180.0
2023-01-12 05:00:00	NVDA	Stock	16.118	16.118	16.052	16.064	55220.0
2023-01-12 06:00:00	NVDA	Stock	16.075	16.125	16.072	16.072	55810.0
2023-01-12 07:00:00	NVDA	Stock	16.093	16.25	16.07	16.25	235800.0
2023-01-12 08:00:00	NVDA	Stock	16.103	16.303	15.6	16.273	7320560.0
2023-01-12 09:00:00	NVDA	Stock	16.274	16.348	15.492	15.649	68570790.0
2023-01-12 10:00:00	NVDA	Stock	15.649	16.127	15.639	15.932	88877310.0
2023-01-12 11:00:00	NVDA	Stock	15.9334	16.106	15.815	16.096	45343060.0
2023-01-12 12:00:00	NVDA	Stock	16.096	16.488	16.089	16.44	62332160.0
2023-01-12 13:00:00	NVDA	Stock	16.4405	16.586	16.293	16.584	60416480.0
2023-01-12 14:00:00	NVDA	Stock	16.586	16.637	16.502	16.553	47710240.0
2023-01-12 15:00:00	NVDA	Stock	16.553	16.5603	16.376	16.511	61549340.0
2023-01-12 16:00:00	NVDA	Stock	16.511	16.515	16.45	16.45	25863020.0
2023-01-12 17:00:00	NVDA	Stock	16.4551	16.511	16.451	16.47	437850.0
2023-01-12 18:00:00	NVDA	Stock	16.467	16.474	16.46	16.468	175990.0
2023-01-12 19:00:00	NVDA	Stock	16.475	16.475	16.459	16.461	243190.0
2023-01-12 04:00:00	AMZN	Stock	94.68	95.35	94.68	95.35	24246.0
2023-01-12 05:00:00	AMZN	Stock	95.3	95.3	94.92	95.18	20188.0

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

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