PREVIEW / stock_1hour / 2007-01-11

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-11.parquet
  size:    647 KB
  rows:    30,718
  symbols: 2,503

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-01-11 04:00:00	AAPL	Stock	3.44	3.4475	3.44	3.4475	22400.0
2007-01-11 06:00:00	AAPL	Stock	3.4468	3.4468	3.4464	3.4464	11200.0
2007-01-11 07:00:00	AAPL	Stock	3.4496	3.4589	3.4393	3.4393	1363040.0
2007-01-11 08:00:00	AAPL	Stock	3.4425	3.4425	3.425	3.4382	14610680.0
2007-01-11 09:00:00	AAPL	Stock	3.4389	3.4511	3.3968	3.4032	277473588.0
2007-01-11 10:00:00	AAPL	Stock	3.4032	3.4432	3.3964	3.4429	271910604.0
2007-01-11 11:00:00	AAPL	Stock	3.4436	3.4564	3.4289	3.4325	212097396.0
2007-01-11 12:00:00	AAPL	Stock	3.4332	3.4393	3.4118	3.4364	135817948.0
2007-01-11 13:00:00	AAPL	Stock	3.4364	3.4489	3.4257	3.4361	157697008.0
2007-01-11 14:00:00	AAPL	Stock	3.4357	3.4561	3.4129	3.4296	192773168.0
2007-01-11 15:00:00	AAPL	Stock	3.4293	3.4386	3.4121	3.4236	156416148.0
2007-01-11 16:00:00	AAPL	Stock	3.4229	3.4246	3.4196	3.4211	2131836.0
2007-01-11 17:00:00	AAPL	Stock	3.4211	3.4229	3.4196	3.4221	649376.0
2007-01-11 18:00:00	AAPL	Stock	3.4214	3.4214	3.4111	3.4111	897932.0
2007-01-11 19:00:00	AAPL	Stock	3.4111	3.4139	3.4061	3.4089	965412.0
2007-01-11 08:00:00	MSFT	Stock	29.67	29.7	29.65	29.7	16621.0
2007-01-11 09:00:00	MSFT	Stock	29.7	29.8	29.65	29.761	4381678.0
2007-01-11 10:00:00	MSFT	Stock	29.76	29.98	29.74	29.971	7704890.0
2007-01-11 11:00:00	MSFT	Stock	29.972	30.23	29.97	30.151	13449525.0
2007-01-11 12:00:00	MSFT	Stock	30.153	30.49	30.15	30.48	15300371.0
2007-01-11 13:00:00	MSFT	Stock	30.48	30.49	30.28	30.31	9530510.0
2007-01-11 14:00:00	MSFT	Stock	30.31	30.5	30.26	30.5	11255933.0
2007-01-11 15:00:00	MSFT	Stock	30.49	30.75	30.37	30.69	34461442.0
2007-01-11 16:00:00	MSFT	Stock	30.69	30.78	30.6	30.77	1527854.0
2007-01-11 17:00:00	MSFT	Stock	30.76	30.78	30.75	30.78	10170.0
2007-01-11 18:00:00	MSFT	Stock	30.75	30.79	30.7	30.75	12515.0
2007-01-11 19:00:00	MSFT	Stock	30.75	30.78	30.75	30.78	7955.0
2007-01-11 08:00:00	NVDA	Stock	0.5817	0.5838	0.5808	0.5808	159000.0
2007-01-11 09:00:00	NVDA	Stock	0.5798	0.5833	0.5698	0.5792	159615780.0
2007-01-11 10:00:00	NVDA	Stock	0.5792	0.586	0.5715	0.5772	199375020.0
2007-01-11 11:00:00	NVDA	Stock	0.577	0.5838	0.5768	0.5813	85531800.0
2007-01-11 12:00:00	NVDA	Stock	0.5813	0.5853	0.5793	0.5848	75369540.0
2007-01-11 13:00:00	NVDA	Stock	0.5847	0.585	0.5768	0.5782	83281200.0
2007-01-11 14:00:00	NVDA	Stock	0.578	0.5822	0.5748	0.5815	106623420.0
2007-01-11 15:00:00	NVDA	Stock	0.5817	0.5827	0.5745	0.5798	108322200.0
2007-01-11 16:00:00	NVDA	Stock	0.5798	0.58	0.5773	0.5773	6983160.0
2007-01-11 17:00:00	NVDA	Stock	0.5792	0.5792	0.5775	0.5788	312000.0
2007-01-11 19:00:00	NVDA	Stock	0.5777	0.5792	0.5777	0.5792	66000.0
2007-01-11 09:00:00	AMZN	Stock	1.861	1.885	1.8555	1.87	13408200.0
2007-01-11 10:00:00	AMZN	Stock	1.87	1.9	1.863	1.8895	13448020.0
2007-01-11 11:00:00	AMZN	Stock	1.8895	1.8915	1.879	1.888	20160800.0
2007-01-11 12:00:00	AMZN	Stock	1.8881	1.8925	1.8775	1.89	18420380.0
2007-01-11 13:00:00	AMZN	Stock	1.8905	1.892	1.881	1.881	9816140.0
2007-01-11 14:00:00	AMZN	Stock	1.881	1.883	1.864	1.8745	24405740.0
2007-01-11 15:00:00	AMZN	Stock	1.8745	1.8825	1.8645	1.8705	26051580.0
2007-01-11 16:00:00	AMZN	Stock	1.87	1.8785	1.8605	1.87	319600.0
2007-01-11 19:00:00	AMZN	Stock	1.8725	1.8725	1.8725	1.8725	20000.0
2007-01-11 09:00:00	CL	Stock	33.02	33.13	32.975	32.995	301600.0
2007-01-11 10:00:00	CL	Stock	33.005	33.06	32.92	33.005	421400.0
2007-01-11 11:00:00	CL	Stock	33.01	33.075	32.93	33.05	450600.0

> showing 50 of 30,718 rows — these rows as CSV

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