PREVIEW / stock_1hour / 2006-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-24.parquet
  size:    606 KB
  rows:    28,890
  symbols: 2,196

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-03-24 04:00:00	AAPL	Stock	2.15	2.15	2.15	2.15	2800.0
2006-03-24 06:00:00	AAPL	Stock	2.1536	2.1536	2.1536	2.1536	8400.0
2006-03-24 07:00:00	AAPL	Stock	2.1464	2.1571	2.1464	2.1571	172480.0
2006-03-24 08:00:00	AAPL	Stock	2.1589	2.1643	2.1514	2.1536	2802464.0
2006-03-24 09:00:00	AAPL	Stock	2.1518	2.1607	2.1343	2.1536	149208500.0
2006-03-24 10:00:00	AAPL	Stock	2.1536	2.1764	2.1479	2.1554	228249420.0
2006-03-24 11:00:00	AAPL	Stock	2.1561	2.16	2.1407	2.1421	118353788.0
2006-03-24 12:00:00	AAPL	Stock	2.1422	2.1504	2.1339	2.1393	99972628.0
2006-03-24 13:00:00	AAPL	Stock	2.1393	2.1404	2.1089	2.1118	172593148.0
2006-03-24 14:00:00	AAPL	Stock	2.1118	2.1346	2.1082	2.1282	141351392.0
2006-03-24 15:00:00	AAPL	Stock	2.1279	2.1454	2.125	2.1407	142690408.0
2006-03-24 16:00:00	AAPL	Stock	2.1411	2.1414	2.1371	2.1389	3620288.0
2006-03-24 17:00:00	AAPL	Stock	2.1414	2.1414	2.1375	2.1375	502712.0
2006-03-24 18:00:00	AAPL	Stock	2.1414	2.1414	2.1375	2.14	143248.0
2006-03-24 07:00:00	MSFT	Stock	26.71	26.71	26.71	26.71	100.0
2006-03-24 08:00:00	MSFT	Stock	26.87	26.9	26.7	26.7	48427.0
2006-03-24 09:00:00	MSFT	Stock	26.7	26.75	26.62	26.67	12168592.0
2006-03-24 10:00:00	MSFT	Stock	26.661	26.94	26.66	26.93	16069322.0
2006-03-24 11:00:00	MSFT	Stock	26.94	26.96	26.87	26.95	7454526.0
2006-03-24 12:00:00	MSFT	Stock	26.96	26.99	26.89	26.98	4892389.0
2006-03-24 13:00:00	MSFT	Stock	26.97	27.04	26.92	27.03	9639746.0
2006-03-24 14:00:00	MSFT	Stock	27.02	27.08	26.95	27.05	5704803.0
2006-03-24 15:00:00	MSFT	Stock	27.05	27.21	26.99	27.02	12027222.0
2006-03-24 16:00:00	MSFT	Stock	27.02	27.03	26.96	27.01	215738.0
2006-03-24 17:00:00	MSFT	Stock	27.01	27.01	26.99	27.01	5204.0
2006-03-24 18:00:00	MSFT	Stock	27.009	27.009	27.0	27.0	5411.0
2006-03-24 08:00:00	NVDA	Stock	0.4195	0.4237	0.4189	0.42	372000.0
2006-03-24 09:00:00	NVDA	Stock	0.4203	0.4258	0.4186	0.4257	83078760.0
2006-03-24 10:00:00	NVDA	Stock	0.4257	0.4329	0.4241	0.4309	194976600.0
2006-03-24 11:00:00	NVDA	Stock	0.431	0.4317	0.4284	0.4316	75608400.0
2006-03-24 12:00:00	NVDA	Stock	0.4317	0.4324	0.4276	0.4281	69178080.0
2006-03-24 13:00:00	NVDA	Stock	0.4282	0.4296	0.4267	0.4287	68211960.0
2006-03-24 14:00:00	NVDA	Stock	0.4287	0.4297	0.4278	0.4297	56451600.0
2006-03-24 15:00:00	NVDA	Stock	0.4297	0.4337	0.4297	0.4327	119494320.0
2006-03-24 16:00:00	NVDA	Stock	0.4326	0.4333	0.4312	0.4312	2023800.0
2006-03-24 17:00:00	NVDA	Stock	0.4329	0.4329	0.4321	0.4329	113040.0
2006-03-24 18:00:00	NVDA	Stock	0.4329	0.4329	0.4324	0.4324	26160.0
2006-03-24 07:00:00	AMZN	Stock	1.8	1.8	1.8	1.8	17780.0
2006-03-24 08:00:00	AMZN	Stock	1.8	1.8	1.7885	1.7885	24000.0
2006-03-24 09:00:00	AMZN	Stock	1.792	1.798	1.7785	1.7885	5371000.0
2006-03-24 10:00:00	AMZN	Stock	1.7885	1.806	1.785	1.799	11227880.0
2006-03-24 11:00:00	AMZN	Stock	1.799	1.799	1.7845	1.791	7770800.0
2006-03-24 12:00:00	AMZN	Stock	1.79	1.795	1.7825	1.7845	7756100.0
2006-03-24 13:00:00	AMZN	Stock	1.7845	1.785	1.7655	1.7725	10072680.0
2006-03-24 14:00:00	AMZN	Stock	1.772	1.7775	1.768	1.7725	10076140.0
2006-03-24 15:00:00	AMZN	Stock	1.7725	1.7775	1.77	1.773	17153640.0
2006-03-24 16:00:00	AMZN	Stock	1.7735	1.7875	1.7705	1.7735	205780.0
2006-03-24 17:00:00	AMZN	Stock	1.7735	1.7755	1.7725	1.7735	42660.0
2006-03-24 18:00:00	AMZN	Stock	1.7735	1.7735	1.7735	1.7735	3880.0
2006-03-24 09:00:00	CL	Stock	28.65	28.7	28.515	28.54	393600.0

> showing 50 of 28,890 rows — these rows as CSV

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