PREVIEW / stock_1hour / 2006-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-25.parquet
  size:    572 KB
  rows:    27,852
  symbols: 2,322

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-08-25 05:00:00	AAPL	Stock	2.4196	2.4214	2.4196	2.4214	26600.0
2006-08-25 08:00:00	AAPL	Stock	2.4254	2.4264	2.4214	2.425	257236.0
2006-08-25 09:00:00	AAPL	Stock	2.4239	2.4318	2.4004	2.4264	69789972.0
2006-08-25 10:00:00	AAPL	Stock	2.4261	2.46	2.4246	2.4296	158529504.0
2006-08-25 11:00:00	AAPL	Stock	2.4293	2.4393	2.4254	2.4343	60809980.0
2006-08-25 12:00:00	AAPL	Stock	2.4339	2.4382	2.4261	2.4329	35333592.0
2006-08-25 13:00:00	AAPL	Stock	2.4329	2.4375	2.4289	2.4354	23636984.0
2006-08-25 14:00:00	AAPL	Stock	2.4354	2.4554	2.4325	2.4535	76063960.0
2006-08-25 15:00:00	AAPL	Stock	2.4532	2.4661	2.4496	2.4554	110791380.0
2006-08-25 16:00:00	AAPL	Stock	2.4554	2.4575	2.4536	2.4543	2212560.0
2006-08-25 17:00:00	AAPL	Stock	2.4536	2.4554	2.4518	2.4518	265412.0
2006-08-25 18:00:00	AAPL	Stock	2.4564	2.4564	2.4564	2.4564	7000.0
2006-08-25 07:00:00	MSFT	Stock	25.74	25.74	25.74	25.74	176.0
2006-08-25 08:00:00	MSFT	Stock	25.74	25.77	25.66	25.7	110945.0
2006-08-25 09:00:00	MSFT	Stock	25.7	25.93	25.69	25.9	4408294.0
2006-08-25 10:00:00	MSFT	Stock	25.9	26.0	25.86	25.95	9051870.0
2006-08-25 11:00:00	MSFT	Stock	25.96	25.97	25.814	25.86	4021994.0
2006-08-25 12:00:00	MSFT	Stock	25.86	25.91	25.84	25.87	2148257.0
2006-08-25 13:00:00	MSFT	Stock	25.87	25.92	25.85	25.88	2306806.0
2006-08-25 14:00:00	MSFT	Stock	25.87	25.89	25.82	25.83	3381649.0
2006-08-25 15:00:00	MSFT	Stock	25.83	25.89	25.81	25.84	5275245.0
2006-08-25 16:00:00	MSFT	Stock	25.83	25.89	25.83	25.84	841362.0
2006-08-25 17:00:00	MSFT	Stock	25.84	25.85	25.84	25.84	152300.0
2006-08-25 08:00:00	NVDA	Stock	0.4377	0.4377	0.4377	0.4377	6000.0
2006-08-25 09:00:00	NVDA	Stock	0.4412	0.4432	0.435	0.4413	30028740.0
2006-08-25 10:00:00	NVDA	Stock	0.4412	0.4492	0.4378	0.4383	57786060.0
2006-08-25 11:00:00	NVDA	Stock	0.4383	0.4425	0.4375	0.4412	32852340.0
2006-08-25 12:00:00	NVDA	Stock	0.4412	0.443	0.44	0.442	20206500.0
2006-08-25 13:00:00	NVDA	Stock	0.4418	0.4425	0.4402	0.442	17254500.0
2006-08-25 14:00:00	NVDA	Stock	0.442	0.4437	0.4402	0.4425	19880040.0
2006-08-25 15:00:00	NVDA	Stock	0.4425	0.4445	0.4407	0.4413	46180260.0
2006-08-25 16:00:00	NVDA	Stock	0.4418	0.4418	0.441	0.441	78000.0
2006-08-25 09:00:00	AMZN	Stock	1.392	1.3995	1.381	1.392	10032960.0
2006-08-25 10:00:00	AMZN	Stock	1.3915	1.4115	1.389	1.4009	18034740.0
2006-08-25 11:00:00	AMZN	Stock	1.4	1.404	1.3945	1.3985	9118020.0
2006-08-25 12:00:00	AMZN	Stock	1.398	1.403	1.3955	1.4012	5542600.0
2006-08-25 13:00:00	AMZN	Stock	1.4015	1.405	1.4	1.4025	4177540.0
2006-08-25 14:00:00	AMZN	Stock	1.402	1.4115	1.402	1.41	9783320.0
2006-08-25 15:00:00	AMZN	Stock	1.4105	1.4105	1.4	1.4	11896460.0
2006-08-25 16:00:00	AMZN	Stock	1.4005	1.4025	1.396	1.4025	38760.0
2006-08-25 09:00:00	CL	Stock	29.455	29.5	29.38	29.4	249600.0
2006-08-25 10:00:00	CL	Stock	29.4	29.45	29.265	29.275	540800.0
2006-08-25 11:00:00	CL	Stock	29.275	29.37	29.225	29.36	311600.0
2006-08-25 12:00:00	CL	Stock	29.36	29.42	29.29	29.395	192600.0
2006-08-25 13:00:00	CL	Stock	29.41	29.425	29.36	29.395	178600.0
2006-08-25 14:00:00	CL	Stock	29.39	29.45	29.36	29.425	196800.0
2006-08-25 15:00:00	CL	Stock	29.435	29.475	29.385	29.425	340200.0

> showing 47 of 27,852 rows — these rows as CSV

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