PREVIEW / stock_1hour / 2006-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-07.parquet
  size:    608 KB
  rows:    28,946
  symbols: 2,280

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
2006-06-07 07:00:00	AAPL	Stock	2.1375	2.1375	2.1375	2.1375	2800.0
2006-06-07 08:00:00	AAPL	Stock	2.1393	2.1543	2.1393	2.1471	1300796.0
2006-06-07 09:00:00	AAPL	Stock	2.1464	2.15	2.1207	2.1289	68587232.0
2006-06-07 10:00:00	AAPL	Stock	2.1289	2.1571	2.125	2.1343	162165500.0
2006-06-07 11:00:00	AAPL	Stock	2.1343	2.1496	2.1329	2.1475	85267588.0
2006-06-07 12:00:00	AAPL	Stock	2.1479	2.1518	2.1275	2.1282	61995164.0
2006-06-07 13:00:00	AAPL	Stock	2.1279	2.1325	2.1182	2.1221	74840920.0
2006-06-07 14:00:00	AAPL	Stock	2.1221	2.1224	2.0964	2.1086	118260632.0
2006-06-07 15:00:00	AAPL	Stock	2.1082	2.1296	2.0839	2.0896	157823260.0
2006-06-07 16:00:00	AAPL	Stock	2.0925	2.1036	2.09	2.09	5809636.0
2006-06-07 17:00:00	AAPL	Stock	2.0896	2.14	2.0875	2.0875	1392412.0
2006-06-07 18:00:00	AAPL	Stock	2.0875	2.0911	2.0864	2.09	359100.0
2006-06-07 08:00:00	MSFT	Stock	22.2	22.25	22.18	22.21	115840.0
2006-06-07 09:00:00	MSFT	Stock	22.197	22.3	22.05	22.27	11103416.0
2006-06-07 10:00:00	MSFT	Stock	22.27	22.33	22.17	22.23	10320962.0
2006-06-07 11:00:00	MSFT	Stock	22.24	22.34	22.22	22.31	9860749.0
2006-06-07 12:00:00	MSFT	Stock	22.312	22.36	22.27	22.308	7647296.0
2006-06-07 13:00:00	MSFT	Stock	22.3	22.39	22.28	22.33	9622956.0
2006-06-07 14:00:00	MSFT	Stock	22.33	22.33	22.2	22.23	7024041.0
2006-06-07 15:00:00	MSFT	Stock	22.24	22.27	22.01	22.03	15035951.0
2006-06-07 16:00:00	MSFT	Stock	22.03	22.13	21.99	22.05	1130677.0
2006-06-07 17:00:00	MSFT	Stock	22.04	22.05	22.03	22.05	13340.0
2006-06-07 18:00:00	MSFT	Stock	22.05	22.06	22.05	22.06	4380.0
2006-06-07 08:00:00	NVDA	Stock	0.3692	0.3737	0.3692	0.3737	25860.0
2006-06-07 09:00:00	NVDA	Stock	0.3747	0.378	0.3608	0.363	60936900.0
2006-06-07 10:00:00	NVDA	Stock	0.363	0.3708	0.3628	0.3662	87332040.0
2006-06-07 11:00:00	NVDA	Stock	0.366	0.3682	0.364	0.3665	41201760.0
2006-06-07 12:00:00	NVDA	Stock	0.3663	0.3695	0.3662	0.367	63903720.0
2006-06-07 13:00:00	NVDA	Stock	0.3672	0.3723	0.3666	0.3708	80838300.0
2006-06-07 14:00:00	NVDA	Stock	0.3707	0.3717	0.3667	0.368	55472520.0
2006-06-07 15:00:00	NVDA	Stock	0.3678	0.3692	0.3618	0.3632	90819300.0
2006-06-07 16:00:00	NVDA	Stock	0.3632	0.3635	0.3617	0.3623	429600.0
2006-06-07 17:00:00	NVDA	Stock	0.362	0.3647	0.3618	0.3647	144000.0
2006-06-07 08:00:00	AMZN	Stock	1.675	1.6865	1.675	1.6865	22000.0
2006-06-07 09:00:00	AMZN	Stock	1.684	1.684	1.6455	1.67	8500680.0
2006-06-07 10:00:00	AMZN	Stock	1.67	1.695	1.6695	1.6915	15957820.0
2006-06-07 11:00:00	AMZN	Stock	1.691	1.706	1.68	1.7035	11485820.0
2006-06-07 12:00:00	AMZN	Stock	1.7045	1.7175	1.704	1.7145	12166180.0
2006-06-07 13:00:00	AMZN	Stock	1.7145	1.727	1.712	1.727	17321720.0
2006-06-07 14:00:00	AMZN	Stock	1.726	1.726	1.701	1.7105	17303460.0
2006-06-07 15:00:00	AMZN	Stock	1.7105	1.7125	1.6875	1.688	18315160.0
2006-06-07 16:00:00	AMZN	Stock	1.6875	1.6905	1.6865	1.6905	464520.0
2006-06-07 18:00:00	AMZN	Stock	1.689	1.689	1.688	1.688	22000.0
2006-06-07 09:00:00	CL	Stock	30.21	30.3	30.13	30.275	613800.0
2006-06-07 10:00:00	CL	Stock	30.285	30.445	30.25	30.36	832600.0
2006-06-07 11:00:00	CL	Stock	30.355	30.41	30.25	30.37	616200.0
2006-06-07 12:00:00	CL	Stock	30.375	30.4	30.325	30.4	507600.0
2006-06-07 13:00:00	CL	Stock	30.4	30.46	30.36	30.45	598000.0
2006-06-07 14:00:00	CL	Stock	30.445	30.475	30.295	30.455	519600.0
2006-06-07 15:00:00	CL	Stock	30.455	30.5	30.295	30.345	1069800.0

> showing 50 of 28,946 rows — these rows as CSV

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