PREVIEW / stock_1hour / 2007-03-29

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-29.parquet
  size:    682 KB
  rows:    31,903
  symbols: 2,548

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
2007-03-29 05:00:00	AAPL	Stock	3.3489	3.3489	3.3489	3.3489	4200.0
2007-03-29 07:00:00	AAPL	Stock	3.3554	3.3679	3.3554	3.3554	271348.0
2007-03-29 08:00:00	AAPL	Stock	3.3607	3.3607	3.3496	3.3579	4055464.0
2007-03-29 09:00:00	AAPL	Stock	3.3589	3.3657	3.3364	3.3456	100326548.0
2007-03-29 10:00:00	AAPL	Stock	3.345	3.3518	3.3314	3.3379	105439964.0
2007-03-29 11:00:00	AAPL	Stock	3.3379	3.3543	3.3304	3.3311	80049480.0
2007-03-29 12:00:00	AAPL	Stock	3.3311	3.3354	3.3214	3.3293	81825576.0
2007-03-29 13:00:00	AAPL	Stock	3.3289	3.3357	3.3136	3.3164	71357552.0
2007-03-29 14:00:00	AAPL	Stock	3.3164	3.3186	3.2939	3.3121	118577676.0
2007-03-29 15:00:00	AAPL	Stock	3.3125	3.3482	3.305	3.3479	140504532.0
2007-03-29 16:00:00	AAPL	Stock	3.3482	3.3504	3.345	3.3475	12700660.0
2007-03-29 17:00:00	AAPL	Stock	3.3482	3.3504	3.3475	3.35	260736.0
2007-03-29 18:00:00	AAPL	Stock	3.3482	3.3482	3.345	3.345	229096.0
2007-03-29 19:00:00	AAPL	Stock	3.3446	3.3482	3.3436	3.3479	137620.0
2007-03-29 08:00:00	MSFT	Stock	27.7	27.82	27.7	27.82	36714.0
2007-03-29 09:00:00	MSFT	Stock	27.8	27.845	27.68	27.75	4109578.0
2007-03-29 10:00:00	MSFT	Stock	27.74	27.77	27.63	27.681	5224922.0
2007-03-29 11:00:00	MSFT	Stock	27.68	27.77	27.57	27.57	5285874.0
2007-03-29 12:00:00	MSFT	Stock	27.58	27.7	27.57	27.61	4079208.0
2007-03-29 13:00:00	MSFT	Stock	27.61	27.67	27.53	27.57	4808348.0
2007-03-29 14:00:00	MSFT	Stock	27.57	27.68	27.49	27.67	6146034.0
2007-03-29 15:00:00	MSFT	Stock	27.67	27.75	27.62	27.74	10531523.0
2007-03-29 16:00:00	MSFT	Stock	27.74	27.76	27.68	27.68	1291888.0
2007-03-29 17:00:00	MSFT	Stock	27.71	27.71	27.7	27.7	925.0
2007-03-29 18:00:00	MSFT	Stock	27.7	27.7	27.7	27.7	800.0
2007-03-29 19:00:00	MSFT	Stock	27.69	27.69	27.68	27.68	425.0
2007-03-29 08:00:00	NVDA	Stock	0.4907	0.4925	0.4907	0.4917	443160.0
2007-03-29 09:00:00	NVDA	Stock	0.4925	0.4948	0.488	0.491	76563780.0
2007-03-29 10:00:00	NVDA	Stock	0.4912	0.4915	0.4798	0.4808	100716600.0
2007-03-29 11:00:00	NVDA	Stock	0.4808	0.481	0.4755	0.4756	93225120.0
2007-03-29 12:00:00	NVDA	Stock	0.4755	0.4768	0.4708	0.4718	120202260.0
2007-03-29 13:00:00	NVDA	Stock	0.4718	0.4752	0.4713	0.4722	71759100.0
2007-03-29 14:00:00	NVDA	Stock	0.4722	0.476	0.4705	0.4745	92747400.0
2007-03-29 15:00:00	NVDA	Stock	0.4745	0.4795	0.4725	0.478	114544560.0
2007-03-29 16:00:00	NVDA	Stock	0.4783	0.48	0.4777	0.4792	30594780.0
2007-03-29 17:00:00	NVDA	Stock	0.4783	0.4792	0.4778	0.4778	556620.0
2007-03-29 18:00:00	NVDA	Stock	0.4783	0.4783	0.4763	0.4767	253680.0
2007-03-29 19:00:00	NVDA	Stock	0.4777	0.4777	0.4767	0.4775	45960.0
2007-03-29 07:00:00	AMZN	Stock	2.0235	2.0235	2.0235	2.0235	3200.0
2007-03-29 08:00:00	AMZN	Stock	1.98	1.999	1.98	1.997	46860.0
2007-03-29 09:00:00	AMZN	Stock	1.9795	1.987	1.9775	1.9825	8783060.0
2007-03-29 10:00:00	AMZN	Stock	1.9825	1.996	1.9755	1.9795	27986520.0
2007-03-29 11:00:00	AMZN	Stock	1.9799	1.988	1.971	1.972	16394420.0
2007-03-29 12:00:00	AMZN	Stock	1.9724	1.9765	1.9675	1.972	13447400.0
2007-03-29 13:00:00	AMZN	Stock	1.972	1.98	1.9705	1.9715	12667420.0
2007-03-29 14:00:00	AMZN	Stock	1.9715	1.9785	1.965	1.976	13519500.0
2007-03-29 15:00:00	AMZN	Stock	1.976	1.9945	1.9735	1.9905	26290280.0
2007-03-29 16:00:00	AMZN	Stock	1.9925	1.9925	1.9845	1.9905	896220.0
2007-03-29 17:00:00	AMZN	Stock	1.9905	1.9905	1.9905	1.9905	20000.0
2007-03-29 18:00:00	AMZN	Stock	1.9895	1.9895	1.9895	1.9895	10000.0

> showing 50 of 31,903 rows — these rows as CSV

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