PREVIEW / stock_1hour / 2009-04-15

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-15.parquet
  size:    801 KB
  rows:    39,671
  symbols: 3,308

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
2009-04-15 07:00:00	AAPL	Stock	4.2054	4.2071	4.2018	4.2018	114800.0
2009-04-15 08:00:00	AAPL	Stock	4.1971	4.2025	4.1814	4.1825	383236.0
2009-04-15 09:00:00	AAPL	Stock	4.1839	4.2086	4.1714	4.2007	56129416.0
2009-04-15 10:00:00	AAPL	Stock	4.2011	4.2232	4.1536	4.1554	61544784.0
2009-04-15 11:00:00	AAPL	Stock	4.1554	4.1671	4.1343	4.1579	51990596.0
2009-04-15 12:00:00	AAPL	Stock	4.1578	4.1668	4.1504	4.1554	30037560.0
2009-04-15 13:00:00	AAPL	Stock	4.1554	4.2018	4.1549	4.1786	52383072.0
2009-04-15 14:00:00	AAPL	Stock	4.1786	4.1918	4.145	4.1546	53390148.0
2009-04-15 15:00:00	AAPL	Stock	4.1543	4.2079	4.1532	4.1979	90617884.0
2009-04-15 16:00:00	AAPL	Stock	4.2025	4.2071	4.173	4.2029	12558896.0
2009-04-15 17:00:00	AAPL	Stock	4.2018	4.2054	4.1982	4.2054	102032.0
2009-04-15 18:00:00	AAPL	Stock	4.2014	4.2136	4.2014	4.2082	284984.0
2009-04-15 19:00:00	AAPL	Stock	4.2121	4.2125	4.2107	4.2107	92400.0
2009-04-15 04:00:00	MSFT	Stock	19.11	19.11	19.11	19.11	250.0
2009-04-15 07:00:00	MSFT	Stock	19.26	19.3	19.06	19.1	21100.0
2009-04-15 08:00:00	MSFT	Stock	19.08	19.28	19.08	19.2	35025.0
2009-04-15 09:00:00	MSFT	Stock	19.2	19.26	18.61	18.81	11548490.0
2009-04-15 10:00:00	MSFT	Stock	18.81	18.99	18.61	18.61	12993440.0
2009-04-15 11:00:00	MSFT	Stock	18.61	18.73	18.51	18.71	9434090.0
2009-04-15 12:00:00	MSFT	Stock	18.71	18.89	18.66	18.85	5831114.0
2009-04-15 13:00:00	MSFT	Stock	18.85	18.92	18.8	18.92	6041842.0
2009-04-15 14:00:00	MSFT	Stock	18.92	18.92	18.52	18.6	8979748.0
2009-04-15 15:00:00	MSFT	Stock	18.61	18.9	18.6	18.85	14497335.0
2009-04-15 16:00:00	MSFT	Stock	18.85	18.9	18.666	18.85	2368876.0
2009-04-15 17:00:00	MSFT	Stock	18.88	18.9	18.86	18.9	5213.0
2009-04-15 18:00:00	MSFT	Stock	18.83	18.97	18.83	18.92	213709.0
2009-04-15 19:00:00	MSFT	Stock	18.95	18.96	18.92	18.93	3760.0
2009-04-15 08:00:00	NVDA	Stock	0.2818	0.2825	0.2788	0.282	138000.0
2009-04-15 09:00:00	NVDA	Stock	0.2818	0.285	0.2785	0.2795	128226600.0
2009-04-15 10:00:00	NVDA	Stock	0.2795	0.2838	0.2772	0.2775	163246920.0
2009-04-15 11:00:00	NVDA	Stock	0.2772	0.2783	0.2728	0.2746	133133080.0
2009-04-15 12:00:00	NVDA	Stock	0.2745	0.2778	0.2743	0.2768	79252720.0
2009-04-15 13:00:00	NVDA	Stock	0.2768	0.2812	0.2768	0.2796	111178840.0
2009-04-15 14:00:00	NVDA	Stock	0.2798	0.2815	0.275	0.2772	149928360.0
2009-04-15 15:00:00	NVDA	Stock	0.2772	0.286	0.277	0.2845	223478120.0
2009-04-15 16:00:00	NVDA	Stock	0.2852	0.286	0.2752	0.286	38621800.0
2009-04-15 19:00:00	NVDA	Stock	0.287	0.287	0.287	0.287	4000.0
2009-04-15 04:00:00	AMZN	Stock	3.82	3.82	3.82	3.82	4000.0
2009-04-15 08:00:00	AMZN	Stock	3.8375	3.8375	3.82	3.8375	14100.0
2009-04-15 09:00:00	AMZN	Stock	3.835	3.835	3.7125	3.7465	31988720.0
2009-04-15 10:00:00	AMZN	Stock	3.7465	3.78	3.716	3.72	28593880.0
2009-04-15 11:00:00	AMZN	Stock	3.7205	3.734	3.702	3.7215	16985860.0
2009-04-15 12:00:00	AMZN	Stock	3.7215	3.726	3.6895	3.707	14431260.0
2009-04-15 13:00:00	AMZN	Stock	3.7075	3.7185	3.691	3.7	18711320.0
2009-04-15 14:00:00	AMZN	Stock	3.7	3.7125	3.6755	3.6885	27322300.0
2009-04-15 15:00:00	AMZN	Stock	3.6875	3.7495	3.6815	3.739	43853460.0
2009-04-15 16:00:00	AMZN	Stock	3.735	3.861	3.7177	3.7325	3266420.0
2009-04-15 17:00:00	AMZN	Stock	3.7325	3.7325	3.7315	3.7325	16000.0
2009-04-15 18:00:00	AMZN	Stock	3.7325	3.745	3.7325	3.745	24000.0
2009-04-15 19:00:00	AMZN	Stock	3.74	3.75	3.74	3.75	14160.0

> showing 50 of 39,671 rows — these rows as CSV

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