PREVIEW / stock_1hour / 2005-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-10.parquet
  size:    535 KB
  rows:    25,520
  symbols: 1,910

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-10 08:00:00	AAPL	Stock	1.25	1.2677	1.25	1.2571	11667488.0
2005-01-10 09:00:00	AAPL	Stock	1.2571	1.2571	1.2304	1.2355	260194088.0
2005-01-10 10:00:00	AAPL	Stock	1.2359	1.2371	1.2121	1.218	319715872.0
2005-01-10 11:00:00	AAPL	Stock	1.2177	1.2418	1.2161	1.2234	130359600.0
2005-01-10 12:00:00	AAPL	Stock	1.2236	1.2436	1.2205	1.2427	134627752.0
2005-01-10 13:00:00	AAPL	Stock	1.2429	1.2625	1.2366	1.2509	311280648.0
2005-01-10 14:00:00	AAPL	Stock	1.2513	1.2554	1.2259	1.2386	297925488.0
2005-01-10 15:00:00	AAPL	Stock	1.2384	1.2407	1.2182	1.2309	238000728.0
2005-01-10 16:00:00	AAPL	Stock	1.2309	1.2379	1.2286	1.2314	8248072.0
2005-01-10 17:00:00	AAPL	Stock	1.2316	1.2316	1.23	1.2311	3877216.0
2005-01-10 18:00:00	AAPL	Stock	1.2313	1.2318	1.2289	1.2318	286552.0
2005-01-10 08:00:00	MSFT	Stock	26.68	26.75	26.68	26.7	22999.0
2005-01-10 09:00:00	MSFT	Stock	26.69	26.71	26.54	26.71	6987639.0
2005-01-10 10:00:00	MSFT	Stock	26.7	26.83	26.63	26.778	10403165.0
2005-01-10 11:00:00	MSFT	Stock	26.78	26.86	26.75	26.81	7879326.0
2005-01-10 12:00:00	MSFT	Stock	26.81	26.86	26.78	26.81	4428139.0
2005-01-10 13:00:00	MSFT	Stock	26.81	26.85	26.77	26.79	6315629.0
2005-01-10 14:00:00	MSFT	Stock	26.79	26.85	26.75	26.8	7409913.0
2005-01-10 15:00:00	MSFT	Stock	26.8	26.83	26.64	26.8	20477858.0
2005-01-10 16:00:00	MSFT	Stock	26.81	26.84	26.67	26.8	3268658.0
2005-01-10 17:00:00	MSFT	Stock	26.81	26.81	26.78	26.81	795722.0
2005-01-10 18:00:00	MSFT	Stock	26.81	26.81	26.81	26.81	2000.0
2005-01-10 08:00:00	NVDA	Stock	0.1836	0.1848	0.1836	0.1848	1308000.0
2005-01-10 09:00:00	NVDA	Stock	0.1847	0.1858	0.1834	0.1847	94512720.0
2005-01-10 10:00:00	NVDA	Stock	0.1847	0.1858	0.1837	0.1848	82674240.0
2005-01-10 11:00:00	NVDA	Stock	0.1846	0.1851	0.1837	0.1844	117543600.0
2005-01-10 12:00:00	NVDA	Stock	0.1845	0.1847	0.1839	0.1843	26310840.0
2005-01-10 13:00:00	NVDA	Stock	0.1843	0.1847	0.1837	0.1839	69904800.0
2005-01-10 14:00:00	NVDA	Stock	0.1839	0.1846	0.1839	0.1843	65414160.0
2005-01-10 15:00:00	NVDA	Stock	0.1843	0.1847	0.1829	0.184	109447920.0
2005-01-10 16:00:00	NVDA	Stock	0.1839	0.184	0.1836	0.1836	2132520.0
2005-01-10 17:00:00	NVDA	Stock	0.184	0.184	0.184	0.184	1317240.0
2005-01-10 08:00:00	AMZN	Stock	2.115	2.116	2.115	2.116	9140.0
2005-01-10 09:00:00	AMZN	Stock	2.1205	2.124	2.093	2.115	20307620.0
2005-01-10 10:00:00	AMZN	Stock	2.116	2.148	2.1135	2.143	32166860.0
2005-01-10 11:00:00	AMZN	Stock	2.1415	2.1475	2.1325	2.1385	13962900.0
2005-01-10 12:00:00	AMZN	Stock	2.139	2.146	2.115	2.127	19286600.0
2005-01-10 13:00:00	AMZN	Stock	2.1265	2.139	2.1205	2.1326	10000260.0
2005-01-10 14:00:00	AMZN	Stock	2.133	2.133	2.1045	2.106	17167280.0
2005-01-10 15:00:00	AMZN	Stock	2.106	2.108	2.0855	2.0925	31566940.0
2005-01-10 16:00:00	AMZN	Stock	2.0925	2.096	2.0875	2.092	1006920.0
2005-01-10 17:00:00	AMZN	Stock	2.0925	2.0997	2.092	2.092	664560.0
2005-01-10 09:00:00	CL	Stock	25.04	25.125	25.025	25.11	300000.0
2005-01-10 10:00:00	CL	Stock	25.11	25.365	25.095	25.235	1250000.0
2005-01-10 11:00:00	CL	Stock	25.235	25.295	25.23	25.28	331800.0
2005-01-10 12:00:00	CL	Stock	25.285	25.34	25.23	25.315	368200.0
2005-01-10 13:00:00	CL	Stock	25.315	25.4	25.3	25.395	445000.0
2005-01-10 14:00:00	CL	Stock	25.395	25.405	25.31	25.4	634000.0
2005-01-10 15:00:00	CL	Stock	25.395	25.42	25.215	25.23	825800.0
2005-01-10 16:00:00	CL	Stock	25.27	25.27	25.2695	25.27	255200.0

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

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