PREVIEW / stock_1hour / 2007-03-30

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-30.parquet
  size:    672 KB
  rows:    31,666
  symbols: 2,560

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-30 08:00:00	AAPL	Stock	3.3514	3.3732	3.3429	3.3643	6007568.0
2007-03-30 09:00:00	AAPL	Stock	3.3657	3.3814	3.3568	3.3682	89888960.0
2007-03-30 10:00:00	AAPL	Stock	3.3686	3.3729	3.3486	3.3536	92401932.0
2007-03-30 11:00:00	AAPL	Stock	3.3536	3.3589	3.3129	3.3311	107257892.0
2007-03-30 12:00:00	AAPL	Stock	3.3311	3.3311	3.3143	3.325	63124796.0
2007-03-30 13:00:00	AAPL	Stock	3.3246	3.3393	3.3232	3.3357	45848236.0
2007-03-30 14:00:00	AAPL	Stock	3.3357	3.3536	3.3307	3.3379	49845012.0
2007-03-30 15:00:00	AAPL	Stock	3.3378	3.3382	3.3125	3.3161	121608900.0
2007-03-30 16:00:00	AAPL	Stock	3.3179	3.3214	3.3157	3.3196	5497912.0
2007-03-30 17:00:00	AAPL	Stock	3.3186	3.3236	3.3164	3.3236	121744.0
2007-03-30 18:00:00	AAPL	Stock	3.3214	3.3236	3.3161	3.3161	249928.0
2007-03-30 19:00:00	AAPL	Stock	3.3211	3.3232	3.3171	3.3214	99876.0
2007-03-30 08:00:00	MSFT	Stock	27.72	27.75	27.72	27.75	4366.0
2007-03-30 09:00:00	MSFT	Stock	27.7	27.95	27.7	27.86	3818237.0
2007-03-30 10:00:00	MSFT	Stock	27.86	27.92	27.77	27.91	4792975.0
2007-03-30 11:00:00	MSFT	Stock	27.91	27.93	27.5	27.68	6577078.0
2007-03-30 12:00:00	MSFT	Stock	27.67	27.74	27.57	27.58	3993272.0
2007-03-30 13:00:00	MSFT	Stock	27.58	27.78	27.57	27.69	4277820.0
2007-03-30 14:00:00	MSFT	Stock	27.69	27.9	27.65	27.84	5421626.0
2007-03-30 15:00:00	MSFT	Stock	27.84	27.9	27.76	27.87	12287536.0
2007-03-30 16:00:00	MSFT	Stock	27.87	27.89	27.84	27.86	1158900.0
2007-03-30 17:00:00	MSFT	Stock	27.87	27.87	27.87	27.87	292955.0
2007-03-30 18:00:00	MSFT	Stock	27.86	27.88	27.86	27.87	4395.0
2007-03-30 19:00:00	MSFT	Stock	27.84	27.84	27.84	27.84	290.0
2007-03-30 04:00:00	NVDA	Stock	0.483	0.4857	0.483	0.4857	66000.0
2007-03-30 07:00:00	NVDA	Stock	0.4833	0.4835	0.4833	0.4833	66000.0
2007-03-30 08:00:00	NVDA	Stock	0.4838	0.4842	0.4825	0.4842	529860.0
2007-03-30 09:00:00	NVDA	Stock	0.4842	0.4858	0.4805	0.4835	49649160.0
2007-03-30 10:00:00	NVDA	Stock	0.4833	0.4883	0.4815	0.4878	84447060.0
2007-03-30 11:00:00	NVDA	Stock	0.4877	0.488	0.4772	0.4818	82133580.0
2007-03-30 12:00:00	NVDA	Stock	0.4818	0.4855	0.481	0.4818	55110060.0
2007-03-30 13:00:00	NVDA	Stock	0.4818	0.4848	0.4815	0.4827	55952400.0
2007-03-30 14:00:00	NVDA	Stock	0.4827	0.4838	0.4808	0.4833	84368340.0
2007-03-30 15:00:00	NVDA	Stock	0.4834	0.4835	0.479	0.4795	129835080.0
2007-03-30 16:00:00	NVDA	Stock	0.4797	0.4798	0.4775	0.4775	1486920.0
2007-03-30 17:00:00	NVDA	Stock	0.4775	0.4793	0.475	0.4793	74040.0
2007-03-30 19:00:00	NVDA	Stock	0.4793	0.4793	0.4793	0.4793	7800.0
2007-03-30 08:00:00	AMZN	Stock	1.983	1.983	1.982	1.982	4400.0
2007-03-30 09:00:00	AMZN	Stock	1.993	2.008	1.987	2.0065	11903540.0
2007-03-30 10:00:00	AMZN	Stock	2.007	2.012	2.0005	2.002	21783840.0
2007-03-30 11:00:00	AMZN	Stock	2.0015	2.0025	1.971	1.9945	19043280.0
2007-03-30 12:00:00	AMZN	Stock	1.9945	1.9945	1.9755	1.9775	10458100.0
2007-03-30 13:00:00	AMZN	Stock	1.978	2.01	1.9765	1.9805	13004220.0
2007-03-30 14:00:00	AMZN	Stock	1.981	1.9925	1.9775	1.988	15189700.0
2007-03-30 15:00:00	AMZN	Stock	1.988	1.9925	1.984	1.989	20805180.0
2007-03-30 16:00:00	AMZN	Stock	1.988	1.9895	1.988	1.9891	510500.0
2007-03-30 09:00:00	CL	Stock	33.46	33.69	33.42	33.64	318000.0
2007-03-30 10:00:00	CL	Stock	33.63	33.65	33.5	33.535	316600.0
2007-03-30 11:00:00	CL	Stock	33.535	33.545	33.135	33.28	649000.0
2007-03-30 12:00:00	CL	Stock	33.29	33.29	33.165	33.235	284800.0

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

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