PREVIEW / stock_1hour / 2003-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-27.parquet
  size:    446 KB
  rows:    21,473
  symbols: 1,607

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
2003-08-27 09:00:00	AAPL	Stock	0.368	0.3752	0.3677	0.3716	13251112.0
2003-08-27 10:00:00	AAPL	Stock	0.3714	0.3746	0.3711	0.3723	11692968.0
2003-08-27 11:00:00	AAPL	Stock	0.3725	0.3725	0.3689	0.3696	10421600.0
2003-08-27 12:00:00	AAPL	Stock	0.3698	0.3743	0.3698	0.3741	17506104.0
2003-08-27 13:00:00	AAPL	Stock	0.3741	0.3788	0.3738	0.3773	31669568.0
2003-08-27 14:00:00	AAPL	Stock	0.3773	0.3791	0.3771	0.3788	53954824.0
2003-08-27 15:00:00	AAPL	Stock	0.3788	0.3836	0.3786	0.3832	49093352.0
2003-08-27 16:00:00	AAPL	Stock	0.383	0.3845	0.382	0.3841	7134400.0
2003-08-27 17:00:00	AAPL	Stock	0.3836	0.3836	0.3836	0.3836	840000.0
2003-08-27 08:00:00	MSFT	Stock	26.58	26.58	26.55	26.55	2800.0
2003-08-27 09:00:00	MSFT	Stock	26.5	26.6	26.37	26.39	4264226.0
2003-08-27 10:00:00	MSFT	Stock	26.39	26.54	26.35	26.44	5563694.0
2003-08-27 11:00:00	MSFT	Stock	26.4405	26.46	26.36	26.4	2735035.0
2003-08-27 12:00:00	MSFT	Stock	26.4	26.43	26.37	26.41	1507499.0
2003-08-27 13:00:00	MSFT	Stock	26.41	26.49	26.4	26.42	3682568.0
2003-08-27 14:00:00	MSFT	Stock	26.417	26.45	26.33	26.389	3476609.0
2003-08-27 15:00:00	MSFT	Stock	26.39	26.49	26.38	26.43	5013720.0
2003-08-27 16:00:00	MSFT	Stock	26.42	26.45	26.25	26.44	1103486.0
2003-08-27 17:00:00	MSFT	Stock	26.42	26.44	26.401	26.41	108790.0
2003-08-27 18:00:00	MSFT	Stock	26.43	26.44	26.43	26.44	1700.0
2003-08-27 08:00:00	NVDA	Stock	0.1489	0.1489	0.1489	0.1489	105600.0
2003-08-27 09:00:00	NVDA	Stock	0.1482	0.1512	0.1482	0.15	74347320.0
2003-08-27 10:00:00	NVDA	Stock	0.1499	0.152	0.1492	0.1515	99222360.0
2003-08-27 11:00:00	NVDA	Stock	0.1515	0.1532	0.1512	0.1523	65980680.0
2003-08-27 12:00:00	NVDA	Stock	0.1524	0.1542	0.152	0.1541	47256960.0
2003-08-27 13:00:00	NVDA	Stock	0.1541	0.155	0.1537	0.1544	50456760.0
2003-08-27 14:00:00	NVDA	Stock	0.1544	0.1544	0.1514	0.1528	95128200.0
2003-08-27 15:00:00	NVDA	Stock	0.1528	0.1537	0.1522	0.1533	89299680.0
2003-08-27 16:00:00	NVDA	Stock	0.1534	0.1535	0.1526	0.1534	5348400.0
2003-08-27 17:00:00	NVDA	Stock	0.1535	0.1535	0.1533	0.1533	660000.0
2003-08-27 18:00:00	NVDA	Stock	0.1533	0.1533	0.1533	0.1533	12000.0
2003-08-27 08:00:00	AMZN	Stock	2.2965	2.3	2.283	2.291	153280.0
2003-08-27 09:00:00	AMZN	Stock	2.2876	2.3035	2.2703	2.273	11684660.0
2003-08-27 10:00:00	AMZN	Stock	2.2725	2.2865	2.263	2.2775	11380740.0
2003-08-27 11:00:00	AMZN	Stock	2.2775	2.292	2.276	2.285	15852140.0
2003-08-27 12:00:00	AMZN	Stock	2.285	2.2885	2.2805	2.286	7830860.0
2003-08-27 13:00:00	AMZN	Stock	2.286	2.2985	2.285	2.29	11369420.0
2003-08-27 14:00:00	AMZN	Stock	2.29	2.2925	2.276	2.289	9994520.0
2003-08-27 15:00:00	AMZN	Stock	2.289	2.2935	2.2845	2.291	14304160.0
2003-08-27 16:00:00	AMZN	Stock	2.2905	2.296	2.29	2.294	797600.0
2003-08-27 17:00:00	AMZN	Stock	2.2915	2.2955	2.2915	2.2915	242000.0
2003-08-27 09:00:00	CL	Stock	27.24	27.75	27.24	27.72	1317600.0
2003-08-27 10:00:00	CL	Stock	27.715	27.905	27.715	27.77	1326200.0
2003-08-27 11:00:00	CL	Stock	27.77	27.81	27.69	27.78	708800.0
2003-08-27 12:00:00	CL	Stock	27.775	27.8	27.745	27.76	453800.0
2003-08-27 13:00:00	CL	Stock	27.76	27.8	27.75	27.75	398800.0
2003-08-27 14:00:00	CL	Stock	27.75	27.755	27.625	27.665	714600.0
2003-08-27 15:00:00	CL	Stock	27.665	27.725	27.665	27.68	895200.0
2003-08-27 16:00:00	CL	Stock	27.675	27.71	27.24	27.24	91000.0

> showing 49 of 21,473 rows — these rows as CSV

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