PREVIEW / stock_1hour / 2005-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-01.parquet
  size:    564 KB
  rows:    26,760
  symbols: 2,063

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-08-01 08:00:00	AAPL	Stock	1.5232	1.525	1.5111	1.5214	794724.0
2005-08-01 09:00:00	AAPL	Stock	1.5214	1.5361	1.515	1.5268	45667244.0
2005-08-01 10:00:00	AAPL	Stock	1.5268	1.5275	1.5029	1.5182	70257656.0
2005-08-01 11:00:00	AAPL	Stock	1.5186	1.5307	1.5139	1.5293	47019616.0
2005-08-01 12:00:00	AAPL	Stock	1.5293	1.5321	1.5157	1.5286	27454308.0
2005-08-01 13:00:00	AAPL	Stock	1.5289	1.5304	1.5171	1.5254	29258656.0
2005-08-01 14:00:00	AAPL	Stock	1.5257	1.5386	1.525	1.5304	43968512.0
2005-08-01 15:00:00	AAPL	Stock	1.5307	1.5339	1.525	1.5254	38440108.0
2005-08-01 16:00:00	AAPL	Stock	1.5257	1.5279	1.5214	1.5268	1455664.0
2005-08-01 17:00:00	AAPL	Stock	1.5268	1.5268	1.525	1.5254	169596.0
2005-08-01 18:00:00	AAPL	Stock	1.5254	1.5254	1.5254	1.5254	53424.0
2005-08-01 07:00:00	MSFT	Stock	25.8	25.8	25.76	25.76	106500.0
2005-08-01 08:00:00	MSFT	Stock	25.76	26.0	25.73	25.79	140107.0
2005-08-01 09:00:00	MSFT	Stock	25.79	25.92	25.61	25.92	9021999.0
2005-08-01 10:00:00	MSFT	Stock	25.91	25.98	25.85	25.89	12445301.0
2005-08-01 11:00:00	MSFT	Stock	25.89	25.94	25.85	25.938	5439173.0
2005-08-01 12:00:00	MSFT	Stock	25.94	25.99	25.91	25.94	7044988.0
2005-08-01 13:00:00	MSFT	Stock	25.94	25.96	25.9	25.92	3958870.0
2005-08-01 14:00:00	MSFT	Stock	25.92	26.05	25.91	25.97	11446182.0
2005-08-01 15:00:00	MSFT	Stock	25.97	26.01	25.91	25.91	10073525.0
2005-08-01 16:00:00	MSFT	Stock	25.9	25.97	25.85	25.92	484864.0
2005-08-01 17:00:00	MSFT	Stock	25.87	25.92	25.87	25.89	12124.0
2005-08-01 18:00:00	MSFT	Stock	25.89	25.9	25.89	25.89	3740.0
2005-08-01 09:00:00	NVDA	Stock	0.2257	0.2277	0.2257	0.2273	43736640.0
2005-08-01 10:00:00	NVDA	Stock	0.2275	0.2286	0.2254	0.2267	66687240.0
2005-08-01 11:00:00	NVDA	Stock	0.2267	0.2267	0.2253	0.2254	38868240.0
2005-08-01 12:00:00	NVDA	Stock	0.2256	0.227	0.2255	0.2267	26079480.0
2005-08-01 13:00:00	NVDA	Stock	0.2267	0.2272	0.226	0.2272	24487200.0
2005-08-01 14:00:00	NVDA	Stock	0.2272	0.2291	0.2272	0.2287	77336880.0
2005-08-01 15:00:00	NVDA	Stock	0.2287	0.2299	0.2283	0.2288	103645320.0
2005-08-01 16:00:00	NVDA	Stock	0.2286	0.2289	0.2259	0.2284	3636480.0
2005-08-01 17:00:00	NVDA	Stock	0.2289	0.2297	0.2289	0.2297	528000.0
2005-08-01 18:00:00	NVDA	Stock	0.2292	0.2292	0.2292	0.2292	84000.0
2005-08-01 08:00:00	AMZN	Stock	2.2525	2.26	2.2525	2.255	458400.0
2005-08-01 09:00:00	AMZN	Stock	2.255	2.2575	2.2315	2.2379	24790720.0
2005-08-01 10:00:00	AMZN	Stock	2.238	2.248	2.2235	2.225	28359600.0
2005-08-01 11:00:00	AMZN	Stock	2.225	2.24	2.2175	2.234	15379240.0
2005-08-01 12:00:00	AMZN	Stock	2.234	2.242	2.234	2.2355	12735640.0
2005-08-01 13:00:00	AMZN	Stock	2.236	2.239	2.2295	2.237	10384340.0
2005-08-01 14:00:00	AMZN	Stock	2.2375	2.2595	2.2365	2.256	24991380.0
2005-08-01 15:00:00	AMZN	Stock	2.256	2.2575	2.2435	2.248	21828740.0
2005-08-01 16:00:00	AMZN	Stock	2.247	2.2585	2.245	2.2575	852380.0
2005-08-01 17:00:00	AMZN	Stock	2.256	2.256	2.247	2.255	49240.0
2005-08-01 18:00:00	AMZN	Stock	2.2515	2.257	2.2515	2.257	13000.0
2005-08-01 09:00:00	CL	Stock	26.575	26.685	26.48	26.625	337600.0
2005-08-01 10:00:00	CL	Stock	26.62	26.6225	26.35	26.4	594600.0
2005-08-01 11:00:00	CL	Stock	26.4	26.45	26.35	26.385	291600.0
2005-08-01 12:00:00	CL	Stock	26.39	26.44	26.36	26.43	269800.0
2005-08-01 13:00:00	CL	Stock	26.44	26.53	26.43	26.51	417800.0
2005-08-01 14:00:00	CL	Stock	26.51	26.565	26.46	26.51	732400.0

> showing 50 of 26,760 rows — these rows as CSV

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