PREVIEW / stock_1hour / 2006-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-12.parquet
  size:    586 KB
  rows:    27,901
  symbols: 2,228

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-04-12 06:00:00	AAPL	Stock	2.4232	2.4232	2.4232	2.4232	5600.0
2006-04-12 07:00:00	AAPL	Stock	2.4232	2.4232	2.4232	2.4232	11200.0
2006-04-12 08:00:00	AAPL	Stock	2.4268	2.4446	2.4232	2.4382	3115840.0
2006-04-12 09:00:00	AAPL	Stock	2.4382	2.4425	2.4082	2.4139	98454132.0
2006-04-12 10:00:00	AAPL	Stock	2.4143	2.4243	2.4054	2.4175	114142812.0
2006-04-12 11:00:00	AAPL	Stock	2.4171	2.4304	2.4089	2.4114	98529508.0
2006-04-12 12:00:00	AAPL	Stock	2.4114	2.4186	2.4029	2.4175	65211664.0
2006-04-12 13:00:00	AAPL	Stock	2.4175	2.4196	2.4032	2.4054	49255024.0
2006-04-12 14:00:00	AAPL	Stock	2.4054	2.4086	2.3754	2.3771	146981352.0
2006-04-12 15:00:00	AAPL	Stock	2.3775	2.3868	2.3679	2.3836	154027272.0
2006-04-12 16:00:00	AAPL	Stock	2.3843	2.3843	2.3793	2.3804	1610168.0
2006-04-12 17:00:00	AAPL	Stock	2.3804	2.3839	2.3786	2.3825	934640.0
2006-04-12 18:00:00	AAPL	Stock	2.3821	2.3839	2.3804	2.3804	433944.0
2006-04-12 04:00:00	MSFT	Stock	27.1	27.1	27.1	27.1	100.0
2006-04-12 07:00:00	MSFT	Stock	27.1	27.1	27.1	27.1	1000.0
2006-04-12 08:00:00	MSFT	Stock	27.1	27.12	27.1	27.1	5890.0
2006-04-12 09:00:00	MSFT	Stock	27.09	27.2	27.05	27.11	2778195.0
2006-04-12 10:00:00	MSFT	Stock	27.119	27.13	26.97	27.04	6289036.0
2006-04-12 11:00:00	MSFT	Stock	27.05	27.13	27.02	27.1	3016150.0
2006-04-12 12:00:00	MSFT	Stock	27.1	27.19	27.09	27.18	2748156.0
2006-04-12 13:00:00	MSFT	Stock	27.18	27.19	27.1	27.11	2767518.0
2006-04-12 14:00:00	MSFT	Stock	27.11	27.13	27.08	27.11	3608143.0
2006-04-12 15:00:00	MSFT	Stock	27.112	27.17	27.02	27.07	7557213.0
2006-04-12 16:00:00	MSFT	Stock	27.08	27.2	27.06	27.09	1018576.0
2006-04-12 17:00:00	MSFT	Stock	27.1	27.1	27.09	27.09	2274.0
2006-04-12 18:00:00	MSFT	Stock	27.1	27.1	27.1	27.1	500.0
2006-04-12 08:00:00	NVDA	Stock	0.4875	0.4893	0.4875	0.4893	42000.0
2006-04-12 09:00:00	NVDA	Stock	0.49	0.4975	0.4883	0.4943	43275840.0
2006-04-12 10:00:00	NVDA	Stock	0.4946	0.5007	0.4938	0.4985	89197020.0
2006-04-12 11:00:00	NVDA	Stock	0.4983	0.5048	0.498	0.5032	72084000.0
2006-04-12 12:00:00	NVDA	Stock	0.5032	0.5033	0.5	0.5025	47968560.0
2006-04-12 13:00:00	NVDA	Stock	0.5025	0.5042	0.5018	0.5037	45747840.0
2006-04-12 14:00:00	NVDA	Stock	0.5035	0.5078	0.5027	0.5037	101317500.0
2006-04-12 15:00:00	NVDA	Stock	0.5035	0.5102	0.5027	0.507	130128420.0
2006-04-12 16:00:00	NVDA	Stock	0.507	0.5083	0.5005	0.505	12740340.0
2006-04-12 17:00:00	NVDA	Stock	0.5033	0.5065	0.5023	0.5058	504000.0
2006-04-12 18:00:00	NVDA	Stock	0.5058	0.5058	0.5058	0.5058	90000.0
2006-04-12 09:00:00	AMZN	Stock	1.7955	1.8205	1.7955	1.8155	4003080.0
2006-04-12 10:00:00	AMZN	Stock	1.8155	1.822	1.8106	1.815	9967900.0
2006-04-12 11:00:00	AMZN	Stock	1.815	1.8185	1.815	1.8165	12412200.0
2006-04-12 12:00:00	AMZN	Stock	1.8165	1.8205	1.8155	1.82	7288660.0
2006-04-12 13:00:00	AMZN	Stock	1.82	1.8205	1.8125	1.817	7539400.0
2006-04-12 14:00:00	AMZN	Stock	1.8175	1.8175	1.8125	1.813	3573280.0
2006-04-12 15:00:00	AMZN	Stock	1.813	1.813	1.806	1.8065	8838200.0
2006-04-12 16:00:00	AMZN	Stock	1.8065	1.807	1.8	1.8065	148040.0
2006-04-12 17:00:00	AMZN	Stock	1.804	1.81	1.804	1.81	21000.0
2006-04-12 09:00:00	CL	Stock	28.6	28.7	28.575	28.65	295000.0
2006-04-12 10:00:00	CL	Stock	28.65	28.655	28.415	28.61	261800.0
2006-04-12 11:00:00	CL	Stock	28.615	28.62	28.455	28.475	266400.0
2006-04-12 12:00:00	CL	Stock	28.47	28.525	28.44	28.48	271400.0

> showing 50 of 27,901 rows — these rows as CSV

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