PREVIEW / stock_1hour / 2008-01-02

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-02.parquet
  size:    835 KB
  rows:    41,538
  symbols: 3,257

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-02 05:00:00	AAPL	Stock	7.1239	7.125	7.1239	7.125	56000.0
2008-01-02 06:00:00	AAPL	Stock	7.1246	7.1364	7.1246	7.1364	119280.0
2008-01-02 07:00:00	AAPL	Stock	7.1364	7.1404	7.1179	7.1304	442400.0
2008-01-02 08:00:00	AAPL	Stock	7.1318	7.1382	7.0743	7.0964	6110132.0
2008-01-02 09:00:00	AAPL	Stock	7.0982	7.1504	7.0743	7.1486	112054320.0
2008-01-02 10:00:00	AAPL	Stock	7.1493	7.1521	7.0711	7.0732	171745084.0
2008-01-02 11:00:00	AAPL	Stock	7.0732	7.0961	6.9107	6.9696	215247480.0
2008-01-02 12:00:00	AAPL	Stock	6.9686	7.125	6.8768	6.9454	126967204.0
2008-01-02 13:00:00	AAPL	Stock	6.9454	6.9804	6.9107	6.9636	97722492.0
2008-01-02 14:00:00	AAPL	Stock	6.9639	7.0386	6.9286	6.9329	174956208.0
2008-01-02 15:00:00	AAPL	Stock	6.9318	6.975	6.9204	6.9618	158844728.0
2008-01-02 16:00:00	AAPL	Stock	6.9629	7.0743	6.9586	6.9714	13639360.0
2008-01-02 17:00:00	AAPL	Stock	6.9757	7.0076	6.9357	6.975	831404.0
2008-01-02 18:00:00	AAPL	Stock	6.975	6.9768	6.97	6.9768	270312.0
2008-01-02 19:00:00	AAPL	Stock	6.9768	6.9821	6.9714	6.9821	289856.0
2008-01-02 07:00:00	MSFT	Stock	35.65	35.65	35.65	35.65	1100.0
2008-01-02 08:00:00	MSFT	Stock	35.65	35.75	35.6	35.71	705907.0
2008-01-02 09:00:00	MSFT	Stock	35.71	35.96	35.6	35.87	4911268.0
2008-01-02 10:00:00	MSFT	Stock	35.86	35.86	35.4	35.49	9368588.0
2008-01-02 11:00:00	MSFT	Stock	35.49	35.67	35.18	35.407	9416203.0
2008-01-02 12:00:00	MSFT	Stock	35.4	35.58	35.02	35.19	6429719.0
2008-01-02 13:00:00	MSFT	Stock	35.19	35.33	35.07	35.22	6939898.0
2008-01-02 14:00:00	MSFT	Stock	35.23	35.48	35.07	35.08	8188422.0
2008-01-02 15:00:00	MSFT	Stock	35.08	35.3	35.0	35.23	13938287.0
2008-01-02 16:00:00	MSFT	Stock	35.23	35.83	35.14	35.22	3124184.0
2008-01-02 17:00:00	MSFT	Stock	35.22	35.34	35.1	35.22	82600.0
2008-01-02 18:00:00	MSFT	Stock	35.22	35.22	35.22	35.22	300.0
2008-01-02 19:00:00	MSFT	Stock	35.22	35.22	35.2	35.2	800.0
2008-01-02 08:00:00	NVDA	Stock	0.8505	0.8505	0.8505	0.8505	4134400.0
2008-01-02 09:00:00	NVDA	Stock	0.8505	0.8588	0.8426	0.8462	39375840.0
2008-01-02 10:00:00	NVDA	Stock	0.846	0.846	0.8278	0.8308	95123840.0
2008-01-02 11:00:00	NVDA	Stock	0.8308	0.85	0.8152	0.8222	67135480.0
2008-01-02 12:00:00	NVDA	Stock	0.8222	0.8228	0.814	0.818	54519760.0
2008-01-02 13:00:00	NVDA	Stock	0.818	0.8305	0.8158	0.8245	58775480.0
2008-01-02 14:00:00	NVDA	Stock	0.8248	0.8325	0.822	0.8252	67965320.0
2008-01-02 15:00:00	NVDA	Stock	0.8252	0.83	0.8212	0.8242	81141920.0
2008-01-02 16:00:00	NVDA	Stock	0.8252	0.8505	0.8242	0.8248	6928280.0
2008-01-02 17:00:00	NVDA	Stock	0.827	0.8283	0.8252	0.8268	198640.0
2008-01-02 19:00:00	NVDA	Stock	0.8268	0.8268	0.8268	0.8268	20000.0
2008-01-02 06:00:00	AMZN	Stock	4.7125	4.7485	4.7125	4.7485	30000.0
2008-01-02 07:00:00	AMZN	Stock	4.745	4.755	4.7375	4.7375	142780.0
2008-01-02 08:00:00	AMZN	Stock	4.7375	4.7625	4.632	4.7175	1119040.0
2008-01-02 09:00:00	AMZN	Stock	4.722	4.8715	4.7205	4.844	56920880.0
2008-01-02 10:00:00	AMZN	Stock	4.8435	4.859	4.785	4.793	62940800.0
2008-01-02 11:00:00	AMZN	Stock	4.795	4.824	4.741	4.7885	37061780.0
2008-01-02 12:00:00	AMZN	Stock	4.7875	4.7995	4.74	4.7904	21854080.0
2008-01-02 13:00:00	AMZN	Stock	4.79	4.7965	4.763	4.7715	18132320.0
2008-01-02 14:00:00	AMZN	Stock	4.772	4.833	4.766	4.768	32330160.0
2008-01-02 15:00:00	AMZN	Stock	4.7695	4.816	4.7505	4.8105	42338240.0
2008-01-02 16:00:00	AMZN	Stock	4.812	4.8225	4.7846	4.8225	4051580.0

> showing 50 of 41,538 rows — these rows as CSV

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