PREVIEW / stock_1hour / 2007-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-09.parquet
  size:    644 KB
  rows:    30,702
  symbols: 2,492

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-01-09 04:00:00	AAPL	Stock	3.0714	3.0786	3.0714	3.0786	30800.0
2007-01-09 05:00:00	AAPL	Stock	3.0782	3.0818	3.0782	3.0818	30800.0
2007-01-09 06:00:00	AAPL	Stock	3.0818	3.0818	3.0818	3.0818	8400.0
2007-01-09 07:00:00	AAPL	Stock	3.0854	3.0946	3.0736	3.0857	2728404.0
2007-01-09 08:00:00	AAPL	Stock	3.0857	3.0893	3.0782	3.0839	5356568.0
2007-01-09 09:00:00	AAPL	Stock	3.0829	3.0968	3.0732	3.0879	146881336.0
2007-01-09 10:00:00	AAPL	Stock	3.0867	3.1271	3.0821	3.1132	257548928.0
2007-01-09 11:00:00	AAPL	Stock	3.1136	3.1382	3.1082	3.1193	257676160.0
2007-01-09 12:00:00	AAPL	Stock	3.1196	3.1607	3.0411	3.1314	730321732.0
2007-01-09 13:00:00	AAPL	Stock	3.1311	3.3125	3.125	3.2468	911424444.0
2007-01-09 14:00:00	AAPL	Stock	3.2471	3.2893	3.2357	3.2768	447012916.0
2007-01-09 15:00:00	AAPL	Stock	3.2768	3.3207	3.2761	3.3054	564185468.0
2007-01-09 16:00:00	AAPL	Stock	3.3054	3.3121	3.3018	3.3096	11081140.0
2007-01-09 17:00:00	AAPL	Stock	3.3096	3.3125	3.3036	3.3071	3758300.0
2007-01-09 18:00:00	AAPL	Stock	3.3071	3.3093	3.3046	3.3071	2664844.0
2007-01-09 19:00:00	AAPL	Stock	3.3068	3.3143	3.3061	3.3129	1540084.0
2007-01-09 08:00:00	MSFT	Stock	29.95	29.97	29.91	29.94	20186.0
2007-01-09 09:00:00	MSFT	Stock	29.96	30.09	29.9	29.96	5232228.0
2007-01-09 10:00:00	MSFT	Stock	29.96	30.18	29.95	30.11	7333182.0
2007-01-09 11:00:00	MSFT	Stock	30.12	30.14	29.88	29.9	6888717.0
2007-01-09 12:00:00	MSFT	Stock	29.9	29.92	29.73	29.79	7243883.0
2007-01-09 13:00:00	MSFT	Stock	29.79	29.92	29.76	29.889	3638367.0
2007-01-09 14:00:00	MSFT	Stock	29.89	29.972	29.77	29.93	3994390.0
2007-01-09 15:00:00	MSFT	Stock	29.93	30.07	29.84	29.96	8176455.0
2007-01-09 16:00:00	MSFT	Stock	29.96	30.038	29.77	29.96	129187.0
2007-01-09 17:00:00	MSFT	Stock	29.91	29.91	29.86	29.87	16014.0
2007-01-09 18:00:00	MSFT	Stock	29.96	29.96	29.96	29.96	7296.0
2007-01-09 19:00:00	MSFT	Stock	29.92	29.92	29.88	29.88	2475.0
2007-01-09 08:00:00	NVDA	Stock	0.5683	0.5742	0.5683	0.5717	445500.0
2007-01-09 09:00:00	NVDA	Stock	0.5717	0.5723	0.5548	0.5572	84444000.0
2007-01-09 10:00:00	NVDA	Stock	0.5572	0.5668	0.5567	0.5633	123992700.0
2007-01-09 11:00:00	NVDA	Stock	0.5635	0.5647	0.5583	0.5597	83421480.0
2007-01-09 12:00:00	NVDA	Stock	0.5597	0.56	0.5542	0.5575	153964200.0
2007-01-09 13:00:00	NVDA	Stock	0.5575	0.5615	0.5558	0.5585	82050660.0
2007-01-09 14:00:00	NVDA	Stock	0.5588	0.56	0.555	0.5572	72330120.0
2007-01-09 15:00:00	NVDA	Stock	0.5571	0.5575	0.5535	0.5538	137923500.0
2007-01-09 16:00:00	NVDA	Stock	0.5535	0.5548	0.5533	0.5542	915420.0
2007-01-09 17:00:00	NVDA	Stock	0.5547	0.5548	0.5542	0.5542	162000.0
2007-01-09 18:00:00	NVDA	Stock	0.554	0.5542	0.554	0.554	100020.0
2007-01-09 19:00:00	NVDA	Stock	0.554	0.5543	0.554	0.5542	54900.0
2007-01-09 08:00:00	AMZN	Stock	1.881	1.881	1.875	1.875	30000.0
2007-01-09 09:00:00	AMZN	Stock	1.875	1.8935	1.8695	1.885	14280160.0
2007-01-09 10:00:00	AMZN	Stock	1.885	1.897	1.875	1.8945	21293600.0
2007-01-09 11:00:00	AMZN	Stock	1.894	1.8945	1.878	1.8785	17331080.0
2007-01-09 12:00:00	AMZN	Stock	1.8785	1.887	1.868	1.8695	15144700.0
2007-01-09 13:00:00	AMZN	Stock	1.8685	1.9	1.867	1.894	11263460.0
2007-01-09 14:00:00	AMZN	Stock	1.8935	1.9	1.88	1.8955	9332020.0
2007-01-09 15:00:00	AMZN	Stock	1.895	1.903	1.8865	1.889	20985740.0
2007-01-09 16:00:00	AMZN	Stock	1.889	1.889	1.885	1.885	52240.0
2007-01-09 17:00:00	AMZN	Stock	1.885	1.885	1.885	1.885	4000.0

> showing 50 of 30,702 rows — these rows as CSV

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