PREVIEW / stock_1hour / 2005-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-11.parquet
  size:    557 KB
  rows:    26,498
  symbols: 2,054

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-08-11 08:00:00	AAPL	Stock	1.5536	1.5571	1.5493	1.55	276612.0
2005-08-11 09:00:00	AAPL	Stock	1.5493	1.5586	1.5446	1.555	31304784.0
2005-08-11 10:00:00	AAPL	Stock	1.5554	1.5721	1.5546	1.5675	52798172.0
2005-08-11 11:00:00	AAPL	Stock	1.5675	1.5704	1.5607	1.5679	29189300.0
2005-08-11 12:00:00	AAPL	Stock	1.5675	1.5679	1.5593	1.5625	24799824.0
2005-08-11 13:00:00	AAPL	Stock	1.5625	1.5664	1.5614	1.565	15517124.0
2005-08-11 14:00:00	AAPL	Stock	1.5654	1.5707	1.5632	1.5679	37419396.0
2005-08-11 15:00:00	AAPL	Stock	1.5682	1.5757	1.5664	1.5707	68898984.0
2005-08-11 16:00:00	AAPL	Stock	1.5714	1.5725	1.5593	1.5614	7432964.0
2005-08-11 17:00:00	AAPL	Stock	1.5618	1.57	1.5607	1.5625	603764.0
2005-08-11 18:00:00	AAPL	Stock	1.5714	1.5714	1.5625	1.5629	40096.0
2005-08-11 07:00:00	MSFT	Stock	26.99	26.99	26.99	26.99	500.0
2005-08-11 08:00:00	MSFT	Stock	27.0	27.05	26.95	27.0	49214.0
2005-08-11 09:00:00	MSFT	Stock	27.02	27.18	26.96	27.071	5589239.0
2005-08-11 10:00:00	MSFT	Stock	27.08	27.3	27.06	27.19	9178720.0
2005-08-11 11:00:00	MSFT	Stock	27.19	27.201	27.039	27.1	4120436.0
2005-08-11 12:00:00	MSFT	Stock	27.11	27.11	26.95	27.05	4830370.0
2005-08-11 13:00:00	MSFT	Stock	27.05	27.07	26.92	26.95	5643046.0
2005-08-11 14:00:00	MSFT	Stock	26.95	27.08	26.89	27.07	5548600.0
2005-08-11 15:00:00	MSFT	Stock	27.07	27.3	27.06	27.29	11059831.0
2005-08-11 16:00:00	MSFT	Stock	27.26	27.331	27.0	27.1	1202480.0
2005-08-11 17:00:00	MSFT	Stock	27.29	27.29	27.12	27.17	13604.0
2005-08-11 18:00:00	MSFT	Stock	27.29	27.29	27.14	27.16	37708.0
2005-08-11 08:00:00	NVDA	Stock	0.2325	0.2325	0.2321	0.2321	204000.0
2005-08-11 09:00:00	NVDA	Stock	0.2321	0.2329	0.2299	0.2307	59566920.0
2005-08-11 10:00:00	NVDA	Stock	0.2307	0.2337	0.2307	0.2327	118319400.0
2005-08-11 11:00:00	NVDA	Stock	0.2327	0.2348	0.2326	0.2333	94413000.0
2005-08-11 12:00:00	NVDA	Stock	0.2333	0.2335	0.2311	0.233	50007000.0
2005-08-11 13:00:00	NVDA	Stock	0.2331	0.2333	0.2321	0.2331	38364240.0
2005-08-11 14:00:00	NVDA	Stock	0.2331	0.2337	0.2322	0.2337	58302960.0
2005-08-11 15:00:00	NVDA	Stock	0.2338	0.2358	0.2332	0.235	167829840.0
2005-08-11 16:00:00	NVDA	Stock	0.2353	0.2417	0.2167	0.2313	102996240.0
2005-08-11 17:00:00	NVDA	Stock	0.2324	0.2512	0.23	0.2492	191653200.0
2005-08-11 18:00:00	NVDA	Stock	0.2496	0.2502	0.2354	0.25	23607960.0
2005-08-11 08:00:00	AMZN	Stock	2.2445	2.2445	2.2375	2.239	10000.0
2005-08-11 09:00:00	AMZN	Stock	2.2345	2.242	2.225	2.233	20159060.0
2005-08-11 10:00:00	AMZN	Stock	2.2325	2.2555	2.229	2.2545	19864960.0
2005-08-11 11:00:00	AMZN	Stock	2.255	2.2565	2.236	2.236	15743200.0
2005-08-11 12:00:00	AMZN	Stock	2.2365	2.2485	2.236	2.2485	11252620.0
2005-08-11 13:00:00	AMZN	Stock	2.248	2.25	2.2435	2.2435	8644200.0
2005-08-11 14:00:00	AMZN	Stock	2.2435	2.2445	2.2365	2.237	13597100.0
2005-08-11 15:00:00	AMZN	Stock	2.2365	2.2606	2.2345	2.2585	24001320.0
2005-08-11 16:00:00	AMZN	Stock	2.261	2.261	2.2404	2.251	2070360.0
2005-08-11 17:00:00	AMZN	Stock	2.256	2.2565	2.2525	2.2565	83120.0
2005-08-11 18:00:00	AMZN	Stock	2.254	2.254	2.251	2.251	269920.0
2005-08-11 09:00:00	CL	Stock	26.375	26.5	26.315	26.32	174000.0
2005-08-11 10:00:00	CL	Stock	26.315	26.405	26.295	26.34	327600.0
2005-08-11 11:00:00	CL	Stock	26.34	26.38	26.31	26.375	423400.0
2005-08-11 12:00:00	CL	Stock	26.37	26.38	26.315	26.33	209400.0
2005-08-11 13:00:00	CL	Stock	26.325	26.375	26.325	26.345	237400.0

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

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