PREVIEW / stock_1hour / 2005-09-02

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-02.parquet
  size:    550 KB
  rows:    26,265
  symbols: 2,067

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-09-02 08:00:00	AAPL	Stock	1.65	1.6571	1.65	1.6571	190596.0
2005-09-02 09:00:00	AAPL	Stock	1.6521	1.6714	1.6518	1.6593	42034748.0
2005-09-02 10:00:00	AAPL	Stock	1.6589	1.6643	1.6536	1.6561	51968672.0
2005-09-02 11:00:00	AAPL	Stock	1.6557	1.6589	1.6518	1.6543	25195996.0
2005-09-02 12:00:00	AAPL	Stock	1.6543	1.6554	1.6471	1.6486	24484208.0
2005-09-02 13:00:00	AAPL	Stock	1.6489	1.6589	1.6479	1.6579	24527832.0
2005-09-02 14:00:00	AAPL	Stock	1.6582	1.66	1.6525	1.6525	18232620.0
2005-09-02 15:00:00	AAPL	Stock	1.6525	1.6539	1.6471	1.6504	28421792.0
2005-09-02 16:00:00	AAPL	Stock	1.6507	1.6568	1.6482	1.6493	862400.0
2005-09-02 17:00:00	AAPL	Stock	1.6486	1.6493	1.6486	1.6493	96320.0
2005-09-02 18:00:00	AAPL	Stock	1.6507	1.6507	1.6507	1.6507	2800.0
2005-09-02 08:00:00	MSFT	Stock	27.2	27.29	27.13	27.22	40276.0
2005-09-02 09:00:00	MSFT	Stock	27.22	27.26	27.15	27.161	4060626.0
2005-09-02 10:00:00	MSFT	Stock	27.16	27.2	27.11	27.15	10468283.0
2005-09-02 11:00:00	MSFT	Stock	27.15	27.2	27.11	27.17	8544066.0
2005-09-02 12:00:00	MSFT	Stock	27.17	27.27	27.15	27.221	6283466.0
2005-09-02 13:00:00	MSFT	Stock	27.23	27.26	27.19	27.2	5379574.0
2005-09-02 14:00:00	MSFT	Stock	27.2	27.25	27.12	27.13	6095532.0
2005-09-02 15:00:00	MSFT	Stock	27.12	27.17	26.97	27.0	9490636.0
2005-09-02 16:00:00	MSFT	Stock	26.99	27.05	26.99	26.99	183807.0
2005-09-02 17:00:00	MSFT	Stock	26.985	26.99	26.985	26.99	10430.0
2005-09-02 08:00:00	NVDA	Stock	0.2557	0.2567	0.2557	0.2567	229200.0
2005-09-02 09:00:00	NVDA	Stock	0.2558	0.2562	0.2523	0.2528	90722880.0
2005-09-02 10:00:00	NVDA	Stock	0.2528	0.2531	0.2507	0.2529	82098840.0
2005-09-02 11:00:00	NVDA	Stock	0.2527	0.2535	0.2525	0.2527	43204320.0
2005-09-02 12:00:00	NVDA	Stock	0.2528	0.2545	0.2527	0.2544	42926760.0
2005-09-02 13:00:00	NVDA	Stock	0.2544	0.2547	0.2532	0.2532	44141280.0
2005-09-02 14:00:00	NVDA	Stock	0.2532	0.2547	0.2532	0.254	29165640.0
2005-09-02 15:00:00	NVDA	Stock	0.2541	0.255	0.2512	0.2517	114168120.0
2005-09-02 16:00:00	NVDA	Stock	0.2516	0.2526	0.251	0.251	16817400.0
2005-09-02 17:00:00	NVDA	Stock	0.2517	0.2517	0.2517	0.2517	18000.0
2005-09-02 08:00:00	AMZN	Stock	2.09	2.09	2.09	2.09	18480.0
2005-09-02 09:00:00	AMZN	Stock	2.092	2.1025	2.076	2.079	8089600.0
2005-09-02 10:00:00	AMZN	Stock	2.079	2.081	2.052	2.058	22540000.0
2005-09-02 11:00:00	AMZN	Stock	2.058	2.063	2.052	2.0595	14672040.0
2005-09-02 12:00:00	AMZN	Stock	2.0595	2.071	2.0585	2.0705	6415720.0
2005-09-02 13:00:00	AMZN	Stock	2.07	2.0785	2.067	2.069	4547020.0
2005-09-02 14:00:00	AMZN	Stock	2.069	2.079	2.0665	2.0735	8358460.0
2005-09-02 15:00:00	AMZN	Stock	2.073	2.078	2.066	2.075	12684700.0
2005-09-02 16:00:00	AMZN	Stock	2.0755	2.0785	2.0675	2.0675	489860.0
2005-09-02 17:00:00	AMZN	Stock	2.0755	2.0755	2.0755	2.0755	6760.0
2005-09-02 08:00:00	CL	Stock	26.32	26.32	26.32	26.32	4600.0
2005-09-02 09:00:00	CL	Stock	26.35	26.35	26.125	26.215	267000.0
2005-09-02 10:00:00	CL	Stock	26.215	26.265	26.135	26.175	330200.0
2005-09-02 11:00:00	CL	Stock	26.18	26.35	26.125	26.21	412400.0
2005-09-02 12:00:00	CL	Stock	26.215	26.26	26.185	26.24	268600.0
2005-09-02 13:00:00	CL	Stock	26.25	26.27	26.2	26.27	316800.0
2005-09-02 14:00:00	CL	Stock	26.27	26.3	26.24	26.274	354600.0
2005-09-02 15:00:00	CL	Stock	26.275	26.29	26.23	26.24	396200.0
2005-09-02 16:00:00	CL	Stock	26.245	26.245	26.245	26.245	200.0

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

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