PREVIEW / stock_1hour / 2005-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-09.parquet
  size:    546 KB
  rows:    25,885
  symbols: 1,964

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-09 08:00:00	AAPL	Stock	1.3321	1.3364	1.33	1.335	1189496.0
2005-05-09 09:00:00	AAPL	Stock	1.3354	1.3375	1.3171	1.3196	50853544.0
2005-05-09 10:00:00	AAPL	Stock	1.3196	1.32	1.3125	1.3146	73754688.0
2005-05-09 11:00:00	AAPL	Stock	1.3146	1.3286	1.3136	1.3232	52237332.0
2005-05-09 12:00:00	AAPL	Stock	1.3229	1.3261	1.3189	1.3225	28364168.0
2005-05-09 13:00:00	AAPL	Stock	1.3221	1.3243	1.3193	1.3229	25186812.0
2005-05-09 14:00:00	AAPL	Stock	1.3225	1.3229	1.3132	1.3182	53054344.0
2005-05-09 15:00:00	AAPL	Stock	1.3182	1.3214	1.3154	1.3204	59176068.0
2005-05-09 16:00:00	AAPL	Stock	1.3193	1.3204	1.3171	1.3189	2972564.0
2005-05-09 17:00:00	AAPL	Stock	1.3189	1.3204	1.3189	1.3204	245364.0
2005-05-09 18:00:00	AAPL	Stock	1.3204	1.3214	1.3193	1.3193	30800.0
2005-05-09 08:00:00	MSFT	Stock	25.26	25.26	25.2	25.23	29755.0
2005-05-09 09:00:00	MSFT	Stock	25.24	25.3	25.19	25.24	6199286.0
2005-05-09 10:00:00	MSFT	Stock	25.25	25.26	25.11	25.12	8243166.0
2005-05-09 11:00:00	MSFT	Stock	25.12	25.221	25.11	25.18	6655985.0
2005-05-09 12:00:00	MSFT	Stock	25.178	25.23	25.15	25.18	4368013.0
2005-05-09 13:00:00	MSFT	Stock	25.19	25.2	25.15	25.16	3322510.0
2005-05-09 14:00:00	MSFT	Stock	25.16	25.33	25.07	25.09	7659703.0
2005-05-09 15:00:00	MSFT	Stock	25.1	25.19	25.05	25.11	14678367.0
2005-05-09 16:00:00	MSFT	Stock	25.12	25.18	25.11	25.12	2382608.0
2005-05-09 17:00:00	MSFT	Stock	25.16	25.16	25.12	25.15	34815.0
2005-05-09 18:00:00	MSFT	Stock	25.15	25.15	25.12	25.12	11823.0
2005-05-09 08:00:00	NVDA	Stock	0.193	0.193	0.193	0.193	24000.0
2005-05-09 09:00:00	NVDA	Stock	0.193	0.1958	0.193	0.1946	87850320.0
2005-05-09 10:00:00	NVDA	Stock	0.1946	0.1946	0.1927	0.1942	138943560.0
2005-05-09 11:00:00	NVDA	Stock	0.1941	0.1957	0.1938	0.1956	102300720.0
2005-05-09 12:00:00	NVDA	Stock	0.1957	0.1958	0.1952	0.1955	92744160.0
2005-05-09 13:00:00	NVDA	Stock	0.1955	0.198	0.1952	0.1973	91496520.0
2005-05-09 14:00:00	NVDA	Stock	0.1973	0.1974	0.1963	0.1968	63603720.0
2005-05-09 15:00:00	NVDA	Stock	0.1967	0.197	0.1959	0.1967	142833960.0
2005-05-09 16:00:00	NVDA	Stock	0.1967	0.1968	0.1959	0.1959	17118360.0
2005-05-09 17:00:00	NVDA	Stock	0.196	0.1967	0.1954	0.1954	26892600.0
2005-05-09 18:00:00	NVDA	Stock	0.1958	0.1958	0.1958	0.1958	60000.0
2005-05-09 08:00:00	AMZN	Stock	1.726	1.726	1.726	1.726	2000.0
2005-05-09 09:00:00	AMZN	Stock	1.726	1.726	1.7125	1.7205	11499960.0
2005-05-09 10:00:00	AMZN	Stock	1.7205	1.7235	1.7135	1.723	20792420.0
2005-05-09 11:00:00	AMZN	Stock	1.723	1.734	1.721	1.7315	10093800.0
2005-05-09 12:00:00	AMZN	Stock	1.7315	1.74	1.7315	1.737	9273960.0
2005-05-09 13:00:00	AMZN	Stock	1.737	1.7375	1.733	1.7335	5012160.0
2005-05-09 14:00:00	AMZN	Stock	1.733	1.735	1.724	1.725	9184220.0
2005-05-09 15:00:00	AMZN	Stock	1.7255	1.7335	1.7195	1.731	20446400.0
2005-05-09 16:00:00	AMZN	Stock	1.731	1.732	1.725	1.732	399820.0
2005-05-09 17:00:00	AMZN	Stock	1.732	1.7335	1.7306	1.7306	135820.0
2005-05-09 09:00:00	CL	Stock	24.625	24.64	24.49	24.6	366400.0
2005-05-09 10:00:00	CL	Stock	24.6	24.625	24.47	24.505	632600.0
2005-05-09 11:00:00	CL	Stock	24.51	24.595	24.49	24.555	398800.0
2005-05-09 12:00:00	CL	Stock	24.555	24.59	24.535	24.555	549400.0
2005-05-09 13:00:00	CL	Stock	24.55	24.55	24.51	24.54	602400.0
2005-05-09 14:00:00	CL	Stock	24.54	24.54	24.49	24.52	643400.0
2005-05-09 15:00:00	CL	Stock	24.52	24.54	24.46	24.49	1269600.0

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

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