PREVIEW / stock_1hour / 2005-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-28.parquet
  size:    529 KB
  rows:    24,768
  symbols: 1,921

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-28 08:00:00	AAPL	Stock	1.2975	1.2975	1.2946	1.297	602896.0
2005-01-28 09:00:00	AAPL	Stock	1.2964	1.3114	1.2936	1.3079	113833608.0
2005-01-28 10:00:00	AAPL	Stock	1.308	1.3143	1.3023	1.3061	130095672.0
2005-01-28 11:00:00	AAPL	Stock	1.3057	1.3059	1.2955	1.3025	135323440.0
2005-01-28 12:00:00	AAPL	Stock	1.3025	1.3036	1.2968	1.2975	41911128.0
2005-01-28 13:00:00	AAPL	Stock	1.2975	1.3102	1.2952	1.3057	88781448.0
2005-01-28 14:00:00	AAPL	Stock	1.3057	1.3134	1.3002	1.3129	88831288.0
2005-01-28 15:00:00	AAPL	Stock	1.3129	1.3209	1.308	1.3209	179425008.0
2005-01-28 16:00:00	AAPL	Stock	1.3195	1.3268	1.3163	1.3243	8567048.0
2005-01-28 17:00:00	AAPL	Stock	1.3243	1.3266	1.3236	1.3239	622160.0
2005-01-28 18:00:00	AAPL	Stock	1.3232	1.3232	1.3232	1.3232	151200.0
2005-01-28 08:00:00	MSFT	Stock	26.7	26.8	26.63	26.63	1864496.0
2005-01-28 09:00:00	MSFT	Stock	26.64	26.65	26.16	26.41	24987391.0
2005-01-28 10:00:00	MSFT	Stock	26.41	26.49	26.24	26.26	21880091.0
2005-01-28 11:00:00	MSFT	Stock	26.26	26.26	25.96	26.12	19341324.0
2005-01-28 12:00:00	MSFT	Stock	26.11	26.553	26.03	26.09	6236892.0
2005-01-28 13:00:00	MSFT	Stock	26.1	26.2	26.08	26.16	8535685.0
2005-01-28 14:00:00	MSFT	Stock	26.16	26.17	26.09	26.129	8233516.0
2005-01-28 15:00:00	MSFT	Stock	26.13	26.251	26.09	26.19	15761645.0
2005-01-28 16:00:00	MSFT	Stock	26.19	26.22	26.15	26.2	1161135.0
2005-01-28 17:00:00	MSFT	Stock	26.2	26.21	26.19	26.21	36790.0
2005-01-28 18:00:00	MSFT	Stock	26.22	26.24	26.2	26.21	9743.0
2005-01-28 08:00:00	NVDA	Stock	0.1917	0.1921	0.1917	0.1921	120000.0
2005-01-28 09:00:00	NVDA	Stock	0.1917	0.1924	0.1889	0.1911	131611080.0
2005-01-28 10:00:00	NVDA	Stock	0.191	0.1919	0.1901	0.1901	109526040.0
2005-01-28 11:00:00	NVDA	Stock	0.1901	0.1906	0.1884	0.1897	192691560.0
2005-01-28 12:00:00	NVDA	Stock	0.1897	0.1899	0.1875	0.1879	43045680.0
2005-01-28 13:00:00	NVDA	Stock	0.1878	0.1885	0.1865	0.1877	42480840.0
2005-01-28 14:00:00	NVDA	Stock	0.1877	0.1902	0.1876	0.1894	52231080.0
2005-01-28 15:00:00	NVDA	Stock	0.1895	0.1907	0.1887	0.1906	90074640.0
2005-01-28 16:00:00	NVDA	Stock	0.1906	0.1917	0.1904	0.1907	3921000.0
2005-01-28 17:00:00	NVDA	Stock	0.1908	0.1908	0.1906	0.1906	540000.0
2005-01-28 18:00:00	NVDA	Stock	0.1907	0.1908	0.1902	0.1908	691200.0
2005-01-28 08:00:00	AMZN	Stock	2.1125	2.115	2.11	2.11	98540.0
2005-01-28 09:00:00	AMZN	Stock	2.11	2.15	2.1	2.1195	25332080.0
2005-01-28 10:00:00	AMZN	Stock	2.119	2.14	2.1115	2.1145	20966680.0
2005-01-28 11:00:00	AMZN	Stock	2.114	2.1195	2.0965	2.1	14298940.0
2005-01-28 12:00:00	AMZN	Stock	2.1	2.1035	2.0815	2.0895	9186040.0
2005-01-28 13:00:00	AMZN	Stock	2.09	2.098	2.078	2.078	8231260.0
2005-01-28 14:00:00	AMZN	Stock	2.0775	2.099	2.0765	2.097	16940600.0
2005-01-28 15:00:00	AMZN	Stock	2.0965	2.1115	2.093	2.111	23257280.0
2005-01-28 16:00:00	AMZN	Stock	2.1105	2.111	2.1055	2.111	1566600.0
2005-01-28 08:00:00	CL	Stock	26.345	26.345	26.0	26.34	7200.0
2005-01-28 09:00:00	CL	Stock	26.325	26.33	25.84	25.84	2859600.0
2005-01-28 10:00:00	CL	Stock	25.825	25.885	25.22	25.27	3646200.0
2005-01-28 11:00:00	CL	Stock	25.27	25.615	25.18	25.57	2109600.0
2005-01-28 12:00:00	CL	Stock	25.555	25.605	25.425	25.505	1122400.0
2005-01-28 13:00:00	CL	Stock	25.505	26.1	25.48	25.64	1524000.0
2005-01-28 14:00:00	CL	Stock	25.635	25.78	25.63	25.745	1086200.0
2005-01-28 15:00:00	CL	Stock	25.745	25.945	25.745	25.84	1707600.0

> showing 50 of 24,768 rows — these rows as CSV

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