PREVIEW / stock_1hour / 2008-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-22.parquet
  size:    856 KB
  rows:    43,315
  symbols: 3,289

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
2008-01-22 04:00:00	AAPL	Stock	5.1289	5.5	5.0893	5.1964	273056.0
2008-01-22 05:00:00	AAPL	Stock	5.2232	5.3211	5.2054	5.2836	209356.0
2008-01-22 06:00:00	AAPL	Stock	5.2821	5.375	5.2821	5.2857	722316.0
2008-01-22 07:00:00	AAPL	Stock	5.3482	5.4839	5.2818	5.4289	5929252.0
2008-01-22 08:00:00	AAPL	Stock	5.3571	5.7393	5.2857	5.4036	77857052.0
2008-01-22 09:00:00	AAPL	Stock	5.3989	5.6071	5.2143	5.5457	342058752.0
2008-01-22 10:00:00	AAPL	Stock	5.5482	5.6571	5.5107	5.6004	321404496.0
2008-01-22 11:00:00	AAPL	Stock	5.6004	5.7068	5.545	5.5511	230329064.0
2008-01-22 12:00:00	AAPL	Stock	5.5513	5.6254	5.5361	5.6243	170039940.0
2008-01-22 13:00:00	AAPL	Stock	5.6243	5.7136	5.6043	5.6104	226400076.0
2008-01-22 14:00:00	AAPL	Stock	5.6089	5.6729	5.5739	5.6018	246337784.0
2008-01-22 15:00:00	AAPL	Stock	5.5979	5.6789	5.545	5.625	407942444.0
2008-01-22 16:00:00	AAPL	Stock	5.6236	5.7629	4.8146	4.9686	281500128.0
2008-01-22 17:00:00	AAPL	Stock	4.9654	5.563	4.8754	4.9657	100918104.0
2008-01-22 18:00:00	AAPL	Stock	4.9657	5.6846	4.9193	4.9539	21067396.0
2008-01-22 19:00:00	AAPL	Stock	4.9554	4.9568	4.92	4.9261	3914288.0
2008-01-22 04:00:00	MSFT	Stock	30.77	30.8	30.62	30.62	700.0
2008-01-22 05:00:00	MSFT	Stock	30.4	31.08	30.4	30.86	3262.0
2008-01-22 06:00:00	MSFT	Stock	31.06	31.35	30.89	31.29	18658.0
2008-01-22 07:00:00	MSFT	Stock	31.29	31.6	31.25	31.53	120876.0
2008-01-22 08:00:00	MSFT	Stock	31.5	32.69	31.4	31.98	484698.0
2008-01-22 09:00:00	MSFT	Stock	31.97	32.33	31.5	31.85	15459636.0
2008-01-22 10:00:00	MSFT	Stock	31.85	32.53	31.8	31.92	19944397.0
2008-01-22 11:00:00	MSFT	Stock	31.91	32.25	31.8	31.89	13483256.0
2008-01-22 12:00:00	MSFT	Stock	31.89	32.12	31.82	32.04	8266439.0
2008-01-22 13:00:00	MSFT	Stock	32.04	32.24	31.92	32.0	11046453.0
2008-01-22 14:00:00	MSFT	Stock	32.02	32.1	31.85	32.02	10533695.0
2008-01-22 15:00:00	MSFT	Stock	32.01	32.4	31.95	31.98	20102637.0
2008-01-22 16:00:00	MSFT	Stock	31.96	33.01	31.3	31.63	9830017.0
2008-01-22 17:00:00	MSFT	Stock	31.55	32.071	31.55	31.75	101129.0
2008-01-22 18:00:00	MSFT	Stock	32.025	32.37	31.6	31.74	141777.0
2008-01-22 19:00:00	MSFT	Stock	31.74	31.8	31.7	31.8	11777.0
2008-01-22 04:00:00	NVDA	Stock	0.5875	0.5875	0.5625	0.5625	12000.0
2008-01-22 06:00:00	NVDA	Stock	0.5625	0.5625	0.5625	0.5625	4000.0
2008-01-22 07:00:00	NVDA	Stock	0.5762	0.5778	0.575	0.5778	84000.0
2008-01-22 08:00:00	NVDA	Stock	0.575	0.6	0.575	0.581	1379480.0
2008-01-22 09:00:00	NVDA	Stock	0.5788	0.585	0.5582	0.5765	80507680.0
2008-01-22 10:00:00	NVDA	Stock	0.5762	0.6045	0.5758	0.5923	156059760.0
2008-01-22 11:00:00	NVDA	Stock	0.5925	0.6015	0.586	0.593	84182600.0
2008-01-22 12:00:00	NVDA	Stock	0.5933	0.602	0.5875	0.5952	65412200.0
2008-01-22 13:00:00	NVDA	Stock	0.5955	0.6043	0.5928	0.5995	68437040.0
2008-01-22 14:00:00	NVDA	Stock	0.5995	0.5995	0.588	0.594	76533600.0
2008-01-22 15:00:00	NVDA	Stock	0.594	0.6023	0.5898	0.5928	136222320.0
2008-01-22 16:00:00	NVDA	Stock	0.5935	0.621	0.5692	0.575	40928160.0
2008-01-22 17:00:00	NVDA	Stock	0.5725	0.592	0.5725	0.59	130440.0
2008-01-22 18:00:00	NVDA	Stock	0.5946	0.5946	0.57	0.5812	1416560.0
2008-01-22 19:00:00	NVDA	Stock	0.5782	0.5838	0.5782	0.5838	153520.0
2008-01-22 04:00:00	AMZN	Stock	3.88	3.88	3.633	3.633	44000.0
2008-01-22 05:00:00	AMZN	Stock	3.73	3.73	3.7	3.7	21220.0
2008-01-22 06:00:00	AMZN	Stock	3.725	3.7375	3.725	3.7375	12000.0

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

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