PREVIEW / stock_1hour / 2005-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-20.parquet
  size:    555 KB
  rows:    26,341
  symbols: 1,987

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
2005-06-20 08:00:00	AAPL	Stock	1.3571	1.3571	1.3393	1.35	1076180.0
2005-06-20 09:00:00	AAPL	Stock	1.35	1.3604	1.3482	1.3496	49321048.0
2005-06-20 10:00:00	AAPL	Stock	1.3496	1.3521	1.3375	1.3429	75837300.0
2005-06-20 11:00:00	AAPL	Stock	1.3425	1.3464	1.3411	1.3461	34904968.0
2005-06-20 12:00:00	AAPL	Stock	1.3461	1.3518	1.3432	1.3435	25585868.0
2005-06-20 13:00:00	AAPL	Stock	1.3432	1.3446	1.3407	1.3425	24639552.0
2005-06-20 14:00:00	AAPL	Stock	1.3429	1.3521	1.3404	1.3482	38221148.0
2005-06-20 15:00:00	AAPL	Stock	1.3482	1.3543	1.3432	1.3432	59608388.0
2005-06-20 16:00:00	AAPL	Stock	1.3439	1.3554	1.3432	1.3464	11679416.0
2005-06-20 17:00:00	AAPL	Stock	1.3454	1.3464	1.3454	1.3464	11200.0
2005-06-20 18:00:00	AAPL	Stock	1.3471	1.3471	1.3439	1.3464	131964.0
2005-06-20 07:00:00	MSFT	Stock	25.04	25.04	25.04	25.04	400.0
2005-06-20 08:00:00	MSFT	Stock	25.0	25.0	24.96	24.99	10897.0
2005-06-20 09:00:00	MSFT	Stock	24.99	25.1	24.93	25.1	5465949.0
2005-06-20 10:00:00	MSFT	Stock	25.1	25.13	25.03	25.08	7197180.0
2005-06-20 11:00:00	MSFT	Stock	25.08	25.2	25.06	25.192	7862221.0
2005-06-20 12:00:00	MSFT	Stock	25.19	25.23	25.1	25.102	4096977.0
2005-06-20 13:00:00	MSFT	Stock	25.1	25.14	25.06	25.11	3598114.0
2005-06-20 14:00:00	MSFT	Stock	25.12	25.24	25.04	25.22	6129583.0
2005-06-20 15:00:00	MSFT	Stock	25.22	25.28	25.11	25.11	12134298.0
2005-06-20 16:00:00	MSFT	Stock	25.11	25.26	25.08	25.11	781900.0
2005-06-20 17:00:00	MSFT	Stock	25.11	25.15	25.1	25.1	212367.0
2005-06-20 18:00:00	MSFT	Stock	25.1	25.11	25.05	25.07	12635.0
2005-06-20 08:00:00	NVDA	Stock	0.2237	0.2237	0.2237	0.2237	22320.0
2005-06-20 09:00:00	NVDA	Stock	0.2234	0.2246	0.2208	0.2212	56158080.0
2005-06-20 10:00:00	NVDA	Stock	0.2214	0.2237	0.2206	0.2233	61560000.0
2005-06-20 11:00:00	NVDA	Stock	0.2234	0.2259	0.2232	0.2256	64611000.0
2005-06-20 12:00:00	NVDA	Stock	0.2256	0.2262	0.225	0.2259	59722320.0
2005-06-20 13:00:00	NVDA	Stock	0.2259	0.2277	0.2252	0.2275	81114480.0
2005-06-20 14:00:00	NVDA	Stock	0.2276	0.2292	0.2271	0.2286	115208160.0
2005-06-20 15:00:00	NVDA	Stock	0.2286	0.2288	0.2267	0.2272	144880440.0
2005-06-20 16:00:00	NVDA	Stock	0.2276	0.2277	0.2273	0.2277	12083880.0
2005-06-20 17:00:00	NVDA	Stock	0.2283	0.2283	0.2276	0.2279	766680.0
2005-06-20 08:00:00	AMZN	Stock	1.7525	1.7545	1.752	1.754	92540.0
2005-06-20 09:00:00	AMZN	Stock	1.7545	1.7585	1.7515	1.753	7788280.0
2005-06-20 10:00:00	AMZN	Stock	1.753	1.7585	1.752	1.7565	15169420.0
2005-06-20 11:00:00	AMZN	Stock	1.756	1.7625	1.7555	1.7615	8392500.0
2005-06-20 12:00:00	AMZN	Stock	1.7615	1.7845	1.7615	1.784	17412800.0
2005-06-20 13:00:00	AMZN	Stock	1.784	1.791	1.7795	1.789	12521080.0
2005-06-20 14:00:00	AMZN	Stock	1.789	1.7955	1.7845	1.7955	13838200.0
2005-06-20 15:00:00	AMZN	Stock	1.7955	1.7985	1.7835	1.7835	24666480.0
2005-06-20 16:00:00	AMZN	Stock	1.786	1.786	1.78	1.785	82000.0
2005-06-20 17:00:00	AMZN	Stock	1.7855	1.786	1.7855	1.786	62000.0
2005-06-20 08:00:00	CL	Stock	25.065	25.5	25.065	25.075	3600.0
2005-06-20 09:00:00	CL	Stock	24.925	25.08	24.845	25.08	957400.0
2005-06-20 10:00:00	CL	Stock	25.075	25.36	25.06	25.285	1524800.0
2005-06-20 11:00:00	CL	Stock	25.28	25.335	25.13	25.335	827600.0
2005-06-20 12:00:00	CL	Stock	25.335	25.415	25.285	25.285	619600.0
2005-06-20 13:00:00	CL	Stock	25.285	25.295	25.215	25.275	382400.0
2005-06-20 14:00:00	CL	Stock	25.285	25.375	25.27	25.365	674600.0

> showing 50 of 26,341 rows — these rows as CSV

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