PREVIEW / stock_1hour / 2006-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-06.parquet
  size:    618 KB
  rows:    29,305
  symbols: 2,198

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-06 08:00:00	AAPL	Stock	2.4321	2.4325	2.4214	2.4286	2220848.0
2006-03-06 09:00:00	AAPL	Stock	2.4279	2.4296	2.3689	2.3814	162138228.0
2006-03-06 10:00:00	AAPL	Stock	2.3818	2.3911	2.3675	2.3754	169249584.0
2006-03-06 11:00:00	AAPL	Stock	2.3754	2.3868	2.3675	2.3785	87608108.0
2006-03-06 12:00:00	AAPL	Stock	2.3786	2.3786	2.3657	2.3689	59877832.0
2006-03-06 13:00:00	AAPL	Stock	2.3689	2.3768	2.3375	2.3464	110145728.0
2006-03-06 14:00:00	AAPL	Stock	2.3464	2.3471	2.3239	2.3296	149791208.0
2006-03-06 15:00:00	AAPL	Stock	2.33	2.3857	2.3193	2.3382	161265272.0
2006-03-06 16:00:00	AAPL	Stock	2.3396	2.3407	2.3325	2.3354	3688160.0
2006-03-06 17:00:00	AAPL	Stock	2.3339	2.3382	2.3339	2.3371	662816.0
2006-03-06 18:00:00	AAPL	Stock	2.3389	2.3461	2.3339	2.345	636132.0
2006-03-06 08:00:00	MSFT	Stock	26.96	27.0	26.96	26.97	27171.0
2006-03-06 09:00:00	MSFT	Stock	26.99	26.99	26.83	26.92	5295983.0
2006-03-06 10:00:00	MSFT	Stock	26.92	27.15	26.91	27.1	8187077.0
2006-03-06 11:00:00	MSFT	Stock	27.09	27.1	27.02	27.06	4762232.0
2006-03-06 12:00:00	MSFT	Stock	27.06	27.13	27.02	27.09	4643570.0
2006-03-06 13:00:00	MSFT	Stock	27.08	27.13	26.98	27.04	7888132.0
2006-03-06 14:00:00	MSFT	Stock	27.04	27.04	26.9	26.93	9157721.0
2006-03-06 15:00:00	MSFT	Stock	26.93	27.1	26.91	26.93	10118257.0
2006-03-06 16:00:00	MSFT	Stock	26.93	26.95	26.9	26.91	1188196.0
2006-03-06 17:00:00	MSFT	Stock	26.92	26.92	26.89	26.908	7937.0
2006-03-06 18:00:00	MSFT	Stock	26.87	26.87	26.85	26.86	20107.0
2006-03-06 08:00:00	NVDA	Stock	0.4124	0.4124	0.4124	0.4124	12000.0
2006-03-06 09:00:00	NVDA	Stock	0.4124	0.4217	0.4122	0.4147	114247320.0
2006-03-06 10:00:00	NVDA	Stock	0.4147	0.4173	0.4106	0.4128	76372680.0
2006-03-06 11:00:00	NVDA	Stock	0.4128	0.413	0.4092	0.4104	49050000.0
2006-03-06 12:00:00	NVDA	Stock	0.4102	0.4125	0.4096	0.4112	37776240.0
2006-03-06 13:00:00	NVDA	Stock	0.4112	0.4148	0.4093	0.4097	76793760.0
2006-03-06 14:00:00	NVDA	Stock	0.4097	0.4104	0.4068	0.4084	65161680.0
2006-03-06 15:00:00	NVDA	Stock	0.4083	0.4128	0.4077	0.4089	86387280.0
2006-03-06 16:00:00	NVDA	Stock	0.4089	0.4095	0.4086	0.4086	1635000.0
2006-03-06 17:00:00	NVDA	Stock	0.4092	0.4104	0.4092	0.4104	324000.0
2006-03-06 08:00:00	AMZN	Stock	1.875	1.875	1.875	1.875	4000.0
2006-03-06 09:00:00	AMZN	Stock	1.863	1.879	1.8495	1.868	11780080.0
2006-03-06 10:00:00	AMZN	Stock	1.8675	1.8725	1.852	1.8645	14361480.0
2006-03-06 11:00:00	AMZN	Stock	1.864	1.867	1.857	1.8662	8456740.0
2006-03-06 12:00:00	AMZN	Stock	1.866	1.8695	1.857	1.8605	4445700.0
2006-03-06 13:00:00	AMZN	Stock	1.8605	1.8655	1.8385	1.8505	12578460.0
2006-03-06 14:00:00	AMZN	Stock	1.8505	1.8565	1.8395	1.848	12638260.0
2006-03-06 15:00:00	AMZN	Stock	1.8485	1.8485	1.84	1.841	18380820.0
2006-03-06 16:00:00	AMZN	Stock	1.8415	1.845	1.841	1.8434	66600.0
2006-03-06 17:00:00	AMZN	Stock	1.845	1.845	1.8429	1.8429	20140.0
2006-03-06 09:00:00	CL	Stock	27.365	27.43	27.28	27.295	177200.0
2006-03-06 10:00:00	CL	Stock	27.29	27.49	27.255	27.28	356400.0
2006-03-06 11:00:00	CL	Stock	27.28	27.33	27.235	27.25	357200.0
2006-03-06 12:00:00	CL	Stock	27.255	27.255	27.185	27.202	218600.0
2006-03-06 13:00:00	CL	Stock	27.215	27.31	27.195	27.22	248000.0
2006-03-06 14:00:00	CL	Stock	27.23	27.255	27.06	27.13	496000.0
2006-03-06 15:00:00	CL	Stock	27.13	27.17	27.1	27.16	434400.0

> showing 49 of 29,305 rows — these rows as CSV

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