PREVIEW / stock_1hour / 2010-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-28.parquet
  size:    909 KB
  rows:    43,485
  symbols: 3,419

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-28 04:00:00	AAPL	Stock	7.4464	7.4464	7.4429	7.4432	12600.0
2010-01-28 05:00:00	AAPL	Stock	7.4482	7.4482	7.4107	7.4129	61320.0
2010-01-28 06:00:00	AAPL	Stock	7.4054	7.4079	7.3929	7.3929	116200.0
2010-01-28 07:00:00	AAPL	Stock	7.3929	7.4107	7.3793	7.4	595756.0
2010-01-28 08:00:00	AAPL	Stock	7.3996	7.41	7.34	7.34	8509452.0
2010-01-28 09:00:00	AAPL	Stock	7.3418	7.3504	7.1561	7.2229	199952816.0
2010-01-28 10:00:00	AAPL	Stock	7.2229	7.2411	7.1271	7.1464	231104552.0
2010-01-28 11:00:00	AAPL	Stock	7.1471	7.1854	7.1071	7.1636	189468972.0
2010-01-28 12:00:00	AAPL	Stock	7.1629	7.175	7.1125	7.1425	95843552.0
2010-01-28 13:00:00	AAPL	Stock	7.1429	7.1486	7.0964	7.1336	119567812.0
2010-01-28 14:00:00	AAPL	Stock	7.1339	7.1936	7.0993	7.1675	118813408.0
2010-01-28 15:00:00	AAPL	Stock	7.1671	7.2032	7.1057	7.1179	181820716.0
2010-01-28 16:00:00	AAPL	Stock	7.1179	7.1756	7.095	7.1404	15228248.0
2010-01-28 17:00:00	AAPL	Stock	7.1378	7.1461	7.1175	7.1214	1382612.0
2010-01-28 18:00:00	AAPL	Stock	7.1232	7.1232	7.0914	7.0993	990192.0
2010-01-28 19:00:00	AAPL	Stock	7.0964	7.1018	7.0893	7.0904	635684.0
2010-01-28 06:00:00	MSFT	Stock	29.97	29.97	29.97	29.97	200.0
2010-01-28 07:00:00	MSFT	Stock	29.9	29.94	29.89	29.93	6610.0
2010-01-28 08:00:00	MSFT	Stock	29.9	29.94	29.85	29.88	114194.0
2010-01-28 09:00:00	MSFT	Stock	29.86	29.91	29.54	29.56	9156756.0
2010-01-28 10:00:00	MSFT	Stock	29.565	29.57	29.05	29.23	18709300.0
2010-01-28 11:00:00	MSFT	Stock	29.24	29.26	29.0	29.02	14335536.0
2010-01-28 12:00:00	MSFT	Stock	29.01	29.11	28.89	29.06	9527249.0
2010-01-28 13:00:00	MSFT	Stock	29.06	29.39	28.96	29.29	12881862.0
2010-01-28 14:00:00	MSFT	Stock	29.3	29.5	29.14	29.41	11480763.0
2010-01-28 15:00:00	MSFT	Stock	29.41	29.54	29.16	29.16	24391978.0
2010-01-28 16:00:00	MSFT	Stock	29.16	30.17	28.62	29.51	13194494.0
2010-01-28 17:00:00	MSFT	Stock	28.94	29.7	28.94	29.3	971984.0
2010-01-28 18:00:00	MSFT	Stock	29.3	29.35	29.16	29.27	267406.0
2010-01-28 19:00:00	MSFT	Stock	29.27	29.27	29.05	29.12	181963.0
2010-01-28 08:00:00	NVDA	Stock	0.4178	0.4215	0.4178	0.4213	120000.0
2010-01-28 09:00:00	NVDA	Stock	0.4213	0.4218	0.408	0.4141	68960120.0
2010-01-28 10:00:00	NVDA	Stock	0.414	0.4148	0.4035	0.4062	138952360.0
2010-01-28 11:00:00	NVDA	Stock	0.4062	0.4062	0.4	0.402	110150480.0
2010-01-28 12:00:00	NVDA	Stock	0.402	0.403	0.3965	0.3988	87643360.0
2010-01-28 13:00:00	NVDA	Stock	0.399	0.4038	0.3985	0.4005	69794280.0
2010-01-28 14:00:00	NVDA	Stock	0.4008	0.4028	0.3985	0.4018	62983280.0
2010-01-28 15:00:00	NVDA	Stock	0.4018	0.4065	0.4015	0.4028	119579600.0
2010-01-28 16:00:00	NVDA	Stock	0.4022	0.4068	0.402	0.4022	24581840.0
2010-01-28 17:00:00	NVDA	Stock	0.402	0.402	0.402	0.402	207000.0
2010-01-28 18:00:00	NVDA	Stock	0.4022	0.4022	0.4022	0.4022	572080.0
2010-01-28 19:00:00	NVDA	Stock	0.3978	0.4038	0.3978	0.4038	60000.0
2010-01-28 05:00:00	AMZN	Stock	6.1645	6.1645	6.1645	6.1645	2000.0
2010-01-28 06:00:00	AMZN	Stock	6.161	6.1685	6.161	6.1685	42000.0
2010-01-28 07:00:00	AMZN	Stock	6.1685	6.22	6.1685	6.193	95340.0
2010-01-28 08:00:00	AMZN	Stock	6.193	6.2505	6.185	6.233	1436680.0
2010-01-28 09:00:00	AMZN	Stock	6.233	6.286	6.199	6.2514	56204300.0
2010-01-28 10:00:00	AMZN	Stock	6.2485	6.277	6.1855	6.2229	58552840.0
2010-01-28 11:00:00	AMZN	Stock	6.2245	6.2356	6.14	6.211	54339040.0
2010-01-28 12:00:00	AMZN	Stock	6.212	6.249	6.2005	6.2265	37030360.0

> showing 50 of 43,485 rows — these rows as CSV

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