PREVIEW / stock_1hour / 2005-01-21

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-21.parquet
  size:    539 KB
  rows:    25,070
  symbols: 1,908

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-01-21 08:00:00	AAPL	Stock	1.2813	1.2821	1.2668	1.2802	5905144.0
2005-01-21 09:00:00	AAPL	Stock	1.2802	1.2802	1.2582	1.2721	238683312.0
2005-01-21 10:00:00	AAPL	Stock	1.2721	1.2746	1.2636	1.2668	149119656.0
2005-01-21 11:00:00	AAPL	Stock	1.2666	1.2714	1.2643	1.2696	66731616.0
2005-01-21 12:00:00	AAPL	Stock	1.2698	1.2705	1.2618	1.2659	65773736.0
2005-01-21 13:00:00	AAPL	Stock	1.2659	1.2661	1.2559	1.2604	108863776.0
2005-01-21 14:00:00	AAPL	Stock	1.2605	1.2639	1.252	1.2534	95237968.0
2005-01-21 15:00:00	AAPL	Stock	1.2534	1.2627	1.25	1.2595	167481496.0
2005-01-21 16:00:00	AAPL	Stock	1.2595	1.2698	1.2563	1.2613	6662096.0
2005-01-21 17:00:00	AAPL	Stock	1.2611	1.2643	1.2611	1.2625	786296.0
2005-01-21 18:00:00	AAPL	Stock	1.2634	1.2634	1.2625	1.2625	44800.0
2005-01-21 08:00:00	MSFT	Stock	26.06	26.06	25.91	26.0	464177.0
2005-01-21 09:00:00	MSFT	Stock	26.0	26.09	25.75	26.07	18162676.0
2005-01-21 10:00:00	MSFT	Stock	26.07	26.13	25.97	26.09	11601119.0
2005-01-21 11:00:00	MSFT	Stock	26.08	26.09	25.97	25.98	5860733.0
2005-01-21 12:00:00	MSFT	Stock	25.97	25.98	25.9	25.93	6679041.0
2005-01-21 13:00:00	MSFT	Stock	25.93	25.94	25.83	25.87	8670095.0
2005-01-21 14:00:00	MSFT	Stock	25.87	25.93	25.75	25.77	6494209.0
2005-01-21 15:00:00	MSFT	Stock	25.76	25.84	25.65	25.65	13630015.0
2005-01-21 16:00:00	MSFT	Stock	25.65	25.94	25.65	25.7	2848356.0
2005-01-21 17:00:00	MSFT	Stock	25.7	25.7	25.67	25.69	12700.0
2005-01-21 18:00:00	MSFT	Stock	25.7	25.7	25.7	25.7	1647.0
2005-01-21 09:00:00	NVDA	Stock	0.1786	0.1814	0.178	0.1792	66988320.0
2005-01-21 10:00:00	NVDA	Stock	0.1792	0.1822	0.1786	0.1808	123919680.0
2005-01-21 11:00:00	NVDA	Stock	0.1808	0.182	0.1804	0.1811	50596080.0
2005-01-21 12:00:00	NVDA	Stock	0.1811	0.1817	0.18	0.1814	57782160.0
2005-01-21 13:00:00	NVDA	Stock	0.1814	0.1815	0.1783	0.1797	75919320.0
2005-01-21 14:00:00	NVDA	Stock	0.1797	0.1808	0.1792	0.1803	101543280.0
2005-01-21 15:00:00	NVDA	Stock	0.1803	0.1805	0.1781	0.1786	112512840.0
2005-01-21 16:00:00	NVDA	Stock	0.1787	0.1799	0.1787	0.1787	971280.0
2005-01-21 17:00:00	NVDA	Stock	0.1783	0.1783	0.1783	0.1783	12000.0
2005-01-21 08:00:00	AMZN	Stock	2.1125	2.124	2.1075	2.11	421460.0
2005-01-21 09:00:00	AMZN	Stock	2.11	2.119	2.085	2.1055	39350140.0
2005-01-21 10:00:00	AMZN	Stock	2.105	2.1175	2.0918	2.114	31852480.0
2005-01-21 11:00:00	AMZN	Stock	2.1135	2.1275	2.1105	2.117	16737160.0
2005-01-21 12:00:00	AMZN	Stock	2.1175	2.1195	2.106	2.109	14162480.0
2005-01-21 13:00:00	AMZN	Stock	2.109	2.111	2.0885	2.0975	24350720.0
2005-01-21 14:00:00	AMZN	Stock	2.097	2.1015	2.07	2.072	32365240.0
2005-01-21 15:00:00	AMZN	Stock	2.072	2.0735	2.051	2.062	49935260.0
2005-01-21 16:00:00	AMZN	Stock	2.061	2.0935	2.058	2.058	951440.0
2005-01-21 17:00:00	AMZN	Stock	2.065	2.065	2.065	2.065	12000.0
2005-01-21 18:00:00	AMZN	Stock	2.065	2.0725	2.065	2.0725	12000.0
2005-01-21 09:00:00	CL	Stock	25.06	25.135	25.0	25.035	382200.0
2005-01-21 10:00:00	CL	Stock	25.04	25.075	24.89	24.9	574800.0
2005-01-21 11:00:00	CL	Stock	24.9	24.935	24.755	24.765	528200.0
2005-01-21 12:00:00	CL	Stock	24.76	24.9	24.72	24.87	549800.0
2005-01-21 13:00:00	CL	Stock	24.87	24.915	24.835	24.91	462000.0
2005-01-21 14:00:00	CL	Stock	24.915	24.945	24.855	24.89	362600.0
2005-01-21 15:00:00	CL	Stock	24.89	24.985	24.86	24.905	785200.0
2005-01-21 16:00:00	CL	Stock	24.9	24.9	24.9	24.9	800.0

> showing 50 of 25,070 rows — these rows as CSV

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