PREVIEW / stock_1hour / 2006-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-20.parquet
  size:    611 KB
  rows:    29,143
  symbols: 2,390

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
2006-10-20 07:00:00	AAPL	Stock	2.8268	2.8314	2.8211	2.8211	49000.0
2006-10-20 08:00:00	AAPL	Stock	2.8268	2.8321	2.815	2.8196	2161824.0
2006-10-20 09:00:00	AAPL	Stock	2.8179	2.8425	2.8096	2.8189	137216744.0
2006-10-20 10:00:00	AAPL	Stock	2.8196	2.8418	2.8179	2.8375	114841804.0
2006-10-20 11:00:00	AAPL	Stock	2.8379	2.8461	2.8279	2.8421	74925592.0
2006-10-20 12:00:00	AAPL	Stock	2.8418	2.8443	2.8379	2.8386	46373852.0
2006-10-20 13:00:00	AAPL	Stock	2.8386	2.8418	2.8361	2.8389	57661436.0
2006-10-20 14:00:00	AAPL	Stock	2.8386	2.8418	2.8375	2.8393	49335048.0
2006-10-20 15:00:00	AAPL	Stock	2.8395	2.8568	2.8393	2.8554	142528540.0
2006-10-20 16:00:00	AAPL	Stock	2.8554	2.8571	2.85	2.8554	3884440.0
2006-10-20 17:00:00	AAPL	Stock	2.8554	2.8564	2.8536	2.8536	260596.0
2006-10-20 18:00:00	AAPL	Stock	2.8568	2.8571	2.8546	2.8554	232708.0
2006-10-20 07:00:00	MSFT	Stock	28.4	28.42	28.4	28.42	800.0
2006-10-20 08:00:00	MSFT	Stock	28.41	28.42	28.37	28.4	7730.0
2006-10-20 09:00:00	MSFT	Stock	28.38	28.48	28.17	28.29	11907928.0
2006-10-20 10:00:00	MSFT	Stock	28.29	28.37	28.269	28.37	5982257.0
2006-10-20 11:00:00	MSFT	Stock	28.367	28.47	28.35	28.41	7347778.0
2006-10-20 12:00:00	MSFT	Stock	28.41	28.47	28.37	28.4	3336005.0
2006-10-20 13:00:00	MSFT	Stock	28.4	28.45	28.36	28.38	3756353.0
2006-10-20 14:00:00	MSFT	Stock	28.38	28.49	28.38	28.44	5054423.0
2006-10-20 15:00:00	MSFT	Stock	28.449	28.47	28.37	28.43	7395234.0
2006-10-20 16:00:00	MSFT	Stock	28.42	28.43	28.38	28.41	1356846.0
2006-10-20 17:00:00	MSFT	Stock	28.41	28.43	28.296	28.43	22106.0
2006-10-20 18:00:00	MSFT	Stock	28.4	28.4	28.4	28.4	1000.0
2006-10-20 08:00:00	NVDA	Stock	0.5417	0.5417	0.5417	0.5417	9960.0
2006-10-20 09:00:00	NVDA	Stock	0.5378	0.5405	0.5258	0.531	68470380.0
2006-10-20 10:00:00	NVDA	Stock	0.531	0.5355	0.523	0.526	67383000.0
2006-10-20 11:00:00	NVDA	Stock	0.5262	0.5287	0.5222	0.5277	48284700.0
2006-10-20 12:00:00	NVDA	Stock	0.5275	0.5333	0.5258	0.5313	37838760.0
2006-10-20 13:00:00	NVDA	Stock	0.5312	0.5325	0.5255	0.5267	26498760.0
2006-10-20 14:00:00	NVDA	Stock	0.5265	0.5287	0.5258	0.5277	33001620.0
2006-10-20 15:00:00	NVDA	Stock	0.5277	0.53	0.5267	0.5295	57234060.0
2006-10-20 16:00:00	NVDA	Stock	0.5292	0.5337	0.5285	0.5337	1878540.0
2006-10-20 18:00:00	NVDA	Stock	0.5325	0.5325	0.5325	0.5325	12000.0
2006-10-20 08:00:00	AMZN	Stock	1.625	1.626	1.625	1.6255	7000.0
2006-10-20 09:00:00	AMZN	Stock	1.6255	1.6345	1.6105	1.618	17007840.0
2006-10-20 10:00:00	AMZN	Stock	1.618	1.63	1.616	1.627	11232760.0
2006-10-20 11:00:00	AMZN	Stock	1.6275	1.6335	1.625	1.6285	16161380.0
2006-10-20 12:00:00	AMZN	Stock	1.628	1.6305	1.6235	1.63	10652400.0
2006-10-20 13:00:00	AMZN	Stock	1.6305	1.631	1.6245	1.625	9283680.0
2006-10-20 14:00:00	AMZN	Stock	1.625	1.6255	1.6205	1.6245	15498700.0
2006-10-20 15:00:00	AMZN	Stock	1.6245	1.628	1.623	1.628	30413060.0
2006-10-20 16:00:00	AMZN	Stock	1.627	1.6285	1.625	1.625	2353280.0
2006-10-20 09:00:00	CL	Stock	30.15	30.25	30.1	30.15	1034200.0
2006-10-20 10:00:00	CL	Stock	30.165	30.21	30.09	30.2	785600.0
2006-10-20 11:00:00	CL	Stock	30.205	30.24	30.17	30.2	704400.0
2006-10-20 12:00:00	CL	Stock	30.2	30.255	30.105	30.235	1119200.0
2006-10-20 13:00:00	CL	Stock	30.22	30.315	30.22	30.29	529200.0
2006-10-20 14:00:00	CL	Stock	30.305	30.325	30.28	30.31	545800.0
2006-10-20 15:00:00	CL	Stock	30.315	30.43	30.315	30.36	964600.0

> showing 50 of 29,143 rows — these rows as CSV

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