PREVIEW / stock_1hour / 2006-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-10.parquet
  size:    604 KB
  rows:    29,009
  symbols: 2,317

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-07-10 08:00:00	AAPL	Stock	1.9911	1.9957	1.9911	1.9936	403200.0
2006-07-10 09:00:00	AAPL	Stock	1.9943	2.0118	1.9868	2.0075	62007820.0
2006-07-10 10:00:00	AAPL	Stock	2.0071	2.0175	1.9975	2.0043	87743432.0
2006-07-10 11:00:00	AAPL	Stock	2.0043	2.0043	1.9836	1.9839	65687580.0
2006-07-10 12:00:00	AAPL	Stock	1.9843	1.9889	1.9764	1.9779	48536768.0
2006-07-10 13:00:00	AAPL	Stock	1.9779	1.9789	1.9625	1.9679	62553680.0
2006-07-10 14:00:00	AAPL	Stock	1.9679	1.9714	1.9464	1.9511	96377064.0
2006-07-10 15:00:00	AAPL	Stock	1.9507	1.9679	1.9496	1.9629	102423972.0
2006-07-10 16:00:00	AAPL	Stock	1.9625	1.9643	1.9593	1.9611	809144.0
2006-07-10 17:00:00	AAPL	Stock	1.9611	1.9643	1.96	1.9643	307860.0
2006-07-10 18:00:00	AAPL	Stock	1.9643	1.9643	1.9607	1.9607	1852200.0
2006-07-10 08:00:00	MSFT	Stock	23.33	23.38	23.33	23.35	39116.0
2006-07-10 09:00:00	MSFT	Stock	23.38	23.55	23.35	23.54	5544268.0
2006-07-10 10:00:00	MSFT	Stock	23.54	23.66	23.51	23.55	7207711.0
2006-07-10 11:00:00	MSFT	Stock	23.55	23.56	23.47	23.5	3705459.0
2006-07-10 12:00:00	MSFT	Stock	23.49	23.55	23.47	23.5	2804781.0
2006-07-10 13:00:00	MSFT	Stock	23.5	23.55	23.38	23.49	6202207.0
2006-07-10 14:00:00	MSFT	Stock	23.482	23.5	23.4	23.41	5154363.0
2006-07-10 15:00:00	MSFT	Stock	23.41	23.54	23.38	23.48	8933593.0
2006-07-10 16:00:00	MSFT	Stock	23.48	23.5	23.48	23.5	235888.0
2006-07-10 17:00:00	MSFT	Stock	23.48	23.5	23.48	23.48	1470.0
2006-07-10 18:00:00	MSFT	Stock	23.48	23.48	23.48	23.48	500.0
2006-07-10 08:00:00	NVDA	Stock	0.3243	0.3245	0.3243	0.3245	42000.0
2006-07-10 09:00:00	NVDA	Stock	0.3248	0.326	0.3225	0.323	26415480.0
2006-07-10 10:00:00	NVDA	Stock	0.3232	0.3245	0.3192	0.3197	72876300.0
2006-07-10 11:00:00	NVDA	Stock	0.3195	0.3198	0.3147	0.3157	55772220.0
2006-07-10 12:00:00	NVDA	Stock	0.3155	0.3165	0.3137	0.3143	47574180.0
2006-07-10 13:00:00	NVDA	Stock	0.3143	0.3147	0.3087	0.3088	83355900.0
2006-07-10 14:00:00	NVDA	Stock	0.3088	0.3112	0.3067	0.3075	62669580.0
2006-07-10 15:00:00	NVDA	Stock	0.3073	0.3097	0.306	0.3087	80721300.0
2006-07-10 16:00:00	NVDA	Stock	0.3087	0.3093	0.308	0.3083	228240.0
2006-07-10 17:00:00	NVDA	Stock	0.31	0.31	0.31	0.31	18000.0
2006-07-10 18:00:00	NVDA	Stock	0.31	0.31	0.31	0.31	6000.0
2006-07-10 09:00:00	AMZN	Stock	1.811	1.83	1.811	1.8205	7839800.0
2006-07-10 10:00:00	AMZN	Stock	1.821	1.833	1.819	1.833	7702680.0
2006-07-10 11:00:00	AMZN	Stock	1.832	1.835	1.8025	1.803	13367920.0
2006-07-10 12:00:00	AMZN	Stock	1.803	1.8185	1.795	1.807	6207800.0
2006-07-10 13:00:00	AMZN	Stock	1.8065	1.823	1.7895	1.79	9449100.0
2006-07-10 14:00:00	AMZN	Stock	1.7895	1.829	1.771	1.775	15263260.0
2006-07-10 15:00:00	AMZN	Stock	1.7745	1.8215	1.77	1.789	16160700.0
2006-07-10 16:00:00	AMZN	Stock	1.7885	1.7895	1.7885	1.7885	85520.0
2006-07-10 17:00:00	AMZN	Stock	1.7885	1.7885	1.788	1.788	19740.0
2006-07-10 09:00:00	CL	Stock	30.45	30.64	30.45	30.615	169200.0
2006-07-10 10:00:00	CL	Stock	30.615	30.7	30.585	30.68	386800.0
2006-07-10 11:00:00	CL	Stock	30.69	30.825	30.665	30.825	218200.0
2006-07-10 12:00:00	CL	Stock	30.825	30.88	30.75	30.84	296000.0
2006-07-10 13:00:00	CL	Stock	30.84	30.845	30.746	30.75	171200.0
2006-07-10 14:00:00	CL	Stock	30.75	30.765	30.685	30.74	175800.0
2006-07-10 15:00:00	CL	Stock	30.74	30.825	30.735	30.81	582200.0

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

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