PREVIEW / stock_1hour / 2001-01-02

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-02.parquet
  size:    325 KB
  rows:    16,676
  symbols: 1,266

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
2001-01-02 08:00:00	AAPL	Stock	0.2656	0.2656	0.2656	0.2656	39200.0
2001-01-02 09:00:00	AAPL	Stock	0.2656	0.2723	0.2634	0.2645	52595200.0
2001-01-02 10:00:00	AAPL	Stock	0.2645	0.2656	0.2612	0.2623	41776000.0
2001-01-02 11:00:00	AAPL	Stock	0.2634	0.2679	0.26	0.2645	55249600.0
2001-01-02 12:00:00	AAPL	Stock	0.2656	0.2656	0.2634	0.2656	60636800.0
2001-01-02 13:00:00	AAPL	Stock	0.2656	0.2712	0.2645	0.2667	70795200.0
2001-01-02 14:00:00	AAPL	Stock	0.2667	0.2679	0.2656	0.2667	64377600.0
2001-01-02 15:00:00	AAPL	Stock	0.2667	0.2679	0.2623	0.2667	78321600.0
2001-01-02 16:00:00	AAPL	Stock	0.2667	0.2667	0.2634	0.2634	10472000.0
2001-01-02 17:00:00	AAPL	Stock	0.264	0.2662	0.264	0.2645	532000.0
2001-01-02 18:00:00	AAPL	Stock	0.2667	0.2667	0.2667	0.2667	56000.0
2001-01-02 08:00:00	MSFT	Stock	21.8125	22.0625	21.7188	21.8438	62400.0
2001-01-02 09:00:00	MSFT	Stock	21.875	22.5	21.6875	22.2812	12694400.0
2001-01-02 10:00:00	MSFT	Stock	22.2812	22.375	21.7812	21.8438	11276600.0
2001-01-02 11:00:00	MSFT	Stock	21.8125	22.125	21.4375	22.125	11532000.0
2001-01-02 12:00:00	MSFT	Stock	22.125	22.1875	21.75	22.0312	5415000.0
2001-01-02 13:00:00	MSFT	Stock	22.0	22.2812	21.8125	21.9688	8362800.0
2001-01-02 14:00:00	MSFT	Stock	21.9688	22.125	21.8438	22.0	9543200.0
2001-01-02 15:00:00	MSFT	Stock	22.0	22.125	21.4375	21.625	14849800.0
2001-01-02 16:00:00	MSFT	Stock	21.6562	22.1875	21.5625	21.7344	5584600.0
2001-01-02 17:00:00	MSFT	Stock	21.75	21.875	21.6875	21.6875	120800.0
2001-01-02 18:00:00	MSFT	Stock	21.7188	21.7188	21.6875	21.6875	400.0
2001-01-02 09:00:00	NVDA	Stock	0.1375	0.1396	0.1313	0.1318	49920000.0
2001-01-02 10:00:00	NVDA	Stock	0.1316	0.1333	0.1266	0.1289	69840000.0
2001-01-02 11:00:00	NVDA	Stock	0.1286	0.1313	0.1255	0.1292	39864000.0
2001-01-02 12:00:00	NVDA	Stock	0.1294	0.1313	0.1271	0.1289	11736000.0
2001-01-02 13:00:00	NVDA	Stock	0.1294	0.1333	0.1284	0.1292	11784000.0
2001-01-02 14:00:00	NVDA	Stock	0.1297	0.131	0.125	0.1266	29088000.0
2001-01-02 15:00:00	NVDA	Stock	0.1266	0.1305	0.1242	0.1245	62136000.0
2001-01-02 16:00:00	NVDA	Stock	0.1245	0.1289	0.1201	0.1289	6936000.0
2001-01-02 17:00:00	NVDA	Stock	0.1208	0.1208	0.1208	0.1208	48000.0
2001-01-02 18:00:00	NVDA	Stock	0.1182	0.1182	0.1182	0.1182	24000.0
2001-01-02 08:00:00	AMZN	Stock	0.8125	0.8125	0.7875	0.7906	254000.0
2001-01-02 09:00:00	AMZN	Stock	0.7938	0.8	0.7344	0.7344	25628000.0
2001-01-02 10:00:00	AMZN	Stock	0.7375	0.7375	0.6875	0.6875	39242000.0
2001-01-02 11:00:00	AMZN	Stock	0.6906	0.7094	0.6812	0.7062	34212000.0
2001-01-02 12:00:00	AMZN	Stock	0.7062	0.7281	0.7031	0.7156	22492000.0
2001-01-02 13:00:00	AMZN	Stock	0.7188	0.7344	0.7125	0.7219	15506000.0
2001-01-02 14:00:00	AMZN	Stock	0.7219	0.725	0.7	0.7	14096000.0
2001-01-02 15:00:00	AMZN	Stock	0.7	0.7031	0.6875	0.6906	24244000.0
2001-01-02 16:00:00	AMZN	Stock	0.6906	0.7	0.6625	0.6812	2230000.0
2001-01-02 17:00:00	AMZN	Stock	0.6812	0.6938	0.675	0.6906	176000.0
2001-01-02 18:00:00	AMZN	Stock	0.6781	0.6781	0.675	0.675	16000.0
2001-01-02 09:00:00	CL	Stock	31.675	31.745	31.45	31.635	487200.0
2001-01-02 10:00:00	CL	Stock	31.64	32.125	31.635	31.98	662800.0
2001-01-02 11:00:00	CL	Stock	31.96	32.2	31.735	31.8	510600.0
2001-01-02 12:00:00	CL	Stock	31.8	31.835	31.45	31.72	322600.0
2001-01-02 13:00:00	CL	Stock	31.72	31.74	31.48	31.48	261600.0
2001-01-02 14:00:00	CL	Stock	31.475	31.575	31.45	31.46	296800.0
2001-01-02 15:00:00	CL	Stock	31.475	31.625	31.21	31.25	555000.0

> showing 50 of 16,676 rows — these rows as CSV

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