PREVIEW / stock_1hour / 2006-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-01.parquet
  size:    615 KB
  rows:    29,332
  symbols: 2,206

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-03-01 07:00:00	AAPL	Stock	2.4643	2.4732	2.4571	2.4571	42000.0
2006-03-01 08:00:00	AAPL	Stock	2.4732	2.4814	2.4461	2.4664	3625300.0
2006-03-01 09:00:00	AAPL	Stock	2.4668	2.4818	2.45	2.4689	133617736.0
2006-03-01 10:00:00	AAPL	Stock	2.4686	2.4739	2.4293	2.4671	221077416.0
2006-03-01 11:00:00	AAPL	Stock	2.4668	2.4782	2.4557	2.4782	92609468.0
2006-03-01 12:00:00	AAPL	Stock	2.4775	2.4814	2.4704	2.4775	57992032.0
2006-03-01 13:00:00	AAPL	Stock	2.4775	2.4807	2.4661	2.4675	49362264.0
2006-03-01 14:00:00	AAPL	Stock	2.4679	2.4729	2.4514	2.4654	82982088.0
2006-03-01 15:00:00	AAPL	Stock	2.4654	2.4793	2.4621	2.4679	95674684.0
2006-03-01 16:00:00	AAPL	Stock	2.4679	2.475	2.463	2.4707	2283288.0
2006-03-01 17:00:00	AAPL	Stock	2.4725	2.4732	2.4678	2.4707	575736.0
2006-03-01 18:00:00	AAPL	Stock	2.4714	2.4732	2.4707	2.4732	53200.0
2006-03-01 07:00:00	MSFT	Stock	26.92	26.92	26.87	26.87	3500.0
2006-03-01 08:00:00	MSFT	Stock	26.92	26.98	26.87	26.97	54145.0
2006-03-01 09:00:00	MSFT	Stock	26.97	27.09	26.87	27.06	6596885.0
2006-03-01 10:00:00	MSFT	Stock	27.06	27.09	26.96	27.04	7890561.0
2006-03-01 11:00:00	MSFT	Stock	27.05	27.18	26.96	27.1	8157607.0
2006-03-01 12:00:00	MSFT	Stock	27.09	27.13	27.03	27.05	2888573.0
2006-03-01 13:00:00	MSFT	Stock	27.06	27.09	27.03	27.07	4156676.0
2006-03-01 14:00:00	MSFT	Stock	27.07	27.2	27.05	27.16	7018274.0
2006-03-01 15:00:00	MSFT	Stock	27.16	27.16	27.05	27.13	11467736.0
2006-03-01 16:00:00	MSFT	Stock	27.14	27.14	27.06	27.1	2161319.0
2006-03-01 17:00:00	MSFT	Stock	27.14	27.14	27.09	27.09	55011.0
2006-03-01 18:00:00	MSFT	Stock	27.09	27.1	27.08	27.1	8200.0
2006-03-01 09:00:00	NVDA	Stock	0.3933	0.4007	0.3917	0.4006	86210280.0
2006-03-01 10:00:00	NVDA	Stock	0.4006	0.4032	0.3972	0.402	106248000.0
2006-03-01 11:00:00	NVDA	Stock	0.4022	0.4052	0.4009	0.4048	87717840.0
2006-03-01 12:00:00	NVDA	Stock	0.4047	0.4066	0.4033	0.4039	58882440.0
2006-03-01 13:00:00	NVDA	Stock	0.4041	0.4079	0.4034	0.4072	57921840.0
2006-03-01 14:00:00	NVDA	Stock	0.4071	0.4088	0.4071	0.4077	82091160.0
2006-03-01 15:00:00	NVDA	Stock	0.4077	0.41	0.4062	0.4076	95511120.0
2006-03-01 16:00:00	NVDA	Stock	0.4077	0.4082	0.4065	0.4082	1486800.0
2006-03-01 18:00:00	NVDA	Stock	0.4069	0.4069	0.4069	0.4069	72000.0
2006-03-01 08:00:00	AMZN	Stock	1.872	1.872	1.872	1.872	165000.0
2006-03-01 09:00:00	AMZN	Stock	1.8845	1.8845	1.8615	1.865	10508120.0
2006-03-01 10:00:00	AMZN	Stock	1.865	1.8675	1.843	1.8465	26632420.0
2006-03-01 11:00:00	AMZN	Stock	1.846	1.8675	1.8425	1.861	32306420.0
2006-03-01 12:00:00	AMZN	Stock	1.8605	1.8647	1.857	1.861	12307080.0
2006-03-01 13:00:00	AMZN	Stock	1.861	1.8735	1.8575	1.867	11532900.0
2006-03-01 14:00:00	AMZN	Stock	1.867	1.8785	1.8635	1.8725	14944180.0
2006-03-01 15:00:00	AMZN	Stock	1.873	1.875	1.8515	1.8535	25405640.0
2006-03-01 16:00:00	AMZN	Stock	1.8525	1.8599	1.85	1.85	359960.0
2006-03-01 17:00:00	AMZN	Stock	1.857	1.857	1.855	1.856	1064960.0
2006-03-01 18:00:00	AMZN	Stock	1.855	1.855	1.855	1.855	12000.0
2006-03-01 08:00:00	CL	Stock	27.24	27.24	27.19	27.24	4600.0
2006-03-01 09:00:00	CL	Stock	27.34	27.455	27.245	27.295	346400.0
2006-03-01 10:00:00	CL	Stock	27.3	27.365	27.27	27.285	290800.0
2006-03-01 11:00:00	CL	Stock	27.29	27.385	27.265	27.38	320000.0
2006-03-01 12:00:00	CL	Stock	27.375	27.475	27.345	27.455	264800.0
2006-03-01 13:00:00	CL	Stock	27.45	27.46	27.355	27.46	182000.0

> showing 50 of 29,332 rows — these rows as CSV

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