PREVIEW / stock_1hour / 2010-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-14.parquet
  size:    895 KB
  rows:    42,706
  symbols: 3,439

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
2010-01-14 04:00:00	AAPL	Stock	7.5411	7.5411	7.5411	7.5411	2800.0
2010-01-14 06:00:00	AAPL	Stock	7.5439	7.5439	7.5357	7.5357	11200.0
2010-01-14 07:00:00	AAPL	Stock	7.5529	7.5529	7.5193	7.5321	180684.0
2010-01-14 08:00:00	AAPL	Stock	7.5261	7.5464	7.5029	7.5079	2177056.0
2010-01-14 09:00:00	AAPL	Stock	7.5082	7.5179	7.465	7.4771	80365124.0
2010-01-14 10:00:00	AAPL	Stock	7.4771	7.5121	7.4689	7.4776	87259592.0
2010-01-14 11:00:00	AAPL	Stock	7.4768	7.4936	7.4664	7.4768	57921780.0
2010-01-14 12:00:00	AAPL	Stock	7.4775	7.4993	7.476	7.4889	33711888.0
2010-01-14 13:00:00	AAPL	Stock	7.4882	7.4911	7.4696	7.4793	30532544.0
2010-01-14 14:00:00	AAPL	Stock	7.4793	7.5104	7.4789	7.4989	36682548.0
2010-01-14 15:00:00	AAPL	Stock	7.4982	7.5118	7.4725	7.4793	67996544.0
2010-01-14 16:00:00	AAPL	Stock	7.4889	7.5268	7.473	7.5	9894696.0
2010-01-14 17:00:00	AAPL	Stock	7.4745	7.505	7.4745	7.4986	521780.0
2010-01-14 18:00:00	AAPL	Stock	7.4982	7.4986	7.4796	7.4957	339780.0
2010-01-14 19:00:00	AAPL	Stock	7.4971	7.5036	7.4929	7.5	163996.0
2010-01-14 07:00:00	MSFT	Stock	30.43	30.46	30.43	30.46	6200.0
2010-01-14 08:00:00	MSFT	Stock	30.45	30.48	30.36	30.36	21613.0
2010-01-14 09:00:00	MSFT	Stock	30.36	30.765	30.26	30.64	7314102.0
2010-01-14 10:00:00	MSFT	Stock	30.64	30.77	30.61	30.63	7645662.0
2010-01-14 11:00:00	MSFT	Stock	30.64	30.75	30.55	30.55	8060952.0
2010-01-14 12:00:00	MSFT	Stock	30.56	30.83	30.55	30.823	6451300.0
2010-01-14 13:00:00	MSFT	Stock	30.82	31.09	30.82	31.0	9532660.0
2010-01-14 14:00:00	MSFT	Stock	31.01	31.09	30.99	31.06	5947138.0
2010-01-14 15:00:00	MSFT	Stock	31.07	31.1	30.96	30.97	12133890.0
2010-01-14 16:00:00	MSFT	Stock	30.97	31.29	30.331	31.17	4329958.0
2010-01-14 17:00:00	MSFT	Stock	30.35	31.27	30.35	31.18	97965.0
2010-01-14 18:00:00	MSFT	Stock	30.96	31.24	30.96	31.24	22084.0
2010-01-14 19:00:00	MSFT	Stock	31.19	31.22	31.18	31.22	9615.0
2010-01-14 08:00:00	NVDA	Stock	0.4478	0.4488	0.4478	0.4478	112000.0
2010-01-14 09:00:00	NVDA	Stock	0.4475	0.4475	0.4375	0.4378	90760200.0
2010-01-14 10:00:00	NVDA	Stock	0.4375	0.44	0.4348	0.437	122079400.0
2010-01-14 11:00:00	NVDA	Stock	0.4372	0.4382	0.4345	0.4358	77685080.0
2010-01-14 12:00:00	NVDA	Stock	0.4358	0.4372	0.4345	0.4349	62108680.0
2010-01-14 13:00:00	NVDA	Stock	0.435	0.4375	0.4332	0.437	66699840.0
2010-01-14 14:00:00	NVDA	Stock	0.437	0.4415	0.4361	0.44	75052600.0
2010-01-14 15:00:00	NVDA	Stock	0.44	0.4422	0.44	0.441	86619040.0
2010-01-14 16:00:00	NVDA	Stock	0.4408	0.4458	0.435	0.4392	22052760.0
2010-01-14 17:00:00	NVDA	Stock	0.4478	0.4478	0.435	0.4375	1138840.0
2010-01-14 18:00:00	NVDA	Stock	0.4358	0.4358	0.4358	0.4358	40000.0
2010-01-14 19:00:00	NVDA	Stock	0.4365	0.438	0.4365	0.438	240000.0
2010-01-14 04:00:00	AMZN	Stock	6.4555	6.4555	6.4555	6.4555	2000.0
2010-01-14 07:00:00	AMZN	Stock	6.4405	6.4405	6.4405	6.4405	4000.0
2010-01-14 08:00:00	AMZN	Stock	6.464	6.495	6.4385	6.447	490960.0
2010-01-14 09:00:00	AMZN	Stock	6.442	6.519	6.376	6.385	36618520.0
2010-01-14 10:00:00	AMZN	Stock	6.384	6.411	6.325	6.33	43638460.0
2010-01-14 11:00:00	AMZN	Stock	6.33	6.4045	6.32	6.3703	34193400.0
2010-01-14 12:00:00	AMZN	Stock	6.3693	6.3905	6.363	6.3785	11340660.0
2010-01-14 13:00:00	AMZN	Stock	6.378	6.3885	6.3525	6.3608	10749980.0
2010-01-14 14:00:00	AMZN	Stock	6.36	6.405	6.3525	6.3955	15504940.0
2010-01-14 15:00:00	AMZN	Stock	6.3955	6.413	6.347	6.37	37151400.0

> showing 50 of 42,706 rows — these rows as CSV

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