PREVIEW / stock_1hour / 2010-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-13.parquet
  size:    900 KB
  rows:    42,688
  symbols: 3,445

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-13 04:00:00	AAPL	Stock	7.4261	7.4261	7.4261	7.4261	5600.0
2010-01-13 06:00:00	AAPL	Stock	7.4557	7.4557	7.4557	7.4557	2800.0
2010-01-13 07:00:00	AAPL	Stock	7.4518	7.4557	7.4214	7.4429	204148.0
2010-01-13 08:00:00	AAPL	Stock	7.4346	7.4464	7.4043	7.4073	1099448.0
2010-01-13 09:00:00	AAPL	Stock	7.4071	7.4457	7.3775	7.3832	67621820.0
2010-01-13 10:00:00	AAPL	Stock	7.3832	7.3893	7.2893	7.3504	154778904.0
2010-01-13 11:00:00	AAPL	Stock	7.35	7.3929	7.3221	7.3704	62253268.0
2010-01-13 12:00:00	AAPL	Stock	7.37	7.4614	7.37	7.4479	73797500.0
2010-01-13 13:00:00	AAPL	Stock	7.4482	7.4982	7.4356	7.4893	59790136.0
2010-01-13 14:00:00	AAPL	Stock	7.4893	7.5175	7.4821	7.5018	66445540.0
2010-01-13 15:00:00	AAPL	Stock	7.5025	7.5332	7.49	7.5143	96396720.0
2010-01-13 16:00:00	AAPL	Stock	7.5246	7.527	7.4205	7.5257	9224292.0
2010-01-13 17:00:00	AAPL	Stock	7.5268	7.5321	7.5232	7.5304	213276.0
2010-01-13 18:00:00	AAPL	Stock	7.5321	7.5429	7.5232	7.5375	1006544.0
2010-01-13 19:00:00	AAPL	Stock	7.5375	7.5493	7.5375	7.5482	333396.0
2010-01-13 05:00:00	MSFT	Stock	30.1	30.1	30.1	30.1	185.0
2010-01-13 08:00:00	MSFT	Stock	30.18	30.21	30.15	30.21	12782.0
2010-01-13 09:00:00	MSFT	Stock	30.19	30.28	30.04	30.048	4636266.0
2010-01-13 10:00:00	MSFT	Stock	30.04	30.3	30.01	30.245	7446918.0
2010-01-13 11:00:00	MSFT	Stock	30.24	30.27	30.168	30.242	5134450.0
2010-01-13 12:00:00	MSFT	Stock	30.243	30.45	30.24	30.44	5508047.0
2010-01-13 13:00:00	MSFT	Stock	30.45	30.45	30.26	30.26	4486826.0
2010-01-13 14:00:00	MSFT	Stock	30.26	30.45	30.26	30.45	3825578.0
2010-01-13 15:00:00	MSFT	Stock	30.45	30.52	30.33	30.35	9258830.0
2010-01-13 16:00:00	MSFT	Stock	30.35	30.44	30.257	30.38	6604952.0
2010-01-13 17:00:00	MSFT	Stock	30.36	30.36	30.32	30.35	212924.0
2010-01-13 18:00:00	MSFT	Stock	30.32	30.32	30.32	30.32	5093.0
2010-01-13 19:00:00	MSFT	Stock	30.35	30.36	30.32	30.32	5948.0
2010-01-13 20:00:00	MSFT	Stock	30.22	30.22	30.22	30.22	18900.0
2010-01-13 07:00:00	NVDA	Stock	0.4505	0.451	0.4505	0.451	146000.0
2010-01-13 08:00:00	NVDA	Stock	0.4418	0.4462	0.4418	0.4442	88000.0
2010-01-13 09:00:00	NVDA	Stock	0.445	0.4462	0.4328	0.4342	74794160.0
2010-01-13 10:00:00	NVDA	Stock	0.434	0.4372	0.4275	0.4368	110916200.0
2010-01-13 11:00:00	NVDA	Stock	0.437	0.4438	0.4348	0.4425	85974160.0
2010-01-13 12:00:00	NVDA	Stock	0.4425	0.4452	0.442	0.4435	57679320.0
2010-01-13 13:00:00	NVDA	Stock	0.4435	0.4466	0.4428	0.4462	38565720.0
2010-01-13 14:00:00	NVDA	Stock	0.4462	0.4492	0.4452	0.4485	44976520.0
2010-01-13 15:00:00	NVDA	Stock	0.4488	0.4492	0.446	0.4478	78296920.0
2010-01-13 16:00:00	NVDA	Stock	0.4475	0.4481	0.4407	0.4475	3545160.0
2010-01-13 17:00:00	NVDA	Stock	0.4422	0.4478	0.4422	0.4478	137880.0
2010-01-13 18:00:00	NVDA	Stock	0.449	0.4492	0.449	0.449	128000.0
2010-01-13 19:00:00	NVDA	Stock	0.4492	0.4492	0.4492	0.4492	6000.0
2010-01-13 07:00:00	AMZN	Stock	6.4245	6.4245	6.4245	6.4245	2000.0
2010-01-13 08:00:00	AMZN	Stock	6.4	6.41	6.367	6.385	203280.0
2010-01-13 09:00:00	AMZN	Stock	6.385	6.411	6.3315	6.4035	25966540.0
2010-01-13 10:00:00	AMZN	Stock	6.4015	6.4045	6.2875	6.36	46207960.0
2010-01-13 11:00:00	AMZN	Stock	6.362	6.375	6.327	6.351	13322640.0
2010-01-13 12:00:00	AMZN	Stock	6.3501	6.396	6.3345	6.384	31274420.0
2010-01-13 13:00:00	AMZN	Stock	6.384	6.464	6.3735	6.441	38613260.0
2010-01-13 14:00:00	AMZN	Stock	6.441	6.4525	6.4215	6.4425	23992560.0

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

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