PREVIEW / stock_1hour / 2005-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-18.parquet
  size:    562 KB
  rows:    26,759
  symbols: 1,986

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-05-18 08:00:00	AAPL	Stock	1.2607	1.2707	1.2596	1.2682	1380120.0
2005-05-18 09:00:00	AAPL	Stock	1.2689	1.2714	1.2496	1.2568	97319012.0
2005-05-18 10:00:00	AAPL	Stock	1.2568	1.2661	1.2536	1.2582	100458064.0
2005-05-18 11:00:00	AAPL	Stock	1.2582	1.2675	1.2568	1.2643	60230772.0
2005-05-18 12:00:00	AAPL	Stock	1.2639	1.2768	1.2625	1.2764	77162344.0
2005-05-18 13:00:00	AAPL	Stock	1.2764	1.285	1.2711	1.2821	89732216.0
2005-05-18 14:00:00	AAPL	Stock	1.2818	1.2907	1.2793	1.285	95211676.0
2005-05-18 15:00:00	AAPL	Stock	1.285	1.3414	1.2746	1.2796	99935836.0
2005-05-18 16:00:00	AAPL	Stock	1.2779	1.2802	1.2714	1.2768	4500048.0
2005-05-18 17:00:00	AAPL	Stock	1.2768	1.28	1.2708	1.28	304360.0
2005-05-18 18:00:00	AAPL	Stock	1.2786	1.2793	1.2782	1.2793	30800.0
2005-05-18 07:00:00	MSFT	Stock	25.44	25.44	25.44	25.44	500.0
2005-05-18 08:00:00	MSFT	Stock	25.45	25.55	25.45	25.55	63150.0
2005-05-18 09:00:00	MSFT	Stock	25.55	25.6	25.42	25.47	10002148.0
2005-05-18 10:00:00	MSFT	Stock	25.47	25.6	25.43	25.58	9218857.0
2005-05-18 11:00:00	MSFT	Stock	25.58	25.66	25.54	25.61	7495908.0
2005-05-18 12:00:00	MSFT	Stock	25.61	25.83	25.6	25.82	10530342.0
2005-05-18 13:00:00	MSFT	Stock	25.82	25.84	25.5	25.732	8671356.0
2005-05-18 14:00:00	MSFT	Stock	25.74	25.8	25.67	25.79	8014001.0
2005-05-18 15:00:00	MSFT	Stock	25.79	25.8	25.67	25.7	13094623.0
2005-05-18 16:00:00	MSFT	Stock	25.71	25.725	25.67	25.7	295644.0
2005-05-18 17:00:00	MSFT	Stock	25.7	25.72	25.67	25.67	1785409.0
2005-05-18 18:00:00	MSFT	Stock	25.69	25.69	25.66	25.67	12309.0
2005-05-18 08:00:00	NVDA	Stock	0.2151	0.2152	0.215	0.215	156000.0
2005-05-18 09:00:00	NVDA	Stock	0.2152	0.2154	0.2114	0.2123	104076360.0
2005-05-18 10:00:00	NVDA	Stock	0.2124	0.216	0.2124	0.2148	113312760.0
2005-05-18 11:00:00	NVDA	Stock	0.2149	0.2153	0.2138	0.2144	64753680.0
2005-05-18 12:00:00	NVDA	Stock	0.2144	0.2159	0.2143	0.2152	63534960.0
2005-05-18 13:00:00	NVDA	Stock	0.2153	0.2157	0.2143	0.2144	42357000.0
2005-05-18 14:00:00	NVDA	Stock	0.2146	0.2158	0.2143	0.2154	46611600.0
2005-05-18 15:00:00	NVDA	Stock	0.2154	0.2162	0.2148	0.2158	98341920.0
2005-05-18 16:00:00	NVDA	Stock	0.2158	0.2161	0.2153	0.216	12777840.0
2005-05-18 17:00:00	NVDA	Stock	0.2159	0.2159	0.2159	0.2159	24000.0
2005-05-18 18:00:00	NVDA	Stock	0.2159	0.2159	0.2159	0.2159	186000.0
2005-05-18 08:00:00	AMZN	Stock	1.735	1.7375	1.735	1.7375	16000.0
2005-05-18 09:00:00	AMZN	Stock	1.7375	1.7485	1.7365	1.7415	11162960.0
2005-05-18 10:00:00	AMZN	Stock	1.742	1.764	1.7385	1.7555	26709720.0
2005-05-18 11:00:00	AMZN	Stock	1.756	1.7625	1.754	1.762	29227600.0
2005-05-18 12:00:00	AMZN	Stock	1.762	1.792	1.76	1.79	32759120.0
2005-05-18 13:00:00	AMZN	Stock	1.7905	1.7985	1.781	1.7835	21506500.0
2005-05-18 14:00:00	AMZN	Stock	1.7835	1.797	1.7835	1.79	14448540.0
2005-05-18 15:00:00	AMZN	Stock	1.79	1.7925	1.766	1.7665	45257820.0
2005-05-18 16:00:00	AMZN	Stock	1.767	1.769	1.76	1.7642	910820.0
2005-05-18 17:00:00	AMZN	Stock	1.7645	1.7645	1.7645	1.7645	20000.0
2005-05-18 09:00:00	CL	Stock	24.83	25.0	24.815	24.98	565400.0
2005-05-18 10:00:00	CL	Stock	24.985	25.035	24.905	24.955	1058200.0
2005-05-18 11:00:00	CL	Stock	24.96	25.05	24.935	25.04	657000.0
2005-05-18 12:00:00	CL	Stock	25.04	25.22	24.975	25.215	670200.0
2005-05-18 13:00:00	CL	Stock	25.208	25.22	25.15	25.17	400800.0
2005-05-18 14:00:00	CL	Stock	25.17	25.215	25.135	25.185	323000.0

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

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