PREVIEW / stock_1hour / 2007-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-01.parquet
  size:    663 KB
  rows:    31,106
  symbols: 2,513

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-03-01 04:00:00	AAPL	Stock	3.0304	3.0304	3.0304	3.0304	2800.0
2007-03-01 07:00:00	AAPL	Stock	3.0354	3.0643	3.0257	3.0304	4723348.0
2007-03-01 08:00:00	AAPL	Stock	3.03	3.0325	2.9964	3.0157	16629508.0
2007-03-01 09:00:00	AAPL	Stock	3.0157	3.0446	2.9911	3.0343	208495224.0
2007-03-01 10:00:00	AAPL	Stock	3.0346	3.0889	3.0346	3.0775	291410084.0
2007-03-01 11:00:00	AAPL	Stock	3.0775	3.1214	3.0711	3.1114	229560324.0
2007-03-01 12:00:00	AAPL	Stock	3.1114	3.1336	3.1036	3.1264	144003972.0
2007-03-01 13:00:00	AAPL	Stock	3.1264	3.1386	3.1196	3.1367	111445712.0
2007-03-01 14:00:00	AAPL	Stock	3.1368	3.1539	3.1329	3.1443	150064152.0
2007-03-01 15:00:00	AAPL	Stock	3.1439	3.1446	3.0989	3.1114	238819000.0
2007-03-01 16:00:00	AAPL	Stock	3.1107	3.1146	3.1089	3.1107	2398872.0
2007-03-01 17:00:00	AAPL	Stock	3.1107	3.1125	3.1082	3.1082	189392.0
2007-03-01 18:00:00	AAPL	Stock	3.1082	3.1107	3.1082	3.1107	157500.0
2007-03-01 19:00:00	AAPL	Stock	3.1121	3.1139	3.1096	3.1111	173600.0
2007-03-01 08:00:00	MSFT	Stock	28.0	28.17	27.82	27.83	308196.0
2007-03-01 09:00:00	MSFT	Stock	27.83	27.92	27.73	27.89	14041108.0
2007-03-01 10:00:00	MSFT	Stock	27.89	28.33	27.89	28.17	17645177.0
2007-03-01 11:00:00	MSFT	Stock	28.17	28.31	28.05	28.18	10371763.0
2007-03-01 12:00:00	MSFT	Stock	28.18	28.23	28.15	28.199	4380857.0
2007-03-01 13:00:00	MSFT	Stock	28.198	28.24	28.14	28.23	4885486.0
2007-03-01 14:00:00	MSFT	Stock	28.23	28.33	28.14	28.19	7809269.0
2007-03-01 15:00:00	MSFT	Stock	28.19	28.21	28.08	28.08	15295852.0
2007-03-01 16:00:00	MSFT	Stock	28.09	28.13	28.07	28.07	31176.0
2007-03-01 17:00:00	MSFT	Stock	28.1	28.1	28.08	28.09	3320.0
2007-03-01 18:00:00	MSFT	Stock	28.08	28.09	28.07	28.07	2358.0
2007-03-01 19:00:00	MSFT	Stock	28.09	28.09	28.07	28.07	1000.0
2007-03-01 08:00:00	NVDA	Stock	0.5183	0.5183	0.5007	0.5042	804420.0
2007-03-01 09:00:00	NVDA	Stock	0.5042	0.5092	0.5005	0.5045	102551040.0
2007-03-01 10:00:00	NVDA	Stock	0.5043	0.5135	0.4988	0.5107	238774560.0
2007-03-01 11:00:00	NVDA	Stock	0.5107	0.5177	0.5083	0.5123	118993680.0
2007-03-01 12:00:00	NVDA	Stock	0.5122	0.514	0.508	0.5132	77726340.0
2007-03-01 13:00:00	NVDA	Stock	0.5132	0.5133	0.5087	0.5132	54746520.0
2007-03-01 14:00:00	NVDA	Stock	0.5132	0.5198	0.512	0.515	84714660.0
2007-03-01 15:00:00	NVDA	Stock	0.515	0.515	0.5087	0.5103	116390160.0
2007-03-01 16:00:00	NVDA	Stock	0.5103	0.5105	0.509	0.5093	322800.0
2007-03-01 17:00:00	NVDA	Stock	0.5105	0.5125	0.5105	0.5125	129480.0
2007-03-01 18:00:00	NVDA	Stock	0.5125	0.5125	0.5125	0.5125	40200.0
2007-03-01 19:00:00	NVDA	Stock	0.5125	0.5125	0.5125	0.5125	12000.0
2007-03-01 08:00:00	AMZN	Stock	1.93	1.957	1.921	1.921	1503000.0
2007-03-01 09:00:00	AMZN	Stock	1.9215	1.966	1.9025	1.93	20568520.0
2007-03-01 10:00:00	AMZN	Stock	1.93	1.949	1.9145	1.9405	32720820.0
2007-03-01 11:00:00	AMZN	Stock	1.9405	1.966	1.9285	1.944	17689040.0
2007-03-01 12:00:00	AMZN	Stock	1.944	1.947	1.929	1.9395	13325300.0
2007-03-01 13:00:00	AMZN	Stock	1.9395	1.941	1.931	1.9405	16700620.0
2007-03-01 14:00:00	AMZN	Stock	1.941	1.963	1.9385	1.9485	30310940.0
2007-03-01 15:00:00	AMZN	Stock	1.9485	1.949	1.9265	1.9425	34255780.0
2007-03-01 16:00:00	AMZN	Stock	1.9445	1.945	1.94	1.943	365000.0
2007-03-01 09:00:00	CL	Stock	33.5	33.5	32.935	33.31	752248.0
2007-03-01 10:00:00	CL	Stock	33.125	33.615	33.125	33.355	844512.0
2007-03-01 11:00:00	CL	Stock	33.525	33.605	33.28	33.295	808518.0

> showing 50 of 31,106 rows — these rows as CSV

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