PREVIEW / stock_1hour / 2006-12-22

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-22.parquet
  size:    624 KB
  rows:    30,083
  symbols: 2,461

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-12-22 04:00:00	AAPL	Stock	2.9675	2.9675	2.9643	2.9643	19600.0
2006-12-22 07:00:00	AAPL	Stock	2.9614	2.9714	2.9614	2.9711	158200.0
2006-12-22 08:00:00	AAPL	Stock	2.9711	2.9889	2.9643	2.9839	2740024.0
2006-12-22 09:00:00	AAPL	Stock	2.9839	2.9864	2.9143	2.9636	108825444.0
2006-12-22 10:00:00	AAPL	Stock	2.9639	3.0014	2.9579	2.9771	162545320.0
2006-12-22 11:00:00	AAPL	Stock	2.9774	2.9857	2.9518	2.9682	70972776.0
2006-12-22 12:00:00	AAPL	Stock	2.9679	2.9732	2.9446	2.9521	87647980.0
2006-12-22 13:00:00	AAPL	Stock	2.9521	2.9529	2.9429	2.9464	43170932.0
2006-12-22 14:00:00	AAPL	Stock	2.9461	2.9514	2.9375	2.9493	42356804.0
2006-12-22 15:00:00	AAPL	Stock	2.9493	2.9554	2.9339	2.9357	84001736.0
2006-12-22 16:00:00	AAPL	Stock	2.9357	2.9364	2.9268	2.9343	1846152.0
2006-12-22 17:00:00	AAPL	Stock	2.9343	2.9375	2.9321	2.9375	298228.0
2006-12-22 18:00:00	AAPL	Stock	2.9354	2.9354	2.9296	2.9296	213500.0
2006-12-22 19:00:00	AAPL	Stock	2.9296	2.9354	2.9286	2.9304	254912.0
2006-12-22 05:00:00	MSFT	Stock	29.86	29.86	29.86	29.86	300.0
2006-12-22 08:00:00	MSFT	Stock	29.92	29.98	29.91	29.95	5537.0
2006-12-22 09:00:00	MSFT	Stock	29.95	29.98	29.63	29.69	7202253.0
2006-12-22 10:00:00	MSFT	Stock	29.69	29.82	29.68	29.73	6278937.0
2006-12-22 11:00:00	MSFT	Stock	29.738	29.77	29.68	29.71	3701571.0
2006-12-22 12:00:00	MSFT	Stock	29.7	29.825	29.69	29.81	3819270.0
2006-12-22 13:00:00	MSFT	Stock	29.81	29.81	29.71	29.73	2204161.0
2006-12-22 14:00:00	MSFT	Stock	29.733	29.75	29.71	29.75	1897247.0
2006-12-22 15:00:00	MSFT	Stock	29.75	29.76	29.62	29.65	11337262.0
2006-12-22 16:00:00	MSFT	Stock	29.64	29.65	29.61	29.64	478299.0
2006-12-22 17:00:00	MSFT	Stock	29.64	29.64	29.64	29.64	500.0
2006-12-22 18:00:00	MSFT	Stock	29.63	29.63	29.63	29.63	700.0
2006-12-22 19:00:00	MSFT	Stock	29.63	29.65	29.63	29.65	2000.0
2006-12-22 09:00:00	NVDA	Stock	0.6317	0.6333	0.6187	0.6217	51035280.0
2006-12-22 10:00:00	NVDA	Stock	0.6223	0.6232	0.6178	0.6198	70234620.0
2006-12-22 11:00:00	NVDA	Stock	0.6198	0.6212	0.6187	0.6188	42264300.0
2006-12-22 12:00:00	NVDA	Stock	0.6187	0.619	0.6163	0.6167	45631500.0
2006-12-22 13:00:00	NVDA	Stock	0.6167	0.6167	0.6145	0.6147	36081060.0
2006-12-22 14:00:00	NVDA	Stock	0.6147	0.6183	0.6142	0.6158	50098500.0
2006-12-22 15:00:00	NVDA	Stock	0.6157	0.6192	0.6157	0.6178	65120040.0
2006-12-22 16:00:00	NVDA	Stock	0.617	0.6183	0.6167	0.617	1631820.0
2006-12-22 17:00:00	NVDA	Stock	0.6168	0.6168	0.6167	0.6167	150000.0
2006-12-22 18:00:00	NVDA	Stock	0.6168	0.6168	0.6168	0.6168	24000.0
2006-12-22 19:00:00	NVDA	Stock	0.6167	0.6167	0.6155	0.6155	55500.0
2006-12-22 09:00:00	AMZN	Stock	1.9995	2.0175	1.9955	2.01	15332880.0
2006-12-22 10:00:00	AMZN	Stock	2.0115	2.0255	2.009	2.0125	39907220.0
2006-12-22 11:00:00	AMZN	Stock	2.0125	2.0155	2.0025	2.01	8802400.0
2006-12-22 12:00:00	AMZN	Stock	2.01	2.0175	2.0055	2.0095	9623380.0
2006-12-22 13:00:00	AMZN	Stock	2.0095	2.0125	2.0075	2.011	7403520.0
2006-12-22 14:00:00	AMZN	Stock	2.011	2.0135	2.008	2.0115	11738460.0
2006-12-22 15:00:00	AMZN	Stock	2.0115	2.013	2.0075	2.0115	15965360.0
2006-12-22 16:00:00	AMZN	Stock	2.0115	2.0115	2.0035	2.004	274380.0
2006-12-22 09:00:00	CL	Stock	32.26	32.3	32.15	32.18	263600.0
2006-12-22 10:00:00	CL	Stock	32.18	32.215	32.135	32.195	356400.0
2006-12-22 11:00:00	CL	Stock	32.195	32.24	32.08	32.14	387600.0
2006-12-22 12:00:00	CL	Stock	32.14	32.16	32.105	32.12	255800.0

> showing 50 of 30,083 rows — these rows as CSV

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